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 root.sh file (on OEM installation, you should modify the root.sh 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:

 

$ORACLE_HOME/install/utl/rootmacro.sh

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

 
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:
source knowledge : http://www.solvemyissue.com/2013/03/rdbms-how-to-change-oracle-installation.html
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s