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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.