<book_title> 검색…

Linux용 NetBackup IT Analytics 설치 및 업그레이드 설명서

Last Published: 2025-03-25

Product(s): NetBackup IT Analytics (11.4)

Oracle 패치 설치

루트 사용자로 다음 명령을 사용하여 /tmp의 Oracle 데이터베이스 콤보 패치 및 JDK 번들 패치 파일을 /opt/aptare/oracle 폴더에 복사하십시오.
```
        mv p37262172_190000_Linux-x86-64.zip /opt/aptare/oracle
mv p37213431_190000_Linux-x86-64.zip /opt/aptare/oracle
      
```
/opt/aptare/oracle 폴더로 이동하여 파일의 압축을 해제하십시오.
```
cd /opt/aptare/oracle
unzip p37262172_190000_Linux-x86-64.zip
```
위의 명령은 36866623 폴더를 /opt/aptare/oracle 폴더에 생성합니다.
unzip p37213431_190000_Linux-x86-64.zip
위의 명령은 36866578 폴더를 /opt/aptare/oracle에 생성합니다.
압축을 해제하는 동안 아래의 메시지가 표시되면 아래에 표시된 대로 'y'를 입력하십시오.
```
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
```
37262172 및 37213431 패치 폴더에 대한 권한 설정
```
chown -R aptare:dba 37262172
chown -R aptare:dba 37213431
```
참고:
이전에 Oracle 패치를 이미 설치한 경우 다음 4~10단계를 건너뛰십시오.

루트 사용자로 /tmp의 두 jar 파일을 /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib 폴더에 복사하십시오.

mv xdb6.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
mv xmlparserv2-sans-jaxp-services.jar 
/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib

jar 파일 및 perl에 대한 권한을 변경하십시오.

cd /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
chown -R aptare:dba xdb6.jar
chown -R aptare:dba xmlparserv2-sans-jaxp-services.jar
cd /opt/aptare/oracle
chown -R aptare:dba perl
chmod -R 775 perl

oraInventory 폴더가 /opt/에 있는지 확인하십시오. 폴더를 사용할 수 없는 경우
```
cd /opt/aptare/upgrade
cp oraInventory.zip /opt/
unzip oraInventory
```
/opt/oraInventory 폴더에 대한 권한이 aptare:dba인지 확인하고, 아닌 경우 권한을 변경하십시오.
```
cd /opt/
chown -R aptare:dba oraInventory
```
su - aptare 명령을 실행하십시오.
다음 명령을 실행하여 Oracle 홈을 연결하십시오.
```
$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/opt/aptare/oracle/oraInst.loc" -attachHome ORACLE_HOME="/opt/aptare/oracle" ORACLE_HOME_NAME="OraDB19c_home" INVENTORY_LOCATION="/opt/oraInventory"
```
참고:
Oracle 홈이 이미 연결되어 있는 경우 Oracle 홈이 이 위치에 이미 있습니다. 다른 위치를 선택하십시오. 메시지가 표시됩니다. 이 메시지를 무시하십시오.
fuser 오류 '누락된 명령: fuser'가 표시되면 다음 단계에 따라 fuser에 대한 변경을 수행하십시오.
```
cd /opt/aptare/oracle/bin/
touch fuser
chmod 755 fuser
```
아래 명령을 사용하여 3단계부터 계속 진행하는 경우 aptare 사용자로 연결하고, 그렇지 않은 경우 다음 단계로 이동하십시오.
su - aptare
PATH를 설정하십시오. 모든 경로를 설정했는지 확인하십시오. 그렇지 않으면 패치 응용 프로그램이 실패할 수 있습니다.
```
export PATH=$PATH:/opt/aptare/oracle/OPatch
export PATH=$PATH:/usr/ccs/bin
PATH=$PATH:/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
```

OPatch 충돌이 있는지 확인하십시오.

이는 데이터베이스 RU 패치 및 OJVM 패치 모두에서 충돌이 있는지 확인합니다.

cd /opt/aptare/oracle/37262172
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
from              : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-48-23PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

충돌이 탐지되지 않는 경우 다음 명령을 실행하여 /opt/aptare/oracle/37262172/37260974 폴더에서 데이터베이스 RU 패치를 적용하십시오.

cd /opt/aptare/oracle/37262172/37260974
   
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37260974
Do you want to proceed? [y|n]
y    
User Responded with: Y
All checks passed.
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch 37260974 to OH '/opt/aptare/oracle'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.util, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.assistants.acf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 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...

Patch 37260974 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [37260974].

Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-59-13PM_1.log
OPatch succeeded.

참고:

패치의 롤백과 관련된 경고는 무시하십시오. 이전 Oracle 보안 패치가 적용되지 않은 경우 이 메시지가 표시됩니다.

다음 명령을 실행하여 /opt/aptare/oracle/37262172/37102264 폴더에서 OJVM 패치를 적용하십시오.

cd /opt/aptare/oracle/37262172/37102264 
    /opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:37102264
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/aptare/oracle')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37102264' to OH '/opt/aptare/oracle'
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 37102264 successfully applied.
Sub-set patch [36414915] has become inactive due to the application of a super-set patch [36878697].
Refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-08-56PM_1.log
OPatch succeeded.

/opt/aptare/oracle/37213431로 이동하여 JDK 번들 패치에서 OPatch 충돌이 있는지 확인하십시오.

cd /opt/aptare/oracle/37213431
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-19-28PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

충돌이 탐지되지 않는 경우 다음 명령을 실행하여 /opt/aptare/oracle/37213431 폴더에서 JDK 패치를 적용하십시오.

cd /opt/aptare/oracle/37213431
   
/opt/aptare/oracle/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37213431

Do you want to proceed? [y|n]
y
User Responded with: Y

All checks passed.
Backing up files...
Applying interim patch '37213431' to OH '/opt/aptare/oracle'

ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ], [ oracle.jdk, 1.8.0.391.11]
not present in the Oracle Home or a higher version is found.
Patching component oracle.jdk, 1.8.0.201.0...
Patch 36866578 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log

OPatch succeeded.

JDK가 없거나 상위 버전이 있다는 "ApplySession: Oracle 홈 또는 상위 버전에 없는 선택적 구성 요소 [ oracle.jdk, 1.8.0.191.0 ]이 발견되었습니다." 메시지를 무시하십시오.

데이터베이스, OJVM 및 JDK 패치에 대한 OPatch 애플리케이션 결과를 표시하는 다음 명령을 사용하여 OPatch가 성공했는지 확인하십시오.
```
/opt/aptare/oracle/OPatch/opatch lsinventory -detail
    .
    .
    .
OPatch succeeded.
```
다음 명령을 사용하여 SQL Plus에 연결하십시오.
-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 7 14:23:49 2025
Version 19.26.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
sysdba로 연결하십시오.
SQL> connect / as sysdba
Connected to an idle instance.
데이터베이스를 시작하십시오.
SQL> startup
ORACLE instance started.
:
:
Database mounted.
Database opened.
모든 플러그형 데이터베이스를 여십시오.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL 프롬프트에서 종료하십시오.
SQL> quit

Datapatch를 실행하여 설치 중인 패치의 설치 후 SQL 배포를 완료하십시오.

다음 명령을 실행하여 플러그형 데이터베이스에 패치를 적용하십시오. 이 작업은 몇 분 정도 걸릴 수 있습니다.

/opt/aptare/oracle/OPatch/datapatch -verbose

참고:

run utlrp.sql 메시지가 표시되는 경우 유효성을 다시 검사하려면 실행하십시오.

SQL Patching tool version 19.26.0.0.0 Production on Fri Feb  7 14:26:04 2025
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_17246_2025_02_07_14_26_04/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
  Binary registry: Installed
  PDB CDB$ROOT: Not installed
  PDB PDB$SEED: Not installed
  PDB SCDB: Not installed

Current state of release update SQL patches:
  Binary registry:
    19.26.0.0.0 Release_Update 250118124854: Installed
  PDB CDB$ROOT:
    No release update patches installed
  PDB PDB$SEED:
    No release update patches installed
  PDB SCDB:
    No release update patches installed

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED SCDB
    No interim patches need to be rolled back
    Patch 37260974 (Database Release Update : 19.26.0.0.250121 (37260974)):
      Apply from 19.1.0.0.0 Feature Release to 19.26.0.0.0 Release_Update 250118124854
    The following interim patches will be applied:
      37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))

Installing patches...
Patch installation complete.  Total patches installed: 6
Validating logfiles...
done
Patch 37260974 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37102264 apply (pdb CDB$ROOT): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37260974 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb PDB$SEED): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37260974 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/
37102264_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: PDB$SEED

SQL Patching tool complete 

-bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 17 13:09:16 2024
.
Version 19.24.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

Version 19.24.0.0.0

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

/opt/aptare/cfgtoollogs/sqlpatch/의 로그 파일에 오류가 있는지 확인하십시오. 로그 파일 이름에는 현재 시간 스탬프가 포함됩니다.
예:
```
Log file for this invocation: 
/opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_20899_2024_10_26_01_55_09/sqlpatch_invocation.log
```
루트 사용자로 모든 서비스를 시작하십시오.
```
/opt/aptare/bin/aptare start
```