Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: lost oracle_sid
you can add an ORACLE_SID entry to your HOME0 registry entry as a default sid
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.comReceived on Sat Apr 19 2003 - 02:26:06 CDT
![]() |
![]() |