Oracle DBMS_PREUP
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Procedures and functions used to perform checks on a database which is getting ready to be upgrade.
Note Constants and subprograms listed here are only those that are publicly accessible. Additional constants and subprograms are private to the package body. A list of all CHECK_NAME values can be found in the INIT_PREUPCHECKS procedure local to the package body (see source code).

The demos below were run against a 12.1.0.1 database with Data Vault configured.
AUTHID DEFINER
Constants
Name Data Type Value
c_version VARCHAR2(30) '12.1.0.1'
c_patchset VARCHAR2(2) '.0'
c_build VARCHAR2(30) '006'
c_supported_versions VARCHAR(50) '10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, 11.2.0.4'
c_tz_version NUMBER 18
c_max_processes NUMBER 300
c_compat_min_num NUMBER 11
c_compat_min VARCHAR(30) '11.0.0'
c_dir_obj VARCHAR2(30) 'PREUPGRADE_DIR'
c_output_fn VARCHAR2(30) 'preupgrade.log'
c_pre_script_fn VARCHAR2(30) 'preupgrade_fixups.sql'
c_post_script_fn VARCHAR2(30) 'postupgrade_fixups.sql'
c_output_text NUMBER 1
c_output_xml NUMBER 2
Fixable Check
c_fix_source_manual NUMBER 0
c_fix_source_auto NUMBER 1
c_fix_target_auto_pre NUMBER 2
c_fix_target_auto_post NUMBER 3
c_fix_target_manual_pre NUMBER 4
c_fix_target_manual_post NUMBER 5
Check Type
c_type_check NUMBER 1
c_type_check_interactive_onlyl NUMBER 2
c_type_recommend_pre NUMBER 3
c_type_recommend_post NUMBER 4
What getHelp Returns
c_help_overview NUMBER 1
c_help_fixup NUMBER 2
Checkup Routine Return Values
c_fixup_status_failure NUMBER 0
c_fixup_status_success NUMBER 1
c_fixup_status_info NUMBER 2
What check/help Returns
c_status_failure NUMBER 0
c_status_success NUMBER 1
c_status_passed NUMBER 1
c_status_not_for_this_version NUMBER 2
Data Types name           VARCHAR2(30),   -- Name of check (and used for function
                               -- names also (if not too long))
type           NUMBER,         -- see type constants for values
                               -- c_type_check = standard check for both xdb/manual
                               -- c_type_check_interactive_only = Standard check, but manual only
                               -- c_type_recommend_pre = pre-up recommendation (manual)
                               -- c_type_recommend_post = post-up recommendation (manual)
descript       VARCHAR2(100),  -- Short description of the check
f_name_prefix  VARCHAR2(30),   -- If name is too long to add
                               -- "_gethelp" and create a valid
                               -- function name, this is set to a
                               -- shorten name to be used when accessing
                               -- a check's functions.
level          NUMBER,         -- Check level (c_check_level_....)
fix_type       NUMBER,         -- fix_type (by_fixup, manual)
executed       BOOLEAN,        -- Has the test been run?
execute_failed BOOLEAN,        -- If the check takes an exception.
passed         BOOLEAN,        -- Did the check pass?
skipped        BOOLEAN,        -- Skipped, check not valid for this version
fixup_executed BOOLEAN,        -- was a fixup attempted ?
fixup_failed   BOOLEAN,        -- did the fixup execute fail?
fixup_status   NUMBER,         -- c_fixup_status... value
always_fail    BOOLEAN,        -- debug the check's failure path (generate a fixup)
valid_versions VARCHAR(100),   -- what versions is this check valid for?
result_text    VARCHAR2(1500), -- result of fixup/check
sqlcode        NUMBER);        -- the sqlcode should an error occur.

TYPE check_table_t IS TABLE OF check_record_t
INDEX BY BINARY_INTEGER;

check_table        check_table_t;

pCheckErrorCount   NUMBER;
pCheckWarningCount NUMBER;
pCheckInfoCount    NUMBER;
Dependencies
D BMS_ASSERT DBMS_SYSTEM USER$
DBMS_OUTPUT DUAL UTL_FILE
DBMS_REGISTRY OBJ$ V$DATABASE
DBMS_STANDARD PLITBLM  
Documented No
Exceptions
Error Code Reason
ORA-20000 Pre-Upgrade Package <resource> does not exist
ORA-20000 Functions must be run AS SYSDBA
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/utluppkg.sql

dbms_preupgrd.sql -- The package is not built until this script is called
dbms_preupgrdx.sql -- calls DBMS_PREUP for DBUA. The package is not built until this script is called
Subprograms
AAR_PRESENT_CHECK EXF_RUL_EXISTS_FIXUP OUTPUT_RESOURCES
AAR_PRESENT_FIXUP EXF_RUL_EXISTS_GETHELP OUTPUT_ROLLBACK_SEGS
AAR_PRESENT_GETHELP FILES_BACKUP_MODE_CHECK OUTPUT_SUMMARY
AMD_EXISTS_CHECK FILES_BACKUP_MODE_FIXUP OUTPUT_TABLESPACES
AMD_EXISTS_FIXUP FILES_BACKUP_MODE_GETHELP PENDING_2PC_TXN_CHECK
AMD_EXISTS_GETHELP FILES_NEED_RECOVERY_CHECK PENDING_2PC_TXN_FIXUP
APPQOSSYS_USER_PRESENT_CHECK FILES_NEED_RECOVERY_FIXUP PENDING_2PC_TXN_GETHELP
APPQOSSYS_USER_PRESENT_FIXUP FILES_NEED_RECOVERY_GETHELP PURGE_RECYCLEBIN_CHECK
APPQOSSYS_USER_PRESENT_GETHELP FIXED_OBJECTS_RECOMMEND PURGE_RECYCLEBIN_FIXUP
AUDIT_RECORDS_RECOMMEND FIXUP_SUMMARY PURGE_RECYCLEBIN_GETHELP
AUDIT_VIEWER_CHECK GET_OUTPUT_PATH REMOTE_REDO_CHECK
AUDIT_VIEWER_FIXUP GET_VERSION REMOTE_REDO_FIXUP
AUDIT_VIEWER_GETHELP HIDDEN_PARAMS_RECOMMEND REMOTE_REDO_GETHELP
AUDSYS_USER_PRESENT_CHECK INVALID_LAF_CHECK REMOVE_DMSYS_CHECK
AUDSYS_USER_PRESENT_FIXUP INVALID_LAF_FIXUP REMOVE_DMSYS_FIXUP
AUDSYS_USER_PRESENT_GETHELP INVALID_LAF_GETHELP REMOVE_DMSYS_GETHELP
AWR_DBIDS_PRESENT_CHECK INVALID_OBJ_EXCLUDE RESET_INIT_PACKAGE
AWR_DBIDS_PRESENT_FIXUP INVALID_OBJ_EXIST_CHECK RUN_ALL_CHECKS
AWR_DBIDS_PRESENT_GETHELP INVALID_OBJ_EXIST_FIXUP RUN_ALL_RECOMMEND
CAPT_ADM_ROLE_PRESENT_CHECK INVALID_OBJ_EXIST_GETHELP RUN_CHECK
CAPT_ADM_ROLE_PRESENT_FIXUP INVALID_SYS_TABLEDATA_CHECK RUN_CHECK_SIMPLE
CAPT_ADM_ROLE_PRESENT_GETHELP INVALID_SYS_TABLEDATA_FIXUP RUN_FIXUP
CLEAR_RUN_FLAG INVALID_SYS_TABLEDATA_GETHELP RUN_FIXUP_AND_REPORT
CLOSE_FILE INVALID_USR_TABLEDATA_CHECK RUN_FIXUP_INFO
COMPATIBLE_PARAMETER_CHECK INVALID_USR_TABLEDATA_FIXUP RUN_RECOMMEND
COMPATIBLE_PARAMETER_FIXUP INVALID_USR_TABLEDATA_GETHELP SET_OUTPUT_FILE
COMPATIBLE_PARAMETER_GETHELP JOB_QUEUE_PROCESS_CHECK SET_OUTPUT_TYPE
CONDITION_EXISTS JOB_QUEUE_PROCESS_FIXUP SET_SCRIPTS
DBG_ALL_CHECKS JOB_QUEUE_PROCESS_GETHELP START_XML_DOCUMENT
DBG_ALL_RESOURCES NACL_OBJECTS_EXIST_CHECK SYNC_STANDBY_DB_CHECK
DBG_CHECK NACL_OBJECTS_EXIST_FIXUP SYNC_STANDBY_DB_FIXUP
DBG_SPACE_RESOURCES NACL_OBJECTS_EXIST_GETHELP SYNC_STANDBY_DB_GETHELP
DBMS_LDAP_DEP_EXIST_CHECK NEW_TIME_ZONES_EXIST_CHECK SYSBACKUP_USER_PRESENT_CHECK
DBMS_LDAP_DEP_EXIST_FIXUP NEW_TIME_ZONES_EXIST_FIXUP SYSBACKUP_USER_PRESENT_FIXUP
DBMS_LDAP_DEP_EXIST_GETHELP NEW_TIME_ZONES_EXIST_GETHELP SYSBACKUP_USER_PRESENT_GETHELP
DEFAULT_PROCESS_COUNT_CHECK OCM_USER_PRESENT_CHECK SYSDG_USER_PRESENT_CHECK
DEFAULT_PROCESS_COUNT_FIXUP OCM_USER_PRESENT_FIXUP SYSDG_USER_PRESENT_FIXUP
DEFAULT_PROCESS_COUNT_GETHELP OCM_USER_PRESENT_GETHELP SYSDG_USER_PRESENT_GETHELP
DICTIONARY_STATS_RECOMMEND OLD_TIME_ZONES_EXIST_CHECK SYSKM_USER_PRESENT_CHECK
DISPLAYDIAGLINE OLD_TIME_ZONES_EXIST_FIXUP SYSKM_USER_PRESENT_FIXUP
DISPLAYLINE OLD_TIME_ZONES_EXIST_GETHELP SYSKM_USER_PRESENT_GETHELP
DISPLAY_CHECK_TEXT OLS_SYS_MOVE_CHECK SYS_DEF_TABLESPACE_CHECK
DUMP_CHECK_REC OLS_SYS_MOVE_FIXUP SYS_DEF_TABLESPACE_FIXUP
DV_ENABLED_CHECK OLS_SYS_MOVE_GETHELP SYS_DEF_TABLESPACE_GETHELP
DV_ENABLED_FIXUP ORDIMAGEINDEX_CHECK TIME_ZONE_CHECK
DV_ENABLED_GETHELP ORDIMAGEINDEX_FIXUP TZ_FIXUP
EM_PRESENT_CHECK ORDIMAGEINDEX_GETHELP ULTRASEARCH_DATA_CHECK
EM_PRESENT_FIXUP OUTPUT_CHECK_SUMMARY ULTRASEARCH_DATA_FIXUP
EM_PRESENT_GETHELP OUTPUT_COMPONENTS ULTRASEARCH_DATA_GETHELP
ENABLED_INDEXES_TBL_CHECK OUTPUT_FLASHBACK UNDERSCORE_EVENTS_RECOMMEND
ENABLED_INDEXES_TBL_FIXUP OUTPUT_INITPARAMS UNSUPPORTED_VERSION_CHECK
ENABLED_INDEXES_TBL_GETHELP OUTPUT_PREUP_CHECKS UNSUPPORTED_VERSION_FIXUP
END_XML_DOCUMENT OUTPUT_PROLOG UNSUPPORTED_VERSION_GETHELP
EXF_RUL_EXISTS_CHECK OUTPUT_RECOMMENDATIONS  
 
AAR_PRESENT_CHECK
Checks to see if the AUDIT_ADMIN role exists prior to upgrade dbms_preup.aar_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.aar_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: -->A user or role with the name AUDIT_ADMIN" found in the database. This is an Oracle defined role. you must drop this role or user prior to upgrading.
 
AAR_PRESENT_FIXUP
Audit Admin Correction
Overload 1		 dbms_preup.aar_present_fixup;
exec dbms_preup.aar_present_fixup;
Overload 2 dbms_preup.aar_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.aar_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "AUDIT_ADMIN" found in the database.
This is an Oracle defined role. You must drop this role or user prior to upgrading.
0
 
AAR_PRESENT_GETHELP
Undocumented dbms_preup.aar_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.aar_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name AUDIT_ADMIN" found in the database. This is an Oracle defined role. you must drop this role or user prior to upgrading.
 
AMD_EXISTS_CHECK
Undocumented dbms_preup.amd_exists_check(result_txt OUT VARCHAR2) RETURN NUBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.amd_exists_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: INFORMATION: --> OLAP Catalog(AMD) exists in database Starting with Oracle Database 12c, OLAP is desupported. If you are not using the OLAP Catalog component and want to remove it, then execute the ORACLE_HOME/oraolap/admin/catnoamd.sql script before or after the upgrade.
 
