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

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