Oracle Database Discussions

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!

Figuring out location of tnsnames.ora and listener.ora file.

557564Jul 14 2008 — edited Jul 14 2008

Hello.

Is there a way to figure out what my oracle instance is reading in terms of tnsnames.ora and/or listener.ora file? According to the 10g docs, they can be found in a few places:

1. $ORACLE_HOME/network/admin
2. $TNS_ADMIN
3. in a global configuration directory, on solaris it is /var/opt/oracle.

How would I know which one my instance/lsnrctl is reading, aside from checking out differences in behavior?

Plus, how would I change where to look for the file?

thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2008

Added on Jul 14 2008

#general-database-discussions

2 comments

725 views