shared memory realm does not exist error

[sirron]

I have just installed Oracle 8.1.7 on a AIX box

Now I'm getting an error
when I type sqlplus at the command prompt
asked for user-name I type a user name and password
and I get this error?

ORA - 01034 Oracle not Available
ORA - 27101 shared memory realm does not exist

IBM AIX RISC system/6000
ERROR 2 No such file or Directory

Any help would be appreciated

 

[Turkbear]

Hi,
Ok, the first things to look for:

Did you follow, exactly , the system preparation requirements to set the AIX system settings?
Did you install and start a listener and a database instance?
Are your environment variables set ( ORACLE_HOME, etc)?

Any errors during the install?

 

[SantaMufasa]

Sirron,

This error often means simply that Oracle is not up and running. On a Unix box, among the ways to confirm whether Oracle is running is by issuing the command:

ps -ef | grep pmon

If you see a pmon process running (or any of the other mandatory processes running), then Oracle is up; otherwise, you must use your typical method for issuing a "startup" command to the database, such as (for Oracle 8):

svrmgrl
connect internal
startup

Let us know if this resolves your problems.

Mufasa
(aka Dave of Sandy, Utah, USA @ 15:29 (08Apr04) UTC (aka "GMT" and "Zulu"), 08:29 (08Apr04) Mountain Time)

 

[sirron]

I get this once I put in the command

oracle 12048 15034 1 22:39:43 pts/0 0:00 grep pmon

 

[SantaMufasa]

Sirron,

If those results are the only ones you received, then Oracle is down. If Oracle were up, you would see at least two lines of results...something like:

  oracle  3425     1  0   Mar 29 ?        5:10 ora_pmon_<SID_name_here>
  oracle 12048 15034   1 22:39:43  pts/0  0:00 grep pmon

So, you should next follow the protocol to startup your Oracle as I suggested, above.

Mufasa
(aka Dave of Sandy, Utah, USA @ 15:49 (08Apr04) UTC (aka "GMT" and "Zulu"), 08:49 (08Apr04) Mountain Time)

 

[sirron]

I typed in
svrmgrl
SVRMGR>connect internal
SVRMGR>startup

came up with this

LRM-00109: could not open parameter file '/u03/app/oracle/product/8.1.7/dbs/init
TEST.ora'
ORA-01078: failure in processing system parameters

 

[SantaMufasa]

There are a few ways to solve this issue (which is that your Oracle parameter file does not reside in the default location that Oracle expects to find it). Perhaps the quickest way to resolve it is to:

cd /u03/app/oracle/product/8.1.7/dbs
ln -s /<path of actual location of initTEST.ora>/initTEST.ora

...then try your "startup" command again. (The above "ln..." command creates a logical link in the ".../dbs" directory to your physical "initTEST.ora" parameter file.

Let us know how that goes.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:50 (08Apr04) UTC (aka "GMT" and "Zulu"), 09:50 (08Apr04) Mountain Time)

 

[sirron]

That worked now I'm trying to shutdown the database
its giving me this problem

any suggestion

SVRMGR> shutdown immediate
ORA-01034: ORACLE not available

 

[Turkbear]

HI,
You need to set the ORACLE_SID to your instance first.