Re: using 10 client to connect to 9 db

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 May 2005 09:55:14 -0700
Message-ID: <1115830514.295154.66330@g14g2000cwa.googlegroups.com>

barneytoe wrote:
> Thanks Niall.
>
> The listener that responds to me is mydev.world, so when I use
> "mydev.world" with sqlplus I get this error:
>
> ORA-12154: TNS: could not resolve the connect identifier specified.
>
> chris

Modify your tnsnames.ora entry as follows then try again. If not successfull then post contents of listener.ora and sqlnet.ora files.

mydev.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 1.2.3.4) // not the actual IP of course
          (Port = 1521)
        )

    )
    (CONNECT_DATA =
       (SERVICE_NAME = mydev)
    )
)

Regards
/Rauf Received on Wed May 11 2005 - 11:55:14 CDT