eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_PREUP dependencies on DBMS_PREUP

Line 1: PACKAGE BODY dbms_preup AS

1: PACKAGE BODY dbms_preup AS
2:
3: c_output_terminal CONSTANT NUMBER := 0;
4: c_output_file CONSTANT NUMBER := 1;
5:

Line 520: return(dbms_preup.c_version);

516:
517: FUNCTION get_version RETURN VARCHAR2
518: IS
519: BEGIN
520: return(dbms_preup.c_version);
521: END get_version;
522:
523: FUNCTION run_all_checks RETURN NUMBER
524: IS

Line 601: check_stmt := 'BEGIN dbms_preup.'

597: --
598: -- BEGIN dictionary_stats_recommend; END;
599: --
600:
601: check_stmt := 'BEGIN dbms_preup.'
602: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
603: || '_recommend; END;';
604:
605: BEGIN

Line 702: estatement := 'BEGIN :r1 := dbms_preup.'

698: IF check_names.EXISTS(name) = FALSE THEN
699: return 'WARNING - CHECK ' || name || ' does not exist';
700: END IF;
701: idx := check_names(name).idx;
702: estatement := 'BEGIN :r1 := dbms_preup.'
703: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
704: || '_gethelp (:helpType); END;';
705: EXECUTE IMMEDIATE estatement
706: USING OUT rhelp, IN helpType;

Line 782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;

778: ''These functions must be run AS SYSDBA''); END;';
779: END IF;
780:
781: EXECUTE IMMEDIATE 'SELECT name FROM v$database' INTO db_name;
782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;
783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;
784: EXECUTE IMMEDIATE 'SELECT version FROM v$instance' INTO db_version;
785:
786: EXECUTE IMMEDIATE 'SELECT value FROM v$parameter WHERE name = ''compatible'''

Line 783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;

779: END IF;
780:
781: EXECUTE IMMEDIATE 'SELECT name FROM v$database' INTO db_name;
782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;
783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;
784: EXECUTE IMMEDIATE 'SELECT version FROM v$instance' INTO db_version;
785:
786: EXECUTE IMMEDIATE 'SELECT value FROM v$parameter WHERE name = ''compatible'''
787: INTO db_compat;

Line 2837: -- Allow dbms_preup.timezone_check to be called which

2833: IS
2834: --
2835: -- This is decared as a public function for the package.
2836: --
2837: -- Allow dbms_preup.timezone_check to be called which
2838: -- tells the real procedure to call the init routine.
2839: --
2840: BEGIN
2841: tz_fixup(TRUE);

Line 3160: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN

3156: -- b) if pdb and TEXT (not dbua) -> concat to main destination files => TRUE
3157: -- c) if pdb and XML (dbua) -> write directly to main destination file
3158: -- one by one => FALSE
3159: --
3160: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN
3161: pConcatToMainFile := FALSE;
3162: ELSE -- if db is a seed or pdb
3163: IF (pOutputType = c_output_text) THEN
3164: -- will append pdb TEXT file to destination file

Line 3180: con_name := sys.dbms_preup.get_con_name;

3176: -- note: above pdb files are first created in PREUPGRADE_DIR.
3177: -- note: after concat is done, then pdb files are moved to PDB_PREUPGRADE_DIR.
3178: --
3179: IF pConcatToMainFile THEN
3180: con_name := sys.dbms_preup.get_con_name;
3181:
3182: pOutputFName := c_text_log_base || con_name || c_text_log_suffix;
3183: pPreScriptFname := c_pre_fixup_base || con_name || c_fixup_suffix;
3184: pPostScriptFname := c_post_fixup_base || con_name || c_fixup_suffix;

Line 3216: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN

3212: END IF;
3213:
3214: -- remove lock (just in case it exists from a previous run) right at the
3215: -- begin of connect to either a non-cdb or cdb root
3216: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN
3217: BEGIN
3218: UTL_FILE.FREMOVE(pOutputLocation, c_wrlock_fname);
3219: EXCEPTION
3220: WHEN invalidFileOperation THEN NULL;

