Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2003
    Posts
    49

    Unanswered: shared memory realm does not exist...

    Hello everybody,
    i have this problem:
    i made an installation of Oracle 8.1.7 on a sun solaris 8. This is not ther first time i do that, so i'm used to set parameters in /etc/system, rebooting and so on...
    i choose the standard installation, that automatically should create a standard (very very standard) db instance (sid=TEST for me...). Everything is alright but when the instance is going to be created i get some errors of Oracle not available (i think this is normal because the istance is still down) but after some messages i get this:
    ORA-27101 shared memory realm does not exist

    If i go on ignoring the errors, i reach the end of the istance creation (installation completed). At this point i try through SVRMGRL (connect internal...) but i get this:
    ORA-03113: end_of_file on communication channel

    the listener is up but i can't startup the instance.

    what's happening??? i made a search on the net but i didn't find anything that could help me. i've already checked ORACLE_SID, tnsnames.ora, sqlnet.ora, listener and anything else is possible to check if there's consistence (for instance uppercase and lowercase...) but... nothing.

    Any kind of help is welcome, i'm in a very big hurry...!

    Thank you,
    Matte

  2. #2
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    any other dbs running

    Do you have any other instances running on that server? Is there an application running that would use your shared memory?
    Michellea Southern-David

  3. #3
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    metalink

    Remember to check metalink.

    http://metalink.oracle.com

    It says to check your ORACLE_HOME, ORACLE_SID, ORACLE_BASE properties.

    BTW... are you on Windows, Solaris, or Linux?
    Michellea Southern-David

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You should not get errors that Oracle is not Available during the instance
    creation. It should be connecting as internal and running proc's like
    catalog and catproc. You should try to connect to svrmgrl again ...
    exit out of the one you have running...

    svrmgrl> set instance test (instance name)
    svrmgrl> connect internal/password@instance
    svrmgrl> startup pfile = ..... if oracle comes up ... you might want
    to rerun the catalog.sql and catproc.sql procedures to get the
    Oracle tables, procs and views created ...

    HTH
    Gregg

  5. #5
    Join Date
    Aug 2003
    Posts
    49

    Re: any other dbs running

    Originally posted by msouthern
    Do you have any other instances running on that server? Is there an application running that would use your shared memory?
    no other instance running. i tried a previous custom installation, but i erased the whole installation (all the $ORACLE_BASE and there there was the whole installation, dbfiles and so on...).
    i also deleted the /var/opt/oracle/oratab (i'm using solaris)....
    i made a reboot, the the system is like a system that never saw Oracle. and no other instance are running.

    i've already checked ORACLE_HOME, ORACLE_SID, ORACLE_BASE properties and everything i could check..... and everything looks to be alright.
    the previous installation might involve some problem now, but i can't understand how....

  6. #6
    Join Date
    Aug 2003
    Posts
    49
    Originally posted by gbrabham
    You should not get errors that Oracle is not Available during the instance
    creation. It should be connecting as internal and running proc's like
    catalog and catproc. You should try to connect to svrmgrl again ...
    exit out of the one you have running...

    svrmgrl> set instance test (instance name)
    svrmgrl> connect internal/password@instance
    svrmgrl> startup pfile = ..... if oracle comes up ... you might want
    to rerun the catalog.sql and catproc.sql procedures to get the
    Oracle tables, procs and views created ...

    HTH
    Gregg
    Thank you Gregg,
    now i can't try your hint because i'm not in the office, but i will tomorrow.
    Would you be so kind to explain better the steps i have to follow?
    i mean, my SID is JANE, then:

    svrmgrl> set JANE test or set instance test (JANE)?
    svrmgrl> connect internal/password@JANE (which password? sys' password?)
    svrmgrl> startup pfile = .... (ok, here the path of pfile)
    if oracle comes up ... you might want to rerun the catalog.sql and catproc.sql procedures to get the Oracle tables, procs and views created ...
    how can i run catalog and catproc? i never did that...

    But... the big question is: what if oracle doesn't come up...???

    is it possible in any way that a previous installation involved this problem in some way? i don't think so, because i deleted ALL the $ORACLE_BASE...
    it might be something about kernel settings, but i'm using Oracle Installation manual's settings... and i did this installation plenty of times with the same values!

    Thank you very very much
    Matte

  7. #7
    Join Date
    Aug 2003
    Posts
    49

    Solution

    If smb is curious, here there's the solution:

    Standard kernel parameters suggested by Oracle didn't fit the standard PROCESSES parameter inserted in the initfile.ora by the standard instance installation. i don't understand why, because this is not the first time i made this kind of standard installation, but changing the semmns parameter (100 -> 200)... it works.

    Thank you

    Matte

  8. #8
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    I agree with matte... the /etc/system parameters that they give you in the install docs only works for the smallest of instances. that's where I'd be looking...
    drew
    ------------------
    http://wjtechnologies.com

Posting Permissions

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