Re: SQLPlus, SQLPlusW crash after login

Xavier J wrote:
> The other two machines are client-only. I can't figure out, for the
> life of me, why this one is behaving badly.
>
> I did a little research since my last post, and found something on
> adding ORACLE_SID to the registry.
>
> I added a registry string value at HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,
> called ORACLE_SID. Now SQLPlusw doesn't crash, and will actually
> connect to the servicename stored in ORACLE_SID, but still crashes if I
> try any other service name. I will actually be using this box to
> connect to various service names, so I'm still wondering what the heck
> is going on -- there is no ORACLE_SID entry on my other two boxes,
> and they don't have this issue!
>
>
> G Quesnel wrote:
> > Did you try the following:
> > sqlplus /nolog
> > set instance <what ever the SID is>
> > connect <someuser>
> >
> > if the instance is on another server, then you might need to...
> > set TWO_TASK=<what ever the SID is>
> > sqlplus /nolog
> > connect <someuser>
> >
> > The other two machines where it works, are they client only also ?

Follow Daniels advice.

Or even: reinstall the complete system. The system probably is a mess, as on properly installed systems this doesn't happen. It is a problem with *your* configuration, not with Oracle !

-- 
Sybrand Bakker
Senior Oracle DBA