Line 3391: IF (dbms_preup.is_db_noncdb = TRUE OR -- is a non-cdb

3387: USING c_dir_obj;
3388: EXCEPTION WHEN NO_DATA_FOUND THEN
3389: -- Bug 18463200: workaround is to return the path that was used to
3390: -- create/replace the directory object if db is a pdb
3391: IF (dbms_preup.is_db_noncdb = TRUE OR -- is a non-cdb
3392: dbms_preup.is_con_root = TRUE) THEN -- OR cdb$root
3393: path := '*** PATH NOT DEFINED ***';
3394: ELSE -- this must be a pdb$seed or just a pdb
3395: IF pTextLogDir is NULL THEN -- path is really not defined

Line 3392: dbms_preup.is_con_root = TRUE) THEN -- OR cdb$root

3388: EXCEPTION WHEN NO_DATA_FOUND THEN
3389: -- Bug 18463200: workaround is to return the path that was used to
3390: -- create/replace the directory object if db is a pdb
3391: IF (dbms_preup.is_db_noncdb = TRUE OR -- is a non-cdb
3392: dbms_preup.is_con_root = TRUE) THEN -- OR cdb$root
3393: path := '*** PATH NOT DEFINED ***';
3394: ELSE -- this must be a pdb$seed or just a pdb
3395: IF pTextLogDir is NULL THEN -- path is really not defined
3396: path := '*** PATH NOT DEFINED ***';

