oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤（一）_kkp2btop

oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤

操作步骤如下：

oracle@oracle-R2:/opt/oracle/datasoft/16056266> opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /opt/oracle/datasoft
Central Inventory : /opt/oraInventory
   from           : /opt/oracle/datasoft/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /opt/oracle/datasoft/cfgtoollogs/opatch/opatch2013-05-15_09-26-10AM_1.log
 
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  
 
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 
 
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  
Email address/User Name: 
 
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
 
 
 
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/datasoft')
 
 
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/opt/oracle/datasoft'
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
 
Verifying the update...
Applying sub-patch '13696216' to OH '/opt/oracle/datasoft'
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.sdo.locator, 11.2.0.3.0...
 
Patching component oracle.sysman.console.db, 11.2.0.3.0...
 
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
 
Verifying the update...
Applying sub-patch '13923374' to OH '/opt/oracle/datasoft'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
 
Patching component oracle.network.rsf, 11.2.0.3.0...
 
Patching component oracle.network.listener, 11.2.0.3.0...
 
Patching component oracle.sysman.console.db, 11.2.0.3.0...
 
Verifying the update...
Applying sub-patch '14275605' to OH '/opt/oracle/datasoft'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
 
Patching component oracle.network.client, 11.2.0.3.0...
 
Patching component oracle.network.rsf, 11.2.0.3.0...
 
Patching component oracle.precomp.common, 11.2.0.3.0...
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
 
Patching component oracle.rdbms.rman, 11.2.0.3.0...
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.rdbms.util, 11.2.0.3.0...
 
Verifying the update...
Applying sub-patch '14727310' to OH '/opt/oracle/datasoft'
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.sdo.locator, 11.2.0.3.0...
 
Patching component oracle.sysman.console.db, 11.2.0.3.0...
 
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
 
Verifying the update...
Applying sub-patch '16056266' to OH '/opt/oracle/datasoft'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
 
Patching component oracle.network.listener, 11.2.0.3.0...
 
Patching component oracle.network.rsf, 11.2.0.3.0...
 
Patching component oracle.ovm, 11.2.0.3.0...
 
Patching component oracle.rdbms, 11.2.0.3.0...
 
Patching component oracle.rdbms.rman, 11.2.0.3.0...
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
Patching component oracle.sdo.locator, 11.2.0.3.0...
 
Patching component oracle.rdbms.deconfig, 11.2.0.3.0...
 
Verifying the update...
Composite patch 16056266 successfully applied.
Log file location: /opt/oracle/datasoft/cfgtoollogs/opatch/opatch2013-05-15_09-26-10AM_1.log
 
OPatch succeeded.
oracle@oracle-R2:/opt/oracle/datasoft/16056266> ls
13343438  13696216  13923374  14275605  14727310  16056266  patchmd.xml  README.html  README.txt
oracle@oracle-R2:/opt/oracle/datasoft/16056266>
oracle@oracle-R2:/opt/oracle/datasoft/16056266> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /opt/oracle/datasoft
Central Inventory : /opt/oraInventory
   from           : /opt/oracle/datasoft/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /opt/oracle/datasoft/cfgtoollogs/opatch/opatch2013-05-15_09-59-19AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed 
Unable to create Patch Object.
Exception occured : 0
 
OPatch succeeded.
oracle@oracle-R2:/opt/oracle/datasoft/16056266> cd $ORACLE_HOME/rdbms/admin
 
oracle@oracle-R2:/opt/oracle/datasoft/rdbms/admin> sqlplus /nolog
 
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 15 09:59:54 2013
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
 
Total System Global Area  338968576 bytes
Fixed Size                  1344820 bytes
Variable Size             209717964 bytes
Database Buffers          121634816 bytes
Redo Buffers                6270976 bytes
Database mounted.
Database opened.
SQL> select * from v$version where rownum<3;
 
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
 
SQL> @catbundle.sql psu apply
 
PL/SQL procedure successfully completed.
 
 
PL/SQL procedure successfully completed.
 
 
PL/SQL procedure successfully completed.
 
 
 
 
 
 
 
 
 
 
Generating apply and rollback scripts...
Check the following file for errors:
/opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_ROCK_GENERATE_2013May15_10_01_06.log
Apply script: /opt/oracle/datasoft/rdbms/admin/catbundle_PSU_ROCK_APPLY.sql
Rollback script: /opt/oracle/datasoft/rdbms/admin/catbundle_PSU_ROCK_ROLLBACK.sql
 
