| DBlink error [message #51635] |
Tue, 04 June 2002 04:53  |
Robin Urff
Messages: 9
Registered: March 2002
|
Junior Member |
|
|
Hi all,
This question is about oracle on Windows NT.
I had to move a database from a production server to a backup server for one day.
The production instancename is 'prod' and the backup-instance name was 'back'.
I ported requests to 'prod' through to 'back' by modifying TNSNAMES.ORA.
prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = server)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = back)
)
)
The 'back' database looked like 'prod' on the network.
Doing a tnsping to prod worked.
When I do the following:
sqlplus system@prod
*****
I would get into my backup db.
(I also gave the backup server the IP and servername of the production machine).
After switching back the following happens:
Another application using a database-link to my prod gives me the following error:
ORA-02085: database link PROD.WORLD connects to BACK.WORLD
I searched every single file I edited and I am 100% sure I put everything back in its old state.
Do database links check the instance name of the DB they connect to and do they store them?
If you can help me, please do! :)
Thanks in advance,
Robin
|
|
|
|
| Re: DBlink error [message #51638 is a reply to message #51635] |
Tue, 04 June 2002 06:00  |
Robin Urff
Messages: 9
Registered: March 2002
|
Junior Member |
|
|
Okay, I solved it!
The application connecting to my 'prod' had global_names=true in the init.ora.
I did a "select * from global_name;"
and tadaaa! There it was!
My PROD global_name was still BACK.world.
So I updated it doing
UPDATE global_name SET global_name='PROD.world';
COMMIT;
and after a test it worked.
greetings,
Robin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
