DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: ORA-00603: ORACLE server session terminated by fatal error

  1. #1
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65

    ORA-00603: ORACLE server session terminated by fatal error

    We have two solaris unix box. The query is successful in one solaris and it is failing in another solaris box

    What parameter need to change

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    can u show some info in the alert and trace files dear
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65
    Once I get this error immediately the mount points are full which is using temporary tablepsace

    ORA-01114: IO error writing block to file 270 (block # 75048)
    ORA-27063: skgfospo: number of bytes read/written is incorrect

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well if the filesystem is full, you will get errors - fix your space problem

  5. #5
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65
    when i run the same query in another solaris box, it is not getting full
    Last edited by pmsuper; 10-17-2006 at 05:08 AM.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    so? your space is getting full - thats the problem - fix it

  7. #7
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65
    When I run the same query the space is not getting full in another solaris

    It is giving different result in two solaris unix box

  8. #8
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    did u print/show the query yet?
    Behind The Success And Failure Of A Man Is A Woman

  9. #9
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65
    You want scriippt ?

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look, your disk is full - sort that out

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