39687
17752121, 17468141, 17602269, 18203835, 17375354, 17313525, 17811456
16731148, 14133975, 18203838, 16956380, 17385178, 17235750, 13866822
17394950, 17478514, 17027426, 12905058, 14338435, 16450169, 13944971
18094246, 16929165, 16785708, 17265217, 17465741, 16220077, 16180763
16069901, 17546973, 16285691, 17323222, 18180390, 17088068, 16875449
17016369, 17443671, 16228604, 17811438, 17811447, 16837842, 18031668
16912439, 17332800, 17393683, 17622427, 17545847, 17186905, 16943711
16850630, 17082359, 17346671, 14852021, 17783588, 17437634, 16618694
17341326, 17296856, 17546761, 17716305
--------------------------------------------------------------------------------
7.执行catbundle.sql将补丁信息反射到数据库中，使数据库知道你最后一次打了什么补丁或者回滚了哪些补丁：
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> Rem
SQL>
SQL> SET TERMOUT on
SQL> SET ECHO off
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
1 row selected.
1 row selected.
Generating apply and rollback scripts...
Check the following file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_FTDB_GENERATE_2014Apr02_17_20_18.log
Apply script: /u01/app/oracle/product/11.2/db_1/rdbms/admin/catbundle_PSU_FTDB_APPLY.sql
Rollback script: /u01/app/oracle/product/11.2/db_1/rdbms/admin/catbundle_PSU_FTDB_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
1 row selected.
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/u01/app/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;
1 row selected.
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> PROMPT Skipping Spatial because it is not installed or versions mismatch...
Skipping Spatial because it is not installed or versions mismatch...
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.4',
9 1,
10 'PSU',
11 'PSU 11.2.0.4.1');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
这个是手动升级db的方法，对于有grid结构的数据库，我们可以通过OPATCH AUTO的方式来进行数据库的自动升级
1,更新gird和oracle用户的Opatch文件
unzip p6880880_112000_Linux-x86-64.zip -d /oracle/11.2.0/grid
unzip p6880880_112000_Linux-x86-64.zip -d /oracle/app/oracle/product/11.2.0/db_1
2.生成响应文件
cd /oracle/11.2.0/grid/OPatch/ocm/bin
./emocmrsp
3，自动打补丁，打补丁的时候grid会自动重启
数据库启动状态 su -root
/oracle/11.2.0/grid/OPatch/opatch auto /oracle/media/psu -ocmrf /oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
此步操作我们需要注意几个问题
(1) 补丁集的属组需要为oracle:oinstall
(2) 我们需要断开一切的数据库的连接，不然的话在进行升级的时候会报错
optach auto的过程中我们是看不到具体的错误内容的
它的安装日志在/u01/app/11.2.0/grid/cfgtoollogs这个文件夹下来，如果遇到错误，我们可以看到详细的错误日志，从而分析出错误的原因
(3) 进行opatch auto的时候我们需要关闭掉数据库，grid可以不用 |