SEO

Hi,

recently upgraded from Oracle 8.1.7 to 9.2 on Solaris 9 and I'm having
some problems. One of our applications won't start if I start Oracle
as an oracle dba (gid is dba). There seems to be some issue there

If I start Oracle is a member of the dba group but has a different
active group the application will start but I get errors when trying
to stop the database as a dba. I start sqlplus with the /nolog switch
and connect as sysdba (sys). First of all sqlplus tells me I'm
connected to and idle instance and then...


shutdown immediate

gives me the following errors:
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-27140: attach to post/wait facility failed

If I try to force a startup it gives me the following error:
ORA-01031: insufficient privileges


It's the same way if I do it the other way around... that is if i
start oracle with a user that has gid=dba and try to shut it down with
a user that is just a member of the dba group i get the same errors.

Anyone have any ideas?

Could you connect via SQL*Net as a user with 'sysoper' privilege
(you'll need a password file and 'grant sysoper to <user>') ?


Also, for your example, check that the 'sticky' bit is set on the user
and group execution bit for the required oracle binaries so that all
processes that run oracle use the same memory

e.g. one of them is this:

-rwsr-s--- 1 oracle dba 69198144 Nov 22 13:12 oracle

Go into the oracle home bin directory and do an ll ... look at the info
for the oracle executable ( what user and group it belongs to and the
permissions ). Post your results if you need more help otherwise you
can probably figure it out.

This is what I get:

-rwsr-xr-x 1 oracle dba 69785384 Feb 1 15:50 oracle

All the binaries looks to have the same permissions set.

Danos wrote:
> This is what I get:
>
> -rwsr-xr-x 1 oracle dba 69785384 Feb 1 15:50 oracle
>
> All the binaries looks to have the same permissions set.

Looks a little different seems like it should be -rwsr-s--r (hint) that
should explain why your startup/shutdown are misbehaving.

Did you run root.sh during the install? If so why are your permissions
kind of wacko?

Sorry of course it is really -rwsr-s--x (typo).

"hpuxrac" <johnbhurley@sbcglobal.net> wrote in message news:<1107974164.046289.142420@c13g2000cwb.googleg roups.com>...
> Sorry of course it is really -rwsr-s--x (typo).

To tell you the truth I didn't actually do the upgrade, I'm just stuck
with the job of getting everything to work afterwards. But changing
the permissions on the oracle binary worked like a charm... thanks to
both of yas