+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Hybrid View

  1. 10-17-2006 01:37 AM #1
    pmsuper
    pmsuper is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 10-17-2006 02:30 AM #2
    yxez
    yxez is offline Advisor
    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
    Reply With Quote Reply With Quote
  3. 10-17-2006 03:29 AM #3
    pmsuper
    pmsuper is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 10-17-2006 04:28 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    well if the filesystem is full, you will get errors - fix your space problem
    Reply With Quote Reply With Quote
  5. 10-17-2006 04:55 AM #5
    pmsuper
    pmsuper is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  6. 10-17-2006 05:13 AM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    so? your space is getting full - thats the problem - fix it
    Reply With Quote Reply With Quote
  7. 10-17-2006 05:24 AM #7
    pmsuper
    pmsuper is offline Junior Member
    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
    Reply With Quote Reply With Quote
  8. 10-17-2006 05:35 AM #8
    yxez
    yxez is offline Advisor
    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
    Reply With Quote Reply With Quote
  9. 10-17-2006 06:16 AM #9
    pmsuper
    pmsuper is offline Junior Member
    Join Date
    Oct 2002
    Location
    INDIA
    Posts
    65
    You want scriippt ?
    Reply With Quote Reply With Quote
  10. 10-17-2006 08:07 AM #10
    yxez
    yxez is offline Advisor
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Quote Originally Posted by pmsuper
    You want scriippt ?
    Yes the code...is it in sqlplus?
    Behind The Success And Failure Of A Man Is A Woman
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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