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
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.
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
Boot listener can not open, error!1[[Email protected] ~]$ lsnrctl Start2 3Lsnrctl forLinux:version 11.2.0.1.0-production on 06-aug-2014 19:40:524 5Copyright (c) 1991, 2009, Oracle. All rights reserved.6 7starting/opt/oracle/11g/bin/tnslsnr:please
This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions.
Full error message:
Ole db provider "MSDAORA" for linked server "LINKED_ORA"
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)
ORACLE encountered a TNS-04415 error with netca configuration listeningError descriptionD: \ Users \ Elvis> netcaOracle Net Services Configuration:Configuring LISTENER: LISTENERServiceAliasException: unable to save service alias: TNS-04415: file I/O
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.