오라클 GIPSU rollback 실패 ../crsconfig_params unable to get oracle owner for

패치 rollback 실패

 

[root@pradg1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /patch/31718723 -rollback
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /patch -patchn 31718723 -rollback -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_10-30-25.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_10-30-25.report.log

2023-09-20 10:30:25: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
unable to get oracle owner for 

 

패치 실패

-rwxrwxr-x.  1 root oinstall     4184  3월 29  2022 crsconfig_params

권한에는 문제가 없다

 

export LANG=C

하고 재 실행 하니 문제 없이 된다.

 

 

[root@pradg1 ~]# export LANG=C
[root@pradg1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /patch/31718723 -rollback
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /patch -patchn 31718723 -rollback -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_10-31-32.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_10-31-32.report.log

2023-09-20 10:31:32: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
A
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch 29938455  rollback successful for home /u01/app/oracle/product/11.2.0/db_1
patch 31537677  rollback successful for home /u01/app/oracle/product/11.2.0/db_1

Stopping CRS...
Stopped CRS successfully

patch 29938455  rollback successful for home /u01/app/11.2.0/grid
patch 31537677  rollback successful for home /u01/app/11.2.0/grid
patch 29509309  rollback successful for home /u01/app/11.2.0/grid

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

 

로그

[root@pradg1 install]# tail -f /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_10-31-32.report.log

***********  Configuration Data  ***********
* It shows only those targets that will be patched in this session *


crs_home=/u01/app/11.2.0/grid      owner=grid      opatch_ver=11.2.0.3.33
rac_home=/u01/app/oracle/product/11.2.0/db_1      owner=oracle      opatch_ver=11.2.0.3.33

*********** Steps to be executed as owner unless specified as root ***********


1: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29938455/custom/server/29938455 -oh /u01/app/oracle/product/11.2.0/db_1

2: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /patch/31718723/31537677 -oh /u01/app/oracle/product/11.2.0/db_1

3: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29938455 -oh /u01/app/11.2.0/grid

4: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/31537677 -oh /u01/app/11.2.0/grid

5: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29509309 -oh /u01/app/11.2.0/grid

6: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole

7: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop agent

8: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29938455/custom/server/29938455 -oh /u01/app/oracle/product/11.2.0/db_1

9: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/31537677 -oh /u01/app/oracle/product/11.2.0/db_1

10: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n pradg1 -f

11: /patch/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1

12: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable  -id 29938455 -oh /u01/app/oracle/product/11.2.0/db_1

13: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 29938455 -local -silent -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

14: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable  -id 31537677 -oh /u01/app/oracle/product/11.2.0/db_1

15: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 31537677 -local -silent -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

16: /patch/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1

17: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root

18: /u01/app/11.2.0/grid/tfa/bin/tfactl stop : run as root

19: /sbin/fuser -k /u01/app/11.2.0/grid/bin/crsctl.bin : run as root

20: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29938455 -oh /u01/app/11.2.0/grid

21: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/31537677 -oh /u01/app/11.2.0/grid

22: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29509309 -oh /u01/app/11.2.0/grid

23: /u01/app/11.2.0/grid/OPatch/opatch prereq checkRollbackable  -id 29938455 -oh /u01/app/11.2.0/grid

24: /u01/app/11.2.0/grid/OPatch/opatch rollback -id 29938455 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

25: /u01/app/11.2.0/grid/OPatch/opatch prereq checkRollbackable  -id 31537677 -oh /u01/app/11.2.0/grid

26: /u01/app/11.2.0/grid/OPatch/opatch rollback -id 31537677 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

27: /u01/app/11.2.0/grid/OPatch/opatch prereq checkRollbackable  -id 29509309 -oh /u01/app/11.2.0/grid

28: /u01/app/11.2.0/grid/OPatch/opatch rollback -id 29509309 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

29: /u01/app/11.2.0/grid/bin/emctl start dbconsole

30: /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root

31: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root

32: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole

33: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start agent

34: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n pradg1

 

확인

[oracle@racdb1 ~]$ opatch lsinv
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.33
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.33
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-09-20_10-43-56오전_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2023-09-20_10-43-56오전.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: pradg1
ARU platform id: 226
ARU platform description:: Linux x86-64

설치된 최상위 레벨 제품(1): 

Oracle Database 11g                                                  11.2.0.4.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

패치 제거 후 추가 작업

 

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID PREFIX>_ROLLBACK.sql
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_RACDB_APPLY_2023Sep20_10_55_52.log
SQL> @utlrp 

 

TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2023-09-20 10:56:55

1 row selected.

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2023-09-20 10:57:01

1 row selected.

DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

1 row selected.

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0

1 row selected.


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

 

완료