Line 3542: DisplayLine (pPreScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');

3538: DisplayLine (pPreScriptUFT, 'con_name varchar2(40);');
3539: DisplayBlankLine (pPreScriptUFT);
3540: DisplayLine (pPreScriptUFT, 'BEGIN ');
3541: DisplayLine (pPreScriptUFT, 'execute immediate ');
3542: DisplayLine (pPreScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');
3543:
3544: -- If the session currently connected to is of a database or container that
3545: -- matches the name in the IF stmt, then stay in the block and run the
3546: -- fixup steps.

Line 3550: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;

3546: -- fixup steps.
3547: -- Else, if the names do not match, then continue on to the next block in
3548: -- the fixup script.
3549: EXECUTE IMMEDIATE
3550: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;
3551: DisplayBlankLine (pPreScriptUFT);
3552: DisplayLine (pPreScriptUFT, 'IF con_name = ''' || con_name || ''' THEN');
3553: DisplayBlankLine (pPreScriptUFT);
3554:

Line 3567: DisplayLine (pPreScriptUFT, 'dbms_preup.clear_run_flag(TRUE);');

3563: DisplayLine (pPreScriptUFT, 'dbms_output.put_line (''' || genline || ''');');
3564: DisplayLine (pPreScriptUFT, 'END;');
3565: DisplayBlankLine (pPreScriptUFT);
3566: DisplayLine (pPreScriptUFT, 'BEGIN');
3567: DisplayLine (pPreScriptUFT, 'dbms_preup.clear_run_flag(TRUE);');
3568: DisplayLine (pPreScriptUFT, 'END;');
3569: DisplayBlankLine (pPreScriptUFT);
3570: --
3571: -- Now post...

Line 3586: DisplayLine (pPostScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');

3582: DisplayLine (pPostScriptUFT, 'con_name varchar2(40);');
3583: DisplayBlankLine (pPostScriptUFT);
3584: DisplayLine (pPostScriptUFT, 'BEGIN ');
3585: DisplayLine (pPostScriptUFT, 'execute immediate ');
3586: DisplayLine (pPostScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');
3587:
3588: -- If the session currently connected to is of a database or container that
3589: -- matches the name in the IF block, then stay in the loop and run the
3590: -- fixup steps.

Line 3594: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;

3590: -- fixup steps.
3591: -- Else, if the names do not match, then continue on to the next block in
3592: -- the fixup script.
3593: EXECUTE IMMEDIATE
3594: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;
3595: DisplayBlankLine (pPostScriptUFT);
3596: DisplayLine (pPostScriptUFT, 'IF con_name = ''' || con_name || ''' THEN');
3597: DisplayBlankLine (pPostScriptUFT);
3598:

Line 3609: DisplayLine (pPostScriptUFT, 'dbms_preup.clear_run_flag(FALSE);');

3605: DisplayLine (pPostScriptUFT, 'dbms_output.put_line (''Beginning Post-Upgrade Fixups...'');');
3606: DisplayLine (pPostScriptUFT, 'END;');
3607: DisplayBlankLine (pPostScriptUFT);
3608: DisplayLine (pPostScriptUFT, 'BEGIN');
3609: DisplayLine (pPostScriptUFT, 'dbms_preup.clear_run_flag(FALSE);');
3610: DisplayLine (pPostScriptUFT, 'END;');
3611: DisplayBlankLine (pPostScriptUFT);
3612: pOutputFixupScripts := TRUE;
3613:

Line 3620: DisplayLine (pPreScriptUFT, 'BEGIN dbms_preup.fixup_summary(TRUE); END;');

3616: --
3617: -- Dump out a call to the routine to run through all the checks and report
3618: -- a summary of success/failures/user actions
3619: --
3620: DisplayLine (pPreScriptUFT, 'BEGIN dbms_preup.fixup_summary(TRUE); END;');
3621: DisplayBlankLine(pPreScriptUFT);
3622:
3623: DisplayLine (pPostScriptUFT, 'BEGIN dbms_preup.fixup_summary(FALSE); END;');
3624: DisplayBlankLine (pPostScriptUFT);

Line 3623: DisplayLine (pPostScriptUFT, 'BEGIN dbms_preup.fixup_summary(FALSE); END;');

3619: --
3620: DisplayLine (pPreScriptUFT, 'BEGIN dbms_preup.fixup_summary(TRUE); END;');
3621: DisplayBlankLine(pPreScriptUFT);
3622:
3623: DisplayLine (pPostScriptUFT, 'BEGIN dbms_preup.fixup_summary(FALSE); END;');
3624: DisplayBlankLine (pPostScriptUFT);
3625:
3626:
3627: EXECUTE IMMEDIATE 'SELECT TO_CHAR(SYSTIMESTAMP,''YYYY-MM-DD HH24:MI:SS '') FROM SYS.DUAL'

Line 4077: (dbms_preup.is_db_noncdb = FALSE AND dbms_preup.is_con_root = FALSE) THEN

4073: -- a) pOutputLocation is not NULL, which means not writing to terminal
4074: -- and
4075: -- b) this db is a non-root container
4076: IF (pOutputLocation is NOT NULL) AND
4077: (dbms_preup.is_db_noncdb = FALSE AND dbms_preup.is_con_root = FALSE) THEN
4078: BEGIN
4079: EXECUTE IMMEDIATE
4080: 'CREATE OR REPLACE DIRECTORY ' || c_pdb_dir_obj || ' AS ' || pdbLogDir ;
4081: IF tracing_on_xxx THEN

Line 4159: if (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) then

4155: -- Let's start an xml document IF one of the following is TRUE:
4156: -- (a) this db is NOT a cdb
4157: -- OR
4158: -- (b) if this db is a cdb and current container is CDB$ROOT
4159: if (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) then
4160: init_package;
4161:
4162: -- This line will be written by DBUA prior to running the preugprade tool:
4163: -- DisplayLine ('');

Line 4230: check_stmt := 'BEGIN :r1 := dbms_preup.'

4226: check_table(idx).fixup_executed := FALSE;
4227: check_table(idx).fixup_failed := FALSE;
4228: check_table(idx).always_fail := FALSE;
4229:
4230: check_stmt := 'BEGIN :r1 := dbms_preup.'
4231: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4232: || '_check (:rtxt); END;';
4233:
4234: BEGIN

Line 4286: t_check_rec := dbms_preup.run_check_simple(check_name);

4282:
4283: BEGIN
4284: init_package;
4285:
4286: t_check_rec := dbms_preup.run_check_simple(check_name);
4287:
4288: IF t_check_rec.passed THEN
4289: RETURN FALSE;
4290: ELSE

Line 4343: check_stmt := 'BEGIN :r1 := dbms_preup.'

4339: --
4340: -- BEGIN :r1 := purge_recyclebin_check(r_text); END;
4341: --
4342:
4343: check_stmt := 'BEGIN :r1 := dbms_preup.'
4344: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4345: || '_check (:rtxt); END;';
4346:
4347: BEGIN

Line 4422: check_stmt := 'BEGIN :r1 := dbms_preup.'

4418: -- An example would be
4419: --
4420: -- BEGIN :r1 := purge_recyclebin_check(r_text); END;
4421: --
4422: check_stmt := 'BEGIN :r1 := dbms_preup.'
4423: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4424: || '_check (:rtxt); END;';
4425:
4426: BEGIN

Line 4501: check_stmt := 'BEGIN :r1 := dbms_preup.'

4497: --
4498: -- BEGIN :r1 := purge_recyclebin_fixup(r_text, r_sqlcode); END;
4499: --
4500:
4501: check_stmt := 'BEGIN :r1 := dbms_preup.'
4502: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4503: || '_fixup (:rtxt, :rsqlcode); END;';
4504:
4505: --

Line 4595: check_stmt := 'BEGIN :r1 := dbms_preup.'

4591: --
4592: -- BEGIN :r1 := purge_recyclebin_fixup(r_text, r_sqlcode); END;
4593: --
4594:
4595: check_stmt := 'BEGIN :r1 := dbms_preup.'
4596: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4597: || '_fixup (:rtxt, :rsqlcode); END;';
4598:
4599: --

Line 4654: check_stmt := 'BEGIN :r1 := dbms_preup.'

4650: --
4651: -- BEGIN :r1 := purge_recyclebin_fixup(r_text, r_sqlcode); END;
4652: --
4653:
4654: check_stmt := 'BEGIN :r1 := dbms_preup.'
4655: || dbms_assert.simple_sql_name(check_table(idx).f_name_prefix)
4656: || '_fixup (:rtxt, :rsqlcode); END;';
4657:
4658: --

Line 5032: IF sys.dbms_preup.is_db_noncdb = TRUE THEN -- this db is a non-cdb

5028:
5029: -- streams_pool_size
5030: minvp(sr_idx).minvalue := 0; -- 0M
5031:
5032: IF sys.dbms_preup.is_db_noncdb = TRUE THEN -- this db is a non-cdb
5033: -- java_pool_size
5034: minvp(jv_idx).minvalue := 100 * c_mb;
5035:
5036: -- shared_pool_size

Line 5053: db_npdbs := sys.dbms_preup.get_npdbs;

5049: -- note: pga_aggregate_limit is a new parameter in 12.1.0.1
5050: minvp(pl_idx).display := FALSE;
5051:
5052: ELSE -- IF db is a cdb
5053: db_npdbs := sys.dbms_preup.get_npdbs;
5054:
5055: -- find # of pdbs that at most will be upgrading at a time.
5056: -- using the default as defined in catctl.pl.
5057: -- will size for default, which is at most smallest integer of cpu_count/2

Line 5439: -- This is a call to the dbms_preup.run_fixup_and_report

5435: END htmlentities;
5436:
5437: --
5438: -- Output a 'fixup' to the passed file.
5439: -- This is a call to the dbms_preup.run_fixup_and_report
5440: -- routine. That routine will run the fixup and report
5441: -- the problem.
5442: --
5443: PROCEDURE genFixup (name VARCHAR2 )

Line 5458: rstr := 'dbms_preup.run_fixup_and_report(''' || name || ''');';

5454: END IF;
5455:
5456: idx := check_names(name).idx;
5457:
5458: rstr := 'dbms_preup.run_fixup_and_report(''' || name || ''');';
5459:
5460: IF check_table(idx).fix_type IN (c_fix_source_manual,
5461: c_fix_source_auto,
5462: c_fix_target_manual_pre,

Line 5516: dbms_output.put_line ('Executing Pre-Upgrade Checks in ' || dbms_preup.get_con_name || '...');

5512: -- header output to preupgrade.log, preupgrade..log, and upgrade.xml
5513: --
5514: dbms_output.put_line('');
5515: dbms_output.put_line('***************************************************************************');
5516: dbms_output.put_line ('Executing Pre-Upgrade Checks in ' || dbms_preup.get_con_name || '...');
5517: dbms_output.put_line('***************************************************************************');
5518: dbms_output.put_line('');
5519:
5520:

Line 5799: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN

5795: -- values for manual upgrades.
5796: -- output_manual_initparams(minvp_db32, FALSE);
5797:
5798: -- do not display [Update parameters] if the db is a pdb
5799: IF (dbms_preup.is_db_noncdb OR dbms_preup.is_con_root) THEN
5800: output_manual_initparams(minvp_db64, TRUE);
5801: -- the parameters currenly under this section are for memory and
5802: -- processes. all of the parameters in this section - in 12.1.0.1
5803: -- anyway - are still cdb level parameters

Line 9270: || crlf || ' exec dbms_preup.run_fixup_and_report(''INVALID_SYS_TABLEDATA'')'

9266: || crlf || ' For plug in, execute the fix up routine in the PDB.'
9267: || crlf
9268: || crlf || ' @?/rdbms/admin/utluppkg.sql'
9269: || crlf || ' SET SERVEROUTPUT ON;'
9270: || crlf || ' exec dbms_preup.run_fixup_and_report(''INVALID_SYS_TABLEDATA'')'
9271: || crlf || ' SET SERVEROUTPUT OFF;';
9272: ELSIF HelpType = c_help_fixup THEN
9273: return 'UPGRADE Oracle supplied table data prior to the database upgrade.';
9274: END IF;

Line 9455: || crlf || ' exec dbms_preup.run_fixup_and_report(''INVALID_USR_TABLEDATA'');'

9451: || crlf || ' For plug in, execute the fix up routine in the PDB.'
9452: || crlf
9453: || crlf || ' @?/rdbms/admin/utluppkg.sql'
9454: || crlf || ' SET SERVEROUTPUT ON;'
9455: || crlf || ' exec dbms_preup.run_fixup_and_report(''INVALID_USR_TABLEDATA'');'
9456: || crlf || ' SET SERVEROUTPUT OFF;';
9457: ELSIF HelpType = c_help_fixup THEN
9458: return 'UPGRADE user table data prior to the database upgrade.';
9459: END IF;

Line 10369: 'BEGIN dbms_preup.purge_recyclebin_fixup; END;',

10365: IF pOutputType = c_output_xml THEN
10366: result_txt:= genDBUAXMLCheck('PURGE_RECYCLEBIN', c_check_level_error,
10367: 'Recycle Bin is not empty',
10368: 'Recycle bin is not empty',
10369: 'BEGIN dbms_preup.purge_recyclebin_fixup; END;',
10370: c_dbua_detail_type_sql,
10371: 'select count(*) from sys.recyclebin$',
10372: c_dbua_fixup_type_auto,
10373: c_dbua_fixup_stage_validation);

Line 10380: || crlf || ' EXECUTE dbms_preup.purge_recyclebin_fixup;';

10376: || crlf || ' Your recycle bin contains ' || TO_CHAR(obj_count) || ' object(s). '
10377: || crlf || ' It is REQUIRED that the recycle bin is empty prior to upgrading.'
10378: || crlf || ' Immediately before performing the upgrade, execute the following'
10379: || crlf || ' command:'
10380: || crlf || ' EXECUTE dbms_preup.purge_recyclebin_fixup;';
10381: END IF;
10382: IF pOutputFixupScripts THEN
10383: genFixup ('PURGE_RECYCLEBIN');
10384: END IF;

Line 10407: || crlf || ' execute dbms_preup.purge_recyclebin_fixup;'

10403: result_txt := 'ERROR: --> Recycle Bin not empty' || crlf
10404: || crlf || ' Your recycle bin contains ' || TO_CHAR(obj_count) || ' object(s).'
10405: || crlf || ' It is REQUIRED that the recycle bin is empty prior to upgrading'
10406: || crlf || ' your database. The command:'
10407: || crlf || ' execute dbms_preup.purge_recyclebin_fixup;'
10408: || crlf || ' must be executed immediately prior to executing your upgrade.';
10409: ELSIF HelpType = c_help_fixup THEN
10410: result_txt := 'The recycle bin will be purged.';
10411: END IF;

Line 10719: 'BEGIN dbms_preup.REMOTE_REDO_fixup; END',

10715: || ' You must specify a destination for local archiving since '
10716: || 'LOG_ARCHIVE_DEST_1 is not available.',
10717: 'You must specify a destination for local archiving since '
10718: || 'LOG_ARCHIVE_DEST_1 is not available.',
10719: 'BEGIN dbms_preup.REMOTE_REDO_fixup; END',
10720: c_dbua_detail_type_text,
10721: 'You must specify a destination for local archiving since '
10722: || 'LOG_ARCHIVE_DEST_1 is not available.',
10723: c_dbua_fixup_type_manual,

Line 10894: 'BEGIN dbms_preup.SYS_DEF_TABLESPACE_fixup; END;',

10890: 'The SYSTEM or SYS schemas have been altered so their default tablespace'
10891: || ' is no longer SYSTEM. Prior to upgrading, the schema default'
10892: || ' tablespace must be reset to the SYSTEM tablespace',
10893: 'The SYSTEM or SYS schemas have been altered so their default tablespace',
10894: 'BEGIN dbms_preup.SYS_DEF_TABLESPACE_fixup; END;',
10895: c_dbua_detail_type_sql,
10896: htmlentities('select username,default_tablespace from sys.dba_users'
10897: || ' where username IN (''SYS'',''SYSTEM'')'),
10898: c_dbua_fixup_type_auto,

Line 10917: || crlf || ' Execute: execute dbms_preup.SYS_DEF_TABLESPACE_fixup; ';

10913: IF HelpType = c_help_overview THEN
10914: return 'WARNING: --> SYS and SYSTEM schema default tablespace has been altered' || crlf
10915: || crlf || ' Prior to upgrading your database, please ensure both'
10916: || crlf || ' the SYS and SYSTEM schema default their tablespace to SYSTEM.'
10917: || crlf || ' Execute: execute dbms_preup.SYS_DEF_TABLESPACE_fixup; ';
10918: ELSIF HelpType = c_help_fixup THEN
10919: return 'SYSTEM account default tablespace is altered to be SYSTEM.';
10920: END IF;
10921: END SYS_DEF_TABLESPACE_gethelp;

Line 12568: DisplayLine(pPreScriptUFT, 'dbms_preup.parameters_display(1);');

12564: DisplayLine(pPreScriptUFT,'BEGIN');
12565: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line
12566: (' ******** Existing Hidden Parameters ********');!');
12567: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');
12568: DisplayLine(pPreScriptUFT, 'dbms_preup.parameters_display(1);');
12569: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');
12570: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line
12571: ('^^^ MANUAL ACTION SUGGESTED ^^^');!');
12572: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');

Line 12634: DisplayLine(pPreScriptUFT, 'dbms_preup.parameters_display(2);');

12630:
12631: DisplayLine(pPreScriptUFT, 'BEGIN');
12632: DisplayLine(pPreScriptUFT,q'!dbms_output.put_line (' ******** Existing Events ********');!');
12633: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');
12634: DisplayLine(pPreScriptUFT, 'dbms_preup.parameters_display(2);');
12635: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');
12636: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line
12637: ('^^^ MANUAL ACTION SUGGESTED ^^^');!');
12638: DisplayLine(pPreScriptUFT, q'!dbms_output.put_line ('');!');

Line 12862: conId NUMBER := sys.dbms_preup.get_con_id;

12858: --
12859: PROCEDURE end_log_preupg_action
12860: IS
12861: PRAGMA AUTONOMOUS_TRANSACTION;
12862: conId NUMBER := sys.dbms_preup.get_con_id;
12863: conName VARCHAR2(30) := sys.dbms_preup.get_con_name;
12864: sqlString VARCHAR2(500); -- string to build sql stmt to execute
12865: BEGIN
12866:

Line 12863: conName VARCHAR2(30) := sys.dbms_preup.get_con_name;

12859: PROCEDURE end_log_preupg_action
12860: IS
12861: PRAGMA AUTONOMOUS_TRANSACTION;
12862: conId NUMBER := sys.dbms_preup.get_con_id;
12863: conName VARCHAR2(30) := sys.dbms_preup.get_con_name;
12864: sqlString VARCHAR2(500); -- string to build sql stmt to execute
12865: BEGIN
12866:
12867: IF tracing_on_xxx THEN

Line 12915: IF sys.dbms_preup.is_db_noncdb = TRUE THEN -- this db is a non-cdb

12911: b_retStat BOOLEAN := FALSE;
12912: conId NUMBER;
12913: BEGIN
12914:
12915: IF sys.dbms_preup.is_db_noncdb = TRUE THEN -- this db is a non-cdb
12916: b_retStat := FALSE; -- no, it can't be the ROOT
12917: ELSE -- this db is a cdb
12918: conId := sys.dbms_preup.get_con_id; -- check con id
12919: IF (conId = 1) THEN -- ROOT's con id is 1

Line 12918: conId := sys.dbms_preup.get_con_id; -- check con id

12914:
12915: IF sys.dbms_preup.is_db_noncdb = TRUE THEN -- this db is a non-cdb
12916: b_retStat := FALSE; -- no, it can't be the ROOT
12917: ELSE -- this db is a cdb
12918: conId := sys.dbms_preup.get_con_id; -- check con id
12919: IF (conId = 1) THEN -- ROOT's con id is 1
12920: b_retStat := TRUE; -- yes, current container is CDB$ROOT
12921: END IF;
12922: END IF;

Line 13092: DisplayLinePL('The output from this run in ' || dbms_preup.get_con_name || ' will remain in ' || pOutputFName || '.');

13088: -- output files and let user know.
13089: IF wr_loops > c_wrlock_max_waits THEN
13090: DisplayLinePL('');
13091: DisplayLinePL('====>> Note: Was not able to write output into log file ''' || c_output_fn || ''' in ' || pTextLogDir || '.');
13092: DisplayLinePL('The output from this run in ' || dbms_preup.get_con_name || ' will remain in ' || pOutputFName || '.');
13093: DisplayLinePL('Note: before running preupgrade tool, please make sure lock file ''' || c_wrlock_fname || ''' in ' || pTextLogDir || ' is removed.');
13094: DisplayLinePL('');
13095: END IF;
13096:

Line 13266: dbms_output.put_line ('Pre-Upgrade Checks in ' || dbms_preup.get_con_name || ' Completed.');

13262: -- display a msg that the preupgrade checks are done
13263: --
13264: dbms_output.put_line('');
13265: dbms_output.put_line('***************************************************************************');
13266: dbms_output.put_line ('Pre-Upgrade Checks in ' || dbms_preup.get_con_name || ' Completed.');
13267: dbms_output.put_line('***************************************************************************');
13268: dbms_output.put_line('');
13269: dbms_output.put_line('***************************************************************************');
13270: DisplayLinePL('***************************************************************************');

Line 13301: END dbms_preup;

13297: END IF; -- if pdb directory object exists
13298:
13299: END end_preupgrd;
13300:
13301: END dbms_preup;