ORA: 12541: TNS: No listener

A series of problems occurred during the installation of the Oracle database. When it was finally ruled out that it was difficult to install the database, a small software connected to the database encountered an error, PL/SQL Developer, a connection will appear ora-12541: TNS: no listening program, is really the first big, so on the Internet to find a solution to the ox, record it, avoid making mistakes later.

1. Check oracle/product/10.1.0/db_1/NETWORK/log/listener. log:
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0-Production on month-2010 13:38:34
Copyright (c) 1991,200 4, Oracle. All rights reserved.
The system parameter file is D:/oracle/product/10.1.0/db_1/network/admin/listener. ora.
Log information written to D:/oracle/product/10.1.0/db_1/network/log/listener. log
Write trace information for D:/oracle/product/10.1.0/db_1/network/trace/listener. trc
The trail level is currently 0.
Start with pid = 7180
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: address 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 oracle/product/10.1.0/db_1/NETWORK/ADMIN/listener. ora
# Listener. ora Network Configuration File: D:/oracle/product/10.1.0/db_1/network/admin/listener. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/oracle/product/10.1.0/db_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 oracle/product/10.1.0/db_1/NETWORK/ADMIN/tnsnames. 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, and lsnrctl start to start.
Then use PL/SQL Developer to log on again.
This is a solution for people from the internet. I tried it and succeeded, but when I opened listener again. at ora, I found 127.0.0.1 changed to the original format. Therefore, I suspect it may be because I restarted the service, so some children's shoes will encounter this problem in the future, restart the service and try again. If not, try again later.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12