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: ORA-12505 error?

Re: ORA-12505 error?

From: Jim Leavitt <jimll_at_halcyon.com>
Date: 1997/07/01
Message-ID: <01bc85e3$f270f250$6b203fce@kryten>#1/1

Joe

I'm running under unix, but I'll bet you have something similar under NT.

I can type:
oerr ora 12505 at the unix prompt and get the full text of any error message.

In your case the result is:

oerr ora 12505
12505, 00000, "TNS:listener could not resolve SID given in connect descriptor"
// *Cause: The SID in the CONNECT_DATA was not found in the listener's tables.

// *Action: Check to make sure that the SID specified is correct.
// The SIDs that are supported can be obtained by typing
// "LSNRCTL STATUS <service name>" and matching the SID specified in
// TNSNAMES.ORA with one of the SIDs displayed in the services summary.
/usr/home/oracle              


Jim Leavitt
jimll_at_halcyon.com

Joe Hegyi <joeh_at_netwalk.com> wrote in article <5p9c11$ejc_at_snews5.zippo.com>...
> Can someone tell me what an ORA-12505 error is? I keep getting it when I
> try to connect with Enterprise Manager to any of the databases I've made.
> Connecting to the starter database works OK. I've checked everthing in
> SQL*NET Easy Config, but don't find anything unusual. The HTML docs
 don't
> list the error code. I'm running Server 7.3 on NT 4.0, and connecting
> with
> NT Workstation 4.0.
>
> As you can tell, I'm a newbie, so any help would be appreciated! :)
>
> Thanks,
> Joe
>
>
>
>
>
  Received on Tue Jul 01 1997 - 00:00:00 CDT

Original text of this message

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