ORA-01918: user 'DVSYS' does not exist While Installing the PSU July DataPatch 23054246
/
Patching on upgraded database
Symptoms
[oracle@hostname OPatch]$./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Fri Aug 5 10:40:38 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_55992_2016_08_05_10_40_38/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
23054246 (Database Patch Set Update : 12.1.0.2.160719 (23054246))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 23054246 apply: WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23054246/20464632/23054246_apply_xxxxxxxx_2016Aug05_10_41_25.log (errors)
Error at line 33473: Warning: Package altered with compilation errors.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_55992_2016_08_05_10_40_38/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Fri Aug 5 10:41:29 2016
SYS@hostname> SELECT patch_id, version, status, bundle_id, bundle_series FROM dba_registry_sqlpatch;
PATCH_ID VERSION STATUS BUNDLE_ID BUNDLE_SERIES
---------- -------------------- --------------- ---------- ------------------------------
23177536 12.1.0.2 SUCCESS
23054246 12.1.0.2 WITH ERRORS 160719 PSU
22291127 12.1.0.2 WITH ERRORS 160719 PSU
[oracle@hostname OPatch]$./datapatch -apply 23054246 -force -verbose
SQL Patching tool version 12.1.0.2.0 on Fri Aug 5 11:00:03 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_64936_2016_08_05_11_00_03/sqlpatch_invocation.log
Connecting to database...OK
Determining current state...done
Current state of SQL patches:
Patch 23054246 ():
Not installed in binary or the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
23054246 ()
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 23054246 apply: WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23054246/20464632/23054246_apply_xxxxxxxx_2016Aug05_11_00_03.log (errors)
Error at line 32899: ORA-04042: procedure, function, package, or package body does not exist
Error at line 33132: ORA-01918: user 'DVSYS' does not exist
Error at line 33155: ORA-06550: line 5, column 37:
Error at line 33157: ORA-06550: line 5, column 1:
Error at line 33177: ORA-01918: user 'DVSYS' does not exist
Error at line 33200: ORA-06550: line 5, column 37:
Error at line 33202: ORA-06550: line 5, column 1:
Error at line 33233: ORA-01918: user 'DVSYS' does not exist
Error at line 33262: ORA-01918: user 'DVSYS' does not exist
Error at line 33287: ORA-01918: user 'DVSYS' does not exist
Error at line 33316: ORA-01918: user 'DVSYS' does not exist
Error at line 33355: ORA-01918: user 'DVSYS' does not exist
Error at line 33379: ORA-01918: user 'DVSYS' does not exist
Error at line 33406: ORA-01918: user 'DVSYS' does not exist
Error at line 33431: ORA-01918: user 'DVSYS' does not exist
Error at line 33465: ORA-01918: user 'DVSYS' does not exist
Error at line 33495: ORA-01918: user 'DVSYS' does not exist
Error at line 33525: ORA-01918: user 'DVSYS' does not exist
Error at line 33555: ORA-01918: user 'DVSYS' does not exist
Error at line 33587: ORA-01918: user 'DVSYS' does not exist
Error at line 33615: ORA-01918: user 'DVSYS' does not exist
Error at line 33639: ORA-01918: user 'DVSYS' does not exist
Error at line 33669: ORA-01918: user 'DVSYS' does not exist
Error at line 33700: ORA-01918: user 'DVSYS' does not exist
Error at line 33734: ORA-01918: user 'DVSYS' does not exist
Error at line 33760: ORA-01918: user 'DVSYS' does not exist
Error at line 33792: ORA-01918: user 'DVSYS' does not exist
Error at line 33824: ORA-01918: user 'DVSYS' does not exist
Error at line 33854: ORA-01918: user 'DVSYS' does not exist
Error at line 33879: ORA-01918: user 'DVSYS' does not exist
Error at line 33938: ORA-01918: user 'DVSYS' does not exist
Error at line 34166: ORA-01918: user 'DVSYS' does not exist
Error at line 34236: ORA-01918: user 'DVSYS' does not exist
Error at line 39035: Warning: View created with compilation errors.
Error at line 39084: Warning: View created with compilation errors.
Error at line 39140: Warning: View created with compilation errors.
Error at line 39190: Warning: View created with compilation errors.
Error at line 39249: Warning: View created with compilation errors.
Error at line 39302: Warning: View created with compilation errors.
Error at line 39382: Warning: View created with compilation errors.
Error at line 39436: Warning: View created with compilation errors.
Error at line 39484: Warning: View created with compilation errors.
Error at line 39531: Warning: View created with compilation errors.
Error at line 39645: Warning: View created with compilation errors.
Error at line 39692: Warning: View created with compilation errors.
Error at line 39737: Warning: View created with compilation errors.
Error at line 39782: Warning: View created with compilation errors.
Error at line 39846: Warning: View created with compilation errors.
Error at line 45402: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45410: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45418: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45426: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45434: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45442: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45450: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45458: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45467: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45475: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45856: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45865: ORA-04042: procedure, function, package, or package body does not exist
Error at line 45873: ORA-04042: procedure, function, package, or package body does not exist
Error at line 46659: ORA-04042: procedure, function, package, or package body does not exist
Error at line 46666: ORA-04042: procedure, function, package, or package body does not exist
Error at line 46673: ORA-04042: procedure, function, package, or package body does not exist
Error at line 46976: ORA-01400: cannot insert NULL into ("SYS"."OBJAUTH$"."OBJ#")
Error at line 47885: ORA-06550: line 9, column 24:
Error at line 47887: ORA-06550: line 9, column 6:
Error at line 47904: ORA-06550: line 2, column 21:
Error at line 47906: ORA-06550: line 2, column 3:
Error at line 47923: ORA-06550: line 2, column 21:
Error at line 47925: ORA-06550: line 2, column 3:
Error at line 48070: ORA-06550: line 2, column 11:
Error at line 48071: PLS-00201: identifier 'DVSYS.DV$FACTOR' must be declared
Error at line 48072: ORA-06550: line 2, column 11:
Error at line 48074: ORA-06550: line 3, column 12:
Error at line 48075: PLS-00201: identifier 'DVSYS.DV$FACTOR' must be declared
Error at line 48076: ORA-06550: line 3, column 12:
Error at line 48078: ORA-06550: line 4, column 18:
Error at line 48079: PLS-00201: identifier 'DVSYS.DV$FACTOR' must be declared
Error at line 48080: ORA-06550: line 4, column 18:
Error at line 48082: ORA-06550: line 10, column 20:
Error at line 48084: ORA-06550: line 9, column 9:
Error at line 48086: ORA-06550: line 14, column 9:
Error at line 48087: PLS-00320: the declaration of the type of this expression is incomplete or
Error at line 48089: ORA-06550: line 14, column 9:
Error at line 48091: ORA-06550: line 15, column 9:
Error at line 48092: PLS-00320: the declaration of the type of this expression is incomplete or
Error at line 48094: ORA-06550: line 15, column 9:
Error at line 48096: ORA-06550: line 20, column 24:
Error at line 48097: PLS-00320: the declaration of the type of this expression is incomplete or
Error at line 48099: ORA-06550: line 20, column 13:
Error at line 48101: ORA-06550: line 24, column 32:
Error at line 48102: PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
Error at line 48103: ORA-06550: line 23, column 13:
Error at line 48105: ORA-06550: line 26, column 24:
Error at line 48106: PLS-00320: the declaration of the type of this expression is incomplete or
Error at line 48108: ORA-06550: line 26, column 13:
Error at line 48110: ORA-06550: line 30, column 61:
Error at line 48111: PLS-00320: the declaration of the type of this expression is incomplete or
Error at line 48113: ORA-06550: line 30, column 13:
Error at line 49480: Warning: Package altered with compilation errors.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_64936_2016_08_05_11_00_03/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Fri Aug 5 11:00:12 2016
[oracle@hostname OPatch]$
|
2. Cause
The DVSYS schema does not exist in the database that is being patched. There are two common reasons for this:
1) the DV metadata was removed for some reasons
2) the database was upgraded from an 11g database that did not have Database Vault installed
3. Resolution
1) Enable OLS ( this is needed if OLS' metadata is not installed yet) :
sqlplus / as sysdba
@?/rdbms/admin/catols.sql
exec lbacsys.configure_ols
exec lbacsys.ols_enforcement.enable_ols
restart the database
2) Run script catmac.sql :
sqlplus / as sysdba
@?/rdbms/admin/catmac.sql system temp <syspasswd>
3) If there are any invalid objects recompile them :
sqlplus / as sysdba
@?\rdbms\admin\utlrp.sql
4) Run the datapatch script again:
cd $ORACLE_HOME/OPatch
[oracle@hostname OPatch]$./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Wed Sep 14 12:11:58 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_2760_2016_09_14_12_11_58/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 23054246 ():
Installed in the binary registry only
Patch 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016)):
Installed in binary and the SQL registry
Bundle series PSU:
ID 160719 in the binary registry and not installed 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:
22291127 (Database Patch Set Update : 12.1.0.2.160419 (22291127))
23054246 ()
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...
Patch 22291127 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/22291127/19694308/22291127_apply_xxxxxxxx_2016Sep14_12_12_45.log (no errors)
Patch 23054246 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23054246/20464632/23054246_apply_xxxxxxxx_2016Sep14_12_12_49.log (no errors)
SQL Patching tool complete on Wed Sep 14 12:12:59 2016
[oracle@hostname OPatch]$
SYS@hostname> SELECT patch_id, version, status, bundle_id, bundle_series FROM dba_registry_sqlpatch;
PATCH_ID VERSION STATUS BUNDLE_ID BUNDLE_SERIES
---------- -------------------- --------------- ---------- ------------------------------
23177536 12.1.0.2 SUCCESS
22291127 12.1.0.2 SUCCESS 160719 PSU
23054246 12.1.0.2 SUCCESS
|
No comments:
Post a Comment