Re: error of 'Refused:ROR=(CODE=12505)(EMFI=4))))' ????

Rock - Thaaaannnnkkkkk Yyyyyoooouuu. That is great information. Where is that kept within the Oracle docs plz??? Will try it out first thing in the AM. Gil Blais

rock_cogar_at_my-deja.com wrote:

> Blais,
>
> Here is the text for error 12505:
>
> "ORA-12505: 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. This error will be returned if the database instance has not
> registered with the listener; the instance may need to be started.
>
> Action: Check to make sure that the SID specified is correct. The SIDs
> that are currently registered with the listener can be obtained by
> typing "LSNRCTL SERVICES <listener name>". These SIDs correspond to
> SID_NAMEs in TNSNAMES.ORA, or DB_NAMES in the initialization file."
>
> I suggest using "SQL*NET Easy Configuration" and/or "NET8 Easy
> Configuration" to properly setup your TNS.
>
> Email me at Rock_cogar_at_my-deja.com if you need more help.
>
> Rock Cogar
> Radian International LLC.
> Oak Ridge, TN, USA.
> In article <3869CBB8.51F7D1D9_at_mindspring.com>,
> Gil Blais <gilblais_at_mindspring.com> wrote:
> > Received this while attempting to connect to an Oracle 8.0.5 database
> > using the :thin driver in Java. Cannot find any documentation about
> this
> > and it is certainly cryptic to me. SQL Exception was " -
> > Refused:ROR=(CODE=12505)(EMFI=4))))". Any help greatly appreciated.
> Gil
> > Blais
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 30 1999 - 02:58:43 CET