Ask the Expert

Trouble with database links

I had two instances set up on a Sun 450 server, with one as the master and one as the snapshot database. They were set up as follows.

 
 DB1 - master			DB2 - snapshot
 db_name = db1			db_name = db2
 db_domain = te.com		db_domain = te.com
 instance_name = db1		instance_name = db2
 service_names = db1.te.com	service_names =
 db2.te.com
 global_names = TRUE		global_names = TRUE
I was able to set up replication, using refresh groups and all was working fine. When I created a database link, I would check with
 SELECT * FROM
 dba_db_links 
and find the DB_LINK column was link_name.te.com. This was true in both instances and communication worked both ways.

We got a second Sun 450, so I re-created DB1 on that server, all parameters the same. When I went to reset replication, everytime I made a database link, the DB_LINK comes in as link_name.world. There is no sqlnet.ora file in use. The listener.ora file is very plain and tnsnames.ora has entries of the form;

 DB1 =
   (DESCRIPTION =
     (ADDRESS = 
       (PROTOCOL = TCP)
       (HOST = ds2.matchlogic.com)
       (PORT = 1521)
     )
     (CONNECT_DATA =
       (SID = whsp)
     )
   )
 
What is causing the database links to be created differently and stopping my replication?


    Requires Free Membership to View

The difference lies in your DB_DOMAIN parameter. It defauls to ".world". You will want to make sure that this is set correctly for your environment.

For More Information


This was first published in June 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: