utlu121s0.log


SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 5 21:24:04 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> Connected.
SQL>   2
Session altered.

SQL>   2
Session altered.

SQL>   2
Session altered.

SQL>   2
Session altered.

SQL> SQL>
SQL>   2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = CDB$ROOT Id = 1 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = CDB$ROOT Id = 1 ====

SQL>   2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2
CATCONSECTION
--------------------------
==== CATCON EXEC ROOT ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:CDB$ROOT Id:1 14-0
8-05 09:24:04 Proc:0 ====


SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:CDB$ROOT Id:1 14-0
8-05 09:24:04 Proc:0 ====


SQL>   2
Session altered.

SQL>   2
Session altered.

SQL>
PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.





CATCTL REPORT = /u01/app/12.1.0.2/db/cfgtoollogs/cdb/upgrade/upg_summary.log

PL/SQL procedure successfully completed.






Oracle Database 12.1 Post-Upgrade Status Tool           08-05-2014 21:24:05
                             [CDB$ROOT:1]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.1.0.2.0  00:10:54
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:04:59
Oracle Real Application Clusters     OPTION OFF      12.1.0.2.0  00:00:01
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:01:14
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:35
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:22
Oracle Label Security                     VALID      12.1.0.2.0  00:00:15
Oracle XDK                                VALID      12.1.0.2.0  00:00:54
Oracle Text                               VALID      12.1.0.2.0  00:00:25
Oracle XML Database                       VALID      12.1.0.2.0  00:01:02
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:18
Oracle Multimedia                         VALID      12.1.0.2.0  00:02:16
Spatial                                   VALID      12.1.0.2.0  00:02:02
Oracle Application Express                VALID     4.2.5.00.08  00:03:27
Oracle Database Vault                     VALID      12.1.0.2.0  00:00:14
Final Actions                                                    00:00:13
Post Upgrade                                                     00:00:10

Total Upgrade Time: 00:29:31 [CDB$ROOT]

PL/SQL procedure successfully completed.

SQL>
SQL> --
SQL> -- Update Summary Table with con_name and endtime.
SQL> --
SQL> UPDATE sys.registry$upg_summary SET reportname = :ReportName,
  2                                  con_name = SYS_CONTEXT('USERENV','CON_NAME'),
  3                                  endtime  = SYSDATE
  4         WHERE con_id = -1;

1 row updated.

SQL> commit;

Commit complete.

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:CDB$ROOT Id:1 14-0
8-05 09:24:05 Proc:0 ====


SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:CDB$ROOT Id:1 14-0
8-05 09:24:05 Proc:0 ====


SQL> SQL>
SQL>   2
Session altered.

SQL> SQL>
SQL>   2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB$SEED Id = 2 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB$SEED Id = 2 ====

SQL>   2
CATCONSECTION
-----------------------------------
==== CATCON EXEC IN CONTAINERS ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:PDB$SEED Id:2 14-0
8-05 09:24:10 Proc:0 ====


SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:PDB$SEED Id:2 14-0
8-05 09:24:10 Proc:0 ====


SQL>   2
Session altered.

SQL>   2
Session altered.

