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

Thread: Tnsnames.ora

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi

    When we look into tnsnames.ora

    seed.dbasupport.com = -- what is this called as
    (DESCRIPTION = (seed.dbasupport.com)
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = 166.55.555.55)
    (PORT = 1521)
    )
    )
    (CONNECT_DATA =
    (SID = seed) - I know that this is the data base name .


    )


    should seed.dbasupport.com and sid should be same .When these names are created .

    when we connect to database we connect it by userid/password@host string ----------
    the host string refers to seed.dbasupport.com or sid name


    Thanks
    lnreddy
    html code is off

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    >should seed.dbasupport.com and sid should be same .
    Do they have to be? No. Should they? That is a matter for personal preference. I prefer they are the same.

    >When these names are created .
    The SID is created when you create the database. seed.dbasupport.com is just an alias. You create the alias when you are ready to have clients connect to the database.

    >when we connect to database we connect it by >userid/password@host string ----------
    >the host string refers to seed.dbasupport.com or sid name
    sqlplus system/manager@seed.dbasupport.com (in most cases. You can mess around with your sqlnet.ora file and specify that dbasupport.com is your default domain thereby bypassing the need to put dbasupport.com for every connect.)
    Jeff Hunter

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