1 PACKAGE dbms_preup AS
2 --
3 -- preupgrd.sql will look at the version to
4 -- make sure things match up.
5 --
6 c_version CONSTANT VARCHAR2(30) := '12.1.0.2';
7
8 c_patchset CONSTANT VARCHAR2(2) := '.0';
9 c_build CONSTANT VARCHAR2(30) := '015';
10 c_supported_versions
11 CONSTANT VARCHAR(100) := '10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, 11.2.0.4, 12.1.0.1';
12 c_max_processes CONSTANT NUMBER := 300;
13 c_min_open_cursors CONSTANT NUMBER := 150; -- min value for upgrades to
14 -- 12102 (needed for APEX)
15
16 -- c_NA_str : the display string to indicate Not Applicable for container info
17 -- c_NA_ver : the version where container info is not applicable is pre-12.1
18 c_NA_str CONSTANT VARCHAR2(100) := 'Not Applicable in Pre-12.1 database';
19 c_NA_ver CONSTANT VARCHAR2(30) := '12.1.0.1';
20
21 --
22 -- what we require for min compat, in numeric and
23 -- text form
24 --
25 c_compat_min_num CONSTANT NUMBER := 11;
26 c_compat_min CONSTANT VARCHAR(30) := '11.0.0';
27
28 -- directory objects and file names for preupgrade text output
29 c_dir_obj CONSTANT VARCHAR2(30) := 'PREUPGRADE_DIR'; -- top level dir obj
30 c_output_fn CONSTANT VARCHAR2(30) := 'preupgrade.log';
31 c_pre_script_fn CONSTANT VARCHAR2(30) := 'preupgrade_fixups.sql';
32 c_post_script_fn CONSTANT VARCHAR2(30) := 'postupgrade_fixups.sql';
33 c_pdb_dir_obj CONSTANT VARCHAR2(30) := 'PDB_PREUPGRADE_DIR'; -- pdb subdir
34
35 -- file name components to 'preupgrade.log', 'preupgrade_fixups.sql' and
36 -- 'postupgrade_fixups.sql'
37 c_text_log_base CONSTANT VARCHAR2(30) := 'preupgrade.'; -- base name
38 c_text_log_suffix CONSTANT VARCHAR2(30) := '.log'; -- suffix name
39 c_pre_fixup_base CONSTANT VARCHAR2(30) := 'preupgrade_fixups.'; -- base name
40 c_post_fixup_base CONSTANT VARCHAR2(30) := 'postupgrade_fixups.'; -- base name
41 c_fixup_suffix CONSTANT VARCHAR2(30) := '.sql'; -- fixup script suffix name
42
43 -- file components to 'upgrade.xml'
44 c_xml_log_base CONSTANT VARCHAR2(30) := 'upgrade.'; -- base name
45 c_xml_log_suffix CONSTANT VARCHAR2(30) := '.xml'; -- suffix name
46
47 -- write lock file info
48 c_wrlock_fname CONSTANT VARCHAR2(30) := 'writelock.lck';
49 c_wrlock_max_waits CONSTANT NUMBER := 600; -- max waits/loops for write lock
50 c_wrlock_sleep_secs CONSTANT NUMBER := 1; -- 1 sec-sleep/wait for write lock
51
52 --
53 -- TO DO: these are the latest versions shipped that needs to be
54 -- reviewed and/or updated per oracle release
55 --
56 -- latest time zone file shipped
57 c_tz_version CONSTANT NUMBER := 18;
58 -- latest apex version shipped
59 c_apex_version CONSTANT VARCHAR2(20) := '4.2.5'; -- list first 6 places
60
61 --
62 -- What kind of output are we doing?
63 --
64 c_output_text CONSTANT NUMBER := 1;
65 c_output_xml CONSTANT NUMBER := 2;
66
67 --
68 -- UTL_FILE attributes
69 --
70 c_fopen_max_lsz CONSTANT NUMBER := 15000; -- max linesize to UTL_FILE.FOPEN
71
72 --
73 -- Used to keep track of pre-upgrade checks
74 --
75 --
76 TYPE check_record_t IS RECORD (
77 name VARCHAR2(30), -- Name of check (and used for function
78 -- names also (if not too long))
79 type NUMBER, -- see type constants for values
80 -- c_type_check = standard check for both xdb/manual
81 -- c_type_check_interactive_only = Standard check, but manual only
82 -- c_type_recommend_pre = pre-up recommendation (manual)
83 -- c_type_recommend_post = post-up recommendation (manual)
84 --
85 descript VARCHAR2(100), -- Short description of the check
86 f_name_prefix VARCHAR2(30), -- If name is too long to add
87 -- "_gethelp" and create a valid
88 -- function name, this is set to a
89 -- shorten name to be used when accessing
90 -- a check's functions.
91 level NUMBER, -- Check level (c_check_level_....)
92 fix_type NUMBER, -- fix_type (by_fixup, manual)
93 executed BOOLEAN, -- Has the test been run?
94 execute_failed BOOLEAN, -- If the check takes an exception.
95 passed BOOLEAN, -- Did the check pass?
96 skipped BOOLEAN, -- Skipped, check not valid for this version
97 fixup_executed BOOLEAN, -- Was a fixup attempted ?
98 fixup_failed BOOLEAN, -- Did the fixup execute fail?
99 fixup_status NUMBER, -- c_fixup_status... value
100 always_fail BOOLEAN, -- Debug the check's failure path (generate a fixup)
101 valid_versions VARCHAR(100), -- What versions is this check valid for?
102 result_text VARCHAR2(4000), -- result of fixup/check
103 sqlcode NUMBER -- The sqlcode should an error occur.
104 );
105 TYPE check_table_t is TABLE of check_record_t INDEX BY BINARY_INTEGER;
106
107 --
108 -- This record is to index the check_table by name
109 --
110 TYPE check_record_name_t IS RECORD (
111 idx NUMBER -- Index into check_table
112 );
113
114 TYPE check_names_table_t is TABLE of check_record_name_t INDEX BY VARCHAR2(30);
115
116 --
117 -- dbms_preup.check_table contains
118 -- a list of all of the checks this package (once inited)
119 -- has performed on the database.
120 --
121 -- Although check_table could have been indexed by name, doing so would have
122 -- changed the order when looping through as new checks were added or old
123 -- checks removed.
124 --
125 check_table check_table_t;
126
127 --
128 -- Index by name
129 --
130 check_names check_names_table_t;
131
132
133 pCheckCount NUMBER := 0; -- Total number of checks we have available.
134 pCheckErrorCount NUMBER;
135 pCheckWarningCount NUMBER;
136 pCheckInfoCount NUMBER;
137
138 --
139 -- How the fix can be fixed
140 --
141 c_fix_source_manual CONSTANT NUMBER := 0;
142 c_fix_source_auto CONSTANT NUMBER := 1; -- pre-upgrade
143 c_fix_target_auto_pre CONSTANT NUMBER := 2; -- targetpre - only new timezone
144 c_fix_target_auto_post CONSTANT NUMBER := 3; -- after upgrade process is done
145 c_fix_target_manual_pre CONSTANT NUMBER := 4; -- manual, before
146 c_fix_target_manual_post CONSTANT NUMBER := 5; -- manual after upgrade
147 --
148 -- Type of Check
149 --
150 c_type_check CONSTANT NUMBER := 1;
151 c_type_check_interactive_only CONSTANT NUMBER := 2;
152 c_type_recommend_pre CONSTANT NUMBER := 3;
153 c_type_recommend_post CONSTANT NUMBER := 4;
154
155 --
156 -- What gethelp returns
157 --
158 c_help_overview CONSTANT NUMBER := 1;
159 c_help_fixup CONSTANT NUMBER := 2;
160
161 --
162 -- What a Fixup routine could return
163 --
164 c_fixup_status_failure CONSTANT NUMBER := 0;
165 c_fixup_status_success CONSTANT NUMBER := 1;
166 c_fixup_status_info CONSTANT NUMBER := 2;
167
168 --
169 -- What Check/help routine could return
170 --
171 c_status_failure CONSTANT NUMBER := 0;
172 c_status_success CONSTANT NUMBER := 1;
173 c_status_passed CONSTANT NUMBER := 1;
174 c_status_not_for_this_version CONSTANT NUMBER := 2;
175
176 -- Functions
177
178 FUNCTION get_version RETURN VARCHAR2;
179 FUNCTION run_all_checks RETURN NUMBER;
180
181 FUNCTION run_check (check_name IN VARCHAR2) RETURN check_record_t;
182 FUNCTION run_check_simple (check_name IN VARCHAR2) RETURN check_record_t;
183 FUNCTION condition_exists (check_name IN VARCHAR2) RETURN BOOLEAN;
184 PROCEDURE run_check (check_name IN VARCHAR2);
185 FUNCTION run_fixup (check_name IN VARCHAR2) RETURN check_record_t;
186 PROCEDURE run_fixup_and_report (check_name VARCHAR2);
187 PROCEDURE run_fixup_info (check_name VARCHAR2);
188 PROCEDURE display_check_text (check_record check_record_t );
189 PROCEDURE fixup_summary (preup BOOLEAN);
190 PROCEDURE clear_run_flag (preup BOOLEAN);
191
192 FUNCTION run_recommend (check_name IN VARCHAR2) RETURN check_record_t;
193 PROCEDURE run_all_recommend (whatType NUMBER);
194
195 PROCEDURE DisplayLine (line IN VARCHAR2);
196 PROCEDURE DisplayLine (uft UTL_FILE.FILE_TYPE, line IN VARCHAR2);
197 PROCEDURE DisplayDiagLine (line IN VARCHAR2);
198
199 PROCEDURE start_xml_document;
200 PROCEDURE end_xml_document;
201
202 PROCEDURE output_summary;
203 PROCEDURE output_components;
204 PROCEDURE output_flashback;
205 PROCEDURE output_initparams;
206 PROCEDURE output_preup_checks;
207 PROCEDURE output_prolog;
208 PROCEDURE output_check_summary;
209 PROCEDURE output_recommendations;
210 PROCEDURE output_resources;
211 PROCEDURE output_tablespaces;
212 PROCEDURE output_rollback_segs;
213
214 --
215 -- Call these to debug a certain check,
216 -- debug all checks, or debug tablespace resources
217 --
218 PROCEDURE dbg_check (check_name IN VARCHAR2);
219 PROCEDURE dbg_all_checks;
220 PROCEDURE dbg_all_resources (onoff BOOLEAN);
221 PROCEDURE dbg_space_resources (onoff BOOLEAN);
222 PROCEDURE time_zone_check;
223 PROCEDURE tz_fixup (call_init BOOLEAN);
224
225 --
226 -- Set the output type to either Text or XML
227 --
228 -- If XML is chosen, a call to start_xml_document
229 -- and close_xml_docuement must be
230 -- made to ensure correct syntax of the XML output.
231 --
232 -- Output type default to TEXT
233 --
234 PROCEDURE set_output_type (p_type VARCHAR2);
235
236 --
237 -- If the diag output is going to a file, use these
238 -- proceduress to set, and close that output file.
239 --
240 -- The package uses utl_file, and if there is an
241 -- error opening the file, the package will throw
242 -- an error.
243 --
244 PROCEDURE set_output_file (p_on_off BOOLEAN);
245 PROCEDURE set_output_file (p_fn VARCHAR2);
246 PROCEDURE set_output_file (p_location VARCHAR2, p_fn VARCHAR2);
247
248 PROCEDURE close_file;
249
250 FUNCTION get_con_id RETURN NUMBER; -- get container or db id
251 FUNCTION get_con_name RETURN VARCHAR2; -- get container or db name
252 FUNCTION is_con_root RETURN BOOLEAN; -- is this container a root? TRUE/FALSE
253 FUNCTION is_db_noncdb RETURN BOOLEAN; -- is this db a non-cdb? TRUE/FALSE
254 FUNCTION get_npdbs RETURN NUMBER; -- get total # of pdbs in cdb
255
256 FUNCTION is_db_readonly RETURN BOOLEAN; -- is this db READ ONLY? TRUE/FALSE
257
258 -- append a pdb file to end of main destination file
259 PROCEDURE write_pdb_file (locDirObj IN VARCHAR2,
260 pdbFileName IN VARCHAR2,
261 pdbFilePtr IN OUT UTL_FILE.FILE_TYPE,
262 destFileName IN VARCHAR2);
263
264 PROCEDURE concat_pdb_file; -- create write lock and then call write_pdb_file
265
266 PROCEDURE output_results_location; -- display results (log and fixups) location
267
268 -- begin logging preupgrade action into registry$log
269 PROCEDURE begin_log_preupg_action;
270
271 -- end logging preupgrade action into registry$log
272 PROCEDURE end_log_preupg_action;
273
274 PROCEDURE end_preupgrd; -- ending/finishing-up preupgrade tool
275
276 --
277 -- Turn generating fixup scripts on/off
278 --
279 PROCEDURE set_fixup_scripts (p_on_off BOOLEAN);
280
281 --
282 -- Function to get path of directory used to output log/script
283 --
284 FUNCTION get_output_path RETURN VARCHAR2;
285
286 --
287 -- Display a single check record fields
288 --
289 PROCEDURE dump_check_rec (p_check_rec check_record_t);
290
291 --
292 -- Specific Check/fixup Functions
293 --
294 FUNCTION amd_exists_check (result_txt OUT VARCHAR2) RETURN number;
295 PROCEDURE amd_exists_fixup;
296 FUNCTION amd_exists_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
297 FUNCTION amd_exists_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
298
299 FUNCTION aar_present_check (result_txt OUT VARCHAR2) RETURN number;
300 PROCEDURE aar_present_fixup;
301 FUNCTION aar_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
302 FUNCTION aar_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
303
304 FUNCTION appqossys_user_present_check (result_txt OUT VARCHAR2) RETURN number;
305 PROCEDURE appqossys_user_present_fixup;
306 FUNCTION appqossys_user_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
307 FUNCTION appqossys_user_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
308
309 FUNCTION audsys_user_present_check (result_txt OUT VARCHAR2) RETURN number;
310 PROCEDURE audsys_user_present_fixup;
311 FUNCTION audsys_user_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
312 FUNCTION audsys_user_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
313
314 FUNCTION audit_viewer_check (result_txt OUT VARCHAR2) RETURN number;
315 PROCEDURE audit_viewer_fixup;
316 FUNCTION audit_viewer_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
317 FUNCTION audit_viewer_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
318
319 FUNCTION SYSBACKUP_USER_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
320 FUNCTION SYSBACKUP_USER_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
321 PROCEDURE SYSBACKUP_USER_PRESENT_fixup;
322 FUNCTION SYSBACKUP_USER_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
323
324 FUNCTION SYSDG_USER_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
325 FUNCTION SYSDG_USER_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
326 PROCEDURE SYSDG_USER_PRESENT_fixup;
327 FUNCTION SYSDG_USER_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
328
329 FUNCTION SYSKM_USER_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
330 FUNCTION SYSKM_USER_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
331 PROCEDURE SYSKM_USER_PRESENT_fixup;
332 FUNCTION SYSKM_USER_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
333
334 FUNCTION CAPT_ADM_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
335 FUNCTION CAPT_ADM_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
336 PROCEDURE CAPT_ADM_ROLE_PRESENT_fixup;
337 FUNCTION CAPT_ADM_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
338
339 FUNCTION GSMCATUSER_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
340 FUNCTION GSMCATUSER_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
341 PROCEDURE GSMCATUSER_PRESENT_fixup;
342 FUNCTION GSMCATUSER_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
343
344 FUNCTION GSMUSER_USER_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
345 FUNCTION GSMUSER_USER_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
346 PROCEDURE GSMUSER_USER_PRESENT_fixup;
347 FUNCTION GSMUSER_USER_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
348
349 FUNCTION GSMADM_INT_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
350 FUNCTION GSMADM_INT_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
351 PROCEDURE GSMADM_INT_PRESENT_fixup;
352 FUNCTION GSMADM_INT_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
353
354 FUNCTION GSMUSER_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
355 FUNCTION GSMUSER_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
356 PROCEDURE GSMUSER_ROLE_PRESENT_fixup;
357 FUNCTION GSMUSER_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
358
359 FUNCTION GSM_PAD_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
360 FUNCTION GSM_PAD_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
361 PROCEDURE GSM_PAD_ROLE_PRESENT_fixup;
365 FUNCTION GSMADMIN_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
362 FUNCTION GSM_PAD_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
363
364 FUNCTION GSMADMIN_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
366 PROCEDURE GSMADMIN_ROLE_PRESENT_fixup;
367 FUNCTION GSMADMIN_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
368
369 FUNCTION GDS_CT_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
370 FUNCTION GDS_CT_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
371 PROCEDURE GDS_CT_ROLE_PRESENT_fixup;
372 FUNCTION GDS_CT_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
373
374
375 FUNCTION awr_dbids_present_check (result_txt OUT VARCHAR2) RETURN number;
376 PROCEDURE awr_dbids_present_fixup;
377 FUNCTION awr_dbids_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
378 FUNCTION awr_dbids_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
379
380 FUNCTION compatible_parameter_check (result_txt OUT VARCHAR2) RETURN number;
381 PROCEDURE compatible_parameter_fixup;
382 FUNCTION compatible_parameter_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
383 FUNCTION compatible_parameter_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
384
385 FUNCTION dbms_ldap_dep_exist_check (result_txt OUT VARCHAR2) RETURN number;
386 PROCEDURE dbms_ldap_dep_exist_fixup;
387 FUNCTION dbms_ldap_dep_exist_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
388 FUNCTION dbms_ldap_dep_exist_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
389
390 FUNCTION default_process_count_check (result_txt OUT VARCHAR2) RETURN number;
391 PROCEDURE default_process_count_fixup;
392 FUNCTION default_process_count_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
393 FUNCTION default_process_count_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
394
395 -- jvm_mitigation patch check backport for bug 20950535. Check if JAVAVM mitigation patch is installed in the database.
396 FUNCTION jvm_mitigation_patch_check (result_txt OUT VARCHAR2) RETURN number;
397 PROCEDURE jvm_mitigation_patch_fixup;
398 FUNCTION jvm_mitigation_patch_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
399 FUNCTION jvm_mitigation_patch_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
400
401 -- post_jvm_mitigat patch check backport for bug 20950535. Information to warn customer at tend of upgrade.
402 FUNCTION post_jvm_mitigat_patch_check (result_txt OUT VARCHAR2) RETURN number;
403 PROCEDURE post_jvm_mitigat_patch_fixup;
404 FUNCTION post_jvm_mitigat_patch_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
405 FUNCTION post_jvm_mitigat_patch_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
406
407 FUNCTION dv_enabled_check (result_txt OUT VARCHAR2) RETURN number;
408 PROCEDURE dv_enabled_fixup;
409 FUNCTION dv_enabled_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
410 FUNCTION dv_enabled_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
411
412 FUNCTION em_present_check (result_txt OUT VARCHAR2) RETURN number;
413 PROCEDURE em_present_fixup;
414 FUNCTION em_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
415 FUNCTION em_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
416
417 FUNCTION enabled_indexes_tbl_check (result_txt OUT VARCHAR2) RETURN number;
418 PROCEDURE enabled_indexes_tbl_fixup;
419 FUNCTION enabled_indexes_tbl_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
420 FUNCTION enabled_indexes_tbl_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
421
422 FUNCTION exf_rul_exists_check (result_txt OUT VARCHAR2) RETURN number;
423 PROCEDURE exf_rul_exists_fixup;
424 FUNCTION exf_rul_exists_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
425 FUNCTION exf_rul_exists_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
426
427 FUNCTION files_need_recovery_check (result_txt OUT VARCHAR2) RETURN number;
428 PROCEDURE files_need_recovery_fixup;
429 FUNCTION files_need_recovery_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
430 FUNCTION files_need_recovery_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
431
432 FUNCTION files_backup_mode_check (result_txt OUT VARCHAR2) RETURN number;
433 PROCEDURE files_backup_mode_fixup;
434 FUNCTION files_backup_mode_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
435 FUNCTION files_backup_mode_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
436
437 FUNCTION invalid_laf_check (result_txt OUT VARCHAR2) RETURN number;
438 PROCEDURE invalid_laf_fixup;
439 FUNCTION invalid_laf_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
440 FUNCTION invalid_laf_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
441
442 FUNCTION invalid_obj_exist_check (result_txt OUT VARCHAR2) RETURN number;
443 PROCEDURE invalid_obj_exist_fixup;
444 FUNCTION invalid_obj_exist_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
445 FUNCTION invalid_obj_exist_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
446 FUNCTION invalid_obj_exclude RETURN VARCHAR2;
447
448 FUNCTION invalid_sys_tabledata_check (result_txt OUT VARCHAR2) RETURN number;
449 PROCEDURE invalid_sys_tabledata_fixup;
450 FUNCTION invalid_sys_tabledata_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
454 PROCEDURE invalid_usr_tabledata_fixup;
451 FUNCTION invalid_sys_tabledata_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
452
453 FUNCTION invalid_usr_tabledata_check (result_txt OUT VARCHAR2) RETURN number;
455 FUNCTION invalid_usr_tabledata_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
456 FUNCTION invalid_usr_tabledata_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
457
458 FUNCTION job_queue_process_check (result_txt OUT VARCHAR2) RETURN number;
459 PROCEDURE job_queue_process_fixup;
460 FUNCTION job_queue_process_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
461 FUNCTION job_queue_process_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
462
463 FUNCTION nacl_objects_exist_check (result_txt OUT VARCHAR2) RETURN number;
464 PROCEDURE nacl_objects_exist_fixup;
465 FUNCTION nacl_objects_exist_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
466 FUNCTION nacl_objects_exist_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
467
468 FUNCTION new_time_zones_exist_check (result_txt OUT VARCHAR2) RETURN number;
469 PROCEDURE new_time_zones_exist_fixup;
470 FUNCTION new_time_zones_exist_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
471 FUNCTION new_time_zones_exist_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
472
473 FUNCTION ocm_user_present_check (result_txt OUT VARCHAR2) RETURN number;
474 PROCEDURE ocm_user_present_fixup;
475 FUNCTION ocm_user_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
476 FUNCTION ocm_user_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
477
478 FUNCTION old_time_zones_exist_check (result_txt OUT VARCHAR2) RETURN number;
479 PROCEDURE old_time_zones_exist_fixup;
480 FUNCTION old_time_zones_exist_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
481 FUNCTION old_time_zones_exist_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
482
483 FUNCTION ols_sys_move_check (result_txt OUT VARCHAR2) RETURN number;
484 PROCEDURE ols_sys_move_fixup;
485 FUNCTION ols_sys_move_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
486 FUNCTION ols_sys_move_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
487
488 FUNCTION ordimageindex_check (result_txt OUT VARCHAR2) RETURN number;
489 PROCEDURE ordimageindex_fixup;
490 FUNCTION ordimageindex_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
491 FUNCTION ordimageindex_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
492
493 FUNCTION pending_2pc_txn_check (result_txt OUT VARCHAR2) RETURN number;
494 PROCEDURE pending_2pc_txn_fixup;
495 FUNCTION pending_2pc_txn_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
496 FUNCTION pending_2pc_txn_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
497
498 FUNCTION purge_recyclebin_check (result_txt OUT VARCHAR2) RETURN number;
499 PROCEDURE purge_recyclebin_fixup;
500 FUNCTION purge_recyclebin_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
501 FUNCTION purge_recyclebin_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
502
503 FUNCTION remove_dmsys_check (result_txt OUT VARCHAR2) RETURN number;
504 PROCEDURE remove_dmsys_fixup;
505 FUNCTION remove_dmsys_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
506 FUNCTION remove_dmsys_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
507
508 FUNCTION remote_redo_check (result_txt OUT VARCHAR2) RETURN number;
509 PROCEDURE remote_redo_fixup;
510 FUNCTION remote_redo_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
511 FUNCTION remote_redo_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
512
513 FUNCTION sync_standby_db_check (result_txt OUT VARCHAR2) RETURN number;
514 PROCEDURE sync_standby_db_fixup;
515 FUNCTION sync_standby_db_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
516 FUNCTION sync_standby_db_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
517
518 FUNCTION sys_def_tablespace_check (result_txt OUT VARCHAR2) RETURN number;
519 PROCEDURE sys_def_tablespace_fixup;
520 FUNCTION sys_def_tablespace_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
521 FUNCTION sys_def_tablespace_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
522
523 FUNCTION ultrasearch_data_check (result_txt OUT VARCHAR2) RETURN number;
524 PROCEDURE ultrasearch_data_fixup;
525 FUNCTION ultrasearch_data_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
526 FUNCTION ultrasearch_data_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
527
528 FUNCTION unsupported_version_check (result_txt OUT VARCHAR2) RETURN number;
529 PROCEDURE unsupported_version_fixup;
530 FUNCTION unsupported_version_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
531 FUNCTION unsupported_version_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
532
533 FUNCTION provisioner_present_check (result_txt OUT VARCHAR2) RETURN number;
534 PROCEDURE provisioner_present_fixup;
535 FUNCTION provisioner_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
536 FUNCTION provisioner_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
537
538 FUNCTION xs_resource_present_check (result_txt OUT VARCHAR2) RETURN number;
539 PROCEDURE xs_resource_present_fixup;
540 FUNCTION xs_resource_present_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
541 FUNCTION xs_resource_present_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
542
543 FUNCTION xs_session_admin_check (result_txt OUT VARCHAR2) RETURN number;
544 PROCEDURE xs_session_admin_fixup;
545 FUNCTION xs_session_admin_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
546 FUNCTION xs_session_admin_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
547
548 FUNCTION xs_namespace_admin_check (result_txt OUT VARCHAR2) RETURN number;
549 PROCEDURE xs_namespace_admin_fixup;
550 FUNCTION xs_namespace_admin_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
551 FUNCTION xs_namespace_admin_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
552
553 FUNCTION xs_cache_admin_check (result_txt OUT VARCHAR2) RETURN number;
554 PROCEDURE xs_cache_admin_fixup;
555 FUNCTION xs_cache_admin_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
556 FUNCTION xs_cache_admin_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
557
558 FUNCTION not_upg_by_std_upgrd_check (result_txt OUT VARCHAR2) RETURN number;
559 PROCEDURE not_upg_by_std_upgrd_fixup;
560 FUNCTION not_upg_by_std_upgrd_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
561 FUNCTION not_upg_by_std_upgrd_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
562
563
564 FUNCTION EMX_BASIC_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
565 FUNCTION EMX_BASIC_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
566 PROCEDURE EMX_BASIC_ROLE_PRESENT_fixup;
567 FUNCTION EMX_BASIC_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
568
569 FUNCTION EMX_ALL_ROLE_PRESENT_check (result_txt OUT VARCHAR2) RETURN number;
570 FUNCTION EMX_ALL_ROLE_PRESENT_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
571 PROCEDURE EMX_ALL_ROLE_PRESENT_fixup;
572 FUNCTION EMX_ALL_ROLE_PRESENT_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
573
574 -- bug 17656978: open_cursors check for apex on upgrades to 12102; error check
575 FUNCTION open_cursors_check (result_txt OUT VARCHAR2) RETURN number;
576 FUNCTION open_cursors_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
577 PROCEDURE open_cursors_fixup;
578 FUNCTION open_cursors_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
579
580 -- bug 18523430: if current apex version is older (by the 1st 6 digits) than
581 -- the version shipped in the target oracle home, then let user know that
582 -- apex upgrade can be done manually outside of and prior to database upgrade.
583 FUNCTION apex_upgrade_msg_check (result_txt OUT VARCHAR2) RETURN number;
584 FUNCTION apex_upgrade_msg_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
585 PROCEDURE apex_upgrade_msg_fixup;
586 FUNCTION apex_upgrade_msg_fixup (result_txt IN OUT VARCHAR2,
587 pSqlcode IN OUT NUMBER) RETURN number;
588
589 -- bug 17589566: warn that RESOURCE_LIMIT's default is changing from FALSE
590 -- to TRUE starting in 12.1.0.2
591 FUNCTION default_resource_limit_check (result_txt OUT VARCHAR2) RETURN number;
592 FUNCTION default_resource_limit_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
593 PROCEDURE default_resource_limit_fixup;
594 FUNCTION default_resource_limit_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
595
596 -- xbrl version check
597 FUNCTION xbrl_version_check (result_txt OUT VARCHAR2) RETURN number;
598 FUNCTION xbrl_version_gethelp (HelpType IN NUMBER) RETURN VARCHAR2;
599 PROCEDURE xbrl_version_fixup;
600 FUNCTION xbrl_version_fixup (result_txt IN OUT VARCHAR2, pSqlcode IN OUT NUMBER) RETURN number;
601
602 --
603 -- The recommendation procedures
604 --
605 PROCEDURE dictionary_stats_recommend;
606 PROCEDURE hidden_params_recommend;
607 PROCEDURE underscore_events_recommend;
608 PROCEDURE audit_records_recommend;
609 PROCEDURE fixed_objects_recommend;
610
611 --
612 -- bug 17593282 - list underscore and event params used
613 --
614 PROCEDURE parameters_display(param_type_to_display IN NUMBER);
615 c_display_underscore_params CONSTANT NUMBER := 1; -- display underscore params
616 c_display_events CONSTANT NUMBER := 2; -- display events
617
618 END dbms_preup;