Friday, March 15, 2013

[RDBMS] How To Change Oracle Installation Owner

Applies to:
          Oracle Database 10g
          Oracle Database 11g
          Oracle Enterprise Manager 11gR1 and Cloud Control 12c

OS: Linux x86, Linux x86_64, Solaris (Tested). (It should work on all UNIX based systems)

Note: Before to proceed you need to stop all the services running on the Oracle Home (databases, listeners, oms, agent)

1. If you don't have the user that will be the new owner of the ORACLE_HOME created, create one. I'll use oraoem.

2. With all the services stopped, change the ORACLE_HOME's owner:

         chown -R oraoem $ORACLE_HOME/

 You will need to change your Database files owner too:

3. Edit the file (on OEM installation, you should modify the files under the OMS and the Agent home):

Original File:

After the change:

Note: On Database 11gR1 and R2 installations, the file that contains the owner is under:


4.  You will need to execute the, on OEM installation you should execute the one is on the OMS Home:

5. ON Linux installations, you will need to modify the /etc/security/limits.conf, from the last owner to the new one (oraoem)

6. With the new owner, export the environment and start the services (listener, databases, oms, agents)

Start the listener:
Start database: