1

My listener in Oracle 11g R2 can not start . When I want to give the status of that, the error in below is shown:

Connecting to <ADDRESS=<PROTOCOL=tcp><HODT=><PORT=1521>>
TNS-12541 : TNS:no listener
 TNS-12560 : TNS:protocol adapter error
  TNS-00511 : NO LISTENER 
   64-bit Windowns Eroor : 61: Wnknown error

My tnsnames.ora is :

# tnsnames.ora Network Configuration File: D:\app\SHOJAIE\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)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SHOJAIE-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

My listener.ora is :

# listener.ora Network Configuration File: D:\app\SHOJAIE\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\SHOJAIE\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\SHOJAIE\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = SHOJAIE-PC)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = D:\app\SHOJAIE

Can any one help me ?

closed as unclear what you're asking by Colin 't Hart, Marco, Andriy M, joanolo, miracle173 Jun 12 '17 at 4:07

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Looks like you've installed some Quest software that's messed with your paths. What is %ORACLE_HOME% set to! and is it at the beginning of your PATH? – Philᵀᴹ Jan 29 '14 at 6:25
  • set ORACLE_HOME = D:\app\SHOJAIE\product\11.2.0\dbhome_1 – saeed.sh Jan 29 '14 at 7:14
  • but my quest software in C:\program files <x86>\Quest – saeed.sh Jan 29 '14 at 7:15
  • What is %TNS_ADMIN% set to? – Philᵀᴹ Jan 29 '14 at 8:32
1

Try to Restart Oracle Service by following Commands

net stop oracleserviceORCL;
net start oracleserviceORCL;

and then start listener first, if it is not already started by this command.

lsnrctl start listener;

and update me if it help...

  • when i write this command , the error in below is shown : TNS-12560 : TNS:protocol adapter error TNS-00530 : Protocl adapter error – saeed.sh Jan 29 '14 at 5:54
  • what error are you getting when you ping ORCL, like: SQL> tnsping ORCL; – N J Jan 29 '14 at 5:58
  • @saeed - Check answer updates. – N J Jan 29 '14 at 6:09
  • when i write netca in command prompt , i dont see any listener to configure and when i want to add , some of error is occured like : TNS - 04415 : file i/o error caused by :java.io.FileNotException : C:\Program files <x86>\common Files \ Quest Shared \ instantclient-basic-win-x86-11.2.0.1.0\listener.ora <access is denied > – saeed.sh Jan 29 '14 at 6:10
  • open CMD with Administrator and the execute netca command, or goto start>all progrram>oracle > configuration and migration > Oracle Configuration Assistance and right click and select 'run as administrator' and try to create listener – N J Jan 29 '14 at 6:16
0

In my case, I tried to start the listener via console:

> lsnrctl star

This command printed the following error:

TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters

So, I performed the following actions:

  1. Check if Oracle listener.ora or sqlnet.ora file contains special characters
  2. Check if Oracle listener.ora or sqlnet.ora` file are in wrong format or syntax
  3. Check if Oracle listener.ora or sqlnet.ora file have some left justified parenthesis which are not accepted by oracle parser.

Have a look at these files and check the proper syntax. If possible remove/rename sqlnet.ora and try to restart the listener. Or remove/rename both listener.ora or sqlnet.ora file and recreate it properly. These will defenitely resolve the issue.

Not the answer you're looking for? Browse other questions tagged or ask your own question.