Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How Can I Logon to the Local Node Using UID/PWD@SID Syntax?
You need to add an entry to your local tnsnames.ora file.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "Jonathan Gennick" <jonathan_at_gennick.com> wrote in message news:r38ejsoo46p8k41r0cjs1knd62flb24o56_at_4ax.com...Received on Fri Jun 02 2000 - 00:00:00 CDT
> 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