Status failure test failed ошибка ввода вывода - Решение и исправление самых разных ошибок на TopOshibok.ru

I created a database using SQL developer list of 1000 entries and it created successfully. The connection also succeeded. But today while I’m trying to connect there is an error occurring:

IO Error: The Network Adapter could not establish the connection in SQL developer

I can surely say it is not connecting I tried it in Command prompt also in prompt it is mentioning as Protocol Adapter Error.

What is the problem here?

What is meant by Protocol Adapter Error how can i overcome it?

What is Network Adapter Error?

Aruna

12k3 gold badges28 silver badges42 bronze badges

asked Jul 2, 2014 at 6:56

Please check the listener to see if it is down:-

ps -ef | grep tns

If you dont find the output of the listener then you have to start it. To do that type start in the LSNRCTL> prompt.

From the Oracle forum:

If the Oracle clients have been installed with 11.1.2.3 the TNS_ADMIN
will be point to \user_projects\config\dbclient In
that folder there should be a tnsnames.ora, if the Oracle DB is on the
same machine you may want to copy the contents of database tnsnames
folder to the TNS_ADMIN folder or as suggested change the environment
variable.

answered Jul 2, 2014 at 7:00

Rahul TripathiRahul Tripathi

169k31 gold badges280 silver badges332 bronze badges

You need to follow few steps .

Go to the directory «C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN»

Open tnsnames.ora file and change the host. Generally localhost in your case

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = XE)
)
)

Open listener.ora file and change the listener host name to localhost.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

Open command prompt as administrator. Check for the listener status.
```
c:\> lsnrctl status
```
If you find listener is up then you can be able to connect to the sql developer. Other wise start the listener by using below command.
```
c:\> lsnrctl start
```
Now you can be able to login to sql developer without the above mentioned error.

answered Jun 8, 2018 at 10:14

SQL Developer problem: The network adapter could not establish the connection

Open the file sqldeveloper.conf in wordpad or your favourite text editor. The file is placed in the installation directory, probably:
```
%programfiles%\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
```
Add the following line at the bottom of the file and save:
```
AddVMOption -Djava.net.preferIPv4Stack=true
```
Restart SQL Developer.

answered Apr 10, 2018 at 12:36

I had a similar issue where I also continuously got the same error. I tried many things like changing the listener port number, turning off the firewall etc. Finally I was able to resolve the issue by changing listener.ora file. I changed the following line:

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))

I also added an entry in the /etc/hosts file.

you can use Oracle net manager to change the above line in listener.ora file. See Oracle Net Services Administrator’s Guide for more information on how to do it using net manager.

Also you can use the service name (database_name.domain_name) instead of SID while making the connnection.

Hope this helps.

answered Dec 16, 2014 at 19:28

scvscv

4905 silver badges14 bronze badges

the answer for your question is some times the listener will be shut-down at this point it will not allow you to connect to the database, for example when the machine restarts.
Solution is : Go to services check the Oracle_ora Db —> tns_listener is in running mode are not if not restart the services.

answered Apr 1, 2015 at 9:50

I had a similar issue with oracle running on my suse vm.
This fixed the problem:
1.) Removed the file listener.ora.
2.) Made listener part of tnsnames.ora

LISTENER_MDB1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

MDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MDB1)
    )
  )

There may be a better solution though.

answered Jun 30, 2015 at 5:14

ssvssv

1251 silver badge11 bronze badges

In my case I need to set Hostname like «my-oracle-server-name», not by ip (192.168.1.23)

answered Oct 9, 2017 at 12:34

VladVlad

1,0271 gold badge15 silver badges18 bronze badges

I had this issue but finally found a solution.
Follow the next steps.

Stop all services that you hace runnig about oracle
Please check your ip configuration in a console(windows command ipconfig, linux command ifconfig), save that ip
Change the ip than you have in the following files:
listener.ora
tnsnames.ora
Start all services that you stoped

The previous steps should have solved the issue.

Note: if you don’t want to repeat the above steps every time you restart your computer, just put in the ip addresses 127.0.0.1 in the files.

answered Jul 6, 2021 at 14:56

Источник

3 / 3 / 2

Регистрация: 20.07.2014

Сообщений: 654

16.03.2021, 05:23. Показов 14985. Ответов 5

Всем привет!
Все было нормально) Все работало)
Но решил через некоторое время запустить базы на Oracle
В итоге базы не запускаются

Я пробовал оживить командами
lsnrctl status
lsnrctl start
Они оказались актуальны и сработали
Но ошибка осталась…
Подскажите, пожалуйста, что с этим можно дальше сделать?
Может, просто переустановить и все…

3 / 3 / 2