SQL> SQL> Rem
SQL> Rem $Header: rdbms/admin/utlu121s.sql /main/2 2014/01/29 16:21:04 jerrede Exp $
SQL> Rem
SQL> Rem utlu121s.sql
SQL> Rem
SQL> Rem Copyright (c) 2011, 2014, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem         utlu121s.sql - UTiLity Upgrade Status
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem         This script provides information about databases that have
SQL> Rem         been upgraded to 12.1
SQL> Rem
SQL> Rem    NOTES
SQL> Rem         Connect AS SYSDBA
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    jerrede     01/21/14 - Call catresults.sql so we produce summary report
SQL> Rem    cmlim       03/11/11 - post-upgrade status tool after db upgrade to 12.1
SQL> Rem    cmlim       03/11/11 - Created
SQL> Rem
SQL>
SQL> @@catresults.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/catresults.sql /main/5 2014/02/20 19:49:18 jerrede Exp $
SQL> Rem
SQL> Rem catresults.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, 2014, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem         catresults.sql - Display Upgrade Status
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem         Display the upgrade results.
SQL> Rem
SQL> Rem    NOTES
SQL> Rem         
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    jerrede     01/30/14 - Fix Report Name
SQL> Rem    jerrede     01/08/14 - Fix bug 18044666 Summary Report not displayed
SQL> Rem    jerrede     11/23/13 - Add Summary Report
SQL> Rem    jerrede     08/28/12 - Created
SQL> Rem
SQL>
SQL> Rem =====================================================================
SQL> Rem  Reset package just in case comming from migrate
SQL> Rem =====================================================================
SQL> EXECUTE dbms_session.reset_package;

PL/SQL procedure successfully completed.

SQL>
SQL> Rem =====================================================================
SQL> Rem REPORT TIMINGS AND SHUTDOWN THE DATABASE..!!!!!
SQL> Rem =====================================================================
SQL>
SQL> Rem =====================================================================
SQL> Rem Note:  NO DDL STATEMENTS. DO NOT RECOMMEND ANY SQL BEYOND THIS POINT.
SQL> Rem =====================================================================
SQL>
SQL> Rem =====================================================================
SQL> Rem Run component status as the last output
SQL> Rem Note:  NO DDL STATEMENTS. DO NOT RECOMMEND ANY SQL BEYOND THIS POINT.
SQL> Rem Note:  ACTIONS_END must stay here to get the correct upgrade time.
SQL> Rem =====================================================================
SQL>
SQL> Rem
SQL> Rem Turn option on for report
SQL> Rem
SQL> set linesize 5000;
SQL> set serveroutput on;
SQL>
SQL> Rem
SQL> Rem Variables
SQL> Rem
SQL> VARIABLE ReportName  VARCHAR2(2000);
SQL> VARIABLE DirName     VARCHAR2(1500);
SQL> VARIABLE CmdName     VARCHAR2(15);
SQL>
SQL>
SQL> ---
SQL> --- See if we need to run the create directory script
SQL> ---
SQL> begin
  2
  3      :CmdName := '@nothing.sql';
  4      :DirName := dbms_registry_sys.get_pfile_path ('upgrade');
  5
  6      --
  7      -- If Directory does not exits then we create it
  8      --
  9      IF NOT sys.dbms_registry_sys.dir_exists_and_is_writable(:DirName) THEN
 10          :CmdName := '@utlucdir.sql';
 11      END IF;
 12
 13  end;
 14  /

PL/SQL procedure successfully completed.

SQL>
SQL> ---
SQL> --- Create Directory if need be
SQL> ---
SQL> COLUMN Cmd_Name NEW_VALUE cn NOPRINT;
SQL> SELECT :CmdName as Cmd_Name FROM sys.dual;




