Home » RDBMS Server » Server Administration » Problem with .WORLD in DB links
Problem with .WORLD in DB links [message #221912] Thu, 01 March 2007 00:44 Go to next message
shahul_555
Messages: 4
Registered: February 2007
Location: India
Junior Member
Hi all,
I migrated the database from 8i to 10g. DB links which were in 8i were not created in 10g after IMPORT so I had to create it manually using scripts. DB links in 8i were in the format DB_linkname.WORLD ie., SINT.WORLD,HSDL.WORLD etc. I created the same in 10g. Now the problem is in accessing the DB links.

select * from dual@SINT;

This workds in 8i but not in 10g. Only if I give SINT.WORLD in 10g it is working. ie., select * from dual@SINT.WORLD;

Why is this happening? I cannot remove .WORLD from all the procedures and packages which uses DB links. So please suggest me a good solution. Thanks.

Re: Problem with .WORLD in DB links [message #222042 is a reply to message #221912] Thu, 01 March 2007 09:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you crosscheck the tnsentries?
Regards~
Re: Problem with .WORLD in DB links [message #222051 is a reply to message #221912] Thu, 01 March 2007 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
The problem/fix involves contents of sqlnet.ora
Re: Problem with .WORLD in DB links [message #222141 is a reply to message #221912] Fri, 02 March 2007 00:33 Go to previous messageGo to next message
shahul_555
Messages: 4
Registered: February 2007
Location: India
Junior Member
The sqlnet.ora file contains the following entries. But still I face problem with .WORLD

names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
Re: Problem with .WORLD in DB links [message #222144 is a reply to message #221912] Fri, 02 March 2007 00:46 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>names.default_domain = world
>name.default_zone = world
So what happens if 1 or both are commented out of functionality?
Re: Problem with .WORLD in DB links [message #223627 is a reply to message #221912] Fri, 09 March 2007 19:10 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
There are several things that do not live through export/import. I think db links are one of them.
I would also recommend you check that the following is valid.
your functions
your procedures
your packages
triggers
views
And the same owned by sys and system
Sometimes if you recompile these a few times they become valid. This is due to dependency.
You will probably have to drop and recreate your links. Make sure your links have a user/password on the remote db and your links has the correct passwords.

[Updated on: Fri, 09 March 2007 19:12]

Report message to a moderator

Previous Topic: Urgent !!!!do we need to apply Java DST patch on DB server
Next Topic: orphaned processes
Goto Forum:
  


Current Time: Tue Dec 06 02:24:01 CST 2016

Total time taken to generate the page: 0.05465 seconds