When we look into tnsnames.ora
seed.dbasupport.com = -- what is this called as
(DESCRIPTION = (seed.dbasupport.com)
(PROTOCOL = TCP)
(HOST = 166.55.555.55)
(PORT = 1521)
(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
html code is off
>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 email@example.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.)
Click Here to Expand Forum to Full Width