Today, a database server is not logged on, reported Tns-12541:tns:no listener
Look at the listener status on the server
1. oracle@linux-34:~> lsnrctl Status
2.
3. Lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:37
4.
5.
Today, a database server is not logged on, reported Tns-12541:tns:no listenerLook at the listener status on the server
oracle@linux-34:~> lsnrctl status
lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:37
C
1. TNS-00525: insufficient privilege for operation
Started with pid=30869Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=1521)))Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12555: TNS:permission
Monitor startup error, report the following error:Lsnrctl startLsnrctl for linux:version 9.2.0.4.0-production on 06-jul-2009 14:37:59Copyright (c) 1991, 2002, Oracle Corporation. All rights
1.tns-00525:insufficient Privilege for operation
Started with pid=30869
listening on: (Description= (Address= (protocol=tcp) (host=ora11g) (port=1521))
Error Listening on: (Description= (Address= (PROTOCOL=IPC)
Very strange symptom.
Databases on the client server,It turns out that there is no problem to access other machines through IP + database name.But when I came on a business trip, I found that I couldn't access it in my book! No listening
In their own virtual machine to do experiments, suddenly found that the use of PL/SQL developer can not connect to the database, error ORA-12514, said to be monitoring does not start.First introduce the virtual machine environment: Redhat7.2+gi 12.2.
Over time, I feel that Oracle is getting more and more needed. Today, let's take a look.
For Windows 7, Oracle 10g for windows.iso,when later, setup.exe, prompt must be 4.0, 5.0, 5.1 or 5.2 actual 6.1 failed
Actually passed, I don't understand. Is
1. Use set oracle_sid=*** to jump between different versions of Oracle instances. 2. In different oracle_home may not be able to log on to Oracle instances, at this time the home under the Network/admin/sqlnet.ora is working;
I:\oracle\product\10
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.