Thursday, June 16, 2011

How to change Oracle user ORACLE_HOME

We have to change our ora user $ORACLE_HOME from /u02/oracle to /u02/oracle/11.1.0. Here are steps which I have followed and done this.

1. Run adpreclone.pl on dbtier as oracle user
perl adpreclone.pl dbTier
2. Shutdown down database and listener.
3. mv all files from /u02/oracle to /u02/oracle/11.1.0
4. run adcfgclone.pl for binaries only to avoid db creation
perl adcfgclone.pl dbTechStack
It will ask you certain info, please provide it accordingly.
5. update profiles from $OH/appsutil/install/
sqlplus "/ as sysdba" @adupdlib.sql so
6. change directory to $OH/appsutil/clone/bin
perl adcfgclone.pl dbconfig $OH/appsutil/context_file.xml
7. run autoconfig on appstiers too.
8. Start all services and check.
 
 
Apps Dba Free Lance

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.