ORA-03113 when attempting to connect to Oracle 9i instance

I have a very simple instance of Oracle (v9.2.0.1.0) installed on my laptop. By simple, I mean that I have installed nothing other than the databse and all required dependencies (no parallel server, no Intermedia, no JVM, no XML DB, etc.). My laptop is running Windows 2000 Professional, and I am attempting to connect to Oracle using SQL*Plus (v9.2.0.1.0).

During the course of debugging this problem, I've noticed the following:

While disconnected from our internal network:
- I can install Oracle w/o problems

• I can connect to my SID w/o problems using SQL*Plus

However, while connected to the network, I can do neither of the above. When I attempt to connect to my SID using SQL*Plus, I receive a generic ORA-03113 message. Through my searches on Google, I've determined that a 3113 message is pretty generic and could mean almost anything.

As far as debugging is concerned, I've changed the port number from 1521 to 2521 in both my tnsnames.ora and listener.ora file. Unfortunately, this hasn't resulted in any changes.

Apparently, I'm an Oracle novice, as I have run fresh out of ideas. Any suggestions would be greatly appreciated. Thank you! Received on Mon Oct 20 2003 - 09:43:31 CDT