Re: Database Link to DB2

The problems was parameter "global_names=true" in ora.ini

Thanks to all

"massimo camporesi" <massimo.camporesi_at_gruppopro.it> ha scritto nel messaggio news:9kqtp4$238$1_at_pinco.nettuno.it...
> I'm trying to configure a database link from an Oracle 8.1.7 on Win2K to
a
> DB2 7.1 on Win NT.
>
> What I have configured:
>
> - ODBC driver for DB2 named PROGET
> - in listener.ora :
> (SID_DESC =
> (PROGRAM = hsodbc)
> (SID_NAME = PROGET)
> (ORACLE_HOME = D:\ORACLE\ORA81)
>
> - in tsnames.ora:
> PROGET.GRUPPOPRO.IT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bownt00s376)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = PROGET)
> )
> (HS = OK)
> )
>
>
> Then I created a database link with the command:
> CREATE PUBLIC DATABASE LINK 'PROGET.GRUPPOPRO.IT' CONNECT TO 'DB2ADMIN'
> IDENTIFIED BY 'DB2ADMIN' USING 'PROGET'
>
> When testing the link I get the message : 'The Database Link is not
active'
>
> Network configurations semms to be correct because, while testing, I
> register network activity on DB2 and ODBC trace registers no errors.
>
>
> Can someone help me ?
>
> Thanks
>
>
>
>
Received on Fri Aug 17 2001 - 10:28:02 CDT