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 adapter error...just advice, ok?

Re: TNS adapter error...just advice, ok?

From: vg <vgalan_at_personal.ro>
Date: 22 Oct 2001 03:55:03 -0700
Message-ID: <54e5e6b4.0110220255.7ae8596e@posting.google.com>


One more thing...

It seems that someone have deleted my ORA8I database!!! :-/

Do you know any method to recreate it without reinstalling ORACLE?

I go now to get myself drunk....

VG

vgalan_at_personal.ro (vg) wrote in message news:<54e5e6b4.0110212248.2c63a3df_at_posting.google.com>...
> 1. I apologize for my previous posting but I got a little frustrated
> because of this situation.
> 2. YES, it's the notorious 12560 error. I read so many postings about
> this error I assumed everybody knows it.
> 3. You may be right. I do have an ORACLE_SID registry key but only for
> my first database. My question is to what exactly should point this
> ORACLE_SID key in order to be able to create a new DB? And where
> should this key be added? ( ...\ORACLE\ALL_HOMES ? ) And of course,
> what value this key should have? ORCL?
>
> Thank you again for your time and patience...
>
> VG.
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tt0p0sh65knv10_at_corp.supernews.com>...
> > "vg" <vgalan_at_personal.ro> wrote in message
> > news:54e5e6b4.0110190629.5c32c023_at_posting.google.com...
> > > I&#8217;ll be very brief:
> > >
> > > 1. TNS adapter error when I connect as internal/oracle via svrmgrl.
> > > 2. No problem connecting to other db.
> > > 3. I&#8217;m using 8.1.6 on W2k
> > >
> > > May guess is that somehow I deleted some default settings for
> > > ORCL&#8230;How can I fix it?
> > > In my listener.ora there are only my listeners&#8230;
> > >
> > > Thank you for your time!
> > >
> > > VG
> >
> > Which error? Please always post error numbers and messages.
> > If it is 12560, you don't have an environment var/registry key ORACLE_SID
> >
> > Hth,
> > Sybrand Bakker
> > Senior Oracle DBA
Received on Mon Oct 22 2001 - 05:55:03 CDT

Original text of this message

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