Re: Changing ownership of Oracle database installation

speed_at_racer.cartoon.spam.address wrote:
>
> Given an Oracle installation that was installed as owner=Oracle,
> group=dba, what steps are necessary in order to change the ownership of
> the installation to an owner other than Oracle?
>

I have *installed* Oracle for an owner != oracle with no problems. For an existing install the following 'chown -R' command will alter the owner at file level. You may also want to check any cronjobs, other scripts doing 'su - oracle'.
It will be interesting to see what Oracle would do for a 'connect internal' via sqldba or svrmgrl. If it keeps the old owner's UNIX user-id (not user login name) to identify the owner and not ask for password for such connection, then I believe, you could change 'oracle' to something else keeping the UNIX user-id the same in the password file. However, try this on a test box first and please post the results. I am tempted to try it myself too. If I get a chance to do it, I will post the results.

> Is it as simple as a 'chown -R' on the installation tree?
>
> The reason I want to do this is to "localize" the Oracle installation
> thus eliminating the need for multiple installations to use the same
> oracle login ID.
>
> Thanks in advance.
>
> Note: the 'From:' address is de-spammified. Note correct email address
> below
>
> Peace.
>
> --
> Bruce W. Hoylman (303/541-6557) -- bhoylma_at_advtech.USWest.COM ._ 0
> - __0 Speaking for myself... /\/\ /\ / //\.
> - - - _-\<,_ "Please saw my legs off". /~/~~\/\/~~\ ' \>> |
> - __(_)/_(_)_____________________________/\ / \ \/\ \________\\ `_
 

-- 
Kirti Deshpande
GTE, DFW Airport      
kirtid658_at_gte.net
=======================================
Please remove all numbers from address 
=======================================