Регистрация: 20.07.2014

Сообщений: 654

16.03.2021, 07:13

[ТС]

Попробовал еще раз

https://www.youtube.com/watch?… ningCenter

Тоже самое, ошибка.
Но уже другая ошибка. Прежняя осталась.
Не успеваю додуматься, хелп.

Миниатюры

Модератор

4214 / 3054 / 582

Регистрация: 21.01.2011

Сообщений: 13,205

16.03.2021, 10:44

Сообщение от antoniogrid

Но уже другая ошибка

Попробуй в listener.ora прописать статически данные о твоей БД. Кстати 12560 — это ошибка, возникающая во многих случаях, например, если БД «лежит». Ну и поищи по коду ошибки 12505 темы на форуме — подобные вопросы уже обсуждались

3 / 3 / 2

Регистрация: 20.07.2014

Сообщений: 654

16.03.2021, 18:32

[ТС]

Мда… причина была на моей стороне… чуть не помер…

Пришел с работы, запустил докер…
запустил докер….
запустил…
докер

с..

Просто иконка в трее горела, что проблем нет и я открыл — а там сессия не запущена. Конечно, интуитивно предполагал, что проблема где-то могла быть в «цепочке» влияющей на запуск самого скл девелопера.
Думал, и как правило это было так, все работало (запускался докер и сессия в нем автоматически), что он и сейчас запущен.
Но почему — то что-то пошло не так. И «само» работать работать не захотело.
Случайно аспект данный нашел.

Всем спасибо!
Проблема решена!

0 / 0 / 0

Регистрация: 27.02.2020

Сообщений: 8

12.10.2021, 16:32

У меня такая же проблема. Скажите, пожалуйста, где найти докер и что такое трей

Модератор

8590 / 5733 / 2306

Регистрация: 21.01.2014

Сообщений: 24,570

Записей в блоге: 3

12.10.2021, 16:42

Сообщение от POMOGITE_please

и что такое трей

но это же азы работы в операционной системе!!! =-O
Вот он:

Миниатюры

Источник

Most probably you have listener configured wrongly, the hostname you specify in connection string must be the same as in the listener.

First check the Firewall and network related issues.

Check if Oracle Listener service is available and running. If not you may use Oracle Net Configuration Assistant tool to add and register new listener.

If the above steps are ok then you need to configure Oracle Listener appropriately. You may use Oracle Net Manager tool or edit “%ORACLE_HOME%\network\admin\listener.ora” file manually.

There are 2 options that need to be considered carefully:
Listening Locations associated with the Listener – Hostname(IP) and Port in Listening Location must exactly match the ones used in the connection string.

For example, if you use 192.168.74.139 as target hostname, then there must be Listening Location registered with the same IP address.

Also make sure the you use the same SID as indicated in Database Service associated with the Listener.

Fix Oracle “IO ERROR: The network adapter could not establish the connection” error

Источник

Уважаемые господа!
Помогите, пожалуйста, с проблемой. Windows 10, пытаюсь локально подключиться в SQL Developer 19 к Oracle Database 18c Express Edition.
Вылезает ошибка: Status : Failure -Test failed: Ошибка ввода/вывода: The Network Adapter could not establish the connection
Параметры соединения:
Hostname: localhost
port: 1521
SID: xe

listener.ora
DEFAULT_SERVICE_LISTENER = XE

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle\dbhomeXE)
(PROGRAM = extproc)
(ENVS = «EXTPROC_DLLS=ONLY:C:\Oracle\dbhomeXE\bin\oraclr18.dll»)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 77.220.135.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

tnsnames.ora
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

C:\Users\user>tnsping xe

TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 — Production on 07-SEP-2019 15:06:49

Used parameter files:
C:\Oracle\dbhomeXE\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Users\user>ipconfig

Настройка протокола IP для Windows

Адаптер Ethernet Ethernet:

DNS-суффикс подключения . . . . . :
IPv6-адрес. . . . . . . . . . . . : 2a00:1370:812f:7509:3563:7feb:4050:ef5
IPv6-адрес. . . . . . . . . . . . : 2a00:1370:812f:7509:f835:a448:20cc:7542
IPv6-адрес. . . . . . . . . . . . : fd81:2f5:e70:1:3563:7feb:4050:ef5
IPv6-адрес. . . . . . . . . . . . : fda5:efdd:d8b0:1:3563:7feb:4050:ef5
Временный IPv6-адрес. . . . . . . : 2a00:1370:812f:7509:34fe:3e4e:f477:99ae
Временный IPv6-адрес. . . . . . . : fd81:2f5:e70:1:34fe:3e4e:f477:99ae
Временный IPv6-адрес. . . . . . . : fda5:efdd:d8b0:1:34fe:3e4e:f477:99ae
Локальный IPv6-адрес канала . . . : fe80::3563:7feb:4050:ef5%10
IPv4-адрес. . . . . . . . . . . . : 77.220.135.100
Маска подсети . . . . . . . . . . : 255.255.255.240
Основной шлюз. . . . . . . . . : fe80::7a81:2ff:fef5:e70%10
77.220.135.97