PL/SQL procedure successfully completed.
 
Executing script file...
 
 
 
 
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/opt/oracle/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
 
 
 
 
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
 
PL/SQL procedure successfully completed.
 
SQL> PROMPT Processing Oracle Database Packages and Types...
Processing Oracle Database Packages and Types...
SQL> ALTER SESSION SET current_schema = sys;
 
Session altered.
 
SQL> @?/psu/scripts/bug9858539.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug9858539.sql /st_rdbms_11.2.0.3.0dbpsu/1 2012/04/19 06:42:27 mjangir Exp $
SQL> Rem
SQL> Rem bug9858539.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      bug9858539.sql - <one-line expansion of the name>
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      <short description of component this file declares/defines>
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    mjangir     04/18/12 - Created
SQL> Rem
SQL> 
SQL> SET ECHO ON
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL> 
SQL> -- load XSL stylesheets connect / as sysdba
SQL> 
SQL> execute sys.dbms_metadata_util.load_stylesheets;
 
PL/SQL procedure successfully completed.
 
SQL> @?/rdbms/admin/prvsawr.plb
SQL> /* -------------------------------------------------------------------------
>  *   DBMS_SWRF_REPORT_INTERNAL PACKAGE
SQL>  *
SQL>  *     This package will handle the reporting for AWR. The report main
SQL>  *     routine will be called by the dbms_workload_repository.awr_report
SQL>  *     function.
SQL>  * ------------------------------------------------------------------------- */
SQL> /*
SQL>  * -------------------------------------------------------------------------
SQL>  *   DBMS_SWRF_REPORT_INTERNAL error code summary
SQL>  *
SQL>  *   -20001 : error in the report main, at the top of the error stack
SQL>  *   -20002:  internal error in ith_displayable_child routine when passed
SQL>  *            invalid arg tree_idx
SQL>  *   -20003:  internal error in ith_displayable child routine when passed
SQL>  *            invalid arg child_idx
SQL>  *   -20004:  invalid argument passed to dflt_align_for_type, internally
SQL>  *   -20005:  error initializing the report due to missing snapshot data
SQL>  *   -20006:  missing start value for dba_hist_librarycache
SQL>  *   -20007:  missing end value for dba_hist_librarycache
SQL>  *   -20008:  missing init.ora param
SQL>  *   -20009:  missing system stat
SQL>  *   -20010:  missing start value for dba_hist_waitstat
SQL>  *   -20011:  missing end value for dba_hist_waitstat
SQL>  *   -20012:  missing start time wait value for dba_hist_system_event
SQL>  *   -20013:  missing end time wait value for dba_hist_system_event
SQL>  *   -20014:  missing start value for DBA_HIST_LATCH gets and misses
SQL>  *   -20015:  missing end value for DBA_HIST_LATCH gets and misses
SQL>  *   -20016:  missing value for SGASTAT
SQL>  *   -20017:  Missing start value for DLM statistic
SQL>  *   -20018:  Missing end value for DLM statistic
SQL>  *   -20019:  invalid begin_snap/end_snap pair specified by user
SQL>  *   -20020:  invalid dbid/inst_num pair specified by user
SQL>  *   -20021:  missing start value for time model stat
SQL>  *   -20022:  missing end value for time model stat
SQL>  *   -20023:  missing start and end values for time model stat
SQL>  *   -20024:  failed to reset time zone
SQL>  *
SQL>  *   -20100:  invalid flush level specified to create_snapshot
SQL>  *   -20101:  no valid snapshots in range (bid, eid) for database id dbid
SQL>  *   -20102:  user name 'schname' is invalid
SQL>  *   -20103:  directory name 'dmpdir' is invalid
SQL>  *   -20104:  not allowed to specify the 'SYS' user
SQL>  *   -20105:  unable to move AWR data from schema to SYS
SQL>  *   -20106:  cannot move data from newer AWR schema
SQL>  *   -20107:  not allowed to move AWR data for local dbid
SQL>  *   -20108:  cannot move data from newer AWR schema
SQL>  *   -20109:  error encountered during move_to_awr
SQL>  *   -20110:  invalid Top N SQL value.  not allowed to specify 0 or 1.
SQL>  *   -20111:  invalid Top N SQL string: topnsql
SQL>  *
SQL>  *   -20500:  Invalid input to generate ASH report
SQL>  *   -20501:  Invalid input to helper function to create report
SQL>  *
SQL>  *   -20600:  Invalid (dbid, version) for DB Feature Usage
SQL>  *   -20601:  Invalid (dbid, version) for High Water Mark
SQL>  */
SQL> create or replace package dbms_swrf_report_internal wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  9
 20  9738 206d
 
 
132  MW5PuDuBQLeYPPHrL8axf/AryMJWMlrtXP6hxeEw4EbEgmFnZb7ybeTotbgCOZ7TQK93gDD8
133  gxsr0bQ7K9iJbFe4T0CKui8rSow3s5HUFK0YOQWbLOnvyslwlgPap0A/Em4iIgWzVc0LEVkX
134  EZ8aTAZcA/KwfsdtdrdWJYJ2Bv2qbmzDwpwy9fibmvlbalVnog==
135  
136  /
 
Package created.
 
SQL> SHOW ERRORS;
No errors.
SQL> @?/rdbms/admin/prvtawr.plb
SQL> /* -------------------------------------------------------------------------
>  *   DBMS_SWRF_REPORT_INTERNAL PACKAGE BODY
SQL>  *
SQL>  *     This package will handle the reporting for AWR. It will have the
SQL>  *     following interfaces:
SQL>  * ------------------------------------------------------------------------- */
SQL> create or replace package body dbms_swrf_report_internal wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  b
 20  8a8a7 1752c
 21  kJdswIBy2atlN05e2rPpIOORqLYwg4pz9hL9eMIWXz/BZN3/owOhG6BW+qHJ4JWtrrd+oXpI
 
1323  JRfIyfT7XjUkv00XGZYED0HLh0mZtmD58B2wiv1AMj+S0bBbtLtvl2nuxxYNNsky7O0LmtrT
1324  Zn/IpBZpXQOtsu7xEjRHminLdeRHQZGo2im0caFzaqFRjPFPk+vO2dz7Tcq3WmoUIsBsLAIo
1325  PgDQxm2XDpeuO2oVpB0vJX7PspDkR1gVLF8n3xzD6Aw/yT2tAbCmw4gWxbZJgvyPQZHDH3dl
1326  XFu2ZzXsuhZaxyRoe6b9uZtSe72pz//F2aUeLl0kw2fTnRZAR4RCBQTsQVklhrTOOVgliVB8
1327  wKk7IQ3WXOeFrhDeACwwKPYweqOLM9RTJkM6KrZ3p8+l8hA35i00KEIMYX4lQn/V44J4ul0B
1328  tgil3ydlq67xesDf+re3JkYL9vHtiCjTF7ZlaD6cb+q3zjvt+s9nLEhL9xNPFUpmD6qCKkK3
1329  ka1oEYTwlxs7hcqGoJE+iYdHcoIUQG0UE5W3H7WGtR0rVWgD
1330  
1331  /
 
Package body created.
 
SQL> show errors;
No errors.
SQL> /* --------------------------------------------
>  *    DBMS_WORKLOAD_REPOSITORY package body
SQL>  * -------------------------------------------- */
SQL> CREATE OR REPLACE PACKAGE BODY dbms_workload_repository wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  b
 20  b4ae 1c88
 21  Bld5KyDP/eUzy+9q/SDG+a0X5Lgwg80A9scFV/H+WJ3hDQ3q8WVZKzND6CfGhsPMZpFSB2aU
 
118  QJxOK0ltCVj/j1CWO92Rwm41l7zENqdawMtWOhmeVDbCwrh6OR47BRxfMvo3qCVoy+3E0YVI
119  4T6UXZ+4411BvPc2U5RNWSeumo5Dv4m8G6B3tJc/uA0a9vj5XSBdDVFKeE4HXfAZWMaFFY9Z
120  iH1rtidMcPIOpljmFMHED9x/sogmrVG75YGMrY81xHZpcK362U0+b+laQveklV6BQIq1znhi
121  kDQP
122  
123  /
 