AMD_EXISTS_FIXUP
Undocumented
Overload 1		 dbms_preup.amd_exists_fixup;
exec dbms_preup.amd_exists_fixup;
Overload 2 dbms_preup.amd_exists_fixup(
result_txt IN OUT VARCHAR2,
psqlcode   IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.amd_exists_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
INFORMATION: --> OLAP Catalog(AMD) exists in database Starting with Oracle Database 12c, OLAP is desupported.
If you are not using the OLAP Catalog component and want to remove it,
then execute the ORACLE_HOME/oraolap/admin/catnoamd.sql script before or after the upgrade.
0
 
AMD_EXISTS_GETHELP
Undocumented dbms_preup.amd_exists_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.amd_exists_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
 8 /
INFORMATION: --> OLAP Catalog(AMD) exists in database Starting with Oracle Database 12c, OLAP is desupported. If you are not using the OLAP Catalog component and want to remove it, then execute the ORACLE_HOME/oraolap/admin/catnoamd.sql script before or after the upgrade.
 
APPQOSSYS_USER_PRESENT_CHECK
Checks for the presence of internal user APPQOSSYS dbms_preup.appQOSSys_user_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.appqossys_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> "APPQOSSYS" user found in database. This is an internal account used by Oracle Application Quality of Service Management. Please drop this user prior to upgrading.
 
APPQOSSYS_USER_PRESENT_FIXUP
Drops the user APPQOSSYS
Overload 1		 dbms_preup.appQOSSys_user_present_fixup;
exec dbms_preup.appQOSSys_user_present_fixup;
Overload 2 dbms_preup.appQOSSys_user_present_fixup(
result_txt IN OUT VARCHAR2,
sqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.appQOSSys_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
0
ORA-28014: cannot drop administrative users -28014
 
APPQOSSYS_USER_PRESENT_GETHELP
Advisory message when user APPQOSSYS is found prior to upgrade dbms_preup.appQOSSys_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.appqossys_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> "APPQOSSYS" user found in database. This is an internal account used by Oracle Application Quality of Service Management. Please drop this user prior to upgrading.
 
AUDIT_RECORDS_RECOMMEND
Looks for records in sys.aud$ where DBID is null dbms_preup.audit_records_recommend;
exec dbms_preup.audit_records_recommend;
 
AUDIT_VIEWER_CHECK
Checks sys.user$ for the name  AUDIT_VIEWER dbms_preup.audit_viewer_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.audit_viewer_check(OutVal);
  dbms_output.put_line(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal));
END;
/
ERROR: --> A user or role with the name "AUDIT_VIEWER" found in the database. This is an Oracle defined role. You must drop this role or user prior to upgrading.
0
 
AUDIT_VIEWER_FIXUP
Undocumented
Overload 1		 dbms_preup.audit_viewer_fixup;
exec dbms_preup.audit_viewer_fixup;
Overload 2 dbms_preup.audit_viewer_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.audit_viewer_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "AUDIT_VIEWER" found in the database.
This is an Oracle defined role. You must drop this role or user prior to upgrading.
0
 
AUDIT_VIEWER_GETHELP
Undocumented dbms_preup.audit_viewer_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.audit_viewer_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "AUDIT_VIEWER" found in the database. This is an Oracle defined role. You must drop this role or user prior to upgrading.
 
AUDSYS_USER_PRESENT_CHECK
Checks sys.user$ for the name  AUDIT_VIEWER of type# = 1 dbms_preup.audsys_user_present_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.audsys_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> A user or role with the name "AUDSYS" found in the database. This is an internal account used by Oracle Database Auditing. You must drop this user or role prior to upgrading.
 
AUDSYS_USER_PRESENT_FIXUP
Undocumented
Overload 1		 dbms_preup.audsys_user_present_fixup;
exec dbms_preup.audsys_user_present_fixup;
Overload 2 dbms_preup.audsys_user_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.audsys_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "AUDSYS" found in the database.
This is an internal account used by Oracle Database Auditing. You must drop this user or role prior to upgrading.
0
 
AUDSYS_USER_PRESENT_GETHELP
Undocumented dbms_preup.audsys_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.audsys_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "AUDSYS" found in the database. This is an internal account used by Oracle Database Auditing. You must drop this user or role prior to upgrading.
 
AWR_DBIDS_PRESENT_CHECK
  dbms_preup.awr_dbids_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.awr_dbids_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Inactive DBIDs found in AWR AWR contains inactive DBIDs which may need additional updating after upgrading.
 
AWR_DBIDS_PRESENT_FIXUP
Overload 1 dbms_preup.awr_dbids_present_fixup;
exec dbms_preup.amd_exists_fixup;
Overload 2 dbms_preup.awr_dbids_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.awr_dbids_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Inactive DBIDs found in AWR
AWR contains inactive DBIDs which may need additional updating after upgrading.
0
 
AWR_DBIDS_PRESENT_GETHELP
  dbms_preup.awr_dbids_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.awr_dbids_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Inactive DBIDs found in AWR AWR contains inactive DBIDs which may need additional updating after upgrading.
 
CAPT_ADM_ROLE_PRESENT_CHECK
Undocumented dbms_preup.capt_adm_role_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.capt_adm_role_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> A user or role with the name "CAPTURE_ADMIN" found in the database. This is an Oracle defined role. You must drop this user or role prior to upgrading.
 
CAPT_ADM_ROLE_PRESENT_FIXUP
Overload 1 dbms_preup.capt_adm_role_present_fixup;
exec dbms_preup.capt_adm_role_present_fixup;
Overload 2 dbms_preup.capt_adm_role_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.capt_adm_role_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "CAPTURE_ADMIN" found in the database.
This is an Oracle defined role. You must drop this user or role prior to upgrading.
0
 
CAPT_ADM_ROLE_PRESENT_GETHELP
  dbms_preup.capt_adm_role_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.capt_adm_reole present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "CAPTURE_ADMIN" found in the database. This is an Oracle defined role. You must drop this user or role prior to upgrading.
 
CLEAR_RUN_FLAG
Undocumented dbms_preup.clear_run_flag(preup IN BOOLEAN);
DECLARE
 b BOOLEAN := TRUE;
BEGIN
  dbms_preup.clear_run_flag(b);
END;
/
 
CLOSE_FILE
Undocumented dbms_preup.close_file;
exec dbms_preup.close_file;
 
COMPATIBLE_PARAMETER_CHECK
Undocumented dbms_preup.compatible_parameter_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.compatible_parameter_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> Compatible set too low "compatible" currently set at and must be set to at least 11.0.0 prior to upgrading the database. Update your init.ora or spfile to make this change.
 
COMPATIBLE_PARAMETER_FIXUP
Overload 1 dbms_preup.compatible_parameter_fixup;
exec dbms_preup.compatible_parameter_fixup;
Overload 2 dbms_preup.compatible_parameter_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.compatible_parameter_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> Compatible set too low "compatible" currently set at and must be set to at least 11.0.0 prior to upgrading the database.
Update your init.ora or spfile to make this change.
0
 
COMPATIBLE_PARAMETER_GETHELP
Undocumented dbms_preup.compatible_parameter_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.compatible_parameter_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> Compatible set too low "compatible" currently set at 12.1.0.0.0 and must be set to at least 11.0.0 prior to upgrading the database.
Update your init.ora or spfile to make this change.

SR 3-8294649231 opened with Oracle 29 Dec 2013 as the return message is illogical.
 
CONDITION_EXISTS
Undocumented dbms_preup.condition_exists(check_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF dbms_preup.condition_exists('DV_ENABLED') THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
DBG_ALL_CHECKS
Debug All Checks dbms_preup.dbg_all_checks;
exec dbms_preup.dbg_all_checks;
 
DBG_ALL_RESOURCES
Debug All Resources dbms_preup.dbg_all_resources(onoff IN BOOLEAN);
exec  dbms_preup.dbg_all_resources(TRUE);
 
DBG_CHECK
Debug a specifc check dbms_preup.dbg_check(check_name IN VARCHAR2);
exec dbms_preup.dbg_check('DV_ENABLED'); -- an obviously invalid value
 
DBG_SPACE_RESOURCES
Debug space resources dbms_preup.dbg_space_resources(onoff IN BOOLEAN);
exec dbms_preup.dbg_space_resources(TRUE);
 
DBMS_LDAP_DEP_EXIST_CHECK
Checks for DBMS_LDAP dependencies dbms_preup.dbms_ldap_dep_exist_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.dbms_ldap_dep_exist_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Existing DBMS_LDAP dependent objects
Database contains schemas with objects dependent on DBMS_LDAP package.
Refer to the Upgrade Guide for instructions to configure Network ACLs.
USER APEX_040200 has dependent objects.
 
DBMS_LDAP_DEP_EXIST_FIXUP
Overload 1 dbms_preup.dbms_ldap_dep_exist_fixup;
exec dbms_preup.dbms_ldap_dep_exist_fixup;
Overload 2 dbms_preup.dbms_ldap_dep_exist_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.dbms_ldap_dep_exist_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Existing DBMS_LDAP dependent objects Database contains schemas with objects dependent on DBMS_LDAP package.
Refer to the Upgrade Guide for instructions to configure Network ACLs. USER APEX_040200 has dependent objects.
 
DBMS_LDAP_DEP_EXIST_GETHELP
Undocumented dbms_preup.dbms_ldap_dep_exist_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.dbms_ldap_dep_exist_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Existing DBMS_LDAP dependent objects

Database contains schemas with objects dependent on DBMS_LDAP package.
Refer to the Upgrade Guide for instructions to configure Network ACLs.
USER APEX_040200 has dependent objects.
 
DEFAULT_PROCESS_COUNT_CHECK
Undocumented dbms_preup.default_process_count_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.default_process_count_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
 
DEFAULT_PROCESS_COUNT_FIXUP
Undocumented
Overload 1		 dbms_preup.default_process_count_fixup;
exec dbms_preup.default_process_count_fixup;
Overload 2 dbms_preup.default_process_count_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.default_process_count_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Process Count may be too low Database has a maximum process count of 300 which is lower than the default value of 300 for this release.
You should update your processes value prior to the upgrade to a value of at least 300.
For example: ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE or update your init.ora file.
 
DEFAULT_PROCESS_COUNT_GETHELP
Undocumented dbms_preup.default_process_count_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.default_process_count_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Process Count may be too low

Database has a maximum process count of 300 which is lower than the default value of 300 for this release.
You should update your processes value prior to the upgrade to a value of at least 300.
For example: ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE or update your init.ora file.
 
DICTIONARY_STATS_RECOMMEND
Displays a message recommending the collection of dictionary stats for all the DBAs that don't read the docs until something breaks. dbms_preup.dictionary_stats_recommend;
exec dbms_preup.dictionary_stats_recommend;
*****************************************
********* Dictionary Statistics *********
*****************************************
Please gather dictionary statistics 24 hours prior to upgrading the database.
To gather dictionary statistics execute the following command while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
^^^ MANUAL ACTION SUGGESTED ^^^
 
DISPLAYDIAGLINE
A prepared call to DisplayLine dbms_preup.displayDiagLine(line IN VARCHAR2);
exec dbms_preup.displayDiagLine('Morgan''s Library Demo');

DBG: Morgan's Library Demo
 
DISPLAYLINE
Undocumented
Overload 1		 dbms_preup.displayLine(line IN VARCHAR2);
exec dbms_preup.displayLine('Morgan''s Library Demo');
Morgan's Library Demo
Overload 2 dbms_preup.displayLine(
uft  IN utl_file.file_type,
line IN VARCHAR2);
TBD
 
DISPLAY_CHECK_TEXT
Undocumented dbms_preup.display_check_text(check_record IN check_record_t );
DECLARE
 retVal dbms_preup.check_record_t;
BEGIN
  retVal := dbms_preup.run_check('DV_ENABLED');
  dbms_preup.display_check_text(retVal);
END;
/
WARNING: --> Oracle Database Vault is enabled in this database

Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade. To disable Database Vault, log in as Database Vault administrator and run this operation:
DVSYS.DBMS_MACAMD.DISABLE_DV()
 
DUMP_CHECK_REC
Display a single check record field dbms_preup.dump_check_rec(p_check_rec IN check_record_t);
TBD
 
DV_ENABLED_CHECK
Checks to see if Database Vault is enabled dbms_preup.dv_enabled_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.dv_enabled_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Oracle Database Vault is enabled in this database
    Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade. To disable Database Vault, log in as Database Vault administrator and run this operation: DVSYS.DBMS_MACAMD.DISABLE_DV()
 
DV_ENABLED_FIXUP
Undocumented
Overload 1		 dbms_preup.dv_enabled_fixup;
exec dbms_preup.dv_enabled_fixup;
Overload 2 dbms_preup.dv_enabled_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.dv_enabled_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Oracle Database Vault is enabled in this database Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade.
To disable Database Vault, log in as Database Vault administrator and run this operation: DVSYS.DBMS_MACAMD.DISABLE_DV()
 
DV_ENABLED_GETHELP
Undocumented dbms_preup.dv_enabled_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.dv_enabled_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Oracle Database Vault is enabled in this database Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade. To disable Database Vault, log in as Database Vault administrator and run this operation: DVSYS.DBMS_MACAMD.DISABLE_DV()
 
EM_PRESENT_CHECK
Undocumented dbms_preup.em_present_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.em_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Enterprise Manager Database Control repository found in the database
    In Oracle Database 12c, Database Control is removed during the upgrade.
    To save time during the Upgrade, this action can be done prior to upgrading as follows:
    Copy rdbms/admin/emremove.sql from the new Oracle home and execute it from the SYS account while connected AS DBA.
 
EM_PRESENT_FIXUP
Undocumented
Overload 1		 dbms_preup.em_present_fixup;
exec dbms_preup.em_present_fixup;
Overload 2 dbms_preup.em_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.em_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Enterprise Manager Database Control repository found in the database In Oracle Database 12c, Database Control is removed during the upgrade.
To save time during the Upgrade, this action can be done prior to upgrading using the following steps after copying rdbms/admin/emremove.sql from the new Oracle home - Stop EM Database Control: $> emctl stop dbconsole - Connect to the Database using the SYS account AS SYSDBA: SET ECHO ON; SET SERVEROUTPUT ON; @emremove.sql
Without the set echo and serveroutput commands you will not be able to follow the progress of the script.
 
EM_PRESENT_GETHELP
Undocumented dbms_preup.em_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.em_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Enterprise Manager Database Control repository found in the database

In Oracle Database 12c, Database Control is removed during the upgrade. To save time during the Upgrade, this action can be done prior to upgrading using the following steps after copying rdbms/admin/emremove.sql from the new Oracle home
- Stop EM
Database Control:
$> emctl stop dbconsole

- Connect to the Database using the SYS account AS SYSDBA:

SET ECHO ON;
SET SERVEROUTPUT ON;
@emremove.sql
Without the set echo and serveroutput commands you will not be able to follow the progress of the script.
 
ENABLED_INDEXES_TBL_CHECK
Checks to see if sys.enabled$indexes exists prior to an upgrade dbms_preup.enabled_indexes_tbl_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.enabled_indexes_tbl_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Table sys.enabled$indexes exists in the database
    DROP TABLE sys.enabled$indexes prior to upgrading the database.
 
ENABLED_INDEXES_TBL_FIXUP
Undocumented
Overload 1		 dbms_preup.enabled_indexes_tbl_fixup;
exec dbms_preup.enabled_indexes_tbl_fixup;
Overload 2 dbms_preup.enabled_indexes_tbl_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.enabled_indexes_tbl_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
0
ORA-00942: table or view does not exist
-942
 
ENABLED_INDEXES_TBL_GETHELP
Help text if sys.enabled$indexes exists prior to upgrade dbms_preup.enabled_indexes_tbl_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.enabled_indexes_tbl_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Table sys.enabled$indexes exists in the database

DROP TABLE sys.enabled$indexes prior to upgrading the database.
 
END_XML_DOCUMENT
Returns a closing XML tag dbms_preup.end_xml_document;
exec dbms_preup.end_xml_document;
</RDBMSUP>
 
EXF_RUL_EXISTS_CHECK
Checks to see if the AUDIT_ADMIN role exists prior to upgrade dbms_preup.exf_rul_exists_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.exf_rul_exists_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
EXF_RUL_EXISTS_FIXUP
Audit Admin Correction
Overload 1		 dbms_preup.exf_rul_exists_fixup;
exec dbms_preup.exf_rul_exists_fixup;
Overload 2 dbms_preup.exf_rul_exists_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.exf_rul_exists_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
INFORMATION: --> Expression Filter (EXF) or Rules Manager (RUL) exist in database and will be removed during the upgrade.
Starting with Oracle Database release 12.1, the Expression Filter (EXF) and Database Rules Manager (RUL) features are desupported and will be removed during the upgrade process.
To save time during the upgrade, this action can be done prior to upgrading by executing the ORACLE_HOME/rdbms/admin/catnoexf.sql script.
0
 
EXF_RUL_EXISTS_GETHELP
Undocumented dbms_preup.exf_rul_exists_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.exf_rul_exists_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
INFORMATION: --> Expression Filter (EXF) or Rules Manager (RUL) exist in database and will be removed during the upgrade.

Starting with Oracle Database release 12.1, the Expression Filter (EXF) and Database Rules Manager (RUL) features are desupported and will be removed during the upgrade process. To save time during the upgrade, this action can be done prior to upgrading by executing the ORACLE_HOME/rdbms/admin/catnoexf.sql script.
 
FILES_BACKUP_MODE_CHECK
Checks to see if any datafiles are currently in backup mode dbms_preup.files_backup_mode_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.files_backup_mode_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
2:
 
FILES_BACKUP_MODE_FIXUP
Undocumented
Overload 1		 dbms_preup.files_backup_mode_fixup;
exec dbms_preup.files_backup_mode_fixup;
Overload 2 dbms_preup.files_backup_mode_fixup(
result_txt IN OUT VARCHAR2,
psqlcode   IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.files_backup_mode_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> There are files in backup mode Ensure no files are in backup mode prior to upgrade.
 
FILES_BACKUP_MODE_GETHELP
Warning message if files are found in backup mode prior to an upgrade dbms_preup.files_backup_mode_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.files_backup_mode_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> There are files in backup mode

Ensure no files are in backup mode prior to upgrade.
 
FILES_NEED_RECOVERY_CHECK
Advises the admin if any files currently require recovery dbms_preup.files_need_recovery_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.files_need_recovery_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> There are files which need media recovery Ensure no files need media recovery prior to upgrade.
 
FILES_NEED_RECOVERY_FIXUP
Undocumented
Overload 1		 dbms_preup.files_need_recovery_fixup;
exec dbms_preup.files_need_recovery_fixup;
Undocumented

Overload 2		 dbms_preup.files_need_recovery_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.files_need_recovery_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> There are files which need media recovery Ensure no files need media recovery prior to upgrade.
 
FILES_NEED_RECOVERY_GETHELP
Advises if files require recovery prior to backup dbms_preup.files_need_recovery_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.files_need_recovery_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> There are files which need media recovery Ensure no files need media recovery prior to upgrade.
 
FIXED_OBJECTS_RECOMMEND
Makes post-upgrade recomendation on actions to take with respect to fixed objects dbms_preup.fixed_objects_recommend;
exec dbms_preup.fixed_objects_recommend;

******** Fixed Object Statistics ********
Please create stats on fixed objects two weeks
after the upgrade using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
^^^ MANUAL ACTION SUGGESTED ^^^
 
FIXUP_SUMMARY
Undocumented dbms_preup.fixup_summary(preup IN BOOLEAN);
DECLARE
 b BOOLEAN := TRUE;
BEGIN
  dbms_preup.fixup_summary(b);
END;
/
************************************************
************* Fixup Summary *************
No fixup routines were executed.
************************************************

-- on a different 12c system got this output:
ERROR at line 1:
ORA-20000: Pre-Upgrade Package Fixup Summary called prior to fixups being executed
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_PREUP", line 5674
ORA-06512: at line 4
 
GET_OUTPUT_PATH
Returns the directory  path used to output log/script if a script is being generated at run-time dbms_preup.get_output_path RETURN VARCHAR2;
SELECT dbms_preup.get_output_path
FROM dual;

GET_OUTPUT_PATH
--------------------------------------------
*** Scripts/Logs are not being Generated ***

-- on a different 12c system got this output:
GET_OUTPUT_PATH
-------------------------------------------------------------------------------------------------------------------------
*** Scripts/Logs are not being Generated ***

SQL> SELECT dbms_preup.get_version
2 FROM dual;

GET_VERSION
-------------------------------------------------------------------------------------------------------------------------
12.1.0.1
 
GET_VERSION
Returns the database version number dbms_preup.get_version RETURN VARCHAR2;
SELECT dbms_preup.get_version
FROM dual;

GET_VERSION
----------------------------------
12.1.0.1
 
HIDDEN_PARAMS_RECOMMEND
Returns the SQL to identify recommended changes to current startup parameters dbms_preup.hidden_params_recommend;
exec dbms_preup.hidden_params_recommend;
 
INVALID_LAF_CHECK
Undocumented dbms_preup.invalid_laf_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.invalid_laf_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> log_archive_format must be updated As of 10.1, log_archive_format requires a %r format qualifier be present in its format string.
Your current setting is: log_archive_format='%t_%s_%r.dbf'.
Archive Logging is currently OFF, but failure to add the %r to the format string will still prevent the upgraded database from starting up.
 
INVALID_LAF_FIXUP
Undocumented
Overload 1		 dbms_preup.invalid_laf_fixup;
exec dbms_preup.invalid_laf_fixup;
Overload 2 dbms_preup.invalid_laf_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.invalid_laf_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> log_archive_format must be updated As of 10.1, log_archive_format requires a %r format qualifier be present in its format string.
Your current setting is: log_archive_format='%t_%s_%r.dbf'.
Archive Logging is currently OFF, but failure to add the %r to the format string will still prevent the upgraded database from starting up.
 
INVALID_LAF_GETHELP
Undocumented dbms_preup.invalid_laf_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.invalid_laf_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> log_archive_format must be updated As of 10.1, log_archive_format requires a %r format qualifier be present in its format string.
Your current setting is: log_archive_format='%t_%s_%r.dbf'.
Archive Logging is currently OFF, but failure to add the %r to the format string will still prevent the upgraded database from starting up.
 
INVALID_OBJ_EXCLUDE
Undocumented dbms_preup.invalid_obj_exclude RETURN VARCHAR2;
SELECT dbms_preup.invalid_obj_exclude
FROM dual;

INVALID_OBJ_EXCLUDE
--------------------------------------------------------------------------------
'V$LOGMNR_SESSION', 'V$ACTIVE_SESSION_HISTORY', 'V$BUFFERED_SUBSCRIBERS', 'GV$FLASH_RECOVERY_AREA_USAGE', 'GV$ACTIVE_SESSION_HISTORY', 'GV$BUFFERED_SUBSCRIBERS', 'V$RSRC_PLAN', 'V$SUBSCR_REGISTRATION_STATS', 'GV$STREAMS_APPLY_READER', 'GV$ARCHIVE_DEST', 'GV$LOCK', 'DBMS_STATS_INTERNAL', 'V$STREAMS_MESSAGE_TRACKING', 'GV$SQL_SHARED_CURSOR', 'V$RMAN_COMPRESSION_ALGORITHM', 'V$RSRC_CONS_GROUP_HISTORY', 'V$PERSISTENT_SUBSCRIBERS', 'V$RMAN_STATUS', 'GV$RSRC_CONSUMER_GROUP', 'V$ARCHIVE_DEST', 'GV$RSRCMGRMETRIC', 'GV$RSRCMGRMETRIC_HISTORY', 'V$PERSISTENT_QUEUES', 'GV$CPOOL_CONN_INFO', 'GV$RMAN_COMPRESSION_ALGORITHM', 'DBA_BLOCKERS', 'V$STREAMS_TRANSACTION', 'V$STREAMS_APPLY_READER', 'GV$SGA_DYNAMIC_FREE_MEMORY', 'GV$BUFFERED_QUEUES', 'GV$RSRC_PLAN_HISTORY', 'GV$ENCRYPTED_TABLESPACES', 'V$ENCRYPTED_TABLESPACES', 'GV$RSRC_CONS_GROUP_HISTORY', 'GV$RSRC_PLAN', 'GV$RSRC_SESSION_INFO', 'V$RSRCMGRMETRIC', 'V$STREAMS_CAPTURE', 'V$RSRCMGRMETRIC_HISTORY', 'GV$STREAMS_TRANSACTION', 'DBMS_LOGREP_UTIL', 'V$RSRC_SESSION_INFO', 'GV$STREAMS_CAPTURE', 'V$RSRC_PLAN_HISTORY', 'GV$FLASHBACK_DATABASE_LOGFILE', 'V$BUFFERED_QUEUES', 'GV$PERSISTENT_SUBSCRIBERS', 'GV$FILESTAT', 'GV$STREAMS_MESSAGE_TRACKING', 'V$RSRC_CONSUMER_GROUP', 'V$CPOOL_CONN_INFO', 'DBA_DML_LOCKS', 'V$FLASHBACK_DATABASE_LOGFILE', 'GV$HM_RECOMMENDATION', 'V$SQL_SHARED_CURSOR', 'GV$PERSISTENT_QUEUES', 'GV$FILE_HISTOGRAM', 'DBA_WAITERS', 'GV$SUBSCR_REGISTRATION_STATS', 'DBA_KGLLOCK'

SQL> SELECT owner, object_name
  2 FROM dba_objects
  3 WHERE status = 'INVALID';

OWNER                     OBJECT_NAME
------------------------- ------------------------------
SYS                       SHARDQ
SYS                       DBMS_LIBCACHE
SYS                       AQ$_SHARDQ_V
SYS                       SHARDQ_R
PUBLIC                    WLM_METRICS_STREAM
PUBLIC                    WLM_CLASSIFIER_PLAN
PUBLIC                    WLM_MPA_STREAM
PUBLIC                    WLM_VIOLATION_STREAM
 
INVALID_OBJ_EXIST_CHECK
Undocumented dbms_preup.invalid_obj_exist_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.invalid_obj_exist_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Database contains INVALID objects prior to upgrade
    The list of invalid SYS/SYSTEM objects was written to registry$sys_inv_objs.
    The list of non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs unless there were over 5000.
    Use utluiobj.sql after the upgrade to identify any new invalid objects due to the upgrade.
 
INVALID_OBJ_EXIST_FIXUP
Undocumented
Overload 1		 dbms_preup.invalid_obj_exist_fixup;
exec dbms_preup.invalid_obj_exist_fixup;
Overload 2 dbms_preup.invalid_obj_exist_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.invalid_obj_exist_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Database contains INVALID objects prior to upgrade
The list of invalid SYS/SYSTEM objects was written to registry$sys_inv_objs.
The list of non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs unless there were over 5000.
Use utluiobj.sql after the upgrade to identify any new invalid objects due to the upgrade.
0
 
INVALID_OBJ_EXIST_GETHELP
Undocumented dbms_preup.invalid_obj_exist_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.invalid_obj_exist_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Database contains INVALID objects prior to upgrade
The list of invalid SYS/SYSTEM objects was written to
registry$sys_inv_objs.
The list of non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs unless there were over 5000.
Use utluiobj.sql after the upgrade to identify any new invalid objects due to the upgrade.
 
INVALID_SYS_TABLEDATA_CHECK
Undocumented dbms_preup.invalid_sys_tabledata_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.invalid_sys_tabledata_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> Invalid Oracle supplied table data found in your database.
Invalid data can be seen prior to the database upgrade or during PDB plug in.
This table data must be made valid BEFORE upgrade or plug in. - To fix the data, load the Preupgrade package and execute the fixup routine.
For plug in, execute the fix up routine in the PDB.
@?/rdbms/admin/utluppkg.sql SET SERVEROUTPUT ON; exec dbms_preup.run_fixup_and_report('INVALID_SYS_TABLEDATA') SET SERVEROUTPUT OFF;
 
INVALID_SYS_TABLEDATA_FIXUP
Undocumented
Overload 1		 dbms_preup.invalid_sys_tabledata_fixup;
exec dbms_preup.invalid_sys_tabledata_fixup;
Overload 2 dbms_preup.invalid_sys_tabledata_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.invalid_sys_tabledata_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
1
 
INVALID_SYS_TABLEDATA_GETHELP
Undocumented dbms_preup.invalid_sys_tabledata_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.invalid_sys_tabledata_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> Invalid Oracle supplied table data found in your database. Invalid data can be seen prior to the database upgrade or during PDB plug in.
This table data must be made valid BEFORE upgrade or plug in.
- To fix the data, load the Preupgrade package and execute the fixup routine.
For plug in, execute the fix up routine in the PDB.
@?/rdbms/admin/utluppkg.sql SET SERVEROUTPUT ON;
exec dbms_preup.run_fixup_and_report('INVALID_SYS_TABLEDATA') SET SERVEROUTPUT OFF;
 
INVALID_USR_TABLEDATA_CHECK
Undocumented dbms_preup.invalid_usr_tabledata_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.invalid_usr_tabledata_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> Invalid user table data found in your database.
Invalid data can be seen prior to the database upgrade or during PDB plug in.
This table data must be made valid BEFORE upgrade or plug in.
- To fix the data, load the Preupgrade package and execute the fixup routine.
For plug in, execute the fix up routine in the PDB.
@?/rdbms/admin/utluppkg.sql SET SERVEROUTPUT ON;
exec dbms_preup.run_fixup_and_report('INVALID_USR_TABLEDATA');
SET SERVEROUTPUT OFF;
 
INVALID_USR_TABLEDATA_FIXUP
Undocumented
Overload 1		 dbms_preup.invalid_usr_tabledata_fixup;
exec dbms_preup.invalid_usr_tabledata_fixup;
Overload 2 dbms_preup.invalid_usr_tabledata_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.invalid_usr_tabledata_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
1
 
INVALID_USR_TABLEDATA_GETHELP
Undocumented dbms_preup.invalid_usr_tabledata_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.invalid_usr_tabledata_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> Invalid user table data found in your database. Invalid data can be seen prior to the database upgrade or during PDB plug in.
This table data must be made valid BEFORE upgrade or plug in.
- To fix the data, load the Preupgrade package and execute the fixup routine.
For plug in, execute the fix up routine in the PDB.
@?/rdbms/admin/utluppkg.sql SET SERVEROUTPUT ON;
exec dbms_preup.run_fixup_and_report('INVALID_USR_TABLEDATA');
SET SERVEROUTPUT OFF;
 
JOB_QUEUE_PROCESS_CHECK
Undocumented dbms_preup.job_queue_process_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.job_queue_process_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_PREUP", line 8130
ORA-06512: at line 5
 
JOB_QUEUE_PROCESS_FIXUP
Undocumented
Overload 1		 dbms_preup.job_queue_process_fixup;
exec dbms_preup.job_queue_process_fixup;
Overload 2 dbms_preup.job_queue_process_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.job_queue_process_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> job_queue_processes set too low
This parameter must be removed or updated to a value greater than (default value if not defined is 1000) prior to upgrade.
Not doing so will affect the running of utlrp.sql after the upgrade
Update your init.ora or spfile to make this change.
 
JOB_QUEUE_PROCESS_GETHELP
Undocumented dbms_preup.job_queue_process_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.job_queue_process_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> job_queue_processes set too low
This parameter must be removed or updated to a value greater than (default value if not defined is 1000) prior to upgrade.
Not doing so will affect the running of utlrp.sql after the upgrade
Update your init.ora or spfile to make this change.
 
NACL_OBJECTS_EXIST_CHECK
Undocumented dbms_preup.nacl_objects_exist_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.nacl_objects_exist_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> Existing schemas with network ACLs exist
Database contains schemas with objects dependent on network packages.
Refer to the Upgrade Guide for instructions to configure Network ACLs.
USER APEX_040200 has dependent objects. USER MDSYS has dependent objects.
USER ORACLE_OCM has dependent objects.
USER DVSYS has dependent objects.
USER GSMADMIN_INTERNAL has dependent objects.
 
NACL_OBJECTS_EXIST_FIXUP
Undocumented
Overload 1		 dbms_preup.nacl_objects_exist_fixup;
exec dbms_preup.nacl_objects_exist_fixup;
Overload 2 dbms_preup.nacl_objects_exist_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.nacl_objects_exist_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Existing schemas with network ACLs exist
Database contains schemas with objects dependent on network packages.
Refer to the Upgrade Guide for instructions to configure Network ACLs.
USER APEX_040200 has dependent objects.
USER MDSYS has dependent objects.
USER ORACLE_OCM has dependent objects.
USER DVSYS has dependent objects.
USER GSMADMIN_INTERNAL has dependent objects.
 
NACL_OBJECTS_EXIST_GETHELP
Undocumented dbms_preup.nacl_objects_exist_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.nacl_objects_exist_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Existing schemas with network ACLs exist
Database contains schemas with objects dependent on network packages.
Refer to the Upgrade Guide for instructions to configure Network ACLs.
USER APEX_040200 has dependent objects.
USER MDSYS has dependent objects.
USER ORACLE_OCM has dependent objects.
USER DVSYS has dependent objects.
USER GSMADMIN_INTERNAL has dependent objects.
 
NEW_TIME_ZONES_EXIST_CHECK
Undocumented dbms_preup.new_time_zones_exist_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.new_time_zones_exist_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> New Timezone File in use
Database is using a time zone file newer than version 18.
BEFORE upgrading the database, patch the new ORACLE_HOME/oracore/zoneinfo/ with a time zone data file of the same version as the one used in the release database.
 
NEW_TIME_ZONES_EXIST_FIXUP
Undocumented
Overload 1		 dbms_preup.new_time_zones_exist_fixup;
exec dbms_preup.new_time_zones_exist_fixup;
Overload 2 dbms_preup.new_time_zones_exist_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.new_time_zones_exist_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> New Timezone File in use
Database is using a time zone file newer than version 18.
BEFORE upgrading the database, patch the new ORACLE_HOME/oracore/zoneinfo/ with a time zone data file of the same version as the one used in the release database.
 
NEW_TIME_ZONES_EXIST_GETHELP
Undocumented dbms_preup.new_time_zones_exist_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.new_time_zones_exist_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/ERROR: --> New Timezone File in use
Database is using a time zone file newer than version 18.
BEFORE upgrading the database, patch the new ORACLE_HOME/oracore/zoneinfo/ with a time zone data file of the same version as the one used in the release database.
 
OCM_USER_PRESENT_CHECK
Undocumented dbms_preup.ocm_user_present_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.ocm_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: WARNING: --> "ORACLE_OCM" user found in database
This is an internal account used by Oracle Configuration Manager.
Please drop this user prior to upgrading.
 
OCM_USER_PRESENT_FIXUP
Undocumented
Overload 1		 dbms_preup.ocm_user_present_fixup;
exec dbms_preup.ocm_user_present_fixup;
Overload 2 dbms_preup.ocm_user_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.ocm_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
0
ORA-28014: cannot drop administrative users
-28014
 
OCM_USER_PRESENT_GETHELP
Undocumented dbms_preup.ocm_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.ocm_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> "ORACLE_OCM" user found in database
This is an internal account used by Oracle Configuration Manager.
Please drop this user prior to upgrading.
 
OLD_TIME_ZONES_EXIST_CHECK
Undocumented dbms_preup.old_time_zones_exist_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.old_time_zones_exist_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: INFORMATION: --> Older Timezone in use
Database is using a time zone file older than version 18.
After the upgrade, it is recommended that DBMS_DST package be used to upgrade the database time zone version to the latest version which comes with the new release.
Please refer to My Oracle Support note number 977512.1 for details.
 
OLD_TIME_ZONES_EXIST_FIXUP
Undocumented
Overload 1		 dbms_preup.old_time_zones_exist_fixup;
exec dbms_preup.old_time_zones_exist_fixup;
Overload 2 dbms_preup.old_time_zones_exist_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.old_time_zones_exist_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
INFORMATION: --> Older Timezone in use
Database is using a time zone file older than version 18.
After the upgrade, it is recommended that DBMS_DST package be used to upgrade the database time zone version to the latest version which comes with the new release.
Please refer to My Oracle Support note number 977512.1 for details.
0
 
OLD_TIME_ZONES_EXIST_GETHELP
Undocumented dbms_preup.old_time_zones_exist_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.old_time_zones_exist_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
INFORMATION: --> Older Timezone in use
Database is using a time zone file older than version 18.
After the upgrade, it is recommended that DBMS_DST package be used to upgrade the database time zone version to the latest version which comes with the new release. Please refer to My Oracle Support note number 977512.1 for details.
 
OLS_SYS_MOVE_CHECK
Undocumented dbms_preup.old_sys_move_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.ols_sys_move_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: ERROR: --> SYSTEM.AUD$ (audit records) Move
An error occured retrieving a count from SYSTEM.AUD$
This can happen when the table has already been cleaned up.
The olspreupgrade.sql script should be re-executed.
 
OLS_SYS_MOVE_FIXUP
Undocumented
Overload 1		 dbms_preup.ols_sys_move_fixup;
exec dbms_preup.ols_sys_move_fixup;
Overload 2 dbms_preup.ols_sys_move_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.ols_sys_move_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> SYSTEM.AUD$ (audit records) Move
An error occured retrieving a count from SYSTEM.AUD$
This can happen when the table has already been cleaned up.
The olspreupgrade.sql script should be re-executed.
 
OLS_SYS_MOVE_GETHELP
Undocumented dbms_preup.ols_sys_move_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.ols_sys_move_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> SYSTEM.AUD$ (audit records) Move
An error occured retrieving a count from SYSTEM.AUD$
This can happen when the table has already been cleaned up.
The olspreupgrade.sql script should be re-executed.
 
ORDIMAGEINDEX_CHECK
Undocumented dbms_preup.ordImageIndex_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.ordImageIndex_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
0: INFORMATION: --> ORDSYS.OrdImageIndex in use
The previously desupported Oracle Multimedia image domain index, ORDSYS.
OrdImageIndex, is no longer supported and has been removed in Oracle Database 11g Release 2 (11.2).
Following is the list of affected indexes that are dropped during the upgrade.
 
ORDIMAGEINDEX_FIXUP
Undocumented
Overload 1		 dbms_preup.ordImageIndex_fixup;
exec dbms_preup.ordImageindex_fixup;
Overload 2 dbms_preup.ordImageIndex_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.ordImageIndex_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
OrdimageIndexes are cleaned up as part of the upgrade
1
 
ORDIMAGEINDEX_GETHELP
Undocumented dbms_preup.ordImageIndex_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.ordImageIndex_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
INFORMATION: --> ORDSYS.OrdImageIndex in use
The previously desupported Oracle Multimedia image domain index, ORDSYS.
OrdImageIndex, is no longer supported and has been removed in Oracle Database 11g Release 2 (11.2).
Following is the list of affected indexes that are dropped during the upgrade.
 
OUTPUT_CHECK_SUMMARY
Undocumented dbms_preup.output_check_summary;
exec dbms_preup.output_components;
****************************************************
Results of the checks are located at:
*** Scripts/Los are not being Generated ***preupgrade.log
 
OUTPUT_COMPONENTS
Undocumented dbms_preup.output_components;
exec dbms_preup.output_components;
**********************************************************************
[Component List]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] OPTION OFF
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> Oracle Label Security [upgrade] VALID
--> Oracle Database Vault [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle Multimedia [upgrade] INVALID
--> Oracle Spatial [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID

PL/SQL procedure successfully completed.

SQL> SELECT comp_name, version, status
  2 FROM dba_registry;

COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
Oracle Database Vault 12.1.0.1.0 VALID
Oracle Application Express 4.2.0.00.27 VALID
Oracle Label Security 12.1.0.1.0 VALID
Spatial 12.1.0.1.0 VALID
Oracle Multimedia 12.1.0.1.0 INVALID
Oracle Text 12.1.0.1.0 VALID
Oracle Workspace Manager 12.1.0.1.0 VALID
Oracle XML Database 12.1.0.1.0 VALID
Oracle Database Catalog Views 12.1.0.1.0 VALID
Oracle Database Packages and Types 12.1.0.1.0 VALID
JServer JAVA Virtual Machine 12.1.0.1.0 VALID
Oracle XDK 12.1.0.1.0 VALID
Oracle Database Java Packages 12.1.0.1.0 VALID
OLAP Analytic Workspace 12.1.0.1.0 VALID
Oracle OLAP API 12.1.0.1.0 VALID
Oracle Real Application Clusters 12.1.0.1.0 OPTION OFF
 
OUTPUT_FLASHBACK
Undocumented dbms_preup.output_flashback;
exec dbms_preup.output_flashback;
 
OUTPUT_INITPARAMS
Undocumented dbms_preup.output_initparams;
exec  dbms_preup.output_initparams;

**********************************************************************
[Renamed Parameters]
WARNING: --> "commit_write" new name is "commit_logging,commit_wait"
[Changes required in Oracle Database init.ora or spfile]
**********************************************************************
**********************************************************************
[Obsolete/Deprecated Parameters]
--> commit_write 11.1 DESUPPORTED
--> parallel_io_cap_enabled 11.2 DESUPPORTED
[Changes required in Oracle Database init.ora or spfile]

-- on another 12c database observed this:
**********************************************************************
[Renamed Parameters]
[No Renamed Parameters in use]
**********************************************************************
**********************************************************************
[Obsolete/Deprecated Parameters]
[No Obsolete or Desupported Parameters in use]
 
OUTPUT_PREUP_CHECKS
Undocumented dbms_preup.output_preup_checks;
exec dbms_preup.output_preup_checks;

**********************************************************************
[Pre-Upgrade Checks]
**********************************************************************
 
OUTPUT_PROLOG
Undocumented dbms_preup.output_prolog;
exec dbms_preup.output_prolog;

************ Summary ************
0 ERRORS exist in your database.
0 WARNINGS exist in your database.
0 INFORMATIONAL messages messages have been reported.

After your database is upgraded and open in normal mode you must run rdbms/admin/catuppst.sql which executes several required tasks and completes the upgrade process.

You should follow that with the execution of rdbms/admin/utlrp.sql, and a comparison of invalid objects before and after the upgrade using rdbms/admin/utluiobj.sql

If needed you may want to upgrade your timezone data using the process described in My Oracle Support note 977512.1

***********************************
 
OUTPUT_RECOMMENDATIONS
Undocumented dbms_preup.output_recommendations;
exec dbms_preup.output_recommendations;

**********************************************************************
[Pre-Upgrade Recommendations]
**********************************************************************
*****************************************
********* Dictionary Statistics *********
*****************************************
Please gather dictionary statistics 24 hours prior to upgrading the database.
To gather dictionary statistics execute the following command while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
^^^ MANUAL ACTION SUGGESTED ^^^
**********************************************************************
[Post-Upgrade Recommendations]
**********************************************************************
*****************************************
******** Fixed Object Statistics ********
*****************************************
Please create stats on fixed objects two weeks after the upgrade using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
^^^ MANUAL ACTION SUGGESTED ^^^
**********************************************************************
 
OUTPUT_RESOURCES
Undocumented dbms_preup.output_resources;
exec dbms_preup.output_resources;

**********************************************************************
[ Unsupported Upgrade: Tablespace Data Supressed ]
**********************************************************************
DBG: Archivelog: CATALOG 580
DBG: Flashbacklog: CATALOG 285
DBG: Archivelog: CATPROC 1427
DBG: Flashbacklog: CATPROC 365
DBG: Archivelog: JAVAVM 455
DBG: Flashbacklog: JAVAVM 160
DBG: Archivelog: XML 96
DBG: Flashbacklog: XML 55
DBG: Archivelog: RAC 0
DBG: Flashbacklog: RAC 0
DBG: Archivelog: OWM 49
DBG: Flashbacklog: OWM 60
DBG: Archivelog: APS 96
DBG: Flashbacklog: APS 0
DBG: Archivelog: OLS 0
DBG: Flashbacklog: OLS 0
DBG: Archivelog: DV 47
DBG: Flashbacklog: DV 0
DBG: Archivelog: CONTEXT 92
DBG: Flashbacklog: CONTEXT 0
DBG: Archivelog: XDB 174
DBG: Flashbacklog: XDB 55
DBG: Archivelog: CATJAVA 50
DBG: Flashbacklog: CATJAVA 0
DBG: Archivelog: ORDIM 354
DBG: Flashbacklog: ORDIM 0
DBG: Archivelog: SDO 487
DBG: Flashbacklog: SDO 115
DBG: Archivelog: EXF 0
DBG: Flashbacklog: EXF 0
DBG: Archivelog: RUL 0
DBG: Flashbacklog: RUL 0
DBG: Archivelog: APEX 822
DBG: Flashbacklog: APEX 0
DBG: Archivelog: XOQ 49
DBG: Flashbacklog: XOQ 0
DBG: Archivelog: STATS 0
DBG: Flashbacklog: STATS 0
**********************************************************************
[ Unsupported Upgrade: Flashback Data Supressed ]
**********************************************************************
--> name:
--> limit: 0 MB
--> used: 0 MB
--> size: 0 MB
--> reclaim: 0 MB
--> files: 0
WARNING: --> Flashback Database is enabled.
Ensure adequate disk space exists in the flash recovery area
before performing the upgrade. Your recovery area
will require at least 0 MB - or greater - of free space.
**********************************************************************
 
OUTPUT_ROLLBACK_SEGS
Undocumented dbms_preup.output_rollback_segs;
exec dbms_preup.output_rollback_segs;
 
OUTPUT_SUMMARY
Undocumented dbms_preup.output_summary;
exec dbms_preup.output_summary;

Oracle Database Pre-Upgrade Information Tool 07-30-2013 16:04:42
Script Version: 12.1.0.1.0 Build: 006
**********************************************************************
Database Name: ORABASE2
Version: 12.1.0.1.0
Compatible: 12.1.0.0.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone file: V18
 
OUTPUT_TABLESPACES
Undocumented dbms_preup.output_tablespaces;
exec dbms_preup.output_tablespaces;

**********************************************************************
[ Unsupported Upgrade: Tablespace Data Supressed ]
**********************************************************************
 
PENDING_2PC_TXN_CHECK
Undocumented dbms_preup.pending_2pc_txn_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.pending_2pc_txn_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
PENDING_2PC_TXN_FIXUP
Undocumented
Overload 1		 dbms_preup.pending_2pc_txn_fixup;
exec dbms_preup.pending_2pc_txn_fixup;
Overload 2 dbms_preup.pending_2pc_txn_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.pending_2pc_txn_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> Unresolved distributed transactions
There are outstanding unresolved distributed transactions.
Resolve all outstanding distributed transactions prior to upgrade.
 
PENDING_2PC_TXN_GETHELP
Undocumented dbms_preup.pending_2pc_txn_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.pending_2pc_txn_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> Unresolved distributed transactions
There are outstanding unresolved distributed transactions.
Resolve all outstanding distributed transactions prior to upgrade.
 
PURGE_RECYCLEBIN_CHECK
Undocumented dbms_preup.purge_recyclebin_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.purge_recyclebin_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
PURGE_RECYCLEBIN_FIXUP
Undocumented
Overload 1		 dbms_preup.purge_recyclebin_fixup;
exec dbms_preup.purge_recyclebin_fixup;
Overload 2 dbms_preup.purge_recyclebin_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.purge_recyclebin_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
1
 
PURGE_RECYCLEBIN_GETHELP
Undocumented dbms_preup.purge_recyclebin_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.purge_recyclebin_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> Recycle Bin not empty
Your recycle bin contains 0 object(s).
It is REQUIRED that the recycle bin is empty prior to upgrading your database. The command:
execute dbms_preup.purge_recyclebin_fixup;
must be executed immediately prior to executing your upgrade.
 
REMOTE_REDO_CHECK
Undocumented dbms_preup.remove_redo_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.remote_redo_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
2:
 
REMOTE_REDO_FIXUP
Undocumented
Overload 1		 dbms_preup.remote_redo_fixup;
exec dbms_preup.remote_redo_fixup;
Overload 2 dbms_preup.remote_redo_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.remote_redo_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> REDO Configuration not supported in 11.2
Your REDO configuration is defaulting the use of
LOG_ARCHIVE_DEST_10 for local archiving of redo data to the recovery area and has also defined
LOG_ARCHIVE_DEST_1 for remote use.
Starting with 11.2, only LOG_ARCHIVE_DEST_1 is used for defaulting local archival of redo data.
You must specify a destination for local archiving since LOG_ARCHIVE_DEST_1 is not available.
 
REMOTE_REDO_GETHELP
Undocumented dbms_preup.remove_redo_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.remote_redo_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> REDO Configuration not supported in 11.2
Your REDO configuration is defaulting the use of LOG_ARCHIVE_DEST_10 for local archiving of redo data to the recovery area and has also defined
LOG_ARCHIVE_DEST_1 for remote use.
Starting with 11.2, only LOG_ARCHIVE_DEST_1 is used for defaulting local archival of redo data.
You must specify a destination for local archiving since LOG_ARCHIVE_DEST_1 is not available.
 
REMOVE_DMSYS_CHECK
Undocumented dbms_preup.remove_dmsys_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.remove_dmsys_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
REMOVE_DMSYS_FIXUP
Undocumented
Overload 1		 dbms_preup.remove_dmsys_fixup;
exec dbms_preup.remove_dmsys_fixup;
Overload 2 dbms_preup.remove_dmsys_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.remove_dmsys_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> "DMSYS" schema exists in the database
The DMSYS schema (Oracle Data Mining) will be removed from the database during the database upgrade.
All data in DMSYS will be preserved under the SYS schema.
Refer to the Oracle Data Mining User's Guide for details.
 
REMOVE_DMSYS_GETHELP
Undocumented dbms_preup.remove_dmsys_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.remove_dmsys_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> "DMSYS" schema exists in the database
The DMSYS schema (Oracle Data Mining) will be removed from the database during the database upgrade.
All data in DMSYS will be preserved under the SYS schema.
Refer to the Oracle Data Mining User's Guide for details.
 
RESET_INIT_PACKAGE
Undocumented dbms_preup.reset_init_package;
exec dbms_preup.reset_init_package;
 
RUN_ALL_CHECKS
Undocumented dbms_preup.run_all_checks RETURN NUMBER;
SELECT dbms_preup.run_all_checks
FROM dual;

RUN_ALL_CHECKS
--------------
            43
 
RUN_ALL_RECOMMEND
Undocumented dbms_preup.run_all_recommend(whatType IN NUMBER);
SQL> exec dbms_preup.run_all_recommend(6);

PL/SQL procedure successfully completed.

SQL> exec dbms_preup.run_all_recommend(1);

PL/SQL procedure successfully completed.

SQL> exec dbms_preup.run_all_recommend(0);

PL/SQL procedure successfully completed.

SQL> exec dbms_preup.run_all_recommend(-99); -- possibly an input validation issue

PL/SQL procedure successfully completed.
 
RUN_CHECK
Undocumented dbms_preup.run_check(check_name IN VARCHAR2) RETURN check_record_t;
DECLARE
 retVal dbms_preup.check_record_t;
BEGIN
  retVal := dbms_preup.run_check_simple('DV_ENABLED');
  dbms_preup.display_check_text(retVal);
END;
/
 
RUN_CHECK_SIMPLE
Undocumented dbms_preup.run_check_simple(check_name IN VARCHAR2) RETURN check_record_t;
DECLARE
 retVal dbms_preup.check_record_t;
BEGIN
  retVal := dbms_preup.run_check_simple('DV_ENABLED');
  dbms_output.put_line(retVal.name);
END;
/
 
RUN_FIXUP
Undocumented dbms_preup.run_fixup(check_name IN VARCHAR2) RETURN check_record_t;
DECLARE
 retVal dbms_preup.check_record_t;
BEGIN
  retVal := dbms_preup.run_fixup('DV_ENABLED');
  dbms_output.put_line(retVal.name);
END;
/
DV_ENABLED
 
RUN_FIXUP_AND_REPORT
Run a check, and instead of returning a record with the info
on the run, dumps any errors to stdout		 dbms_preup.run_fixup_and_report(check_name IN VARCHAR2)
exec dbms_preup.run_fixup_and_report('DV_ENABLED');

**********************************************************************
Check Tag: DV_ENABLED
Check Summary: Check if Database Vault is enabled Fix Summary: Database Vault must be disabled prior to upgrading.
**********************************************************************
Fixup Returned Information: WARNING: --> Oracle Database Vault is enabled in this database

Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade.
To disable Database Vault, log in as Database Vault administrator and run this operation:
DVSYS.DBMS_MACAMD.DISABLE_DV()
**********************************************************************
 
RUN_FIXUP_INFO
Undocumented dbms_preup.run_fixup_info(check_name IN VARCHAR2);
exec dbms_preup.run_fixup_info('DV_ENABLED');

------- ---------- Executing Fixup ------------ ----------
------- DV_ENABLED ----------
------- ------------ Fixup Succeeded ----------- ----------
------- ------- Informational Text Returned ---- ----------
WARNING: --> Oracle Database Vault is enabled in this database

Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade.
To disable Database Vault, log in as Database Vault administrator and run this operation:
DVSYS.DBMS_MACAMD.DISABLE_DV()
------- ---------------------------------------- ----------
 
RUN_RECOMMEND
Undocumented dbms_preup.run_recommend(check_name IN VARCHAR2) RETURN check_record_t;
DECLARE
 tvar dbms_preup.check_record_t;
BEGIN
  tvar := dbms_preup.run_recommend('DV_ENABLED');
  dbms_output.put_line(tvar.name);
  dbms_output.put_line(tvar.type);
  dbms_output.put_line(tvar.descript);
  dbms_output.put_line(tvar.f_name_prefix);
  dbms_output.put_line(tvar.level);
  dbms_output.put_line(tvar.fix_type);
  dbms_output.put_line(tvar.valid_versions);
  dbms_output.put_line(tvar.result_text);
  dbms_output.put_line(tvar.sqlcode);
END;
/
DV_ENABLED
1
Check if Database Vault is enabled
DV_ENABLED
2
0
ALL
WARNING: --> Oracle Database Vault is enabled in this database

Starting with release 12.1, it is REQUIRED that Database Vault be disabled prior to database upgrade.
To disable Database Vault, log in as Database Vault administrator and run this operation:
DVSYS.DBMS_MACAMD.DISABLE_DV()
0
 
SET_OUTPUT_FILE
Enable/disable output file
Overload 1		 dbms_preup.set_output_file(p_on_off BOOLEAN);
exec dbms_preup.set_output_file(TRUE);
Set outputfile file name
Overload 2		 dbms_preup.set_output_file(p_fn VARCHAR2);
exec dbms_preup.set_output_file('PREUP.LOG');
Set output file directory and file name
Overload 3		 dbms_preup.set_output_file(p_location VARCHAR2, p_fn VARCHAR2);
-- if the location is invalid produces a UTL_FILE exception
exec dbms_preup.set_output_file('c:\stage', 'PREUP.LOG');
or
exec dbms_preup.set_output_file('CTEMP', 'PREUP.LOG');
 
SET_OUTPUT_TYPE
Set the output type as text or XML dbms_preup.set_output_type(p_type IN VARCHAR2);
exec dbms_preup.set_output_type('anything_you_want'); -- produces a text file output
or
exec dbms_preup.set_output_type('XML');               -- produces an XML output
 
SET_SCRIPTS
Turn generating scripts on/off dbms_preup.set_scripts(p_on_off IN BOOLEAN);
exec dbms_preup.set_scripts(TRUE);
 
START_XML_DOCUMENT
Begin writing an XML document dbms_preup.start_xml_document;
exec dbms_preup.start_xml_document;

<RDBMSUP xmlns="http://www.oracle.com/Upgrade" version="12.1.0.1">
 
SYNC_STANDBY_DB_CHECK
Undocumented dbms_preup.sync_standby_db_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.sync_standby_db_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
SYNC_STANDBY_DB_FIXUP
Undocumented
Overload 1		 dbms_preup.sync_standby_db_fixup;
exec dbms_preup.sync_standby_db_fixup;
Overload 2 dbms_preup.sync_standby_db_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.sync_standby_db_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Standby database not synced
Sync standby database prior to upgrade.
Your standby databases should be synched prior to upgrading.
 
SYNC_STANDBY_DB_GETHELP
Undocumented dbms_preup.sync_standby_db_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.sync_standby_db_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> Standby database not synced
Sync standby database prior to upgrade.
Your standby databases should be synched prior to upgrading.
 
SYSBACKUP_USER_PRESENT_CHECK
Undocumented dbms_preup.sysbackup_user_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.sysbackup_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
2:
 
SYSBACKUP_USER_PRESENT_FIXUP
Undocumented
Overload 1		 dbms_preup.sysbackup_user_present_fixup;
exec dbms_preup.sysbackup_user_present_fixup;
Overload 2 dbms_preup.sysbackup_user_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.sysbackup_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "SYSBACKUP" found in the database.
This is an Oracle defined user.
You must drop this user or role prior to upgrading.
0
 
SYSBACKUP_USER_PRESENT_GETHELP
Undocumented dbms_preup.sysbackup_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.sysbackup_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "SYSBACKUP" found in the database.
This is an Oracle defined user.
You must drop this user or role prior to upgrading.
 
SYSDG_USER_PRESENT_CHECK
Is the SYSDG user present check dbms_preup.sysdg_user_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.sysdg_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
2:
 
SYSDG_USER_PRESENT_FIXUP
SYSDG user present fix recommendation
Overload 1		 dbms_preup.sysdg_user_present_fixup;
exec dbms_preup.sysdg_user_present_fixup;
Overload 2 dbms_preup.sysdg_user_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.sysdg_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "SYSDG" found in the database.

This is an Oracle defined user.
You must drop this user or role prior to upgrading.
0
 
SYSDG_USER_PRESENT_GETHELP
SYSDG user help text dbms_preup.sysdg_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.sysdg_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "SYSDG" found in the database.

This is an Oracle defined user.
You must drop this user or role prior to upgrading.
 
SYSKM_USER_PRESENT_CHECK
Is the SYSKM user present check dbms_preup.syskm_user_present_check(
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.syskm_user_present_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
2:
 
SYSKM_USER_PRESENT_FIXUP
SYSKM user present fix recommendation
Overload 1		 dbms_preup.syskm_user_present_fixup;
exec dbms_preup.syskm_user_present_fixup;
Overload 2 dbms_preup.syskm_user_present_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.syskm_user_present_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> A user or role with the name "SYSKM" found in the database.

This is an Oracle defined user.
You must drop this user or role prior to upgrading.
0
 
SYSKM_USER_PRESENT_GETHELP
SYSKM user help text dbms_preup.syskm_user_present_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.syskm_user_present_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
ERROR: --> A user or role with the name "SYSKM" found in the database.
This is an Oracle defined user.
You must drop this user or role prior to upgrading.
 
SYS_DEF_TABLESPACE_CHECK
Undocumented dbms_preup.sys_def_tablespace_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.sys_def_tablespace_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
SYS_DEF_TABLESPACE_FIXUP
Undocumented
Overload 1		 dbms_preup.sys_def_tablespace_fixup;
exec dbms_preup.sys_def_tablespace_fixup;
Overload 2 dbms_preup.sys_def_tablespace_fixup(
result_txt  IN OUT VARCHAR2,
psqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.sys_def_tablespace_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
1
1
 
SYS_DEF_TABLESPACE_GETHELP
Undocumented dbms_preup.sys_def_tablespace_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 RetVal  VARCHAR2(1024);
 HlpType NUMBER := 1;
BEGIN
  RetVal := dbms_preup.sys_def_tablespace_getHelp(HlpType);
  dbms_output.put_line(RetVal);
END;
/
WARNING: --> SYS and SYSTEM schema default tablespace has been altered

Prior to upgrading your database, please ensure both the SYS and SYSTEM schema default their tablespace to SYSTEM.
Execute: execute dbms_preup.SYS_DEF_TABLESPACE_fixup;
 
TIME_ZONE_CHECK
Undocumented dbms_preup.time_zone_check;
exec dbms_preup.time_zone_check;
 
TZ_FIXUP
Undocumented dbms_preup.tz_fixup(call_init IN BOOLEAN);
exec dbms_preup.tz_fixup(TRUE);
 
ULTRASEARCH_DATA_CHECK
Undocumented dbms_preup.ultrasSearch_data_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.ultraSearch_data_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
ULTRASEARCH_DATA_FIXUP
Undocumented
Overload 1		 dbms_preup.ultraSearch_data_fixup;
exec dbms_preup.ultrasearch_data_fixup;
Overload 2 dbms_preup.ultraSearch_data_fixup(
result_txt IN OUT VARCHAR2,
sqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.ultrasearch_data_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
WARNING: --> Ultra Search not supported

Ultra Search is not supported as of 11.2 and is removed during the upgrade.
You may perform this task prior to the upgrade by using wkremov.sql  located in the rdbms/admin directory of the new software installation.
If you wish to preserve the Ultra Search data please perform a manual cold backup prior to upgrade.
 
ULTRASEARCH_DATA_GETHELP
Undocumented dbms_preup.ultraSearch_data_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.ultraSearch_data_getHelp(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "SYS.DBMS_PREUP", line 9450
ORA-06512: at line 5
 
UNDERSCORE_EVENTS_RECOMMEND
Undocumented dbms_preup.underscore_events_recommend;
exec dbms_preup.underscore_events_recommend;
 
UNSUPPORTED_VERSION_CHECK
Undocumented dbms_preup.unsupported_version_check(result_txt OUT VARCHAR2) RETURN NUMBER;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.unsupported_version_check(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
1:
 
UNSUPPORTED_VERSION_FIXUP
Undocumented
Overload 1		 dbms_preup.unsupported_version_fixup;
exec dbms_preup.unsupported_version_fixup;
Overload 2 dbms_preup.unsupported_version_fixup(
result_txt IN OUT VARCHAR2,
sqlcode    IN OUT NUMBER)
RETURN NUMBER;
DECLARE
 pCode   NUMBER;
 resTxt  VARCHAR2(1024);
 retVal  NUMBER;
BEGIN
  retVal := dbms_preup.unsupported_version_fixup(resTxt, pCode);
  dbms_output.put_line(TO_CHAR(retVal));
  dbms_output.put_line(resTxt);
  dbms_output.put_line(TO_CHAR(pCode));
END;
/
2
ERROR: --> Unsupported Version Upgrade

*****************************************
**** YOU CANNOT UPGRADE THIS DATABASE TO THIS RELEASE ****
*****************************************
Direct upgrade from 12.1.0.1 is not supported.
Please refer to Chapter 2 of the Oracle Database Upgrade Guide for the matrix of releases supported for direct upgrade.
 
UNSUPPORTED_VERSION_GETHELP
Undocumented dbms_preup.unsupported_version_getHelp(HelpType IN NUMBER) RETURN VARCHAR2;
DECLARE
 OutVal VARCHAR2(1024);
 RetVal NUMBER;
BEGIN
  RetVal := dbms_preup.unsupported_version_getHelp(OutVal);
  dbms_output.put_line(TO_CHAR(RetVal) || ': ' || OutVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "SYS.DBMS_PREUP", line 9524
ORA-06512: at line 5

Related Topics
DBMS_OUTPUT
DBMS_REGISTRY
DBMS_SYSTEM
Packages
UTL_FILE

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved