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
>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 firstname.lastname@example.org (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.)