Package body created.
 
SQL> SHOW ERRORS;
No errors.
SQL> @?/rdbms/admin/prvtawrs.plb
SQL> CREATE OR REPLACE PACKAGE BODY dbms_awr_report_layout wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  b
 20  1d1d6e 37272
 21  N4lHor+NgG99294ZjkGBl94cSB4wg4pz9r8FYcIkSiT+Ct2/uw+18QmVH6G8FHlFp1bV9K4Q
 22  CgFJmMH0p9GgO7ZVxQmfwpwP5CwdqRS5NlqtSro6blW0FMl8HandR1vWr+kDgRJOhP2kQSxz
 
3106  tjbptjkqgcSrSNM+2orFsr4NpHlkOEtCp4zXEtjuizvPNELQIo8R8FZi+xC6jAD3VuClyYRH
3107  LbhNC5kGUfENvTqKoU8TKjiuIFoSHXHco9ROmRBakCGYNVwSLoE0OTwS+Xlkh8OHLcLIf+3G
3108  7MloKbr966UieO3EKmleEboKcFQMkz3lAaPEcnXc0+i1CRixaBoPhYYXNWJ48CIiDZTjLiUZ
3109  lmzdWG+rSZXcGLFgGCarPzD3VT/F92w0TO9rYq5kDbRv2fuSHM0GMoEMlAcqCQ8o6JjYRnDQ
3110  IPGHS+C4x5NYbEoTqIf4dKi9aplPG27AFpYolj/UVIImVC1Uw/9D6eBXfYTm1E+AVYxq/wJv
3111  dS14E0fGNXYOjMyiJVSGwH1mzhUL/bKlI0uEYFMddmBtf2ZnnnKpBFH9rL2nj+dVD9CSsSGd
3112  K5Yv8zE4fHTm44PjF7jdjo9NqiQTdgAWBoaVCMz+0l19LKtEhB1c3NDQrq5X/X/h4SWPtBFo
3113  DPiRT4kifQkzJ2M3vpjN1mq23UXHuFAAMa1Iv6uloL/AsxpobmXmPbt1C9ISF39/EJo6Hqk/
3114  mr6YZRC19sFuP7XZKPDOljOI+TBwkkpbJHM/euyrnbvk17z4D1SfVNR/GTBWCwcfB9qAB7WY
3115  7Shs+ikxqrHn2WfyvyKQxz+kzeTHI0IIu7WatSzEK8cx
3116  
3117  /
 
Package body created.
 
SQL> SHOW ERRORS;
No errors.
SQL> @?/patch/scripts/bug12904308.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug12904308.sql /st_rdbms_11.2.0.3.0dbpsu/1 2012/07/18 04:46:58 vpriyans Exp $
SQL> Rem
SQL> Rem bug12904308.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      bug12904308.sql - Audit CREATE/DROP DIRECTORY actions by default
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      This file enables auditing for CREATE/DROP DIRECTORY actions
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    vpriyans    07/12/12 - Created
SQL> Rem
SQL> 
SQL> Rem --Enable Audit for CREATE/DROP DIRECTORY actions
SQL> AUDIT DIRECTORY BY ACCESS;
 
Audit succeeded.
 
SQL> 
SQL> PROMPT Processing Oracle Workspace Manager...
Processing Oracle Workspace Manager...
SQL> ALTER SESSION SET current_schema = sys;
 
Session altered.
 
SQL> @?/rdbms/admin/owmv1120.plb
SQL> update wmsys.wm$env_vars set value = '11.2.0.3.0' where name = 'OWM_VERSION';
 
1 row updated.
 
SQL> commit;
 
Commit complete.
 
SQL> create or replace function wmsys.get_expanded_nextvers wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  8
 20  269 19d
 21  pGwkFZjwr/4ajpli3MJGYw41Fgowg/AJ2SdqfC+KMQ8tB+ZWBkAbxux2kRK2mZExfTjaSczj
 22  KWKJ34nPPwFs4ulr0G3bvMkXYIOI9/YrmTCI/59TNCJPSmqzQUDZOgswEtDH72OUYqDDi2yN
 23  /Ra4gLKxynTBNhQn70T1jXtNXOpVmYoybSXgmlQuggoosuFe81+Q0fulgLvrM/5AdWerrVM0
 24  4sUnE6P7tqv+Fsb6LvzVaJ/YUAFUOObevbfsNm/6Zlh/01S2B+zuQb0HpjTiEwjLr3aFdnpH
 25  A0GyWZIrSmUYZrLHCDvbJiVdFzeMVwFlxsfoiHzko9zTu3OBFOuSMSiu9Z6n+ylDe3PR/J08
 26  zn+KWEDiovOmfu6z6pDJu4ON/83qaEF68GCAuSL7Ql5P/A==
 27  
 28  /
 
Function created.
 
SQL> begin
  2    delete wmsys.wm$nextver_table
  3    where next_vers != '-1' and split=1 and
  4    exists (select 1
  5            from table(wmsys.get_expanded_nextvers(next_vers)) n
  6            where n.next_vers not in(select version from wmsys.wm$version_hierarchy_table v)) ;
  7  end;
  8  /
 
PL/SQL procedure successfully completed.
 
SQL> drop function wmsys.get_expanded_nextvers ;
 
Function dropped.
 
SQL> create or replace view wmsys.wm$exp_map as
  2  select *
  3  from table(wmsys.lt_export_pkg.export_mapping_view_func()) ;
 
View created.
 
SQL> declare
  2    cnt integer ;
  3  begin
  4    select count(*) into cnt
  5    from dba_tables
  6    where owner = 'WMSYS' and
  7          table_name = 'WM$EXP_MAP_TBL' ;
  8  
  9    if (cnt=0) then
 10      execute immediate 'create table wmsys.wm$exp_map_tbl as (select * from wmsys.wm$exp_map where 1=2)' ;
 11    end if ;
 12  end;
 13  /
 
PL/SQL procedure successfully completed.
 
SQL> delete sys.impcalloutreg$ where tag='WMSYS';
 
27 rows deleted.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$EXP_MAP', 4, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$BATCH_COMPRESSIBLE_TABLES', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$CONSTRAINTS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$CONS_COLUMNS', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$ENV_VARS', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$EVENTS_INFO', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$HINT_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$INSTEADOF_TRIGS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$LOCKROWS_INFO', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MODIFIED_TABLES', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MP_GRAPH_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MP_PARENT_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$NESTED_COLUMNS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$NEXTVER_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$REMOVED_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RESOLVE_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_LOCKING_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_TRIGGERS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$UDTRIG_DISPATCH_PROCS', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$UDTRIG_INFO', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VERSION_HIERARCHY_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VERSION_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VT_ERRORS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACES_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACE_PRIV_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACE_SAVEPOINTS_TABLE', 2, 'Workspace Manager') ;
 
1 row created.
 
SQL> commit ;
 
Commit complete.
 
SQL> grant alter session to wmsys ;
 
Grant succeeded.
 
SQL> PROMPT Processing Spatial...
Processing Spatial...
SQL> ALTER SESSION SET current_schema = sys;
 
Session altered.
 
SQL> @?/md/admin/mdprivs.sql
SQL> Rem
SQL> Rem $Header: sdo/admin/mdprivs.sql /st_recommended_11.2.0.3.0/1 2013/01/03 09:09:59 sravada Exp $
SQL> Rem
SQL> Rem mdprivs.sql
SQL> Rem
SQL> Rem Copyright (c) 1998, 2012, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      mdprivs.sql - <one-line expansion of the name>
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      <short description of component this file declares/defines>
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    sravada     12/31/12 - Backport sravada_bug-13561951 from
SQL> Rem    vkolovsk    01/22/09 - grant flashback to mdsys (needed for incremental
SQL> Rem                           semantic inference)
SQL> Rem    ningan      09/24/07 - bug-6415891: add dba_java_classes privilege for NDM
SQL> Rem    bgouslin    01/07/07 - New version to fix Windoze format issue caused by
SQL> Rem                           some ADE bug
SQL> Rem    zzhang      01/05/06 - grant dba_all_tables privilege to georaster
SQL> Rem    zzhang      10/20/05 - add more privileges for georaster
SQL> Rem    nalexand    05/19/05 - add create any trigger to MDSYS
SQL> Rem    sravada     05/11/05 -
> Rem    geadon      05/04/05 - Add DBMS_SYSTEM privilege
SQL> Rem    zzhang      04/27/05 - remove grant DELETE ANY TABLE privilege to MDSYS
SQL> Rem    sravada     04/28/05 -
> Rem    sravada     04/20/04 - bug 3575743
SQL> Rem    wexu        06/24/03 - grant DELETE ANY TABLE privilege to MDSYS
SQL> Rem    sravada     10/01/02  -
> Rem    sravada     04/22/02 -  revoke "all privilleges" from MDSYS
SQL> Rem    sravada     10/08/01 -
> Rem    bgouslin    02/12/01 - Fix mdsys entries
SQL> Rem    sravada     04/20/00 - grant admin to mdsys
SQL> Rem    ranwei      10/22/98 - Privileges list for MDSYS
SQL> Rem    ranwei      10/22/98 - Created
SQL> Rem
SQL> 
SQL> REM
SQL> REM You must connect as SYS prior to running this script.
SQL> REM
SQL> 
SQL> --
SQL> -- System privs needed by MDSYS
SQL> --
SQL> -- grant all privileges to MDSYS with admin option;
SQL> -- the set below should be included in the admin option
SQL> 
SQL> grant create session to MDSYS;
 
