ORA-12541: TNS: No listener, set the receiver, to see who can solve this problem,

Source: Internet
Author: User
Tags time 0

After I have installed a database on XP, I can use SQL plus to log on.
However, after the machine is restarted, SQL plus cannot be used to log on.
ORA-12154: TNS: failed to parse the specified connection identifier
The database should be started and can be seen in the task.

Today, when the system user logs on with SQL plus, the error-ORA-12541: TNS: No listener is reported.

 

However, I found that when I used sqlplus to log on, I entered both the user name and password, and input the host string into orcl to report the following error,
If I only enter the user name/password and the host string is not entered, this is the case. Is this normal?

View the connection information in the console as follows:
C: \ Documents ents and Settings \ Administrator> LSNRCTL status

LSNRCTL for 32-bit windows: Version 10.2.0.1.0-production on-2011
8: 46

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

Connecting to (description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521 )))
Listener status
------------------------
Alias listener
Version tnslsnr for 32-bit windows: Version 10.2.0.1.0-produ
Ction
Start Date: 2011 22:34:20
Normal operation time 0 days 0 hours 34 minutes 25 seconds
Tracking level off
Security on: Local OS Authentication
SNMP off
Listener parameter file E: \ oracle \ 10.2.0 \ Network \ admin \ listener. ora
Listener Log File E: \ oracle \ 10.2.0 \ Network \ log \ listener. Log
Listener endpoint overview...
(Description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521 )))
Service summary ..
The Service "orcl" contains one routine.
Routine "orcl", status unknown, contains 1 handler of this service...
Command executed successfully

C: \ Documents ents and Settings \ Administrator>

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.