oracle12c發布時間，oracle update范例,oracle 12c單范例數據庫打12.1.0.2.4補丁記錄-基礎知識庫-匯編語言學習筆記

oracle12c發布時間，oracle update范例,oracle 12c單范例數據庫打12.1.0.2.4補丁記錄

2023-10-20 阅读 22 评论 0

摘要：當前位置:我的異常網? 數據庫???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 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 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

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

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

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]

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]

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

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

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

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

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>

文章評論

原文链接：https://hbdhgg.com/5/152360.html

发表评论: