Lorri, you might try:
conn lorrif/your_pw_at_tsta
create public database link try3 connect to tele identified by
telea using 'PAPR.world';
where PAPR.world refers to the servicename entry in tnsnames.ora of the Sun
you're
logged on to.
Mike.
Lorri <cole0821_at_fyiowa.infi.net> wrote in article
<3415D8C2.41C5_at_fyiowa.infi.net>...
> I have been attempting to create a database link between 2 servers on my
> network. Here is the stats on the servers and the code that I have been
> entering. Does anyone have any suggestions as to what I am doing wrong.
>
> THANKS IN ADVANCE FOR ANY HELP YOU CAN GIVE !!!
>
> 9/9/97
>
> SID TSTA on SUN --
> SQL*Plus: Release 3.3.2.0.2 - Production on Tue Sep 09 16:02:41 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the parallel query option
> PL/SQL Release 2.3.3.0.0 - Production
>
>
>
> SID PAPR on DEC/ALPHA --
> SQL*Plus: Release 3.3.2.0.2 - Production on Tue Sep 09 16:03:20 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.3.2.3.2 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.3.2.3.2 - Production
>
>
> I can connect to both instances from my PC using SQL*PLUS -
>
> logged into the TSTA instance via SQL*PLUS on the SUN & did the
> following:
> SQL> conn lorrif_at_tsta
> Enter password: *****
> Connected.
> SQL> create public database link try2 connect to tele identified by
> telea using '(DESCRIPTION=(ADDRESS_LIST =
> (PROTOCOL=TCP (HOST=128.71.3.19) (PORT=1521)))
> (CONNECT_DATA = SID=PAPR.world) (SERVER=SHARED)))';
>
> Database link created.
> SQL> select * from sys.dba_db_links where db_link like 'TR%';
>
> OWNER
> ------------------------------
> DB_LINK
>
> USERNAME
> ------------------------------
> HOST
>
> CREATED
> ---------
> PUBLIC
> TRY2.CRIS
> TELE
> (DESCRIPTION=(ADDRESS_LIST =
> (PROTOCOL=TCP (HOST=128.71.3.19) (PORT=1521)))
> (CONNECT_DATA = SID=PAPR) (SERVER=SHARED)))
> 09-SEP-97
>
>
>
> SQL> select username from sys.dba_users_at_TRY2.CRIS where
> 2 username like 'T%';
> select username from sys.dba_users_at_TRY2.CRIS where
> *
> ERROR at line 1:
> ORA-12154: TNS:could not resolve service name
>
> SQL> conn tele_at_papr
> Enter password: *****
> Connected.
> SQL> select username from sys.dba_users where username like 'T%';
>
> USERNAME
> ------------------------------
> TELE
> TEST
> THOMASONN
> THOMSL
> TRAIN
>
>
> ALSO TRIED :
>
> SQL> create public database link try3 connect to tele identified by
> telea using '(DESCRIPTION=(ADDRESS_LIST =
> (PROTOCOL=TCP (HOST=128.71.3.19) (PORT=1521)))
> (CONNECT_DATA = SID=PAPR.world) (SERVER=SHARED)))';
>
> Database link created.
> OWNER
> ------------------------------
> DB_LINK
>
> USERNAME
> ------------------------------
> HOST
>
> CREATED
> ---------
>
> PUBLIC
> TRY3.CRIS
> TELE
> (DESCRIPTION=(ADDRESS_LIST =
> (PROTOCOL=TCP (HOST=128.71.3.19) (PORT=1521)))
> (CONNECT_DATA = SID=PAPR.world) (SERVER=SHARED)))
> 09-SEP-97
>
> SQL> select username from sys.dba_users_at_try3.cris where
> 2 username like 'T%';
> select username from sys.dba_users_at_try3.cris where
> *
> ERROR at line 1:
> ORA-12154: TNS:could not resolve service name
>
>
>
> 12154, 00000, "TNS:could not resolve service name"
> // *Cause: The service name specified is not defined correctly in the
> // TNSNAMES.ORA file.
> // *Action: Make the following checks and correct the error:
> // - Verify that a TNSNAMES.ORA file exists and is in the
> proper
> // place and accessible. See the operating system specific
> manual
> // for details on the required name and location.
> // - Check to see that the service name exists in one of the
> // TNSNAMES.ORA files and add it if necessary.
> // - Make sure there are no syntax errors anywhere in the
> file.
> // Particularly look for unmatched parentheses or stray
> characters.
> // Any error in a TNSNAMES.ORA file makes it unusable. See
> // Chapter 4 in the SQL*Net V2 Administrator's Guide. If
> // possible, regenerate the configuration files using the
> Oracle
> // Network Manager.
> oracle%
>
>
>
>
> I verified after this that I could still connect via SQL-PLUS - can
> connect OK
>
>
> HERE IS THE CHUNK OF THE TNSNAMES.ORA FILE ON MY PC:
> papr.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = CHAMELEON)
> (PROTOCOL = TCP)
> (HOST = 128.71.3.19)
> (PORT = 1521)
> )
> (ADDRESS =
> (COMMUNITY= tcp.world)
> (PROTOCOL = TCP)
> (Host = 128.71.3.19)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = papr)
> )
> )
>
>
>
>
> HERE IS THE CHUNK OF THE TNSNAMES.ORA FILE on the SUN
>
> PAPR.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = CHAMELEON)
> (PROTOCOL = TCP)
> (HOST = 128.71.3.19)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = PAPR)
> )
> )
>
Received on Thu Sep 11 1997 - 00:00:00 CDT
