Skip to Main Content

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!

listener.ora and tnsnames.ora file location

user130038Mar 18 2014 — edited Mar 19 2014

Hello

env: Oracle 11gR2 - on Orable Linux 6.2 64bit

I configured a database server for the client. I installed GI and the RDBMS home as per Oracle standards. Then I configured the listener to run fro the GI home. So the location of the "tnsnames,ora" and "listener.ora" files is $GI_HOME/network/admin.

Client's DBA is asking me to comply with their standard for the location of these two file. Here is what he is asking for:

    /opt/oracle/           owner = oracle, group = dba  (permissions 755)

    /var/opt/oracle     owner = oracle, group = dba  (permissions 755)

  • - touch /var/opt/oracle/listener.ora
  • - touch /var/opt/oracle/tnsnames.ora
  • - chown oracle:dba /var/opt/oracle/listener.ora
  • - chown oracle:dba /var/opt/oracle/tnsnames.ora
  • - ln -s /var/opt/oracle/tnsnames.ora /etc/tnsnames.ora
  • - ln -s /var/opt/oracle/listener.ora  /etc/listener.ora

I am completely lost here. I don't know if I move these two files to the "/etc" folder, how will the LISTENER know about the presence of these files in "/etc".

His reason for this is to support possibility of having multiple Oracle RDBMS homes. I don't know what he is talking about.

Please advise.

Best regards

This post has been answered by EdStevens on Mar 19 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2014
Added on Mar 18 2014
11 comments
4,803 views