-
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?
-
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
-
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!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|