19c ORACLE_HOME 경로 변경

- ORACLE_HOME 경로 변경 
/oracle/app/oracle/product/19.3.0 -> /oracle/app/oracle/product/19.0.0

01. root 유저로 기존정보 백업

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. Golden Image 생성

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

03. 생성된 이미지를 신규경로에 압축해제

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

04. 기존 Inventory 정보 삭제

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 의 ORACLE_HOME 을 신규위치로 변경후 logout

07. 신규 위치 이동, 설치 진행
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/ContentsXML/inventory.xml 내용확인

09. /etc/oratab 변경반영

10. startup

- 참고
작업후 해당 메세지 반복적으로 기록될 경우 재기동하면 해결됨 또는 relink all 하거나 alter system set "_disable_image_check" = TRUE 로 조치가능.
(Doc ID 369260.1 Binary가 바뀐걸 바로 인식못하기 때문)

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