醉逍遥贴吧有V4451升级V5073的吗
点击联系发帖人
时间：2015-03-28 12:21
Oracle 10g(10.2.0.4)升级到10.2.0.5.19_oracle数据库_ThinkSAAS
Oracle 10g(10.2.0.4)升级到10.2.0.5.19
Oracle 10g(10.2.0.4)升级到10.2.0.5.19
内容来源： 网络
一、将数据库版本从10.2.0.4 升级到 10.2.0.5，再升级到10.2.0.5.19(1) 备份等过程略过，一个老库的升级过程，记录之。
(2) 一致性关闭数据库及监听sqlplus /
shutdown immediate
lsnrctl stop二、升级数据库软件1，解压p05_Linux-x86-64.zip
2，直接采用安装方式安装，覆盖原安装目录xhost+
su - oracle
./runInstaller三、升级数据字典1, 升级前检查SQL& STARTUP UPGRADE
SQL& SPOOL upgrade_info.log
SQL& @?/rdbms/admin/utlu102i.sqlOracle Database 10.2 Upgrade Information Utility
**********************************************************************
**********************************************************************
--& version:
10.2.0.4.0
--& compatible: 10.2.0.3.0
--& blocksize:
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--& SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 488 MB
.... AUTOEXTEND additional space required: 8 MB
--& UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 401 MB
.... AUTOEXTEND additional space required: 376 MB
--& SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 259 MB
.... AUTOEXTEND additional space required: 9 MB
--& TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--& Oracle Catalog Views
--& Oracle Packages and Types
--& JServer JAVA Virtual Machine [upgrade]
--& Oracle XDK for Java
--& Oracle Java Packages
--& Oracle Text
--& Oracle XML Database
--& Oracle Workspace Manager
--& Oracle Data Mining
--& OLAP Analytic Workspace
--& OLAP Catalog
--& Oracle OLAP API
--& Oracle interMedia
--& Spatial
--& Expression Filter
--& EM Repository
--& Rule Manager
VALIDPL/SQL procedure successfully completed.SQL& SPOOL OFF2. 开始升级数据库字典（大概需要30分钟）SQL& STARTUP UPGRADE
SQL& SPOOL patch.log
SQL& @?/rdbms/admin/catupgrd.sql
SQL& SPOOL OFF编译无译对象SQL& SHUTDOWN IMMEDIATE
SQL& STARTUP
SQL& @?/rdbms/admin/utlrp.sqlSQL& SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;升级后检查，升级成功。set line 200
col ACTION_TIME for a30
col ACTION for a20
col NAMESPACE for a10
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a25
select * from dba_registry_
ACTION_TIME
ID COMMENTS
------------------------------ -------------------- ---------- ---------- ---------- -------------------------
21-316 10.47.16.102814 VIEW RECOMPILE
8289601 view recompilation21-316 10.47.16.167852 UPGRADE
10.2.0.5.0
Upgraded from 10.2.0.4.0SQL& 四、打PSU19，更新OPatch版本，必须要更新OPatch版本说明：分别在两个节点更新OPatch版本。1. 更新OPatch版本，需要更新到10.2.0.5.19，OPatch直接压缩替换就可以了。(1) 上传p000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限，也可以采用/tmp目录。
(2) root用户下将原OPatch目录改名。mv /u01/app/oracle/product/10.2.0/db_1/OPatch /u01/app/oracle/product/10.2.0/db_1/OPatchBK2. oracle目录OPatch替换(1) root用户cd /u01/software/
chown oracle:oinstall p000_Linux-x86-64.zip
chown oracle:oinstall p05_Linux-x86-64.zip(2) oracle用户su - oracle
cd /u01/software/
unzip p000_Linux-x86-64.zip
unzip p05_Linux-x86-64.zip(3) root用户cd /u01/software/
mv OPatch /u01/app/oracle/product/10.2.0/db_1/(4) oracle用户测试su - oracle/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch versionInvoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded3. 测试兼容性su - oracle$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/ -oh $ORACLE_HOME----------------------------------------------------
Invoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.
All rights reserved.PREREQ session
Oracle Home
: /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
: /etc/oraInst.loc
OPatch version
: 10.2.0.5.1
OUI version
: 10.2.0.5.0
OUI location
: /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_12-33-56PM.logPatch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded. 五、实施打补丁PSU1. 关闭数据库1）关闭数据库
2）关闭监听$ lsnrctl stop3. oracle database打补丁，还是用同一个补丁包su - oracle/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/***************************************************************
Do you want to proceed? [y|n]
User Responded with: YEmail 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]:
...Is the local system ready for patching? [y|n]
User Responded with: Y
Verifying the update...
Inventory check OK: Patch ID
is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID
are present in Oracle Home.
Running make for target client_sharedlib
Running make for target ikfod
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
Running make for target itnslsnr
Execution of &sh /u01/software//custom/scripts/post -apply
&:Return Code = 0The local system has been patched and can be restarted.UtilSession: N-Apply done.OPatch succeeded.
***************************************************************4. 查看升级状态[ ~]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch lsinvInvoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.
All rights reserved.Oracle Home
: /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
: /etc/oraInst.loc
OPatch version
: 10.2.0.5.1
OUI version
: 10.2.0.5.0
OUI location
: /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_11-30-15AM.logPatch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txtLsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory_11-30-15AM.txt--------------------------------------------------------------------------------
Installed Top-level Products (3):Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3
10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 4
10.2.0.5.0
There are 3 products installed in this Oracle Home.Interim patches (1) :Patch
: applied on Mon Mar 21 11:05:03 CST 2016
Unique Patch ID:
Created on 24 Jun :37 hrs PST8PDT
Bugs fixed:
647, 20537
959, 921, 632743
12, 076510
265, 058, 9171933
54, 076894
84, 048091
78, 469008
259, 503598
17, 94, 856395
090, 015379
450, 77, 132870
38, 86, 77300
571, 710774
27, 736501
737047--------------------------------------------------------------------------------
OPatch succeeded.[ ~]$ $ORACLE_HOME/OPatch/opatch lsinv -bugs_fixed
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-058-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-059-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-060-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-061-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-062-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-063-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-064-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-065-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-066-SPUJUL2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-067-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-068-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-069-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-070-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-071-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-072-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-073-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-074-SPUJUL2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-075-SPUJUL2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-076-SPUJUL20155. 升级数据库字典cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL& CONNECT / AS SYSDBA
SQL& STARTUP
SQL& @catbundle.sql psu apply
SQL& -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.
SQL& @utlrp.sql升级后检查SQL& set line 200
SQL& col ACTION_TIME for a30
SQL& col ACTION for a20
SQL& col NAMESPACE for a10
SQL& col VERSION for a20
SQL& col BUNDLE_SERIES for a5
SQL& col COMMENTS for a25
SQL& select * from dba_registry_ACTION_TIME
ID BUNDL COMMENTS
------------------------------ -------------------- ---------- -------------------- ---------- ----- -------------------------
21-316 10.47.16.102814 VIEW RECOMPILE
view recompilation21-316 10.47.16.167852 UPGRADE
10.2.0.5.0
Upgraded from 10.2.0.4.021-316 11.09.17.948626 jvmpsu.sql
10.2.0.5.2OJVMBP
RAN jvmpsu.sql21-316 11.09.52.682715 jvmpsu.sql
10.2.0.5.2OJVMBP
RAN jvmpsu.sql21-316 11.15.00.366608 APPLY
PSU 10.2.0.5.195 rows selected.SQL&升级成功。本文出自 “” 博客，请务必保留此出处
PHP开发框架
开发工具/编程工具
服务器环境
ThinkSAAS商业授权：
ThinkSAAS为用户提供有偿个性定制开发服务
ThinkSAAS将为商业授权用户提供二次开发指导和技术支持
让ThinkSAAS更好，把建议拿来。
开发客服微信}
Oracle 10g(10.2.0.4)升级到10.2.0.5.19
Oracle 10g(10.2.0.4)升级到10.2.0.5.19
内容来源： 网络
一、将数据库版本从10.2.0.4 升级到 10.2.0.5，再升级到10.2.0.5.19(1) 备份等过程略过，一个老库的升级过程，记录之。
(2) 一致性关闭数据库及监听sqlplus /
shutdown immediate
lsnrctl stop二、升级数据库软件1，解压p05_Linux-x86-64.zip
2，直接采用安装方式安装，覆盖原安装目录xhost+
su - oracle
./runInstaller三、升级数据字典1, 升级前检查SQL& STARTUP UPGRADE
SQL& SPOOL upgrade_info.log
SQL& @?/rdbms/admin/utlu102i.sqlOracle Database 10.2 Upgrade Information Utility
**********************************************************************
**********************************************************************
--& version:
10.2.0.4.0
--& compatible: 10.2.0.3.0
--& blocksize:
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--& SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 488 MB
.... AUTOEXTEND additional space required: 8 MB
--& UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 401 MB
.... AUTOEXTEND additional space required: 376 MB
--& SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 259 MB
.... AUTOEXTEND additional space required: 9 MB
--& TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--& Oracle Catalog Views
--& Oracle Packages and Types
--& JServer JAVA Virtual Machine [upgrade]
--& Oracle XDK for Java
--& Oracle Java Packages
--& Oracle Text
--& Oracle XML Database
--& Oracle Workspace Manager
--& Oracle Data Mining
--& OLAP Analytic Workspace
--& OLAP Catalog
--& Oracle OLAP API
--& Oracle interMedia
--& Spatial
--& Expression Filter
--& EM Repository
--& Rule Manager
VALIDPL/SQL procedure successfully completed.SQL& SPOOL OFF2. 开始升级数据库字典（大概需要30分钟）SQL& STARTUP UPGRADE
SQL& SPOOL patch.log
SQL& @?/rdbms/admin/catupgrd.sql
SQL& SPOOL OFF编译无译对象SQL& SHUTDOWN IMMEDIATE
SQL& STARTUP
SQL& @?/rdbms/admin/utlrp.sqlSQL& SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;升级后检查，升级成功。set line 200
col ACTION_TIME for a30
col ACTION for a20
col NAMESPACE for a10
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a25
select * from dba_registry_
ACTION_TIME
ID COMMENTS
------------------------------ -------------------- ---------- ---------- ---------- -------------------------
21-316 10.47.16.102814 VIEW RECOMPILE
8289601 view recompilation21-316 10.47.16.167852 UPGRADE
10.2.0.5.0
Upgraded from 10.2.0.4.0SQL& 四、打PSU19，更新OPatch版本，必须要更新OPatch版本说明：分别在两个节点更新OPatch版本。1. 更新OPatch版本，需要更新到10.2.0.5.19，OPatch直接压缩替换就可以了。(1) 上传p000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限，也可以采用/tmp目录。
(2) root用户下将原OPatch目录改名。mv /u01/app/oracle/product/10.2.0/db_1/OPatch /u01/app/oracle/product/10.2.0/db_1/OPatchBK2. oracle目录OPatch替换(1) root用户cd /u01/software/
chown oracle:oinstall p000_Linux-x86-64.zip
chown oracle:oinstall p05_Linux-x86-64.zip(2) oracle用户su - oracle
cd /u01/software/
unzip p000_Linux-x86-64.zip
unzip p05_Linux-x86-64.zip(3) root用户cd /u01/software/
mv OPatch /u01/app/oracle/product/10.2.0/db_1/(4) oracle用户测试su - oracle/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch versionInvoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded3. 测试兼容性su - oracle$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/ -oh $ORACLE_HOME----------------------------------------------------
Invoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.
All rights reserved.PREREQ session
Oracle Home
: /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
: /etc/oraInst.loc
OPatch version
: 10.2.0.5.1
OUI version
: 10.2.0.5.0
OUI location
: /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_12-33-56PM.logPatch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded. 五、实施打补丁PSU1. 关闭数据库1）关闭数据库
2）关闭监听$ lsnrctl stop3. oracle database打补丁，还是用同一个补丁包su - oracle/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/***************************************************************
Do you want to proceed? [y|n]
User Responded with: YEmail 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]:
...Is the local system ready for patching? [y|n]
User Responded with: Y
Verifying the update...
Inventory check OK: Patch ID
is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID
are present in Oracle Home.
Running make for target client_sharedlib
Running make for target ikfod
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
Running make for target itnslsnr
Execution of &sh /u01/software//custom/scripts/post -apply
&:Return Code = 0The local system has been patched and can be restarted.UtilSession: N-Apply done.OPatch succeeded.
***************************************************************4. 查看升级状态[ ~]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch lsinvInvoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.
All rights reserved.Oracle Home
: /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
: /etc/oraInst.loc
OPatch version
: 10.2.0.5.1
OUI version
: 10.2.0.5.0
OUI location
: /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_11-30-15AM.logPatch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txtLsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory_11-30-15AM.txt--------------------------------------------------------------------------------
Installed Top-level Products (3):Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3
10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 4
10.2.0.5.0
There are 3 products installed in this Oracle Home.Interim patches (1) :Patch
: applied on Mon Mar 21 11:05:03 CST 2016
Unique Patch ID:
Created on 24 Jun :37 hrs PST8PDT
Bugs fixed:
647, 20537
959, 921, 632743
12, 076510
265, 058, 9171933
54, 076894
84, 048091
78, 469008
259, 503598
17, 94, 856395
090, 015379
450, 77, 132870
38, 86, 77300
571, 710774
27, 736501
737047--------------------------------------------------------------------------------
OPatch succeeded.[ ~]$ $ORACLE_HOME/OPatch/opatch lsinv -bugs_fixed
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-058-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-059-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-060-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-061-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-062-SPUJAN2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-063-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-064-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-065-SPUAPR2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-066-SPUJUL2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-067-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-068-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-069-SPUOCT2014
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-070-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-071-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-072-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-073-SPUJAN2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-074-SPUJUL2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-075-SPUJUL2015
Mon Mar 21 11:05:03 CST 2016
DB-10.2.0.5-MOLECULE-076-SPUJUL20155. 升级数据库字典cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL& CONNECT / AS SYSDBA
SQL& STARTUP
SQL& @catbundle.sql psu apply
SQL& -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.
SQL& @utlrp.sql升级后检查SQL& set line 200
SQL& col ACTION_TIME for a30
SQL& col ACTION for a20
SQL& col NAMESPACE for a10
SQL& col VERSION for a20
SQL& col BUNDLE_SERIES for a5
SQL& col COMMENTS for a25
SQL& select * from dba_registry_ACTION_TIME
ID BUNDL COMMENTS
------------------------------ -------------------- ---------- -------------------- ---------- ----- -------------------------
21-316 10.47.16.102814 VIEW RECOMPILE
view recompilation21-316 10.47.16.167852 UPGRADE
10.2.0.5.0
Upgraded from 10.2.0.4.021-316 11.09.17.948626 jvmpsu.sql
10.2.0.5.2OJVMBP
RAN jvmpsu.sql21-316 11.09.52.682715 jvmpsu.sql
10.2.0.5.2OJVMBP
RAN jvmpsu.sql21-316 11.15.00.366608 APPLY
PSU 10.2.0.5.195 rows selected.SQL&升级成功。本文出自 “” 博客，请务必保留此出处
PHP开发框架
开发工具/编程工具
服务器环境
ThinkSAAS商业授权：
ThinkSAAS为用户提供有偿个性定制开发服务
ThinkSAAS将为商业授权用户提供二次开发指导和技术支持
让ThinkSAAS更好，把建议拿来。
开发客服微信}
我要回帖
更多关于 醉逍遥 的文章
- ·及时雨外挂达拉然传送戒指以后为什么不换戒指
- ·醉逍遥礼包领取新区一般多久开一个？
- ·游戏名起逍遥游什么好呢，字符文字一起的，各位帅哥美女帮忙想想
- ·醉逍遥什么职业好玩镶嵌要什么条件
- ·QAQ求俺酱逍遥法外Mp3QAQ！！
- ·醉逍遥升级攻略游戏卡蝙蝠攻略2014
- ·网页37玩游戏广告音乐乐
- ·醉逍遥委托任务路46腰带任务在哪里做啊？
- ·5.0.35版醉逍遥视频怎么去掉任务视频
- ·什么醉逍遥之惊天变 读起来最顺口 还有诗意 2个字 谢谢
- ·醉逍遥下载 绿装雷珠6阶佛法系灵珠多少钱
- ·为什么醉逍遥摆摊旁边出现金元宝,有的摆摊没有金元宝小肚旁边痛是什么原因因?
- ·请问醉逍遥贴吧77英雄本里面的黑白怎么打？
- ·醉逍遥贴吧64级白花号坐骑+8值多少
- ·醉逍遥贴吧有V4451升级V5073的吗
- ·醉逍遥好玩吗经典版什么时候开？
- ·蜀门醉逍遥和蜀门哪个好玩花花需要极品特品蛋蛋吗？
- ·醉逍遥开心令牌神罚令有什么用
- ·醉逍遥在上海龙华寺开光时间的金卡有何种价值？
- ·醉逍遥吧客户端自动退出
- ·醉逍遥sf果酱新出的稻草人都有什么作用
- ·醉逍遥最新版本经典版下载怎么有毒
- ·无法无天醉逍遥官网，念念不忘旧人情，是什么动物呢？
- ·《醉逍遥官网峨眉到底弱不弱，深度分析后期火峨眉
更多推荐
- ·《小李飞刀喜欢林诗音还是惊鸿仙子》手游林诗音怎么样 林诗音技能属性解析
- ·电价有电费是怎么计算的公式吗？
- ·不含直线x=x0与垂直于同一条直线的两条直线平行吗x轴的直线，两种定义一样吗？
- ·户内各个功能室内空间功能区划分尺度由哪三个部分组成？
- ·《梦幻手游69大唐标配西游》手游大唐怎么加点 大唐平民加点推荐
- ·手机安装游戏总是cad安装失败怎么回事事，有内存
- ·求魔界中土之战2 巫王的崛起防爆布丁，
- ·时空猎人满品质装备限时优惠里面的特八装备箱，开出来的装备是什么人物的技能＋2？
- ·换牌21点集换式卡牌游戏 安卓怎么样？
- ·阿提拉全面战争下载安装完steam，就第一次可以进入游戏，第二次就进不去了，怎么解决
- ·天天来塔防保卫女神炼狱峡谷7关塔防三国怎么过魏续
- ·植物大战僵尸2电脑版时空风暴地图视频
- ·qq1665611751是服qq被举报能发现吗
- ·蒙多VS狗熊哪个胜率多少可以跳级大
- ·求神将世界好号求一个有孟获而不玩的号
- ·西游记之大闹天宫下载页游找个师父，能送VIP的
- ·失忆症amnesia laterr汉化PSP游戏
- ·水果忍者破解版炫酷版第三关怎么破
- ·求橙光游戏现代素材帅男素材多来几张
- ·逆战如何抱着逆战解说火神暴君君跑
- ·醉逍遥贴吧有V4451升级V5073的吗
- ·法国佳士德拍卖行控制模块邮箱地址?
- ·使命召唤ol吧 安全认证失败，请确保您的计算机系统时间正确，急··········
- ·不用root的nba2knba2k14mc交易修改器器
- ·真三国无双6帝国pc版7帝国下载安装部骤
- ·9g游戏中围堵 哥哥要教养小软怎么操作?
- ·LOL现在SOLO有那些lol中路solo强势英雄游戏
- ·生化危机启示录2攻略升级档出错
- ·开心笑笑乐发叉第六开心消消乐63关怎么过过
- ·神魔图片3.1.38怎么恢复角色图
- ·乱斗西游金角大王的金角大王和武德打帮派boss那个强?
- ·卖木脑壳歌词被贼抢，，，，大丢脸面
- ·我的世界鬼鬼代购怎样可以放鬼
- ·口袋妖怪梦的光点3.5风来蛹进化成什么
- ·qq炫舞官方下载缘来今生频道在哪个区
- ·拿ak-s的时候剑灵角色死亡怎么办的手弯着怎么办
