ORA-12541: TNS: No listener error resolved

 

Field Back, login pl/SQL error: ORA-12541: TNS: No listener.

1.     
Check oracleproduct10.1.0db _ 1NETWORKloglistener. log:

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0-Production on month-1
-13:38:34 2010

 

Copyright (c) 1991,200 4, Oracle.All rights reserved.

 

The system parameter file is D: oracleproduct10.1.0db _ 1networkadminlistener. ora.

Log information written to D: oracleproduct10.1.0db _ 1networkloglistener. log

Write the trace information of D: oracleproduct10.1.0db _ 1networktracelistener. trc

The trail level is currently 0.

 

To
Pid = 7180 start

Listener: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \. pipeEXTPROCipc )))

Error listening to this object: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 )))

TNS-12542: TNS:
Address occupied

 TNS-12560: TNS:
Protocol adapter Error

 TNS-00512:
The address is already in use.

  32-bit Windows Error: 48: Unknown error

No listening: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \. pipeEXTPROCipc )))

2.     
The listener of Oracle has been started.

3.     
View oracleproduct10.1.0db _ 1NETWORKADMINlistener. ora

# Listener. ora Network Configuration File: D: oracleproduct10.1.0db _ 1networkadminlistener. ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

 (SID_LIST =

   (SID_DESC =

     (SID_NAME = PLSExtProc)

     (ORACLE_HOME = D: oracleproduct10.1.0db _ 1)

     (PROGRAM = extproc)

   )

 )

 

LISTENER =

 (DESCRIPTION_LIST =

   (DESCRIPTION =

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC ))

     )

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

     )

   )

 )

 

Put (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

Change to (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))

Pc-xxx.mail.yyy.cn is the computer name

127.0.0.1 is the IP address currently in use by the database.

4.     
View oracleproduct10.1.0db _ 1NETWORKADMINtnsnames. ora

Find the following statement:

ORCL =

  (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

   )

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orcl)

   )

 )

To (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

Change to (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))

5.     
Close the listener and start listener.

Run-> cmd to start the dos window, execute lsnrctl stop to close, lsnrctl
Start.