This content has been marked as final. Show 2 replies
user8643895 wrote:There is no relationship between the listener and ORACLE_SID. The current value of ORACLE_SID has zero bearing on the listener.
I am getting following error when i start the oracle database lisner
this is how i start the database listner
+[ora112@localhost admin]$ echo $ORACLE_SID+
+[ora112@localhost admin]$ lsnrctl start JIPDB+
Further, one single listener, using the default name of LISTENER and the default port of 1521 is quite capable of - WAS DESIGNED TO - service multiple database instances of multiple versions running from multiple homes. Even implying that there is some sort of one-to-one relationship between listener and database instance (by naming the listener the same as the database) really makes as much sense as the telephone company identifying a particular switchboard by the name of one particular customer. As you have discovered, it only complicates matters.
Do the following:
cd $ORACLE_HOME/network/admin mv listener.ora listener.sav lsnrctl stop lsnrctl start
LSNRCTL for Linux: Version 220.127.116.11.0 - Production on 27-DEC-2012 02:09:29
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /opt/oracle/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 18.104.22.168.0 - Production
System parameter file is /opt/oracle/11.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/localhost/kmsdb/alert/log.xml
TNS-01151: Missing listener name, JIPDB, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
But i have configured lisner JIPDB in listner.ora file, this is how i have configured it
+(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1531))+
please help me to understand, why i am getting this error message
Edited by: user8643895 on Dec 27, 2012 1:16 AM
Edited by: user8643895 on Dec 27, 2012 1:17 AM
Edited by: user8643895 on Dec 27, 2012 1:18 AM