Hi:
I'm having problems setting up and using database link.
My create statement looks as follows:
create database link PROD connect to xuser identified by xpwd using
'TRNGPROD';
I then execute :
select * from sysadm.employees@PROD.
and get the following error:
ORA-12154: TNS:could not resolve se
Hello, Manas,
I think it's about the GLOBAL_NAME init parameter on the server
site.
Check to see if you have GLOBAL_NAME set to TRUE where PROD points
to.
Be very careful about GLOBAL_NAME, coz when it set to be TRUE, then
you are using DB_NAME.DB_DOMAIN instead of just th
;Manas Dasgupta"
fsfhq.com> cc:
Sent by: Subject: Problems with database link -
8.1.6
k the Global_names parameter (as someone already
pointed out)
jack
"Manas Dasgupta"
fsfhq.com> cc:
Sent by: Subject: Problems with
database link - 8.1.6
[EM