Does anyone know how to change the location of the listener.ora file on solaris 2.6.
I inherited a situation where this file was placed in a non default location (7.3.4). Ive recently installed 8.1.6 and need to set up a second listener. Unfortunatly both listeners seem to want to use the same listener.ora file.
Originally posted by mb Does anyone know how to change the location of the listener.ora file on solaris 2.6.
I inherited a situation where this file was placed in a non default location (7.3.4). Ive recently installed 8.1.6 and need to set up a second listener. Unfortunatly both listeners seem to want to use the same listener.ora file.
Any ideas?
ENV variable TNS_ADMIN points to the directory of the listener.ora. Set up different listeners if you need to. They should have different names however. Listener is the default name.
if you want 2 listeners, one 7.3.4, and the other 8.1.6, they won't ask for the same listener.ora file since this file resides in $ORACLE_HOME/network/admin, I guess you didn't change your environment
what you got to do is :
set environment for 7.3.4 (ORACLE_HOME and PATH)
start 7.3.4 listener
set environment for 8.1.6 (ORACLE_HOME and PATH)
start 8.1.6 listener
TNSLSNR for Solaris: Version 2.3.4.0.0 - Production
NL-00462: error loading parameter file /var/opt/oracle/listener.ora
NL-00427: bad list
NL-00427: bad list
If I do this for the ORACLE8 user I can start the listener.
TNSLSNR for Solaris: Version 2.3.4.0.0 - Production
NL-00462: error loading parameter file /var/opt/oracle/listener.ora
NL-00427: bad list
NL-00427: bad list
If I do this for the ORACLE8 user I can start the listener.
Strange!
:-)
Check for mismatched parenthesis in the listener.ora
If that was not the problem then it might be this: set $TNS_ADMIN to a specific directory and place the SQL*Net configuration files in that location.
Reply With Quote
Bookmarks