반응형

[증 상]
-Oracle Linux 9.4 + Oracle DB 19c 설치 과정에서 아래와 같은 메시지 출력

 

[원 인]
Oracle Linux 9 / Redhat Linux 9인 경우 Bug 33794281 - OL9: LIBPTHREAD_NONSHARED.A IS NEEDED FOR ORACLE DATABASE 23C AND 19C 임
해당 Bug는 DB RU 19.21에서 Fix 됨

그외 OS는 Oralce MOS예서 2760289.1 문서 확인 필요

 

[처리방법]
※주의 : Oracle Linux 9 / Redhat Linux 9인 경우에만 해당, 그외 OS 및 OS버전은 Oralce MOS예서 2760289.1 문서 확인 필요

-최신 OPatch로 교체

[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd ..
[oracle@ol9 dbhome_1]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@ol9 dbhome_1]$ mv OPatch OPatch_OLD
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/
[oracle@ol9 STAGE]$ unzip -d $ORACLE_HOME p6880880_190000_Linux-x86-64.zip
Archive:  p6880880_190000_Linux-x86-64.zip
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/doc/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/bin/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/lib/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/features/com.oracle.glcm.patch.opatch-common-api-classpath.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.org.apache.xml.internal.resolver.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.oracle.glcm.patch.opatchauto-wallet_12.2.1.42.0.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.xml.bind.jaxb-jxc.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/javax.activation.javax.activation.jar
[oracle@ol9 STAGE]$
[oracle@ol9 STAGE]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.42

OPatch succeeded.
[oracle@ol9 OPatch]$

 

-최신 RU를 적용 하고 설치 작업

ex)

$ export CV_ASSUME_DISTID=OL8                          <<<<<   If performing Installation on Oracle Linux 9
$ export CV_ASSUME_DISTID=RHEL8                        <<<<<   If performing Installation on Red Hat Linux 9
$ ./runInstaller -applyRU <19.23 DBRU Patch 36233263 unzip Location> -applyOneOffs <19.23 OCW RU 36240578 unzip location>

 

[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/RU/36233126
[oracle@ol9 36233126]$ ls -al
total 144
drwxr-x---. 8 oracle dba    159 Apr 12 10:03 .
drwxr-xr-x. 3 oracle dba     45 Jun 25 13:34 ..
drwxr-x---. 5 oracle dba     81 Apr 12 10:04 36233263
drwxr-x---. 5 oracle dba     62 Apr 12 10:03 36233343
drwxr-x---. 5 oracle dba     62 Apr 12 10:03 36240578
drwxr-x---. 4 oracle dba     48 Apr 12 10:04 36383196
drwxr-x---. 4 oracle dba     48 Apr 12 10:04 36460248
drwxr-x---. 2 oracle dba   4096 Apr 12 10:08 automation
-rw-rw-r--. 1 oracle dba   5824 Apr 12 19:44 bundle.xml
-rw-r--r--. 1 oracle dba 132988 Apr 16 21:15 README.html
-rw-r--r--. 1 oracle dba      0 Apr 12 10:08 README.txt
[oracle@ol9 36233126]$
[oracle@ol9 36233126]$ cd $ORACLE_HOME
[oracle@ol9 dbhome_1]$ ls
addnode     cfgtoollogs  ctx     dbs          dmu      has            inventory  jlib  mgw      olap        oracore  oui    precomp  rdbms        root.sh.old.1  slax          sqlplus   usm
apex        clone        cv      deinstall    drdaas   hs             javavm     ldap  network  OPatch      ord      owm    QOpatch  relnotes     runInstaller   sqldeveloper  srvm      utl
assistants  crs          data    demo         dv       install        jdbc       lib   nls      OPatch_OLD  ords     perl   R        root.sh      schagent.conf  sqlj          suptools  wwg
bin         css          dbjava  diagnostics  env.ora  instantclient  jdk        md    odbc     opmn        oss      plsql  racg     root.sh.old  sdk            sqlpatch      ucp       xdk
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ export CV_ASSUME_DISTID=OL8
[oracle@ol9 dbhome_1]$ ./runInstaller -applyRU /u01/STAGE/RU/36233126/36233263 -applyOneOffs /u01/STAGE/RU/36233126/36240578
Preparing the home to patch...
Applying the patch /u01/STAGE/RU/36233126/36233263...
Successfully applied the patch.
Applying the patch /u01/STAGE/RU/36233126/36240578...
Successfully applied the patch.
The log can be found at: /tmp/InstallActions2024-06-25_02-14-43PM/installerPatchActions_2024-06-25_02-14-43PM.log
Launching Oracle Database Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2024-06-25_02-14-43PM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2024-06-25_02-14-43PM/installActions2024-06-25_02-14-43PM.log

 

 

 

 

[참고문서]

19c Database Installation/relink fails with :"Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk " (문서 ID 2760289.1)
Requirements for Installing Oracle Database/Client 19c (19.22 or higher) on OL9 or RHEL9 64-bit (x86-64) (문서 ID 2982833.1)

반응형

+ Recent posts