Skip to Content
avatar image
Former Member

TNSNAME of the system

Dear Team,

How can I find TNSNAME of the system ?

REgards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 12, 2009 at 01:31 PM

    If you mean TNSNAMES.ORA file , then you can look at ORACLE_HOME\NETWORK\ADMIN directory of your database server.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2009 at 02:54 PM

    Hello Rohan,

    please check sapnote #562403 - Part "5. Where can I find the Oracle Net configuration files?"

    This note also describes which format is needed to add a new entry - Part "8. What do the contents of tnsnames.ora look like?"

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2009 at 05:34 AM

    Hi Rohan ,

    For tnsnames.ora first you have to log into the Linux server with the user with which Oracle was installed (preferably) or you may login as a user who has permissions to access that file .

    The path for tnsnames .ora is $ORACLE_HOME/network/admin/tnsnames.ora

    Where $ORACLE_HOME is the directory where oracle server is downloaded

    You may check it out by entering following command

    echo $ORACLE_HOME

    Thanks ,

    Aditya

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Generally Tnsname in SAP refer to your SID of the system.

      Same can be check in the enovirnment variable of the system the value of variable dbs_ora_tnsname .

      If you are using Unix system then you have to login with ora<SID> user to get envoirnment variable for oracle user.

      Thanks and regards, Atil