Re: How Can I Logon to the Local Node Using UID/PWD@SID Syntax?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/06/02
Message-ID: <r38ejsoo46p8k41r0cjs1knd62flb24o56@4ax.com>#1/1

On Thu, 01 Jun 2000 19:33:50 GMT, dhmac_at_my-deja.com wrote:
>HP-UX(SI): sqlplus user1/user1_at_MYDB_DEV
 

><Successful connection to dev database>
 

>But if I try to logon to the instance on the local server, I get an
>error:
>
>HP-UX(SI): sqlplus user1/user1_at_MYDB_SI
>
>ORA-12154: TNS:could not resolve service name
><snip>
>Is there some option I can set to allow logins using UID/PWD_at_SID syntax?

No. The reason you can connect to MYDB_DEV is undoubtedly because in your server's tnsnames.ora file you have MYDB_DEV defined. You should be able to define MYDB_SI as well (in tnsnames.ora), and then you should be able to connect using it.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Jun 02 2000 - 00:00:00 CDT