SQL> @&cn
SQL> Rem $Header: rdbms/admin/nothing.sql /st_rdbms_12.1/1 2014/06/03 11:24:49 aketkar Exp $
SQL> Rem
SQL> Rem
SQL> Rem BEGIN SQL_FILE_METADATA
SQL> Rem SQL_SOURCE_FILE: rdbms/admin/nothing.sql
SQL> Rem SQL_SHIPPED_FILE: rdbms/admin/nothing.sql
SQL> Rem SQL_PHASE: NOTHING
SQL> Rem SQL_STARTUP_MODE: NORMAL
SQL> Rem SQL_IGNORABLE_ERRORS: NONE
SQL> Rem SQL_CALLING_FILE: NONE
SQL> Rem END SQL_FILE_METADATA
SQL> Rem
SQL>
SQL>
SQL> declare
  2
  3      cnt        NUMBER :=0;
  4      platform   v$database.platform_name%TYPE;
  5      RptName    CONSTANT VARCHAR2(15) := 'upg_summary.log';
  6      WinSlash   CONSTANT VARCHAR2(1)  := '\';        -- 'WinDows
  7      UnixSlash  CONSTANT VARCHAR2(1)  := '/';        --  Unix
  8      Slash      VARCHAR2(1)  := UnixSlash;  --  Default to Unix
  9
 10  begin
 11
 12      --
 13      -- Check Directory If we still can't write to it then
 14      -- default to $ORACLE_HOME/rdbms/log
 15      --
 16      IF NOT sys.dbms_registry_sys.dir_exists_and_is_writable(:DirName) THEN
 17
 18          --
 19          -- Find out the platform
 20          --
 21          EXECUTE IMMEDIATE 'SELECT NLS_UPPER(platform_name) FROM v$database'
 22                          INTO platform;
 23
 24          --
 25          -- Adjust the slash for Windows
 26          --
 27          IF INSTR(platform, 'WINDOWS') != 0 THEN
 28                  slash := WinSlash;
 29          END IF;
 30
 31          --
 32          -- Construct report Name
 33          --
 34          DBMS_SYSTEM.GET_ENV('ORACLE_HOME', :DirName);
 35          IF :DirName IS NOT NULL THEN
 36                  :DirName := :DirName || slash || 'rdbms' || slash
 37                                  || 'log' || slash;
 38          END IF;
 39
 40      END IF;
 41
 42
 43      --
 44      -- Set and display report name
 45      --
 46      :ReportName := :DirName || RptName;
 47      sys.dbms_output.put_line('CATCTL REPORT = ' || :ReportName);
 48
 49
 50  end;
 51  /
CATCTL REPORT = /u01/app/12.1.0.2/db/cfgtoollogs/cdb/upgrade/upg_summary.log

PL/SQL procedure successfully completed.

SQL>
SQL> --
SQL> -- Set echo off so report is clean and
SQL> -- reset line size for report.
SQL> --
SQL> set linesize 80;
SQL> set echo off;





Oracle Database 12.1 Post-Upgrade Status Tool           08-05-2014 21:24:14
                             [PDB$SEED:2]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.1.0.2.0  00:17:37
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:06:13
Oracle Real Application Clusters     OPTION OFF      12.1.0.2.0  00:00:01
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:01:17
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:57
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:49
Oracle Label Security                     VALID      12.1.0.2.0  00:00:16
Oracle XDK                                VALID      12.1.0.2.0  00:01:03
Oracle Text                               VALID      12.1.0.2.0  00:00:24
Oracle XML Database                       VALID      12.1.0.2.0  00:01:10
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:18
Oracle Multimedia                         VALID      12.1.0.2.0  00:02:13
Spatial                                   VALID      12.1.0.2.0  00:03:08
Oracle Application Express                VALID     4.2.5.00.08  00:03:34
Oracle Database Vault                     VALID      12.1.0.2.0  00:00:22
Final Actions                                                    00:00:19
Post Upgrade                                                     00:01:27

Total Upgrade Time: 00:41:22 [PDB$SEED]

PL/SQL procedure successfully completed.

SQL>
SQL> --
SQL> -- Update Summary Table with con_name and endtime.
SQL> --
SQL> UPDATE sys.registry$upg_summary SET reportname = :ReportName,
  2                                  con_name = SYS_CONTEXT('USERENV','CON_NAME'),
  3                                  endtime  = SYSDATE
  4         WHERE con_id = -1;

1 row updated.

SQL> commit;

Commit complete.

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:PDB$SEED Id:2 14-0
8-05 09:24:14 Proc:0 ====


SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @/u01/app/12.1.0.2/db/rdbms/admin/utlu121s.sql Container:PDB$SEED Id:2 14-0
8-05 09:24:14 Proc:0 ====


SQL> SQL>
SQL>   2
Session altered.

SQL> SQL>
SQL> ========== PROCESS ENDED ==========
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: