Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I trace hanging "connect / as sysdba"?
On Sat, 18 Feb 2006 14:40:56 GMT, ianal Vista
<ianal_vista_at_hotmail.com> wrote:
>"DR" <dr_at_invalid.address> wrote in
>news:43f70955$0$15786$14726298_at_news.sunsite.dk:
>
>>> There is no error - it just hangs - which I why I ask
>>> what happens at this point and how to trace it.
>>> Thank you for your input but it doesn't address the problem I have.
>>
>> Could you please post the output from the following commands:
>>
>> net start | findstr /I oracle
>> lsnrctl status <your_listener_name>
>> lsnrctl services <your_listener_name>
>> sqlplus "/@<your_tns_service> as sysdba" --> if it succeeds, if it
>> doesn't, just paste the error stack(if present)
>>
>>
>> Regards,
>> Dimitre
>>
>>
>>
>
>SQL*Net is NOT required to run an Oracle database.
Inaccurate.
Sql*net is NOT required for *LOCAL* connections.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Feb 18 2006 - 14:47:50 CST