19.31 RU Rollback 테스트

RHEL 9.x 환경

- 19.31 RU  Rollback 시 Error 발생

Patching component oracle.jdk, 1.8.0.201.0...
RollbackSession removing interim patch '39034528' from inventory
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk iorion ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libnnzst19.a(ccme_ck_rand_load_fileS1.o): in function `r_ck_random_load_file':
ck_rand_load_file.c:(.text+0xd4): undefined reference to `stat'
make: *** [ins_rdbms.mk:923: /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/lib/orion] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libserver19.a(jskm.o): in function `jskmCheckIMJobBCast':
jskm.c:(.text+0x202d): undefined reference to `stat'
/usr/bin/ld: jskm.c:(.text+0x2066): undefined reference to `stat'
/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libserver19.a(qmsqx.o): in function `qmsqxFetchPos':
qmsqx.c:(text.unlikely+0x1048f): undefined reference to `stat'
/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libjavavm19.a(eobtl.o): in function `eobti_create_sym_tmp_file':
eobtl.c:(.text+0x106): undefined reference to `fstat'
/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libjavavm19.a(eobtl.o): in function `eobti_digest_symbol_file':
eobtl.c:(.text+0x1b8): undefined reference to `fstat'
/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libjavavm19.a(eobtl.o): in function `eobti_build_lookup_tables':
eobtl.c:(.text+0x24ae): undefined reference to `fstat'
/usr/bin/ld: eobtl.c:(.text+0x264f): undefined reference to `fstat'
/usr/bin/ld: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib//libnnzst19.a(ccme_ck_rand_load_fileS1.o): in function `r_ck_random_load_file':
ck_rand_load_file.c:(.text+0xd4): undefined reference to `stat'
make: *** [ins_rdbms.mk:851: /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/lib/oracle] Error 1

다시 시도 

1. opatch rollback -id 39034528 -silent -no_relink 

이렇게 하면 relink 작업 수행하기 않기 때문에 rollback 까지는 잘 수행됨.

2. 그러나 이후 sqlplus 접속 시동하면  
 
sqlplus: error while loading shared libraries: libclntshcore.so.19.1: cannot open shared object file: No such file or directory

3. 기존에 있던 19.30 RU 까지 다시 Rollback 진행해 봄

opatch rollback -id 38632161 -silent

Patching component oracle.jdk, 1.8.0.201.0...
RollbackSession removing interim patch '38632161' from inventory
Make failed to invoke "/usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
genclntsh: Failed to link libclntshcore.so.19.1
make: *** [ins_net_client.mk:143: client_sharedlib] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk iorion ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: cannot find -lclntshcore
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
make: *** [ins_rdbms.mk:923: /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/lib/orion] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk iextjobo ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
make: *** [ins_rdbms.mk:1218: /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/lib/extjobo] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk igenezi ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 OPATCH_SESSION=rollback"....'/usr/bin/ld: cannot find -lclntshcore
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
make: *** [ins_rdbms.mk:1230: /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/lib/genezi] Error 1


4. 마찬가지로 no_relink 로 해야 진행이 됨.

opatch rollback -id 38632161 -silent -no_relink

---- snip -----------

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
RollbackSession removing interim patch '38632161' from inventory
Inactive sub-set patch [29517242] has become active due to the rolling back of a super-set patch [38632161].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-05-18_15-10-00PM_1.log

5. 다시 원하는 19.30 RU (38632161) 적용함. 

opatch apply /u01/install/38632161 -silent 


결론 : 

=> RHEL 9.x 환경에서는 RU rollback 작업이 원활하지 않을수 있으며, 전부 제거후 원하는 버전으로 다시 적용하는 것이 나은것으로 잠정 결론, (- applyRU 로 설치하기 때문? 인듯)