Grant succeeded.
 
SQL> grant connect, resource, create library, create procedure to MDSYS;
 
Grant succeeded.
 
SQL> grant create operator to MDSYS;
 
Grant succeeded.
 
SQL> grant create indextype to MDSYS;
 
Grant succeeded.
 
SQL> grant create type to MDSYS;
 
Grant succeeded.
 
SQL> grant create table to MDSYS;
 
Grant succeeded.
 
SQL> grant create public synonym to MDSYS;
 
Grant succeeded.
 
SQL> grant drop public synonym to MDSYS;
 
Grant succeeded.
 
SQL> --  grant select_catalog_role to MDSYS ;
SQL> -- grant execute_catalog_role to MDSYS;
SQL> grant create view to MDSYS;
 
Grant succeeded.
 
SQL> grant create sequence to MDSYS;
 
Grant succeeded.
 
SQL> 
SQL> -- the following seem to give errors; so explicitly grant them
SQL> --
SQL> -- Privs needed for MDSYS to create mdbootstrap package
SQL> --
SQL> -- grant select on sys.obj$ to MDSYS;
SQL> -- grant select on sys.user$ to MDSYS;
SQL> -- grant select on sys.ts$ to MDSYS;
SQL> -- grant select on sys.col$ to MDSYS;
SQL> 
SQL> --
SQL> -- Privs needed for MDSYS to create mdlib package
SQL> --
SQL> grant select on sys.dba_objects to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_tablespaces to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_tables to MDSYS;
 
Grant succeeded.
 
SQL> grant select on dba_views to mdsys with grant option;
 
Grant succeeded.
 
SQL> grant select on dba_object_tables to mdsys with grant option;
 
Grant succeeded.
 
SQL> grant select on sys.dba_tab_columns to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_tab_privs to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_constraints to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_cons_columns to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_indexes to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.dba_ind_columns to MDSYS;
 
Grant succeeded.
 
SQL> grant select on sys.kopm$ to mdsys;
 
Grant succeeded.
 
SQL> grant EXECUTE on dbms_registry to mdsys;
 
Grant succeeded.
 
SQL> grant select on dba_registry to mdsys;
 
Grant succeeded.
 
SQL> grant select on dba_role_privs to mdsys;
 
Grant succeeded.
 
SQL> grant execute on dbms_lock to mdsys;
 
Grant succeeded.
 
SQL> 
SQL> 
SQL> --
SQL> -- Privs needed for MDSYS to use import/export extensibility
SQL> --
SQL> 
SQL> -- grant insert on sys.exppkgobj$ to MDSYS;
SQL> -- grant insert on sys.exppkgact$ to MDSYS;
SQL> -- grant insert on sys.expdepobj$ to MDSYS;
SQL> -- grant insert on sys.expdepact$ to MDSYS;
SQL> -- grant delete on sys.exppkgobj$ to MDSYS;
SQL> -- grant delete on sys.exppkgact$ to MDSYS;
SQL> -- grant delete on sys.expdepobj$ to MDSYS;
SQL> -- grant delete on sys.expdepact$ to MDSYS;
SQL> 
SQL> 
SQL> --
SQL> -- for GeoRaster
SQL> --
SQL> grant drop any trigger to mdsys;
 
