Hi there!

I am about to waste an entire weekend going through kernel parameters
with a fine toothcombe, Solaris patch levels, reinstalling Oracle 9.2
on a Blade 1000 with 2Gb RAM running Solaris 2.8, etc, etc.

However before I do this can anyone tell me why the following occurs?
The Oracle install reports that it installed successfully.

Is there anyway to list the shared memory realms on Solaris?

The Oracle documentation states something like "Can not connect to
shared memory becuase the shared memory realm can not be found" or
something else blindingly obvious.. Really, really useful. Makes me
want to consider PostgreSQL.. Most Oracle books are Windows centric..
My user id on hotmail is regan_russell which gets piles of spam
already.. I don't need anymore.
-------------------------------------------------------------------------------
bash-2.03$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Aug 23 07:59:59 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: SYSMAN
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory


Enter user-name:

Shared memory segments can be looked at by
ipcs -m

ORA-1034 is often the result of incorrect protection of various Oracle
executables and directories, which is usually the result of not reading
the installation manual carefully and not running root.sh and
rootpre.sh when prompted.
The protection needs to be 755, and the suid bit of the Oracle
executable needs to be set.
Also, usually you need to set ORACLE_SID prior to connecting to Oracle.
If you don't it will assume ORACLE_SID=ORCL, and end up with ora-1034,
if you didn't set up such a sid.
Your statement about Oracle manuals being Windows centric is incorrect.
Usually it is just the opposite. Are you sure you are reading the Unix
manuals (starting from 9i, there are no separate Solaris manuals
anymore)?

--
Sybrand Bakker
Senior Oracle DBA

spam.sink@volcanomail.com wrote:
> Hi there!
>
> I am about to waste an entire weekend going through kernel parameters
> with a fine toothcombe, Solaris patch levels, reinstalling Oracle 9.2
> on a Blade 1000 with 2Gb RAM running Solaris 2.8, etc, etc.
>
> However before I do this can anyone tell me why the following occurs?
> The Oracle install reports that it installed successfully.
>
> Is there anyway to list the shared memory realms on Solaris?
>
> The Oracle documentation states something like "Can not connect to
> shared memory becuase the shared memory realm can not be found" or
> something else blindingly obvious.. Really, really useful. Makes me
> want to consider PostgreSQL.. Most Oracle books are Windows centric..
> My user id on hotmail is regan_russell which gets piles of spam
> already.. I don't need anymore.

A couple of things to suggest ...

Try running the command " ps -ef | grep ora " and this will show you if
any unix processes are running that belong to oracle.

What does the bottom of your /etc/system file look like (this has the
memory parameters).

As sybbrand noted the ipcs command will report back if you have
allocated any shared memory segments.

There are specific install docs available from oracle for 9.2 on
solaris have you followed them?

I would have to disagree about most oracle books being windows centric
it is actually the complete opposite.

Thanks for your guidence. I will apply that knowledge and see how
things go.
Perhaps I should have phrased that message differently..
It should have read most books in my local bookshop are Windows
centric.
I did not mean answerbook type books..

Thanks.

Regan.

spam.sink@volcanomail.com wrote:
> Thanks for your guidence. I will apply that knowledge and see how
> things go.
> Perhaps I should have phrased that message differently..
> It should have read most books in my local bookshop are Windows
> centric.
> I did not mean answerbook type books..
>
> Thanks.
>
> Regan.

Here is what I get from a test system. I did basically a " ps -ef |
grep knora " and got back a list of unix processes running that belong
to this database instance.

*** This system gets restored from an EMC BCV everynight then restarted
at just after midnight that's what the 00:35 column means ... oracle
has been running since then.

oracle 29507 1 0 00:35:02 ? 0:13 ora_pmon_knora1
oracle 29515 1 0 00:35:05 ? 0:54 ora_lms0_knora1
oracle 29519 1 0 00:35:05 ? 0:04 ora_dbw0_knora1
oracle 29527 1 0 00:35:06 ? 0:00 ora_reco_knora1
oracle 29513 1 0 00:35:02 ? 1:30 ora_lmd0_knora1
oracle 29523 1 0 00:35:05 ? 0:22 ora_ckpt_knora1
oracle 29517 1 0 00:35:05 ? 0:49 ora_lms1_knora1
oracle 29531 1 0 00:35:06 ? 0:14 ora_qmn0_knora1
oracle 29533 1 0 00:35:06 ? 0:00 ora_arc0_knora1
oracle 29521 1 0 00:35:05 ? 0:09 ora_lgwr_knora1
oracle 29535 1 0 00:35:06 ? 0:00 ora_arc1_knora1
oracle 29509 1 0 00:35:02 ? 1:37 ora_diag_knora1
oracle 29511 1 0 00:35:02 ? 1:19 ora_lmon_knora1
oracle 29538 1 0 00:35:07 ? 0:11 ora_lck0_knora1
oracle 29529 1 0 00:35:06 ? 0:13 ora_cjq0_knora1
oracle 29525 1 0 00:35:06 ? 0:06 ora_smon_knora1

Before you try to connect into oracle you want to know if you have any
thing running.

If you see things running ... check the setting of your ORACLE_SID and
other things like your PATH variable so see if you are prepared to
connect.

What do your results of a "ps -ef" return you?

Hi,
Now ps -ef shows a list simular the above with the knora1 replaced by
the name of my db.

I basically I uninstalled, re-did everything and did a reconfigure boot
(# touch /reconfigure ; init 6) reinstalled oracle and voila!!
Everything just worked therefore the problem was between the keyboard
and the chair...

Thanks!

Regan.

$ export ORACLE_SID='blorfo'
$ sqlplus

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Aug 26 17:01:14 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: a
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

In other words, it's quite possible you didn't have to do anything
except source your environment! (as Sybrand implied in the ORCL
comment)

jg
--
@home.com is bogus.
http://blogs.washingtonpost.com/secu..._of_zotob.html