purpose of tnsnames.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: purpose of tnsnames.ora

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi

    I would like to know the purpose of tnsnames.ora .Can some explain how it contact the data base and features

    Thanks
    lnr
    html code is off

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    The TNSNAMES.ORA file describes to Net8 how to communicate with your database. It is commonly referred to as an "alias" file. Basically, you define a database and the user can refer to it using the alias. For example, If I had the following entry in my TNSNAMES.ORA file:
    DEV815NT.US =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = mydbserver)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dev815nt.us)
    )
    )

    I could access my database by:
    sqlplus system@dev815nt.us
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width