Symptoms:
While executing /datapatch -verbose we have noticed below error.
Validating logfiles...
Patch 28729169 apply: WITH ERRORS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/28729169/22626239/28729169_apply_ORADB_2020Jun10_06_14_35.log (errors)
Error at line 22725: Warning: Package Body created with compilation errors.
Error at line 22732: 398/13 PLS-00323: subprogram or cursor 'RECLAIMTEMPSEGMENT' is declared
Error at line 22736: 671/13 PLS-00323: subprogram or cursor 'KCP_PLG_RECLAIM_SEGMENT' is declared
Issue:
Seems to be Database component(JVM-Java Virtual Machine)and database object(DBMS_PLUGTS) are in Invalid state.
Fix:
To make both component and object as valid we have opened DB in upgrade mode and executed catupgrd.sql and utlrp.sql.
[oracle@orahost1-TESTCDB] /u02/app/oracle/product/12.1.0/dbhome_1/OPatch > ps -ef|grep pmon
oracle 7683 1 0 Jun09 ? 00:00:07 ora_pmon_TESTCDB
oracle 8363 1 0 Jun09 ? 00:00:07 ora_pmon_ORADB
grid 21190 1 0 2019 ? 00:20:04 asm_pmon_+ASM
oracle 25907 25775 0 06:13 pts/2 00:00:00 grep --color=auto pmon
[oracle@orahost1-TESTCDB]. oraenv
ORACLE_SID = [TESTCDB] ? ORADB
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@orahost1-ORADB]cd $ORACLE_HOME/OPatch
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/OPatch > ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed Jun 10 06:14:25 2020
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_26357_2020_06_10_06_14_25/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 190115 in the binary registry and ID 190115 with errors in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28729169 (DATABASE PATCH SET UPDATE 12.1.0.2.190115)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 28729169 apply: WITH ERRORS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/28729169/22626239/28729169_apply_ORADB_2020Jun10_06_14_35.log (errors)
Error at line 22725: Warning: Package Body created with compilation errors.
Error at line 22732: 398/13 PLS-00323: subprogram or cursor 'RECLAIMTEMPSEGMENT' is declared
Error at line 22736: 671/13 PLS-00323: subprogram or cursor 'KCP_PLG_RECLAIM_SEGMENT' is
Please refer to MOS Note 1609718.1 and/or the invocation log
/u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_26357_2020_06_10_06_14_25/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Wed Jun 10 06:14:40 2020
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/OPatch > sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 10 06:15:06 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> select owner,object_name,object_type,status from dba_objects where status='INVALID' and owner ='SYS';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------- ---------------------- -------------- -------
SYS DBMS_PLUGTS PACKAGE BODY INVALID
1 row selected.
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
------------- ------------------------------------ ---------- -------
OWM Oracle Workspace Manager 12.1.0.2.0 VALID
XDB Oracle XML Database 12.1.0.2.0 VALID
CATALOG Oracle Database Catalog Views 12.1.0.2.0 VALID
CATPROC Oracle Database Packages and Types 12.1.0.2.0 VALID
JAVAVM JServer JAVA Virtual Machine 12.1.0.2.0 INVALID
XML Oracle XDK 12.1.0.2.0 VALID
CATJAVA Oracle Database Java Packages 12.1.0.2.0 VALID
7 rows selected.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 7654304 bytes
Variable Size 1.5703E+10 bytes
Database Buffers 5704253440 bytes
Redo Buffers 59453440 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/dbs > cd $ORACLE_HOME/rdbms/admin
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin > $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl $ORACLE_HOME/rdbms/admin/catupgrd.sql
Argument list for [/u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catctl.pl]
SQL Process Count n = 0
SQL PDB Process Count N = 0
Input Directory d = 0
Phase Logging Table t = 0
Log Dir l = 0
Script s = 0
Serial Run S = 0
Upgrade Mode active M = 0
Start Phase p = 0
End Phase P = 0
Log Id i = 0
Run in c = 0
Do not run in C = 0
Echo OFF e = 1
No Post Upgrade x = 0
Reverse Order r = 0
Open Mode Normal o = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
Display Phases y = 0
Child Process I = 0
catctl.pl version: 12.1.0.2.0
Oracle Base = /u02/app/oracle
Analyzing file /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catupgrd.sql
Log files in /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin
catcon: ALL catcon-related output will be written to /u02/app/oracle/product/12_catcon_6887.lst
catcon: See /u02/app/oracle/product/12*.log files for output generated by scripts
catcon: See /u02/app/oracle/product/12_*.lst files for spool files, if any
Number of Cpus = 32
SQL Process Count = 0
New SQL Process Count = 4
------------------------------------------------------
Phases [0-73] Start Time:[2020_06_10 06:26:35]
------------------------------------------------------
Serial Phase #: 0 Files: 1 Time: 22s
Serial Phase #: 1 Files: 5 Time: 24s
Restart Phase #: 2 Files: 1 Time: 0s
Parallel Phase #: 3 Files: 18 Time: 4s
Restart Phase #: 4 Files: 1 Time: 0s
Serial Phase #: 5 Files: 5 Time: 11s
Serial Phase #: 6 Files: 1 Time: 6s
Serial Phase #: 7 Files: 4 Time: 5s
Restart Phase #: 8 Files: 1 Time: 1s
Parallel Phase #: 9 Files: 62 Time: 13s
Restart Phase #:10 Files: 1 Time: 0s
Serial Phase #:11 Files: 1 Time: 9s
Restart Phase #:12 Files: 1 Time: 0s
Parallel Phase #:13 Files: 91 Time: 4s
Restart Phase #:14 Files: 1 Time: 0s
Parallel Phase #:15 Files: 111 Time: 8s
Restart Phase #:16 Files: 1 Time: 0s
Serial Phase #:17 Files: 3 Time: 0s
Restart Phase #:18 Files: 1 Time: 0s
Parallel Phase #:19 Files: 32 Time: 9s
Restart Phase #:20 Files: 1 Time: 0s
Serial Phase #:21 Files: 3 Time: 3s
Restart Phase #:22 Files: 1 Time: 0s
Parallel Phase #:23 Files: 23 Time: 45s
Restart Phase #:24 Files: 1 Time: 0s
Parallel Phase #:25 Files: 11 Time: 19s
Restart Phase #:26 Files: 1 Time: 0s
Serial Phase #:27 Files: 1 Time: 0s
Restart Phase #:28 Files: 1 Time: 0s
Serial Phase #:30 Files: 1 Time: 0s
Serial Phase #:31 Files: 257 Time: 13s
Serial Phase #:32 Files: 1 Time: 0s
Restart Phase #:33 Files: 1 Time: 0s
Serial Phase #:34 Files: 1 Time: 3s
Restart Phase #:35 Files: 1 Time: 0s
Restart Phase #:36 Files: 1 Time: 0s
Serial Phase #:37 Files: 4 Time: 37s
Restart Phase #:38 Files: 1 Time: 0s
Parallel Phase #:39 Files: 13 Time: 57s
Restart Phase #:40 Files: 1 Time: 0s
Parallel Phase #:41 Files: 10 Time: 3s
Restart Phase #:42 Files: 1 Time: 0s
Serial Phase #:43 Files: 1 Time: 4s
Restart Phase #:44 Files: 1 Time: 0s
Serial Phase #:45 Files: 1 Time: 2s
Serial Phase #:46 Files: 1 Time: 0s
Restart Phase #:47 Files: 1 Time: 0s
Serial Phase #:48 Files: 1 Time: 44s
Restart Phase #:49 Files: 1 Time: 0s
Serial Phase #:50 Files: 1 Time: 0s
Restart Phase #:51 Files: 1 Time: 0s
Serial Phase #:52 Files: 1 Time: 0s
Restart Phase #:53 Files: 1 Time: 1s
Serial Phase #:54 Files: 1 Time: 0s
Restart Phase #:55 Files: 1 Time: 0s
Serial Phase #:56 Files: 1 Time: 0s
Restart Phase #:57 Files: 1 Time: 0s
Serial Phase #:58 Files: 1 Time: 0s
Restart Phase #:59 Files: 1 Time: 0s
Serial Phase #:60 Files: 1 Time: 0s
Restart Phase #:61 Files: 1 Time: 0s
Serial Phase #:62 Files: 1 Time: 0s
Restart Phase #:63 Files: 1 Time: 0s
Serial Phase #:64 Files: 1 Time: 1s
Serial Phase #:65 Files: 1 Time: 15s
Serial Phase #:66 Files: 1 Time: 0s
Serial Phase #:68 Files: 1 Time: 0s
Serial Phase #:69 Files: 1 Time: 109s
Serial Phase #:70 Files: 1 Time: 1s
Serial Phase #:71 Files: 1 Time: 0s
Serial Phase #:72 Files: 1 Time: 0s
Serial Phase #:73 Files: 1 Time: 22s
------------------------------------------------------
Phases [0-73] End Time:[2020_06_10 06:34:50]
------------------------------------------------------
Grand Total Time: 495s
*** WARNING: ERRORS FOUND DURING UPGRADE ***
Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.
*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE ***
1. Evaluate the errors found in the upgrade logs
and determine the proper action.
2. Execute the post upgrade script as described in Chapter 3
of the Database Upgrade Guide.
REASON:
catuppst.sql unable to run in Database: ORADB Id: 0
ERRORS FOUND: during upgrade CATCTL ERROR COUNT=1
------------------------------------------------------
Identifier CATPROC 20-06-10 06:34:27 Script = /u02/app/oracle/product/12catuppst40.663
ERROR = [SP2-0310: unable to open file "/u02/app/oracle/product/catuppst.sql"]
STATEMENT = [SELECT :catuppst_name FROM sys.dual;]
------------------------------------------------------
LOG FILES: (/u02/app/oracle/product/12*.log)
Upgrade Summary Report Located in:
/u02/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/ORADB/upgrade/upg_summary.log
Grand Total Upgrade Time: [0d:0h:8m:15s]
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin > sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 10 06:35:02 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 7654304 bytes
Variable Size 1.5703E+10 bytes
Database Buffers 5704253440 bytes
Redo Buffers 59453440 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2020-06-10 06:42:52
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 2020-06-10 06:43:32
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
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
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
SQL> col OBJECT_NAME for a45
set linesize 999
select Owner,Object_name,object_type,created, Last_DDL_Time, status from dba_objects where status='INVALID' ORDER by Owner desc,Last_DDL_Time desc;
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL STATUS
-------------------------------------------------------- --------- --------- -------
SYS SYS_PLSQL_A2A431D3_37_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_41E1FA4F_2709_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_41E1FA4F_2750_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_AE259416_DUMMY_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_AE259416_9_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_D9B1149D_DUMMY_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_D9B1149D_9_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_FAA5F685_1984_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_9DEB8363_32_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_675_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_DUMMY_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_657_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_541_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_533_1 TYPE 19-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_981_1 TYPE 01-JUL-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_954_1 TYPE 01-JUL-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_1029_1 TYPE 01-JUL-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_989_1 TYPE 01-JUL-17 15-FEB-19 INVALID
SYS SYS_PLSQL_EC6BF05F_644_1 TYPE 22-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_EC6BF05F_DUMMY_1 TYPE 22-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_EC6BF05F_346_1 TYPE 22-MAY-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_835_1 TYPE 05-SEP-17 15-FEB-19 INVALID
SYS SYS_PLSQL_F0AD6A18_724_1 TYPE 05-SEP-17 15-FEB-19 INVALID
SYS SYS_PLSQL_41E1FA4F_2717_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_41E1FA4F_2550_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_41E1FA4F_DUMMY_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_A2A431D3_9_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_FAA5F685_1971_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_A2A431D3_DUMMY_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_FAA5F685_DUMMY_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_9DEB8363_9_1 TYPE 10-JUN-17 15-FEB-19 INVALID
SYS SYS_PLSQL_9DEB8363_DUMMY_1 TYPE 10-JUN-17 15-FEB-19 INVALID
39 rows selected.
SQL> set linesize 400 pages 100
SQL> SELECT 'ALTER TYPE '||OWNER||'.'||OBJECT_NAME||' COMPILE;' FROM dba_objects WHERE status='INVALID' and OBJECT_TYPE='TYPE';
'ALTERTYPE'||OWNER||'.'||OBJECT_NAME||'COMPILE;'
---------------------------------------------------
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_835_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_724_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_37_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2709_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2750_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_AE259416_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_AE259416_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_D9B1149D_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_D9B1149D_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_1984_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_32_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_675_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_657_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_541_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_533_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_981_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_954_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_1029_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_989_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_644_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_346_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_1971_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2550_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2717_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_147_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_DUMMY_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_125_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_59_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_41_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_169_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_85_1 COMPILE;
39 rows selected.
SQL> ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_835_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_724_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_37_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2709_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2750_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_AE259416_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_AE259416_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_D9B1149D_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_D9B1149D_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_1984_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_32_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_675_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_657_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_541_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_533_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_981_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_954_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_1029_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_F0AD6A18_989_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_644_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_EC6BF05F_346_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_9DEB8363_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_FAA5F685_1971_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_A2A431D3_9_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_DUMMY_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2550_1 COMPILE;
ALTER TYPE SYS.SYS_PLSQL_41E1FA4F_2717_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_147_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_DUMMY_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_125_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_59_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_41_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_169_1 COMPILE;
ALTER TYPE INSIS_BLANKS.SYS_PLSQL_35276B50_85_1 COMPILE;
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
Type altered.
SQL>
SQL> select owner,object_name,object_type,status from dba_objects where status='INVALID' and owner ='SYS';
no rows selected.
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
------------- ------------------------------------ ---------- -------
OWM Oracle Workspace Manager 12.1.0.2.0 VALID
XDB Oracle XML Database 12.1.0.2.0 VALID
CATALOG Oracle Database Catalog Views 12.1.0.2.0 VALID
CATPROC Oracle Database Packages and Types 12.1.0.2.0 VALID
JAVAVM JServer JAVA Virtual Machine 12.1.0.2.0 VALID
XML Oracle XDK 12.1.0.2.0 VALID
CATJAVA Oracle Database Java Packages 12.1.0.2.0 VALID
7 rows selected.
[oracle@orahost1-ORADB] /home/oracle > echo $ORACLE_SID
ORADB
[oracle@orahost1-ORADB] /home/oracle > cd $ORACLE_HOME/OPatch
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/OPatch > ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed Jun 10 07:23:28 2020
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3471_2020_06_10_07_23_28/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 190115 in the binary registry and ID 190115 in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The
following patches will be applied:
28729169 (DATABASE PATCH SET UPDATE 12.1.0.2.190115)
Installing
patches...
Patch
installation complete. Total patches installed: 1
Validating
logfiles...
Patch
28729169 apply (ORADB): SUCCESS
logfile:
/u02/app/oracle/cfgtoollogs/sqlpatch/28729169/22626239/28729169_apply_ORADB_2020Jun10_06_11_41.log
(no errors)
SQL Patching tool complete on Wed Jun 10 07:23:39 2020
[oracle@orahost1-ORADB] /u02/app/oracle/product/12.1.0/dbhome_1/OPatch > sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 10 07:23:53 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> set linesize 400
col ACTION_TIME for a30
col DESCRIPTION for a70
col BUNDLE_SERIES for a20
select patch_id,action,status,action_time,description from DBA_REGISTRY_SQLPATCH;
PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION
-------- ------ ------- ---------------------------- -----------------------------------------
28729169 APPLY SUCCESS 10-JUN-20 06.34.27.546793 AM DATABASE PATCH SET UPDATE 12.1.0.2.190115
SQL>
No comments:
Post a Comment