Re: simple connection to remote database for dummy ?

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Wed, 08 Nov 2000 10:20:14 -0800
Message-Id: <10674.121459@fatcity.com>

Put

dummy.world =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D id#)(PORT =3D 1521))     )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D SID)
    )
  )

in your tnsnames. You may need to append whatever your default_domain = parameter is if it isn't "world". SID should also be whatever you named = your dummy database instance. No need to reread the tnsnames file. It = reads it every time.

Then sqlplus username/password_at_dummy

The listener file should have the same SID in its SID_LIST. You can force = the listener to reread its file by doing a reload from lsnrctl.

I'm no expert so I may have left something out, but this should be pretty = close.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> peter_at_schoenster.com 11/08/00 11:07AM >>> 1st, my question :) .... I need to connect from a solaris/oracle8.i to=20 another solars/oracle8.8i. I use telnet to modify any config files.=20 Oracle is running on both boxes. It seems a tnsping works:

> > tnsping ip#

>=20

> TNS Ping Utility for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production
> on 08-NOV-00 08:52:13

>=20

> (c) Copyright 1997 Oracle Corporation.  All rights reserved.

>=20

> Attempting to contact (ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dip#)(PORT=3D1521= )) OK
> (3940 msec)

I understand that the remote oracle server is up and running (as=20 opposed to a computer connected at that address)

But I cannot do this:

sqlplus username/password_at_ip#

I get this:

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given=20 in connect descriptor

and then I default to my local database.

I put this:

SID =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D id#)(PORT =3D=20 1521))

    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D SID)
    )
  )

in the tnsnames.ora but that hasn't helped. I wonder if I need to ask=20 oracle to reread that file again. I've done searches on this at orafaq=20 but found no command like Kill -HUP pid to force it to reread that=20 Received on Wed Nov 08 2000 - 12:20:14 CST