i am fairly new to db administration and need some help. I am trying to create a db link to a new development box and receive the following:
ORA-02085: database link DBDEV.WORLD connects to BDOP.WORLD
BDOP = production SID and where I am trying to create the link
DBDEV = new development SID that I am trying to create a link to
Some db links were created before my involvement to TEST db on seperate box and are successful.
Steps that I have taken:
(1) Made sure that the link name is after the db that I attempt to connect to.
(2) Tried setting 'global_names = false' but received the same error.
(3) Tried creating a link from DBDEV to BDOP but received:
ORA-12154: TNS could not resolve service name
Although I have assured that each db's tnsnames.ora file is updated.
I am obviously missing something and I am not sure what. Is ther a config file that I did not update or another parameter that I need to modify? Any help would be appreciated.
Click Here to Expand Forum to Full Width