-
Unable to use desc in oracle 9i (9.0.1.1)
Fellow brethren of the oracle tribe,
I'm new here. i'm 23 years old and am an aspiring DBA of the future, and am not one as of now.
Can anyone help me?
Well, this is my problem.
We have a windows 2000 server machine with an oracle 9i(9.0.1.1) database. it had been working perfectly fine all along.
All of a sudden this fine morning, i am able to do anything in the database, except the "desc" command.
say, i type in my sql prompt as
SQL> desc dual;
all i get is this...
ORA-03113 End-of-file communication channel
but i'm able to connect, select data from tables, generate dumps using exports and am also able to import from previous dumps.
To work things up i re-installed oracle 9i again on the machine and once again, the same problem has surfaced up.
Help me! this is very urgent.
Anyone has ideas?? i'll be thankful if any one of you gets me out of this fix.
~ Regards,
Me.
Last edited by Cut-throat; 09-12-2003 at 02:54 AM.
-
Not sure about windows but on Unix relinking oracle executables may sole the problem.
http://metalink.oracle.com/metalink/...&p_id=105136.1
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
If this is very urgent, I'd suggest to call Oracle support
immediately.
FYI: For ORA-03113, there can be a ton of possibilities.
-
This is an error "initiated" on the server side, so have a look in the server alert log to see more details on the errors -- there may also be more detailed trace files.
-
As mentioned in Oracle 9i Documentation :
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
In addition, this message could occur when any of the following statements/commands have been issued:
ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.
vishal sood
OCP 8
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|