Hi ,

I was able to find a Note on the metalink site which helped me solve the problem.

Below is the copy of the need. Thought it might be useful.

Thanks
Anurag


Problem Description
-------------------
You're trying to log on to a local oracle database on a windows based
(winNT/winn2000) server and you receive ORA-3113.

Solution Description
--------------------
Make sure you do not have
SQLNET.AUTHENTICATION_SERVICES=(NTS)
in the sqlnet.ora if you're connected to the machine as a domain user but
there is currently no network connection. This is very common on laptops that
are normally used in a networked environment but used standalone as well.

Explanation
-----------
If you log on to a winNT or win2000 machine as a domain user but there is
currently no network connection, you will still be logged on to the machine
if you've been logged on before. Windows will use cached credentials to check
your username/password etc.
If you've got SQLNET.AUTHENTICATION_SERVICES=(NTS) set in your sqlnet.ora
you're asking oracle to authenticate you with the domain server when you log
on to oracle.
This combination of things can lead to oracle trying to ask the NT domain
controler to validate you when there is no actual network connection, the
result is an ORA-3113 error.