database links between servers

From: Lorri <cole0821_at_fyiowa.infi.net>
Date: 1997/09/09
Message-ID: <3415D8C2.41C5@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 Tue Sep 09 1997 - 00:00:00 CDT