"you seems to be confused between db link name and db alias name."
db alias names default to the db name if no other name is mentioned for that during the db creation. so in my case, pdsource is both the db name and db alias name.
dblink name is the name of the db link that i create between "pdsource" and "uii.world" - which i have kept as 'uii.world" keeping the global_names parameter in the pfile = true.
am i wrong somewhere??????
I'm just wondering of where this tnsnames, sqlnet.ora that you are referring to. I'm not sure if you're aware that when creating db links, the tnsnames, sqlnet that is being dealt with is the one located between two servers(source and destination) and not the client. Please correct me guys if im wrong with this.
While creating DBlink between any 2 servers the important thing to note after keeping the global_names=true is to keep the global_names parameter like either 'world' or 'us.oracle.com' or what ever u like on the both servers as same which is not in your case.So use the Alter database command and keep the global_names same on both the servers and then create the fresh DBlinks.Then only u can see the link as active.
exactly, and that is why I want prasen999 to check his sqlnet.ora parameter default_domain. Because it is the one appended to the db link name after creating the dblink.
"cudn't undstand from where did UII.US.ORACLE.COM emerge ?????????"
guys, having a doubt - i see through OEM that my database is PDSOURCE.TCSKOLKATA.CO.IN whereas it is UII.WORLD - and that's bcoz my domain name in the sqlnet.ora is TCSKOLKATA.CO.IN in one case whereas it WORLD in the other.
so can one of u plzz list me the steps of what i have to do get that domain in both the cases to be the same.