Changing location of listener.ora on solaris 2.6

Printable View

08-31-2001, 05:58 AM
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?
08-31-2001, 06:38 AM
julian

Quote:

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.
08-31-2001, 07:31 AM
pipo

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
08-31-2001, 09:25 AM
mb

I set the tns_admin variable for the oracle7 user and got this

bash$ export TNS_ADMIN=/development/usr/local/oracle/product/7.3.4/network/admin/
bash$ echo $TNS_ADMIN
/development/usr/local/oracle/product/7.3.4/network/admin/
bash$ lsnrctl start

LSNRCTL for Solaris: Version 2.3.4.0.0 - Production on 31-AUG-01 14:04:21

Copyright (c) Oracle Corporation 1994. All rights reserved.

Starting /development/usr/local/oracle/product/7.3.4/bin/tnslsnr: please wait...

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!
08-31-2001, 09:35 AM
julian

Quote:

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.