Oracle processes starts with the wrong account (sidadm)

[Former Member]

Hi all,

I am running an ECC 5 test server and for some reason oracle is starting all of its processes using the sidadm account. Does anyone know as to why this is happening?

Thanks and regards,

Iqbal

[fidel_vales · Accepted solution]

probably the authorizations for the "oracle" binary are not correct, check note 583861 UNIX: Errors due to Oracle executable

[Former Member · Accepted solution]

Thanks will do and let you know

[Former Member · Accepted solution]

I disagree.

It's ok. We too are running SAP on Oracle and HP-UX IA 64.

You have to distinguish between real user id (sidadm in this case) and effective user id (orasid in this case case). For some reason HP's ps command by default shows real user id, that is the user id who started Oracle. Nevertheless effective user id is orasid.

There is a way how you can make ps to show the effective user id; I don't rember the details now. (But reading the manuals will help for sure.)

regards

[Former Member]

SAP note 592393 (33) describes this scenario.

[Former Member]

Thank you all, I was able to isolate this issue by adding the “oper” group which had to include the sidadm and orasid accounts.

Thanks,

Iqbal

[markus_doehr2]

What operating system are you running on?

Markus

[Former Member]

HP-UX IA 64

[markus_doehr2]

testsyst:fooadm> uname -a
HP-UX testsyst B.11.23 U ia64 0220029059 unlimited-user license

testsyst:fooadm> ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x   1 orafoo     dba        242790400 Apr  2 23:09 /oracle/FOO/102_64/bin/oracle

As you can see the oracle binary has the s-user bit set so no matter who starts the database, it will run effectively under ora<SID>.

Effective UIDs can be displayed by using

ps -u

(see man ps)

Markus

[Former Member]

Here is an additional situation; I started my system via the startsap from user sidadm. Now I went I initiate sqlplus from user sidadm I get connected to the database, but if I sqlplus as user orasid I am unable to see that the database is started. Can someone please shed some light on this if known?

[Former Member]

Marcus,

I partly disagree. You have to keep in mind XPG4 ps and UNIX95 ps.

look at this on one of our systems:

16:50:50 hostx sh # ps -ef | grep ora_lgwr_FOO | grep -v grep

fooadm 4928 1 0 Mar 26 ? 4:54 ora_lgwr_FOO

16:51:00 hostx sh # UNIX95= ps -ef | grep ora_lgwr_FOO | grep -v grep

orafoo 4928 1 0 Mar 26 ? 04:54 ora_lgwr_FOO

16:51:08 hostx sh #

regards

[Former Member]

Iqbal,

could you please try both versions of ps, as I showed in my previous post, i.e.

ps -ef

UNIX95 ps -ef

And for your last question:

Did you check if s-bit is set for oracle binary?

regards

[Former Member]

Hi Joe/all,

I am not at location and would certainly tey what was recommended once i am there in a few hours.

Thanks to all.

Regards,

Iqbal

[markus_doehr2]

> I partly disagree. You have to keep in mind XPG4 ps and UNIX95 ps.

yes - sure - I agree.

Markus

[markus_doehr2]

In this case I would think that the $ORACLE_SID of <sid>adm and ora<sid> are different.

Markus