ORA-03113 end-of-file on communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-03113 end-of-file on communication channel

  1. #1
    Join Date
    Jun 2000
    Posts
    55
    The original Oracle version on this NT box is 8.0.5. Last year, a DBA installed 8.1.6 and upgraded all databases. And then applied 8.1.6.3 patch to fix some other problems. Ever since the patch installed, this end of communcation channel error started to occur.

    SQL> select distinct owner from dba_segments;

    OWNER
    ------------------------------
    BSTAR
    OUTLN
    SCOTT
    SPLASH21
    SYS
    SYSTEM
    WEBORDER

    7 rows selected. --------------------- OK.

    SQL> select extents from dba_segments;
    select extents from dba_segments
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel ----------------- NOT OK.
    --------------------------------------------------------------------------------------------
    It seems when I select the static columns of dba_segments, like owner, max_extents, the query goes through. But when I select the dynamic columns, like extents, bytes, get ORA-03113 error. Anything you can think about related to this issue will be deserved a try.

    Thank you

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You might check Metalink.

    I seem to remember there was a bug in the 8.1.6.x that was in data dictionary access that was fixed later.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    It looks like to need to run some patch... Open an iTar!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width