Database opened.
SQL> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
Function created.
Function created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/u01/app/cfgtoollogs/catbundle/catbundle_PSU_ORA11G_GENERATE_2015Jul21_01_28_33.log
Apply script: /u01/app/db11g/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_ORA11G_APPLY.sql
Rollback script: /u01/app/db11g/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_ORA11G_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/u01/app/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 sys.dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> PROMPT Processing OLAP Analytic Workspace...
Processing OLAP Analytic Workspace...
SQL> ALTER SESSION SET current_schema = sys;
SQL> @?/rdbms/admin/bug20558005.sql
SQL> --
SQL> -- bug20558005.sql
SQL> --
SQL> -- Copyright (c) 2015, Oracle and/or its affiliates. All rights reserved.
SQL> --
SQL> -- NAME
SQL> -- bug20558005.sql -- drop unneeded procedure
SQL> --
SQL> -- DESCRIPTION
SQL> -- patch 9968263 left a procedure behind. This file drops it.
SQL> --
SQL> -- NOTES
SQL> -- None
SQL> --
SQL> -- MODIFIED (MM/DD/YY)
SQL> -- jcarey 03/16/15 - Created
SQL>
SQL> drop procedure sys.drop_aw_elist_all;
drop procedure sys.drop_aw_elist_all
*
ERROR at line 1:
ORA-04043: object DROP_AW_ELIST_ALL does not exist
SQL>
SQL> PROMPT Processing Oracle Database Packages and Types...
Processing Oracle Database Packages and Types...
SQL> ALTER SESSION SET current_schema = sys;
Session altered.
SQL> @?/rdbms/admin/bug20876312_apply.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug20876312_apply.sql /st_rdbms_11.2.0.4.0dbpsu/2 2015/05/12 23:28:52 ratakuma Exp $
SQL> Rem
SQL> Rem bug20876312_apply.sql
SQL> Rem
SQL> Rem Copyright (c) 2015, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem bug20876312_apply.sql -
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem
SQL> Rem
SQL> Rem NOTES
SQL> Rem
SQL> Rem
SQL> Rem BEGIN SQL_FILE_METADATA
SQL> Rem SQL_SOURCE_FILE: rdbms/admin/bug20876312_apply.sql
SQL> Rem SQL_SHIPPED_FILE:
SQL> Rem SQL_PHASE:
SQL> Rem SQL_STARTUP_MODE: NORMAL
SQL> Rem SQL_IGNORABLE_ERRORS: NONE
SQL> Rem SQL_CALLING_FILE:
SQL> Rem END SQL_FILE_METADATA
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem ratakuma 04/17/15 - 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> create or replace view USER_AUDIT_POLICIES (OBJECT_NAME,
2 POLICY_NAME, POLICY_TEXT, POLICY_COLUMN, PF_SCHEMA,
3 PF_PACKAGE, PF_FUNCTION, ENABLED,
4 SEL, INS, UPD, DEL, AUDIT_TRAIL,
5 POLICY_COLUMN_OPTIONS)
6 as
7 SELECT OBJECT_NAME, POLICY_NAME, POLICY_TEXT, POLICY_COLUMN,
8 PF_SCHEMA, PF_PACKAGE, PF_FUNCTION, ENABLED,
9 SEL, INS, UPD, DEL