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: Rob <rob_at_ohall.com>
Date: Thu, 8 Oct 1998 19:40:33 +0200
Message-ID: <6viti4$ctg$1@goof.de.uu.net>


Correct the sqlnet.ora file
Regards Rob

Gus wrote in message <6vi90n$eum_at_sdaw04.seinf.abb.se>...
>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
>
>
Received on Thu Oct 08 1998 - 12:40:33 CDT

Original text of this message

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