Hi Team
We have installed Oracle 12.1.0.2.0 in production systems. I am not able to connect to database from sqldeveloper using the hostname in one of the machine. I get below error.
Status: Failure- Test failed: IO Error : The network adapter could not establish the connection
We have used localhost in listener.ora instead of hostname as below
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Tnsnames.ora
XSTRPOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xstrpos)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_XSTRPOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
I have local_listener=LISTENER_XSTRPOS
Please help with this.
Thanks