Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help with SQL / TNS

Re: Please help with SQL / TNS

From: <cary_at_nams.net>
Date: Thu, 08 Oct 1998 19:26:41 GMT
Message-ID: <6vj3lh$k4p$1@nnrp1.dejanews.com>


In article <6vi90n$eum_at_sdaw04.seinf.abb.se>,   "Gus" <infbog1_at_ato.abb.se> wrote:
> Please help a Oracle newbie.
>
> I having trouble to connect to one of my Oracle7 NT servers
> I get ORA-12505 (TNSlistner:listner could not resolve SID name) when trying
> to connect with SQL_Plus.
> I checked SID name on the server, the servicename in NT and the instance
> name itself. It's the only instance on the server. I can connect on the
> server itself with SQL_PLUS but not remotly. TNS Easy Net is setup correctly
> (as far as I can se)
> I can connect to the first server (uniqe database alias, nodename and
> instansname) but not to server nr 2.
> Server nr 2 is responding to TNSping.
> The database is build with a full exportfile from server nr 1, the instance
> name is diffrent from the first server. (nr 2 i i thought to be a test
> server)
> I'm aware that Ii probably have the answer right in front of me ;-) but i
> can't find it.
> Any suggestions are welcome.
>
> /Gus
>
>

Hi, Gus,

     You might have a look at the post "Help!-Sql-Net8 simple Problem? ORA- 12505" and my response. Rob's difficulty turned out to be that names.directory_path was not set properly in the SQLNET.ORA file, so you might doublecheck this first.

                                                  Cary

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Thu Oct 08 1998 - 14:26:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US