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+
cd $ORACLE_HOME/network/admin mv listener.ora listener.sav lsnrctl stop lsnrctl start
LSNRCTL for Linux: Version 188.8.131.52.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 184.108.40.206.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