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

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS Error ORA-12505

Re: TNS Error ORA-12505

From: Andrzej Rajczakowski <rajczako_at_teta.com.pl>
Date: Mon, 08 Nov 1999 10:10:51 GMT
Message-ID: <3826A16C.752A9EA@teta.com.pl>


> ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor
> Enter user-name:
>
> Due to this reason I'm also not able to create a DBLink from Oracle8
> to Oracle7 server.
> On the other hand I've successfully created a DBLink from Oracle7 to
> Oracle8 server.
>

Check SID in tnsnames.ora in $ORACLE_HOME\NETWORK\ADMIN and $ORACLE_HOME\NET80\ADMIN
Are you sure, that you have listener process running and listening on proper SID? Try invoking 'lsnrctl.exe', type 'status'... --
Andrzej Rajczakowski
TETA S.A. Received on Mon Nov 08 1999 - 04:10:51 CST

Original text of this message

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