Re: Database link creation problem

"Kevin" <kcheung_at_poboxes.com> wrote:
>I cannot create a database link for an instance that is in
 another unix box
>We're running 7.3.3 on AIX, no oracle names is used.
>
>unix box A: production instance - prd
>unix box B: 3 instances for various purposes
>
>I cannot only create db link for instances in box B to the
 production
>instance in box A. And the tnsnames.ora in box B already
 contains the
>service entry for the production instance.
>
>Does anyone know the reason?
>

It would probably be beneficial if you would post, via cut and paste, the sql and error you are getting.

In the meantime:
1) Does your link name match the database name of the target? This is a requirement that can be turned off via an init.ora parameter on the target.

2) If you link specifies an id/password combination verify that it is set up on the target database.

3) Also if you defaulted the domain name, i.e., world, you may want to verify what it is and specify it.

4) The listener must be set up and running on A for any of the instances on B to reach it, was this done?

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 19 2000 - 00:00:00 CDT