Connect Oracle times Error Ora-12541:tns with Plsql: No listener

Source: Internet
Author: User

After the successful installation of ORACLE11, with Plsql landing when prompted Ora-12541:tns: No monitoring program, unable to login. Here summarizes the solution to this kind of method, hope can help everyone.

The first method: Because the address assignment is not correct, we need to reconfigure the native environment here.

from Oracle installation environment found in the Network, :


My Oracle is installed on the D drive, so you are looking for your own installation path, for example:D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK

LISTENER_ORCL =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)

Oraclr_connection_data=

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = IPC) (KEY =extproc1521))

)

(Connect_data =

(SID = Clrextproc)

(PRESENTATION = RO)

)

)

ORCL =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST =localhost) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)

The modified code {

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)

put the inside localhost modified to a randomly generated computer IP .

Machine Name Input localhost or 127.0.0.1 will prompt for no listener. Because the automatically assigned IP address is subject to change, the host in the Oracle value is changed to the computer name of the machine, saving the modified Tnsnames.ora. Connect (10.1.10.183/orcl) database again, error problem resolved.

The second approach is to see the Oracle system in detail.

The specific process is as follows:

First step: View Oracle of the Log log.

The following error was found:
Tnslsnr for 32-bit windows:version 10.2.0.1.0-production on 20-9 month -2008 10:25:26

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

the system parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Write D:\oracle\product\10.2.0\db_1\network\log\listener.log the log information
Write D:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\TRACE\LISTENER.TRC The tracking information
The trace level is currently 0

in pid=1704 Start

Monitor : 

(description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC))
error listening for this object :(description= (address= (PROTOCOL =TCP) (host=0.5.0.5) (port=1521))
TNS-12545: because the target host or object does not exist connection failed
Tns-12560:tns: protocol adapter error
TNS-00515: connection failed Span style= "COLOR: #333333" >
32-bit Windows error:49:unknown Error
No more listening :(description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC)))

Step Two: View Oracle whether the listener is started

Enter DOS window, shortcut key is menu key +r, enter cmd, enter lsnrctlstatus in DOS window to view your running status, if the result is as follows:

Lsnrctl for 32-bitwindows:version 10.2.0.1.0-production on 20-9 Month -2008 10:5
0:44

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

is 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
is 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

On behalf of your listener does not start, you need to start the listener, there are two ways of booting: one is in DOS inputlsnrctl Start,You can do it. Another way is: computer à management à service à find Oracle's self-service, find Oracleoradb11g_home1tnslistener, click to start on it.

Third: Reset the Listener, and configure the local network name

  My computer is window 7 oracle install directory, find net Configuration Assistant after opening, configure. The main configuration is implemented by Oracle's own management tools, such as:


The pictures here are online search, but I used the method, because then the problem is really a lot, changed several ways. More knowledge friends can search my public platform: Shepherd Flute Assistant, account number: Mudi_assistant, recently started to build, intends to share the study of the case has a variety of problem solving methods. Sweep two-dimensional code:



Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Connect Oracle times Error Ora-12541:tns with Plsql: No listener

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.