Re: lost oracle_sid

"osy45" <member18536_at_dbforums.com> wrote in message news:2784466.1050737166_at_dbforums.com...
>
> you can add an ORACLE_SID entry to your HOME0 registry entry as a
> default sid

From original post:
> > HOME0 registry key is still set and I can log into SQL*Plus without
> > specifying which database to use.

It's already there and SQL*Plus is using it (I can log into SQL*Plus without specifying the database and it reads the registry key to send me to the correct database). It's got to be something that EXP reads that SQL*Plus doesn't (or vice versa).

-Paul

> Originally posted by Paul Murphy
> > EXP-00056: ORACLE error 12560 encountered
> > ORA-12560: TNS:protocol adapter error
> > EXP-00000: Export terminated unsuccessfully
> >
> > Hmm, I just installed 9iDS on Windows 2000 and EXP seems to have
> > forgotten
> > which SID to use. If I specify set oracle_sid=mysid at the
> > command prompt
> > before issuing the EXP command, it works fine. I looked in my
> > tnsnames.ora
> > file and my listener.ora file and they both still have my SID
> > there. The
> > HOME0 registry key is still set and I can log into SQL*Plus without
> > specifying which database to use.
> >
> > I'm guessing that when I installed 9iDS (which is working fine),
> > it added
> > something to a config file that is making the default SID that EXP
> > is using
> > not my normal SID. Has anyone run into this? I'm running
> > everything on my
> > personal computer so I used localhost when it asked for a
> > hostname during
> > the 9iDS setup.
> >
> > Any advice would be helpful to me. If I find out the solution
> > before I get
> > an answer, I'll post it.
> >
> > Thanks,
> Paul Murphy
>
> --
> Posted via http://dbforums.com
Received on Sat Apr 19 2003 - 09:31:07 CDT