Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tns_Admin

N_RajFeb 19 2014 — edited Feb 20 2014

Hi,

Tns admin variable is placed in different location.

First One :

[grid@lm-55 /OCR/network/admin]$ srvctl getenv database -d P06

P06:

ORACLE_BASE=/u01/app/oracle

TNS_ADMIN=/OCR/network/admin

Second One

[grid@lm-55 /OCR/network/admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-FEB-2014 10:50:48

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                29-MAY-2013 15:15:18
Uptime                    265 days 19 hr. 35 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /u01/11.2.0.3/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/lm-55/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.17.158)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.17.159)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM3", status READY, has 1 handler(s) for this service...
Service "P06.IKEADT.COM" has 1 instance(s).
  Instance "P063", status READY, has 1 handler(s) for this service...
Service "PP06XDB.IKEADT.COM" has 1 instance(s).
  Instance "P063", status READY, has 1 handler(s) for this service...
Service "p06.IKEADT.COM" has 1 instance(s).
  Instance "P051", status READY, has 1 handler(s) for this service...
Service "PPOTM.IKEADT.COM" has 1 instance(s).
  Instance "P063", status READY, has 1 handler(s) for this service...
Service "POT0.IKEADT.COM" has 1 instance(s).
  Instance "P051", status READY, has 1 handler(s) for this service...
Service "POT0AP.IKEADT.COM" has 1 instance(s).
  Instance "P051", status READY, has 1 handler(s) for this service...
Service "POT0PA.IKEADT.COM" has 1 instance(s).
  Instance "P051", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@lm-55 /OCR/network/admin]$

Which one right one?

is there any problem If tns_admin variable not set in grid user(srvctl),Why do we need to set in grid user?

Does ASM instance connect DB instance by TNS_ADMIN?Is it right?

Br,

Raj

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2014
Added on Feb 19 2014
3 comments
418 views