Operating System - HP-UX
1748080 Members
5142 Online
108758 Solutions
New Discussion юеВ

Re: The UID of oracle processes has been changed!

 
SOLVED
Go to solution
Sean Park_2
Occasional Contributor

The UID of oracle processes has been changed!

I've run oracle DB with two instances at the same program.
That DB was installed with the user oracle8 and then I added another instance with the user uniora8.
There were 2 instances for 2 users - I used in this condition during several months.
But! It was yesterday that I found that all the oracle processes were running with the user oracle8, not uniora8! There were still 2 instances but... the same user!
And.. what a funny thing goes like this..
The UIDs of those processes are all oracle8 from the command 'ps -ef', but they're normal with the view from 'top'(sorry, I don't have glance or something..) - the UIDs are 'uniora8'!

What happened with my DB or server?

Thank you for any help. May God bless you.
5 REPLIES 5
Jean-Luc Oudart
Honored Contributor
Solution

Re: The UID of oracle processes has been changed!

I guess both oracle8 abd uniora8 are members of the dba group (default oracle dba group)

Therefore both users can start/stop the other instance.

You can check the audit file.
$ORACLE_HOME/rdbms/audit
check for the last file(s) *.aud
It gives you the user, the instance name and the action.

regards,
Jean-Luc
fiat lux
KapilRaj
Honored Contributor

Re: The UID of oracle processes has been changed!

do they have the same "id" number ? i.e.

cat /etc/passwd |cut -f 2 -d: |egrep "uniora8|oracle8"

Kaps
Nothing is impossible
Sean Park_2
Occasional Contributor

Re: The UID of oracle processes has been changed!

Thank you Jean and Kapil.
But.. each instances have been started by each users - one by oracle8 and one by uniora8. I checked it as Jean memtioned.
And.. those users have not the same UID in /etc/passwd.

Ravi_8
Honored Contributor

Re: The UID of oracle processes has been changed!

Hi,

tell me how did you created an instance using uniora8? since you have installed oracle using oracle8, only this user can create instances. ofcourse you can have one or more instances running. but it must belong to same uid. I am not understanding how did you used uniora8 id for creating an instance.
never give up
Sean Park_2
Occasional Contributor

Re: The UID of oracle processes has been changed!

Thank you, Ravi.
Actually, I'm not sure whether the owner of that instance was oracle8 or uniora8. But, I've always stoped and started the second instance with uniora8 user - and it works well!
Well, I restarted that instance a few hours ago and there was no change.
What about the "FUNNY THING" that I've memtioned? The difference between those results of top and ps command - it still lasts.