0

I cannot access oracle from remote due to my listener error. I checked all configuration files which are listener.ora, tnsanmes.ora and sqlnet but I didn't find any missing config. Below is my listener.ora

listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Generated by Oracle configuration tools.

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )

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

ADR_BASE_LISTENER = D:\app\Administrator

Here is tnsnames.ora

tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

Generated by Oracle configuration tools.

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

ORCLAMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.15.192.18)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orclams) ) )

lsnrctl status:

enter image description here

tnsping

enter image description here

lsnrctl listener start:

enter image description here

Below is my log alert message:

10-JAN-2019 07:42:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=jdbc)(USER=STCDB$))(SERVICE_NAME=orclams)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59198)) * establish * orclams * 12560 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error 64-bit Windows Error: 53: Unknown error TNS-12518: TNS:listener could not hand off client connection TNS-12571: TNS:packet writer failure TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error 64-bit Windows Error: 54: Unknown error

Actually, my oracle server worked normally before we change server's IP address from 10.15.193.18 to 10.15.192.18. So I have changed new IP address tnsnames.ora then Oracle have been not working properly

Thanks in advance.

  • 1) Have you restarted your Database or Host Server since you made the change? 2) Have you tried using DIRECT connection to the IP address (10.15.192.18:1521 or 10.15.192.18:1521\oclams)? Can you confirm which OS your host is running on? – MguerraTorres Jan 11 at 6:16
  • @MguerraTorres : I already tried to restart Oracle services and our WIN server but it doesn't work. But I can connect on server using command sqlplus>conn mydb/mypassword. But when I change to sqlplus>conn mydb/mypasswod@10.15.192.18:1521/orclams then it is waiting to access. I am using WIN OS to run Oracle Server – nvtthang Jan 11 at 6:31
  • After long time executed command sqlplus>conn mydb/mypass@10.15.192.18:1521/orclams or sqlplus>conn mydb/mypass@stcdb:1521/orclams it was successfully connected but when I logged out and tried to connect against above these command, it took long time to connect and sometime it returned TNS:no listener. I don't know what's wrong in our Oracle server – nvtthang Jan 11 at 9:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.