C:\Users\user>lsnrctl status

LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 — Production on 07-SEP-2019 15:10:00

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=77.220.135.100)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 — Production
Start Date 07-SEP-2019 13:32:17
Uptime 0 days 1 hr. 37 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\Oracle\dbhomeXE\network\admin\listener.ora
Listener Log File C:\Oracle\diag\tnslsnr\user-╧╩\listener\alert\log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=77.220.135.100)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary…
Service «CLRExtProc» has 1 instance(s).
Instance «CLRExtProc», status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

C:\Users\user>sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 — Production on Sat Sep 7 15:12:04 2019
Version 18.4.0.0.0

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:

Источник

На чтение 4 мин. Просмотров 30 Опубликовано 15.12.2019

When i run the sql developer and set the all data,click the connect but i get this error:

I’m beginner in Oracle ,how can i solve that error?
my windows:7 64bit and oracle 12c

10 Answers 10

You need set «tcp.val >

I got the same issue but following steps worked for me, it seems Gaurav also has shared it already:

From your inputs in the dialog, you are using port 5500. That port is what is used for EM Express. It answers to HTTPs traffic only. So in this case the -1 error message means the protocol negotiation failed. SQLDEV is trying to talk SQL*NET to something listening for HTTPs.

The port you are looking for is 1521 if it wasn’t altered. If it was check the $ORACLE_HOME/network/admin/listener.ora for the proper port number.

Try Connection name: HR_ORCL Username: HR , Password: hr , Connection type : local, Role: SYSDBA Click on connect. It will work.

Seems you have enabled ACL on the listener.

You can follow these steps to avoid the error:

Hope that helps

Actually, It is not database specific issue. it is related to port value generated by database during your installation. To overcome on this issue, please follow below.

Go to the folder where you have installed the database (Like: F:app)

Here you will be able to see many folders, go to product11.2.0(«your databse version»)dbhome_1NETWORKADMIN

find listener.ora file and open as text file

Check for the port number in that file

Now provide that port number while doing connection in sql developer.

Hope it will resolve your issue.

Ensure the DB is up and running and you can connect locally AS SYSDBA to the database using Oracle binaries owner (usually oracle:oinstall Unix / Linux user). If it does not work, probably you encounter a different problem. Check privileges of an Oracle file on Unix / Linux host where database is running:

Change permissions as below:

Most of the answers out there for this problem point to using the wrong PORT number in your connection options, or similar. In my case, after a couple hours of searching, the reason showed to be something else.

Mind which user you are using when starting Oracle listener. You should do it with the oracle user, not as root. Otherwise you end up with listener files being created as e.g. user deamon group root instead of user oracle group dba. This in turn leads to:

To check whether this is the case, go to

and list all files (ls -la). If you find out some of the s#* files being created by a root-group user, stop the listener (lsnrctl stop), delete the above files as root and restart the listener as oracle user.

Unfortunately sqldeveloper doesn’t show the full stack-trace when reading «Got minus one from a read call». I could find the problem thanks to switching to SQL-Squirrel.

The IO Error: Got minus one from a read call error is caused by the SQLNET.ora file on the database server being configured to only allow connections from certain computers on the network (as >

Attempting to connect to a database via SQL Developer throws the error when testing or attempting to use the connection:

If the TCP.VALIDNODE_CHECKING parameter is enabled In the SQNET.ora file then the IP address of each computer allowed to connect to databases via the listener configured using that SQLNET.ora file will need to be added to the TCP.INVITED_NODES list.

Here is an example SQLNET.ora file with VALIDNODE_CHECKING enabled and one computer (with the IP address 192.168.1.101) granted access:

There is an opposite parameter to TCP.INVITED_NODES; TCP.EXCLUDED_NODES will forbid access to those IP addresses configured in its list.

With the appropriate settings in place, SQL Developer should be able to connect as planned:

I setup a DB cloud instance but now I can’t connect to it using SQL Developer.

I setup the SSH connection in SQL Developer + port forwarding and I test that connection successfully.

But when I try to create a connection, I always get this error:

«STATUS: Failure — Test Failed: I/O error: Got minus one from read call, connect lapse XX ms, Authentication lapse 0 ms.»

Источник