Plz. Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Plz. Help

  1. #1
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52

    Unhappy Plz. Help

    Hi...


    my server has ten instances. but often nine are comin up.tenth one is not coming up.what could be the possible causes?


    Joe

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    The version of OS and Oracle? What does the Alert log file show?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    your post info cant make anyone help you

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    Hi...


    My server is solaris 8 and oracle server is 8.1.5. From the alert log I found that it is a OS related problem.

  5. #5
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    May you paste the error message here? And any relevant information?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  6. #6
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    i had a similar problem, my server has 14 instances
    just check the operating system swap space and RAM

    try to distribute SGA of all the instances so that it can fit in the O/S RAM .
    i.e reduce SGA of one instance and increase SGA of other instance all the instances would start .
    sum total of all teh SGA's may be exceeding the operating system swap or RAM area .

    hope fully this will fix
    alternative , just shut down one or two instances and start the one which is not starting .
    siva prakash
    DBA

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