Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Database Link
You might try creating the links manually via SQL. The syntax is as follows:
Create [public] database link db_link_name connect to user_name identified
by password using 'k52';
then test the link - try;
select count(*) from user_tables_at_db_link_name
Unless the link is public which is an optional flag the link will only be accessable to the user who created it. If other users try to use the link they will get an error message.
HTH, Robert
"Steve ." <syarbrou_at_nospam.enteract.com> wrote in message
news:ei3jks06fafd3f64mlpuidd90qpobpbl4g_at_4ax.com...
> I'm trying to create a database link between two database instances on
> the same server. Running a Sun box with Oracle 8.1.5i. It keeps
> saying the Dabase Link is not active. Here is what I've tried:
>
> The instances are called k51 and k52.
>
> 1. Went into Net8 Assistant. Two service names already exist, one
> for each instance. They are k51 and k52 like the instance names.
> Both test successfully.
>
> 2. Open OEM Console. Create database link. Enter k52link as the
> name, set to fixed user with the appropriate login info for k52
> database, and set the service name to k52.
>
> 3. Edit the Init Parameters and the global_names variable is set to
> False already on both instances.
>
> 4. Go back to the link I created and test it. Says the database link
> is not active.
>
> What have I missed? I've looked high and low and all the references
> to this seem to assume it will work as there is no troubleshooting
> listed. Thanks for the help.
>
> Steve
>
> Newsgroup replies preferred. Remove nospam when replying thru email.
Received on Fri Jun 23 2000 - 00:00:00 CDT