Re: HELP! The Database Link is not active.

Hi,
the Problem is in your INIT<SID>.ORA File

You must set the Parameter GLOBAL_NAMES=FALSE for default it is true.

Roger Sprague schrieb:

> How do you successfully create database links between Oracle 8 and Oracle 8?
> How do you successfully create database links between Oracle 7.3.3 and
> Oracle 8?
>
> I have just created a database link to a service name.
> LINK NAME: ORACLE8
> SERVICE NAME: DBTEST
>
> I test the service name and the test succeeds.
> I query the database on the service name and the query succeeds.
>
> "SQL> CONNECT SYSTEM/MANAGER_at_DBTEST;
> Connected.
> SQL> SELECT OWNER, TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SCOTT';
>
> OWNER TABLE_NAME
> ------------------------------ ------------------------------
> SCOTT BONUS
> SCOTT DEPT
> SCOTT EMP
> SCOTT SALGRADE "
>
> I test the database link in the Schema Manager and I recieve the error
> message.
> "The Database Link is not active."
>
> I try to run a query against the link and I recieve the message -
>
> "SQL> CONNECT SYSTEM/MANAGER;
> Connected.
> SQL> SELECT OWNER, TABLE_NAME FROM ALL_TABLES_at_ORACLE8;
> SELECT OWNER, TABLE_NAME FROM ALL_TABLES_at_ORACLE8
> *
> ERROR at line 1:
> ORA-02085: database link ORACLE8.WORLD connects to ORACLE.WORLD"
>
> Both databases are Oracle 8.
> One database resides on my pc and the other resides on a development server.
> Both databases were setup using the install program thus giving them the
> same name and same sid.
> I am using TCP/IP to connect to the remote database.
> I have tried both fixed user and connected user link options.
>
> Thank you for your help.

--
_____________________________________________________________________________
Karl-Heinz Schubert   Tel.  : +49 89  75981-245
Senior Berater    Fax   : +49 89  75981-150
Notkestraße 15
22607 Hamburg          e-mail: kschuber_at_de.oracle.com