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.com