接前文:
双节点RAC系统,添加一个新节点概括
http://bbs.cqsztech.com/forum.ph ... 654&fromuid=482
(出处: 重庆思庄Oracle论坛)
1.对rac1,rac2打好补丁, 查看数据库,已经升级到11.2.0.4.7
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME
--------------- ---------------- -----------------------------------------------
3 ORCL3 rac3
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> select * from dba_registry_history;
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
ACTION_TIME ACTI
--------------------------------------------------------------------------- ----
24-AUG-13 12.03.45.119862 PM APPL
03-DEC-15 08.51.41.048893 AM APPL
04-DEC-15 03.32.47.729909 AM APPL
SQL> set wrap on
SQL> r
1* select * from dba_registry_history
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
24-AUG-13 12.03.45.119862 PM
APPLY SERVER
11.2.0.4 0 PSU
Patchset 11.2.0.2.0
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
03-DEC-15 08.51.41.048893 AM
APPLY SERVER
11.2.0.4 0 PSU
Patchset 11.2.0.2.0
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
04-DEC-15 03.32.47.729909 AM
APPLY SERVER
11.2.0.4 7 PSU
PSU 11.2.0.4.7
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
|