Grant succeeded.
 
SQL> grant select on sys.dba_triggers to mdsys;
 
Grant succeeded.
 
SQL> grant select on sys.dba_synonyms to mdsys;
 
Grant succeeded.
 
SQL> grant select on sys.dba_types to mdsys;
 
Grant succeeded.
 
SQL> grant select on sys.dba_type_attrs to mdsys;
 
Grant succeeded.
 
SQL> grant select on sys.dba_all_tables to mdsys;
 
Grant succeeded.
 
SQL> grant select any table to mdsys;
 
Grant succeeded.
 
SQL> grant update any table to mdsys;
 
Grant succeeded.
 
SQL> grant alter any table to mdsys;
 
Grant succeeded.
 
SQL> 
SQL> 
SQL> --
SQL> -- for RDF
SQL> --
SQL> grant execute on sys.dbms_system to MDSYS;
 
Grant succeeded.
 
SQL> grant create any trigger to MDSYS;
 
Grant succeeded.
 
SQL> grant delete any table to  MDSYS;
 
Grant succeeded.
 
SQL> grant flashback any table to MDSYS;
 
Grant succeeded.
 
SQL> --
SQL> -- for NDM
SQL> --
SQL> grant select on sys.dba_java_classes to MDSYS;
 
Grant succeeded.
 
SQL> 
SQL> grant ADMINISTER DATABASE TRIGGER to MDSYS;
 
Grant succeeded.
 
SQL> 
SQL> ALTER SESSION SET current_schema = SYS;
 
Session altered.
 
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '11.2.0.3',
  9     6,
 10     'PSU',
 11     'PSU 11.2.0.3.6');
 
1 row created.
 
SQL> COMMIT;
 
Commit complete.
 
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_ROCK_APPLY_2013May15_10_01_08.log
SQL> !vi /opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_ROCK_APPLY_2013May15_10_01_08.log
SQL> exec dbms_registry.set_session_namespace('SERVER')
 
PL/SQL procedure successfully completed.
 
SQL> PROMPT Processing Oracle Database Packages and Types...
Processing Oracle Database Packages and Types...
SQL> ALTER SESSION SET current_schema = sys;
 
Session altered.
 
