"Ora-12541:tns: No Listener" error occurred while resolving PL/SQL Developer Connection Database

Occurs when connecting to a database with PL/SQL developer
"Ora-12541:tns: No Listener" error.

1. Check Listener.log log
The following error was found:
Tnslsnr for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 10:25:26

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log information written to D:/oracle/product/10.2.0/db_1/network/log/listener.log
Write Trace information for D:/ORACLE/PRODUCT/10.2.0/DB_1/NETWORK/TRACE/LISTENER.TRC
Trace level is currently 0

Start with pid=1704.
Monitoring: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))
An error occurred while listening to the object: (description= (Address= (protocol=tcp) (host=0.5.0.5) (port=1521)))
TNS-12545: Connection failed because the target host or object does not exist
TNS-12560:TNS: Protocol Adapter error
TNS-00515: Connection failed because the target host or object does not exist
32-bit Windows Error:49:unknown Error
No longer listens: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))

2. See if Oracle's listener is started
C:/Documents and Settings/mengzhaoliang>lsnrctl status

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 10:5
0:44

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
Tns-12541:tns: No listening program
TNS-12560:TNS: Protocol Adapter error
TNS-00511: No listening program
32-bit Windows error:2: No such file or directory
Connecting to (Description= (address= (protocol=tcp) (host=0.5.0.5) (port=1521))
Tns-12535:tns: Operation timed out
TNS-12560:TNS: Protocol Adapter error
TNS-00505: Operation timed out
32-bit Windows Error:60:unknown Error

Originally did not start listener, with "lsnrctl start" command also cannot start.
C:/Documents and Settings/mengzhaoliang>lsnrctl start

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 10:5
2:16

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Start Tnslsnr: Please wait ...

Tnslsnr for 32-bit windows:version 10.2.0.1.0-production
System parameter file is D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log information written to D:/oracle/product/10.2.0/db_1/network/log/listener.log
Monitoring: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))
Error while listening for this object: (Description= (Address= (protocol=tcp) (host=0.5.0.5) (port=1521))
)
TNS-12545: Connection failed because the target host or object does not exist
TNS-12560:TNS: Protocol Adapter error
TNS-00515: Connection failed because the target host or object does not exist
32-bit Windows Error:49:unknown Error

The listener failed to start. See the error message above ...

3. View the contents of Listener.ora:
# Listener.ora Network Configuration File:d:/oracle/product/10.2.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.2.0/db_1)
(program = Extproc)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = 0.5.0.5) (PORT = 1521))
)
)

Originally the IP of the machine has changed, the above problem occurs, change the database listening IP address:
Put (ADDRESS = (PROTOCOL = TCP) (HOST = 0.5.0.5) (PORT = 1521))
Change into
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))

127.0.0.1: This is the IP address that the database is currently using.

4. Start Oracle Listener again
C:/Documents and Settings/mengzhaoliang>lsnrctl start

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 10:5
4:40

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Start Tnslsnr: Please wait ...

Tnslsnr for 32-bit windows:version 10.2.0.1.0-production
System parameter file is D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log information written to D:/oracle/product/10.2.0/db_1/network/log/listener.log
Monitoring: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))
Monitoring: (Description= (Address= (protocol=tcp) (host=127.0.0.1) (port=1521)))

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ
Ction
Start Date 20月-September-2008 10:54:41
Uptime 0 days 0 hours 0 minutes 1 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File D:/ORACLE/PRODUCT/10.2.0/DB_1/NETWORK/ADMIN/LISTENER.O
Ra
Listener log File D:/oracle/product/10.2.0/db_1/network/log/listener.log

Listener Endpoint Summary ...
(Description= (address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))
(Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
Service Summary:
The service "Plsextproc" consists of 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded

Startup has been successful,

5. Add the Tnsnames.ora
orcl_127.0.0.1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

6. Re-connect the database again with PL/SQL developer
The following error occurred:
Tns-12514:tns: Listener currently does not recognize the requested service in the connection descriptor

Check the Listener.log log again
20月-September -2008 11:01:54 * (Connect_data= (server=dedicated) (SERVICE_NAME=ORCL) (cid=

(Program=d:/plsql/plsqldev.exe) (HOST=RUIFEI-EF0ADC98) (User=mengzhaoliang))) * (address=

(PROTOCOL=TCP) (host=127.0.0.1) (port=1267)) * Establish * ORCL * 12514
Tns-12514:tns: Listener currently does not recognize the requested service in the connection descriptor

View Listener:
C:/Documents and Settings/mengzhaoliang>lsnrctl Services

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 11:1
1:09

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
Service Summary:
The service "Plsextproc" consists of 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Handlers:
"Dedicated" established: 0 has been rejected: 0
LOCAL SERVER
Command execution succeeded

7, with Sqlplus also appear the same error:
C:/Documents and Settings/mengzhaoliang>sqlplusscott/[email protected]_127.0.0.1

Sql*plus:release 10.2.0.1.0-production on Saturday September 20 11:15:09 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
Ora-12514:tns: Listener currently does not recognize the requested service in the connection descriptor

8. View Listenser Status:
C:/Documents and Settings/mengzhaoliang>lsnrctl status

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 11:2
6:42

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ
Ction
Start Date 20月-September-2008 11:24:33
Uptime 0 days 0 hours 2 minutes 8 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File D:/ORACLE/PRODUCT/10.2.0/DB_1/NETWORK/ADMIN/LISTENER.O
Ra
Listener log File D:/oracle/product/10.2.0/db_1/network/log/listener.log

Listener Endpoint Summary ...
(Description= (address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))
(Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
Service Summary:
The service "Plsextproc" consists of 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded

C:/Documents and Settings/mengzhaoliang>tnsping ORCL

TNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 20月-September-
2008 11:27:43

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter file:
D:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Cannot resolve name

9. View Sqlnet.ora Content:
# Sqlnet.ora Network Configuration File:d:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

# This file was actually generated by NETCA. But if customers choose to
# install ' Software only ', this file wont exist and without the native
# Authentication, they'll is not being able to connect to the database on NT.

Sqlnet. Authentication_services= (NTS)

NAMES. Directory_path= (TNSNames, Ezconnect)

10. Put the contents of the Listener.ora:
# Listener.ora Network Configuration File:d:/oracle/product/10.2.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.2.0/db_1)
(program = Extproc)
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
)

Change to the following content:

# Listener.ora Network Configuration File:d:/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = ORCL)
(Oracle_home = d:/oracle/product/10.2.0/db_1)
# (program = Extproc)
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = ORCL))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
)

11, then close, then start listener
Execute "lsnrctl stop" and "lsnrctl Stop" command in CMD and log in normally again!
C:/Documents and Settings/mengzhaoliang>sqlplus scott/[email protected]

Sql*plus:release 10.2.0.1.0-production on Saturday September 20 11:55:47 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options

Sql>

again with PL/SQL Peveloper Landing there is no problem.

"Ora-12541:tns: No Listener" error occurred while resolving PL/SQL Developer Connection Database