當前位置:我的異常網? 數據庫???oracle 12c單范例數據庫打12.1.0.2.4補丁記錄
oracle 12c單范例數據庫打12.1.0.2.4補丁記錄
www.myexceptions.net??網友分享于:2015-07-22??瀏覽:0次
oracle 12c單實例數據庫打12.1.0.2.4補丁記錄
oracle12c發布時間、操作系統版本:
[oracle@oel11 OPatch]$ lsb_release -a
LSB Version: ? ?:core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: ? ?Enterprise Linux Enterprise Linux Server release 5.8 (Carthage)
oracle for update?Release: ? ? ? ?5.8
Codename: ? ? ? Carthage
[oracle@oel11 patch]$ ls -ltr
total 73716
drwxr-xr-x 5 oracle oinstall ? ? 4096 Jul 11 15:45 20831110
oracle12c下載,-rw-rw-r-- 1 oracle oinstall ? ?30892 Jul 14 17:06 PatchSearch.xml
-rw-r--r-- 1 oracle oinstall 75370440 Jul 21 09:48 12.1.0.2.4DB_PSU_p20831110_121020_Linux-x86-64.zip
[oracle@oel11 patch]$ cd 20831110
[oracle@oel11 20831110]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.6
Oracle update。Copyright (c) 2015, Oracle Corporation. ?All rights reserved.
Oracle Home ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
from ? ? ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version ? ?: 12.1.0.1.6
oracle create table as改字段類型?OUI version ? ? ? : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-50-01AM_1.log
Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-21_09-50-01AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
oracle12c版本?Oracle Database 12c ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch ?20299023 ? ? : applied on Sun Apr 19 14:36:25 CST 2015
Unique Patch ID: ?18703022
oracle update優化?Patch description: ?"Database Patch Set Update : 12.1.0.2.3 (20299023)"
Created on 16 Mar 2015, 22:21:54 hrs PST8PDT
Sub-patch ?19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19189525, 19065556, 19075256, 19723336, 19077215, 19865345, 18845653
oracle create database命令。19280225, 19524384, 19248799, 18988834, 19048007, 18288842, 19238590
18921743, 18952989, 16870214, 19928926, 19134173, 19180770, 19018206
19197175, 19149990, 18849537, 19730508, 19183343, 19012119, 19001390
18202441, 19067244, 19189317, 19644859, 19358317, 19390567, 20074391
19279273, 19706965, 19068970, 19841800, 19512341, 14643995, 19619732
oracle數據庫修改字段里面的數據。20348653, 18607546, 18940497, 19670108, 19649152, 19065677, 19547370
18948177, 19315691, 19637186, 19676905, 18964978, 19035573, 19176326
18967382, 19174430, 19176223, 19532017, 18674047, 19074147, 19054077
19536415, 19708632, 19289642, 20425790, 19335438, 18856999, 19371175
19468347, 19195895, 19154375, 16359751, 18990693, 19439759, 19769480
oracle11g和12c哪個好,19272708, 19978542, 19329654, 19873610, 19174521, 19520602, 19382851
19658708, 19304354, 19052488, 19291380, 18681056, 19896336, 17835294
19076343, 19791377, 19068610, 19561643, 18618122, 20440930, 18456643
18909599, 19487147, 19143550, 19185876, 19016730, 18250893, 20347562
19627012, 16619249, 18354830, 19577410, 19687159, 19001359, 19174942
oracle批量update數據,19518079, 18610915, 18674024, 18306996, 19309466, 19081128, 19915271
19157754, 19058490, 20284155, 18791688, 18885870, 19303936, 19434529
19018447, 18417036, 19597439, 20235511, 19022470, 18964939, 19430401
19044962, 19385656, 19501299, 17274537, 19409212, 19440586, 19606174
18436647, 19023822, 19684504, 19178851, 19124589, 19805359, 19024808
oracle12c安裝及配置、19597583, 19155797, 19393542, 19050649, 19028800
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oel11 20831110]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.6
oracle12c創建數據庫,Copyright (c) 2015, Oracle Corporation. ?All rights reserved.
PREREQ session
Oracle Home ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
from ? ? ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version ? ?: 12.1.0.1.6
OUI version ? ? ? : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-50-10AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@oel11 20831110]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 09:50:32 2015
Copyright (c) 1982, 2014, Oracle. ?All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oel11 20831110]$ ps -fu oracle
UID ? ? ? ?PID ?PPID ?C STIME TTY ? ? ? ? ?TIME CMD
oracle ? ?2829 ?2828 ?0 09:45 pts/0 ? ?00:00:00 -bash
oracle ? ?3068 ?3067 ?0 09:46 pts/1 ? ?00:00:00 -bash
oracle ? ?3375 ?3373 ?0 09:48 ? ? ? ? ?00:00:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
oracle ? ?3621 ?2829 ?0 09:51 pts/0 ? ?00:00:00 ps -fu oracle
[oracle@oel11 20831110]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, Oracle Corporation. ?All rights reserved.
Oracle Home ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
from ? ? ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version ? ?: 12.1.0.1.6
OUI version ? ? ? : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-51-17AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: ? 20831110
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]: ?y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '20831110' to OH '/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Verifying the update...
Composite patch 20831110 successfully applied.
Log file location: /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-51-17AM_1.log
OPatch succeeded.
[oracle@oel11 20831110]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, Oracle Corporation. ?All rights reserved.
Oracle Home ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
from ? ? ? ? ? : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version ? ?: 12.1.0.1.6
OUI version ? ? ? : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_10-00-04AM_1.log
Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-21_10-00-04AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch ?20831110 ? ? : applied on Tue Jul 21 09:54:03 CST 2015
Unique Patch ID: ?18977826
Patch description: ?"Database Patch Set Update : 12.1.0.2.4 (20831110)"
Created on 11 Jul 2015, 00:45:40 hrs PST8PDT
Sub-patch ?20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch ?19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19189525, 19065556, 19075256, 19723336, 19077215, 19865345, 19280225
18845653, 19524384, 19248799, 18288842, 19048007, 18988834, 19238590
18921743, 18952989, 16870214, 19134173, 19928926, 19197175, 19018206
19180770, 20387265, 19149990, 18849537, 19183343, 19730508, 19703301
19012119, 19001390, 18202441, 19189317, 19067244, 19644859, 20074391
19358317, 19390567, 19279273, 19706965, 19068970, 14643995, 19512341
19841800, 20331945, 19619732, 18607546, 20348653, 18940497, 19670108
19649152, 19547370, 19065677, 18948177, 21225209, 19637186, 19315691
19676905, 18964978, 20165574, 19035573, 18967382, 19176326, 20558005
19174430, 19176223, 19532017, 19054077, 19074147, 18674047, 19536415
19708632, 19289642, 20425790, 19335438, 20294666, 18856999, 19307662
19195895, 19468347, 19371175, 19154375, 16359751, 18990693, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19382851, 19520602
19873610, 19174521, 19658708, 20093776, 19304354, 19052488, 19291380
18681056, 17835294, 19896336, 19076343, 19791377, 19068610, 19561643
18618122, 20746251, 20440930, 18456643, 19699191, 18909599, 19487147
19143550, 18250893, 19016730, 19185876, 20347562, 19627012, 16619249
18354830, 19577410, 19687159, 19001359, 19174942, 20424899, 19989009
19518079, 18610915, 18674024, 18306996, 19309466, 19081128, 19915271
19157754, 19058490, 19399918, 18791688, 20284155, 18885870, 19434529
19303936, 19018447, 18417036, 19597439, 20235511, 20919320, 19284031
19022470, 20474192, 18964939, 19430401, 19044962, 19385656, 19501299
17274537, 20899461, 19409212, 19440586, 20657441, 19606174, 18436647
19023822, 19124589, 19684504, 19178851, 19024808, 19805359, 19597583
19155797, 19050649, 19393542, 19028800
--------------------------------------------------------------------------------
OPatch succeeded.
對Single/Multitenant (CDB/PDB) DB數據庫執行下面的操作:
[oracle@oel11 20831110]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 10:00:26 2015
Copyright (c) 1982, 2014, Oracle. ?All rights reserved.
SQL> Connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area ?838860800 bytes
Fixed Size ? ? ? ? ? ? ? ? ?2929936 bytes
Variable Size ? ? ? ? ? ? 562039536 bytes
Database Buffers ? ? ? ? ?268435456 bytes
Redo Buffers ? ? ? ? ? ? ? ?5455872 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME ? ? ? ? ? ? ? ? ? ? ? OPEN MODE ?RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED ? ? ? ? ? ? ? ? ? ? ? READ ONLY ?NO
3 PDB12C ? ? ? ? ? ? ? ? ? ? ? ? READ WRITE NO
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oel11 20831110]$ cd $ORACLE_HOME/OPatch
[oracle@oel11 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Jul 21 10:03:19 2015
Copyright (c) 2015, Oracle. ?All rights reserved.
Log file for this invocation: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_4768_2015_07_21_10_03_19/sqlpatch_invocation.log
Connecting to database...OK
Note: ?Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 4 in the binary registry and ID 3 in PDB CDB$ROOT, ID 3 in PDB PDB$SEED, ID 3 in PDB PDB12C
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB12C
Nothing to roll back
The following patches will be applied:
20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110))
Installing patches...
Patch installation complete. ?Total patches installed: 3
Validating logfiles...
Patch 20831110 apply (pdb CDB$ROOT): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_CDBROOT_2015Jul21_10_04_30.log (no errors)
Patch 20831110 apply (pdb PDB$SEED): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_PDBSEED_2015Jul21_10_04_34.log (no errors)
Patch 20831110 apply (pdb PDB12C): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_PDB12C_2015Jul21_10_04_34.log (no errors)
SQL Patching tool complete on Tue Jul 21 10:04:44 2015
[oracle@oel11 OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 10:04:57 2015
Copyright (c) 1982, 2014, Oracle. ?All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> desc dba_registry_sqlpatch;
Name ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Null? ? ?Type
----------------------------------------- -------- ----------------------------
PATCH_ID ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?NOT NULL NUMBER
PATCH_UID ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NOT NULL NUMBER
VERSION ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NOT NULL VARCHAR2(20)
FLAGS ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?VARCHAR2(10)
ACTION ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?NOT NULL VARCHAR2(15)
STATUS ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? VARCHAR2(15)
ACTION_TIME ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NOT NULL TIMESTAMP(6)
DESCRIPTION ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?VARCHAR2(100)
BUNDLE_SERIES ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?VARCHAR2(30)
BUNDLE_ID ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?NUMBER
BUNDLE_DATA ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?CLOB
LOGFILE ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?VARCHAR2(500)
SQL> select patch_id,action,status from dba_registry_sqlpatch;
PATCH_ID ACTION ? ? ? ? ?STATUS
---------- --------------- ---------------
19769480 APPLY ? ? ? ? ? SUCCESS
20299023 APPLY ? ? ? ? ? SUCCESS
20831110 APPLY ? ? ? ? ? SUCCESS
SQL>
版權聲明:本文為博主原創文章,未經博主允許不得轉載。
文章評論
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态