Change ORACLE_HOME path - 19c

 - Change ORACLE_HOME path 

/oracle/app/oracle/product/19.3.0 -> /oracle/app/oracle/product/19.0.0

01. Back up existing information as root user

cd /oracle/app/oracle/product/19.3. 0/dbs

tar cvf /tmp/dbs.tar .

cd /oracle/app/oracle/product/19.3.0/network/admin

tar cvf /tmp/admin.tar .

02. Create Golden Image

su - oracle

cd /oracle/app/oracle/product/19.3.0

./runInstaller -createGoldImage -destinationLocation /oracle/app/oracle/product/19.3.0 -silent

03. Change the created image to the new path Unzip to

unzip -q db_home_2021-07-22_04-20-42PM.zip -d /oracle/app/oracle/product/19.0.0

04. Delete existing Inventory information

cd /oracle/app/oracle/product/19.3.0 /oui/bin

./detachHome.sh -silent -intPtrLoc /oracle/app/oracle/product/19.3.0/oraInst.loc

05. cat /oracle/oraInventory/ContentsXML/inventory.xml

06. .bash_profile  logout

07. Run runInstaller

cd  /oracle/app/oracle/product/19.0.0

./runInstaller -silent -ignorePrereqFailure -waitforcompletion -force \

oracle.install.option=INSTALL_DB_SWONLY \

UNIX_GROUP_NAME=dba \

ORACLE_HOME=/oracle/app/oracle/product/19.0.0 \

ORACLE_BASE=/oracle/app \

INVENTORY_LOCATION=/oracle/oraInventory \

oracle.install.db.InstallEdition=EE \

oracle.install.db.isCustomInstall=false \

oracle.install.db.DBA_GROUP=dba \

oracle.install.db.OPER_GROUP=dba \

oracle.install.db.OSBACKUPDBA_GROUP=dba \

oracle.install.db.OSDGDBA_GROUP=dba \

oracle.install.db.OSKMDBA_GROUP=dba \

oracle.install.db.OSRACDBA_GROUP=dba \

DECLINE_SECURITY_UPDATES=true

08. cat /oracle/oraInventory Check the contents of /ContentsXML/inventory.xml

09. Reflect changes in /etc/oratab

10. startup

- Note

If the message is repeatedly recorded after the operation, it is solved by restarting or relink all or alter system set "_disable_image_check" = TRUE.

(Doc ID 369260.1 Binary change is not recognized immediately)

2021-07-22T22:12:49.435670+09:00

WARNING: Oracle executable binary mismatch detected.

 Binary of new process does not match binary which started instance

issue alter system set "_disable_image_check" = true to disable these messages

2021-07-22T22:15:01.458988+09:00

WARNING: Oracle executable binary mismatch detected.

 Binary of new process does not match binary which started instance

issue alter system set "_disable_image_check" = true to disable these messages