SQL> @?/psu/scripts/bug9858539.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug9858539.sql /st_rdbms_11.2.0.3.0dbpsu/1 2012/04/19 06:42:27 mjangir Exp $
SQL> Rem
SQL> Rem bug9858539.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      bug9858539.sql - <one-line expansion of the name>
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      <short description of component this file declares/defines>
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    mjangir     04/18/12 - Created
SQL> Rem
SQL>
SQL> SET ECHO ON
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL> Rem    NAME
SQL> Rem      bug9858539.sql - <one-line expansion of the name>
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> /* -------------------------------------------------------------------------
SQL>  *   DBMS_SWRF_REPORT_INTERNAL error code summary
 
SQL>  *
SQL>  *   -20001 : error in the report main, at the top of the error stack
SQL>  *   -20002:  internal error in ith_displayable_child routine when passed
SQL>  *            invalid arg tree_idx
SQL>  *   -20003:  internal error in ith_displayable child routine when passed
SQL>  *            invalid arg child_idx
SQL>  *   -20004:  invalid argument passed to dflt_align_for_type, internally
SQL>  *   -20005:  error initializing the report due to missing snapshot data
SQL>  *   -20006:  missing start value for dba_hist_librarycache
SQL>  *   -20007:  missing end value for dba_hist_librarycache
SQL>  *   -20008:  missing init.ora param
SQL>  *   -20009:  missing system stat
SQL>  *   -20010:  missing start value for dba_hist_waitstat
SQL>  *   -20011:  missing end value for dba_hist_waitstat
SQL>  *   -20012:  missing start time wait value for dba_hist_system_event
SQL>  *   -20013:  missing end time wait value for dba_hist_system_event
SQL>  *   -20014:  missing start value for DBA_HIST_LATCH gets and misses
SQL>  *   -20015:  missing end value for DBA_HIST_LATCH gets and misses
SQL>  *   -20016:  missing value for SGASTAT
SQL>  *   -20017:  Missing start value for DLM statistic
SQL>  *   -20018:  Missing end value for DLM statistic
SQL>  *   -20019:  invalid begin_snap/end_snap pair specified by user
SQL>  *   -20020:  invalid dbid/inst_num pair specified by user
SQL>  *   -20021:  missing start value for time model stat
SQL>  *   -20022:  missing end value for time model stat
SQL>  *   -20023:  missing start and end values for time model stat
SQL>  *   -20024:  failed to reset time zone
SQL>  *
SQL>  *   -20100:  invalid flush level specified to create_snapshot
SQL>  *   -20101:  no valid snapshots in range (bid, eid) for database id dbid
SQL>  *   -20102:  user name 'schname' is invalid
SQL>  *   -20103:  directory name 'dmpdir' is invalid
SQL>  *   -20104:  not allowed to specify the 'SYS' user
SQL>  *   -20105:  unable to move AWR data from schema to SYS
SQL>  *   -20106:  cannot move data from newer AWR schema
SQL>  *   -20107:  not allowed to move AWR data for local dbid
SQL>  *   -20108:  cannot move data from newer AWR schema
SQL>  *   -20109:  error encountered during move_to_awr
SQL>  *   -20110:  invalid Top N SQL value.  not allowed to specify 0 or 1.
SQL>  *   -20111:  invalid Top N SQL string: topnsql
SQL>  *
SQL>  *   -20500:  Invalid input to generate ASH report
SQL>  *   -20501:  Invalid input to helper function to create report
SQL>  *
SQL>  *   -20600:  Invalid (dbid, version) for DB Feature Usage
SQL>  *   -20601:  Invalid (dbid, version) for High Water Mark
SQL>  */
SQL> create or replace package dbms_swrf_report_internal wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
121  mMoNhJth12pm96+jP3zGeJKVAfeo8w95DaPOFcDi63iTicxaGE3Fq6Owb/DYV5auRjDF26fg
122  wRzr5e0Yd0b0nDO9XxmSIlOnIftjQtyOyFzOS88XB7Sf1qXUZYyun3hrr5hS/42Ur1goGGZ6
123  YyvFGILEzdaREYDdXYUUvF7QdNrYriRTsXV0YPkq7QVlPSlOTfBJKsfXQp/k61SrVY+aZiV1
124  Xzi60ulMkzizX18XXrqz/iVopIRAYf3miv3CfGldWKDF94nYPS5OoTKjrSND5U/aSvraSVkk
125  SUfmsC5gsNehsC4usNdpsC7DsNfqsC66sNeHsC7gsJcBAjuAPLPu/GbZLaxt/CHoNDqaoXBc
126  WAzMiSzMYlxddUBcoYbFGlJVs0slEXGTIeJsq+oo8B4CXsPnuxhjZ96lUK5KKflMA//yzYfJ
127  0dwOmSEfZrhaLXnAL8ODPj6zFA/qfwGjyy66C9nLyKqvuSYDmqVgjYrKClpe/s61sfbcLENA
128  I+SdohJ7LOboAgC6nYwDa23p5ERSR9yU2zbVHHypb//PVZz6y9bBGDEjbBA/gGn9YlZNDbOA
129  fmAwIH5Gbxll3ca5AWMsuH+SqvHyHv6J/SpR/UbN3gOlNY474YRP7cM7xXdDlGPBty/XGS7y
130  T3j2z49Qhezwcm+rHGIhZUqR91nin12YUYsResbGHIa0Mbp1j8swdzH6f/YHDl/CY3PUpU55
131  BIT+5z6O6Mw5JK5+aVDQS2pMRkYs0983oUUELqcGVpGtYtQT3aqybOFhz0OFv0v6ydWyJJp7
132  MW5PuDuBQLeYPPHrL8axf/AryMJWMlrtXP6hxeEw4EbEgmFnZb7ybeTotbgCOZ7TQK93gDD8
133  gxsr0bQ7K9iJbFe4T0CKui8rSow3s5HUFK0YOQWbLOnvyslwlgPap0A/Em4iIgWzVc0LEVkX
134  EZ8aTAZcA/KwfsdtdrdWJYJ2Bv2qbmzDwpwy9fibmvlbalVnog==
135
136  /
 
Package created.