TNS_ADMIN effects to check listener.ora if not set properly.
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > lsnrctl
LSNRCTL
for Solaris: Version 10.2.0.4.0 - Production on 23-JAN-2012 12:11:15
Copyright
(c) 1991, 2007, Oracle. All rights reserved.
Welcome
to LSNRCTL, type "help" for information.
LSNRCTL>
status LISTENER_AMSS
TNS-01101:
Could not find service name
LSNRCTL>
LSNRCTL>
status LISTENER
Connecting
to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS
of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start
Date
20-SEP-2011 13:14:34
Uptime
124 days 22 hr. 57 min. 1 sec
Trace
Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener
Parameter File /var/opt/oracle/listener.ora -à Empty file
Listener
Log File
/app/oracle/amsshome/10.2.0.4/network/log/listener.log
Listening
Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pacdceblprdd1)(PORT=1521)))
Services
Summary...
Service
"AMSS" has 1 instance(s).
Instance "AMSS", status READY, has 1 handler(s) for this service...
Service
"AMSS_pacdceblprdd1" has 1 instance(s).
Instance "AMSS", status READY, has 1 handler(s) for this service...
Service
"AMSS_pacdceblprdd1_XPT" has 1 instance(s).
Instance "AMSS", status READY, has 1 handler(s) for this service...
The
command completed successfully
LSNRCTL>
exit
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > echo $SHELL
/bin/bash
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > echo $TNS_ADMIN
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > export
TNS_ADMIN=/app/oracle/amsshome/10.2.0.4/network/admin
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > echo $TNS_ADMIN
/app/oracle/amsshome/10.2.0.4/network/admin
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > lsnrctl
LSNRCTL
for Solaris: Version 10.2.0.4.0 - Production on 23-JAN-2012 12:46:26
Copyright
(c) 1991, 2007, Oracle. All rights reserved.
Welcome
to LSNRCTL, type "help" for information.
LSNRCTL>
exit
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > lsnrctl status LISTENER_AMSS
LSNRCTL
for Solaris: Version 10.2.0.4.0 - Production on 23-JAN-2012 12:46:48
Copyright
(c) 1991, 2007, Oracle. All rights reserved.
Connecting
to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=24.40.26.83)(PORT=1521)))
STATUS
of the LISTENER
------------------------
Alias
LISTENER_AMSS
Version
TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start
Date
02-SEP-2011 20:56:59
Uptime
142 days 15 hr. 49 min. 49 sec
Trace
Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener
Parameter File
/app/oracle/amsshome/10.2.0.4/network/admin/listener.ora à listener.ora file from
$ORACLE_HOME/network/admin directory
Listener
Log File
/app/oracle/amsshome/10.2.0.4/network/log/listener_amss.log
Listening
Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=24.40.26.83)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services
Summary...
Service
"AMSS" has 1 instance(s).
Instance "AMSS", status UNKNOWN, has 1 handler(s) for this service...
Service
"PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The
command completed successfully
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin > ls -lart listener.ora
-rw-r--r--
1 oracle dba
513 Jul 16 2009 listener.ora
pacdceblprdd1
/app/oracle/amsshome/10.2.0.4/network/admin >
If TNS_ADMIN is not set, it will be search in below sequence:
1)/home/tnsnames.ora(listener.ora)
2)/etc/tnsnames.ora (listener.ora)
3) $ORACLE_HOME/network/admin/tnsmaes.ora (listener.ora)
Thanks, saved my day!
ReplyDelete