Instance won't start
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Instance won't start

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Instance won't start

    Hi,

    This Morning:

    I have a server with 3 instances running(I can access all instances).

    This Afternoon:

    Tried to create a new instance but get the Oracle not available error.
    UNIX admin jacks up max number of processes and users, I can then create new instance.

    When doing a shutdown/startup, one of the instances I was able to access in the morning did not start. Tried to start manually but get

    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist

    What other parameters should I be looking at on the UNIX side?

    BTW...Connecting as internal and issuing a startup command gives me a

    SQL> startup
    ORA-24323: value not allowed
    ORA-03113: end-of-file on communication channel

    error.

    Can anybody help?

    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    82
    OOPS..

    Forgot to specify...

    Oracle 8.1.7 on UNIX 11.0

    Thanks

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    And the Shared Memory and Semaphore setting in /etc/system?
    Last edited by Calvin_Qiu; 11-28-2002 at 07:15 PM.
    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

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    actually u have to see

    what is total memory of ur o/s
    Since u say that there are 3 instances running - check the sga size.
    Keep some memory free for o/s process, working.

    also check the shared Memory and semaphore setting in /etc/system
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    Mar 2001
    Posts
    82
    Here are some of the parameters:

    maxuprc 200
    maxusers 251
    shmmax 1073741824
    shmmni 100
    shmseg 10

    semmni 70
    semmns 200

    Any other important information missing?

    What do these parameters do?

    I am new on UNIX so these are all new to me.


    Thanks

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Check out the installation guide for your platform, it will explain the parameters you require and how to calculate the values.

    http://technet.oracle.com/docs/produ...i/content.html

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  7. #7
    Join Date
    Mar 2001
    Posts
    82
    I read that..

    They really don't say much about setting the semaphores except for saying that the values should be 70 for semmni and 200 for semmns.

    Seems that this is still not enough.

    Are these numbers per instance? They don't say.

    Oracle should specify a "rule of thumb" method for calculating number of semaphores.

  8. #8
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    I think the sum of the existing instances SGA + new instance's SGA and other parameters are exceeding the Operating system allocated resources fro oracle .

    try to adjust the either kernel prameters or init.ora parameters of all the instances to fit into the system resource limits .

    I guess ur earlier instances might be still working
    u can check this by shutting down other instances and starting the enw instance which u have created .
    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