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:46:31 +0100
Message-ID: <4r1fv1tmfk2sinoro4ehp27sgqonkol6ra@4ax.com>


On Sat, 18 Feb 2006 16:16:16 +0100, "DR" <dr_at_invalid.address> wrote:

>
>> Usually, this fails with network errors (there's
>> no networking involved, but anyway), which indicate
>> services are not started.
>> Or with authorization failures, indicating you use
>> a different account, or you have sqlnet.ora wrong.
>> Just "hangs" are rare... Some thoughts:
>> - firewall?
>
>"no networking involved, but anyway" -> "sqlnet.ora" -> "firewall"?
>
>Could you elaborate?
>
>Regards,
>Dimitre
>

sqlnet.ora is at least read always, even with bequeath connections. firewall problems typically result in either ora-12535 or ora-12545.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Feb 18 2006 - 14:46:31 CST

Original text of this message

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