Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I trace hanging "connect / as sysdba"?

Re: How do I trace hanging "connect / as sysdba"?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 18 Feb 2006 21:47:50 +0100
Message-ID: <mu1fv1pjummghgedjqm3ro6vmlvqpk30pt@4ax.com>


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 DBA
Received on Sat Feb 18 2006 - 14:47:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US