苹果种子首先Betas版本iOS9.3.3，Mac OS X10.11.6和tvOS9.2.2给开发商 - 绿盟文章
&几分钟前，日，苹果开始播种的第一个Beta版iOS的9.3.3，Mac OS X的10.11.6和tvOS 9.2.2发行点向开发者参加了苹果开发者计划。标记为建立13G12适用于iOS 9.3.3 Beta 1中，15G7a用于Mac OS X 10.11.6和13Y807为tvOS 9.2.2 Beta 1中，这些bug修复版本现在生活，并通过您的苹果开发者帐户访问，通过内置安装在上注册的iPhone，iPad，iPod touch和tvOS设备或Mac App Store的用于苹果机软件更新。我们不得不承认，我们正在等待苹果推下一个主要的iOS和OS X操作系统，iOS的10和Mac OS的第一个Beta版本点&x10.12，特别是自WWDC（全球开发者大会）2016年活动即将开始从写这篇文章的那一刻起三个星期。WWDC总是关于揭开下一代技术，从苹果公司的最新创新，但还是有希望的，我们认为公司Cupertino的秘密是工作在其移动设备和电脑操作系统更令人兴奋的突破更新。公共Beta版本即将推出公共Beta版了iOS9.3.3，Mac OS X10.11.6和tvOS9.2.2操作系统，应该是下一个小时内可用，所以请确保您收藏此文章，如果你想成为第一个知道什么时候出。我们注意到一件事，不过，是的iOS9.3.3 Beta 1版本尚不可用9.7英寸的iPad Pro中。当然，这只能意味着苹果并没有固定通过安装在上周发布了iOS9.3.2更新后的用户报告的“错误56”的问题。苹果拉到了9.7英寸的iPad Pro器件了iOS9.3.2更新，尚未发布了新的版本来解决这个问题。&
文章来自绿盟(xDowns.com)转载请注明来路。
上一篇文章：iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,3
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
iPhone10,6
该固件为测试版本
建议专业玩家下载该固件oracle_升级9.2.0.8到11.2.0.3RAC(单机到集群升级)
& 这里试验是关于oracle 从9.2.0.8 单机到11.2.0.3
rac的升级过程。&
其实是整理了文档， &有图，这里不好上传，就只贴文字部分。文档见下面云盘。
安装linux oracle
http://download.oracle.com &下载oracle linux
4.7 因为4.7是既可以兼容oracle 9i也可以兼容11g.
安装OS的时候，把develop开发部分的系统包，全都选择上，因为linux 4.的YUM不好配置。
上传9.2.0.4 dis1, dis2,disk3文件，分别解压到不同目录。
http://pan.baidu.com/disk/home#path=/oracle/9Ifor linuc
设置环境变量LD_ASSUME_KERNEL=2.4.9 (不然会报错找不到低版本.so文件)
在disk1中执行./runInstaller
1. OUI will hang at 17% when “copying naeet.o”, this can be
solved by setting environment variable LD_ASSUME_KERNEL to 2.4.19
for oracle user.
2. OUI will prompts error “Error in invoking target
install_isqlplus of makefile
/oracle/opt/oracle/product/9.2.0/db_1/sqlplus/lib/ins_sqlplus.mk”,
this can be solved by link “gcc” and “g++” to lower version:
ln -s /usr/bin/gcc32 /usr/bin/gcc
下载gcc .3.2.2.tar
http://download.chinaunix.net/download/.shtml
Unzip gcc.tar
./configure --prefix=/usr/bin/gcc-3.2.2
--enable-language=c,c++,java
make install
mv /usr/bin/gcc /usr/bin/gcc.bak
[root@ora9 gcc-3.2.2]# ls -l /usr/bin/gcc*
lrwxrwxrwx &1 root root &
& 14 Feb 11 03:25 /usr/bin/gcc -&
/usr/bin/gcc32
-rwxr-xr-x &2 root root
&94360 Oct 10 &2006
/usr/bin/gcc32
-rwxr-xr-x &2 root root 221128 Jun
&3 &2008 /usr/bin/gcc4
-rwxr-xr-x &2 root root 105312 Jun 13
&2008 /usr/bin/gcc.bak
[root@ora9 gcc-3.2.2]#ln -s /usr/bin/gcc32
&/usr/bin/gcc
LN完成后，点击错误提出retry按钮，可以安全通过。
升级到9.2.0.8
&这里就是下一步，下一步，再运行脚本就可以。
单机9.2.0.8升级到11.2.0.3单机
在9i环境下执行脚本utlu112i.sql (如果是11g环境下执行会报ORA-04023: Object
SYS.STANDARD could not be validated or authorized,切记在9i下执行)
@/u01/app/oracle/product/11.2.0/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 02-14-2015
14:26:40 & & &
Script Version: 11.2.0.3.0 Build: 001 &
**********************************************************************
Database: & &
**********************************************************************
--& name: & &
& & &ORACOM
--& version: & &
& 9.2.0.8.0 & &
--& compatible: &
&9.2.0.0.0 & &
--& blocksize: & & 8192
--& timezone file: V1 & &
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
--& The existing log files are adequate. No changes are
required. & & &
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
WARNING: --& SYSTEM tablespace is not large enough for the
upgrade. & & &
.... currently allocated size: 250 MB &
.... minimum required size: 323 MB &
.... increase current size by: 73 MB &
.... tablespace is NOT AUTOEXTEND ENABLED. &
--& UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB &
--& TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB &
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or
spfile] & & &
Note: Pre-upgrade tool was run on a lower version 64-bit
database. & & &
**********************************************************************
--& If Target Oracle is 32-Bit, refer here for Update
Parameters: & &
WARNING: --& "compatible" must be set to at least 10.1.0
WARNING: --& "shared_pool_size" needs to be increased to at
least 252 MB & &
WARNING: --& "db_cache_size" needs to be increased to at
--& If Target Oracle is 64-Bit, refer here for Update
Parameters: & &
WARNING: --& "compatible" must be set to at least 10.1.0
WARNING: --& "shared_pool_size" needs to be increased to at
least 488 MB & &
WARNING: --& "db_cache_size" needs to be increased to at
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or
spfile] & & &
**********************************************************************
-- No renamed parameters found. No changes are required.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2
init.ora or spfile] & &
**********************************************************************
--& hash_join_enabled & &
& OBSOLETE & &
--& background_dump_dest &
& & & 11.1
& & & DEPRECATED
& replaced by
&"diagnostic_dest"
--& user_dump_dest & &
& & 11.1 &
& & DEPRECATED &
replaced by &"diagnostic_dest"
**********************************************************************
Components: [The following database components will be
upgraded or installed] & &
**********************************************************************
--& Oracle Catalog Views &
& & & [upgrade]
&VALID & &
--& Oracle Packages and Types &
&[upgrade] &VALID
--& Oracle Workspace Manager &
& [upgrade] &VALID
**********************************************************************
Miscellaneous Warnings & &
**********************************************************************
WARNING: --& Deprecated CONNECT role granted to some
user/roles. & &
.... CONNECT role after upgrade has only CREATE SESSION
privilege. & & &
WARNING: --& Database is using a timezone file older than
version 14. & &
.... After the release migration, it is recommended that
DBMS_DST package & &
.... be used to upgrade the 9.2.0.8.0 database timezone
version & & &
.... to the latest version which comes with the new release.
**********************************************************************
Recommendations & &
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database. & &
To gather dictionary statistics execute the following commands
while connected as SYSDBA: &
& & EXECUTE
dbms_stats.gather_schema_stats('DBSNMP',options=&'GATHER'
&,estimate_percent=&DBMS_STATS.AUTO_SAMPLE_SIZE
&,method_opt=&'FOR ALL COLUMNS SIZE AUTO'
&,cascade=&TRUE); &
& & EXECUTE
dbms_stats.gather_schema_stats('OUTLN',options=&'GATHER'
&,estimate_percent=&DBMS_STATS.AUTO_SAMPLE_SIZE
&,method_opt=&'FOR ALL COLUMNS SIZE AUTO'
&,cascade=&TRUE); &
& & EXECUTE
dbms_stats.gather_schema_stats('WMSYS',options=&'GATHER'
&,estimate_percent=&DBMS_STATS.AUTO_SAMPLE_SIZE
&,method_opt=&'FOR ALL COLUMNS SIZE AUTO'
&,cascade=&TRUE); &
& & EXECUTE
dbms_stats.gather_schema_stats('SYSTEM',options=&'GATHER'
&,estimate_percent=&DBMS_STATS.AUTO_SAMPLE_SIZE
&,method_opt=&'FOR ALL COLUMNS SIZE AUTO'
&,cascade=&TRUE); &
& & EXECUTE
dbms_stats.gather_schema_stats('SYS',options=&'GATHER'
&,estimate_percent=&DBMS_STATS.AUTO_SAMPLE_SIZE
&,method_opt=&'FOR ALL COLUMNS SIZE AUTO'
&,cascade=&TRUE); &
**********************************************************************
Oracle recommends reviewing any defined events prior to
upgrading. & & &
To view existing non-default events execute the following
commands & & &
while connected AS SYSDBA: &
& Events: &
& & SELECT
(translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
& & & WHERE
&UPPER(name) ='EVENT' AND
&isdefault='FALSE' &
& Trace Events: &
& & SELECT
(translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
& & & WHERE
UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
**********************************************************************
SYSAUX Tablespace: & &
[Create tablespace in the Oracle Database 11.2 environment]
**********************************************************************
--& New "SYSAUX" tablespace &
.... minimum required size for database upgrade: 500 MB
按照检查结果一一修复检查内容，并确保SYSAUX空间足够大，最好5G以上。
按顺序执行下面脚本
@?/9/rdbms/admin/utlu112i.sql &
& --升级检查
&@?/9/rdbms/admin/catpatch.sql
& & -- Script to apply CATalog
PATCH set to a database & &
&@?/11/rdbms/admin/catupgrd.sql
& &-- 升级脚本
&@?/11/rdbms/admin/utlu112s.sql
& &--查看升级后状态
&@?/11/rdbms/admin/catuppst.sql
& &-- CATalog UPgrade
PoST-upgrade actions, Automatically apply the latest PSU.
@?/11/rdbms/admin/utlrp.sql
对TIMEZONE处理
&SQL&Execute
DBMS_DST.BEGIN_UPGRADE(14,true);&
&SQL& select count(*) from
sys.dst$error_&
&select count(*) & from
sys.dst$trigger_ & &
&SQL& VAR numfail number
SQL& BEGIN
&DBMS_DST.UPGRADE_DATABASE(:numfail,
& & & parallel
& & & log_errors
& &=& TRUE,
log_errors_table & &
'SYS.DST$ERROR_TABLE',
log_triggers_table & &
'SYS.DST$TRIGGER_TABLE',
error_on_overlap_time & & =&
error_on_nonexisting_time =& TRUE);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
PL/SQL procedure successfully completed.
SQL& BEGIN
&DBMS_DST.END_UPGRADE(:numfail);
检查升级后TZ版本，primary表示新版本，second表示旧版本
SELECT NAME,VALUE$ FROM PROPS$ WHERE
NAME='DST_PRIMARY_TT_VERSION';
安装新环境10.2.0.4rac
并升级到11.2.0.3rac
Minimum version of the database that can be directly upgraded
to Oracle 11g Release 2 (11.2)
Source Database Target Database
9.2.0.8 or higher 11.2.x
10.1.0.5 or higher 11.2.x
10.2.0.2 or higher 11.2.x
11.1.0.6 or higher 11.2.x
The following database versions will require an indirect
upgrade path:&
Source Database Upgrade Path for Target Database
Target Database
7.3.3 (or lower) ----& 7.3.4 -& 9.2.0.8
&----& 11.2.x
8.0.5 (or lower) ----& 8.0.6 -& 9.2.0.8 ----&
8.1.7 (or lower) ----& 8.1.7.4 -& 10.2.0.2(or any higher
10GR2 version) ----& 11.2.x
9.0.1.3 (or lower) ----& 9.0.1.4 -& 10.2.0.2 (or any
higher 10GR2 version) ----& 11.2.x
9.2.0.7(or lower) ----& 9.2.0.8 ----& 11.2.x
本指南分为以下步骤：
1 准备检查安装
2 升级 Oracle 集群件
3 安装 Oracle 数据库 11g 第 2 版软件
4 升级 Oracle 数据库
Oracle RAC 10g 环境概述：
主机名 实例名 数据库名 集群件文件存储
crs1 sun1 sun Raw
crs2 sun2 sun Raw
主机名 11.2.0.4 集群件主目录 Oracle 主目录
crs1 /u01/app/oracle/product/10.2.0/db_1
/u01/app/oracle/product/10.2.0/crs_1
crs2 /u01/app/oracle/product/10.2.0/db_1
/u01/app/oracle/product/10.2.0/crs_1
Oracle 集群件文件 设备名
Oracle Cluster Registry /dev/raw/raw1
Voting Disk /dev/raw/raw2
Oracle RAC 11g 环境概述：
主机名 实例名 数据库名 集群件文件存储
crs1 sun1 sun Raw
crs2 sun2 sun Raw
主机名 11.2.0.3集群件主目录 Oracle 主目录
crs1 /u01/11.2.0/grid /u01/oracle/product/11.2.0/db_1
crs2 /u01/11.2.0/grid /u01/oracle/product/11.2.0/db_1
Oracle 集群件文件 设备名
Oracle Cluster Registry /dev/raw/raw1
Voting Disk /dev/raw/raw2
将在每个节点的 Oracle 集群件主目录、Oracle ASM 主目录和 Oracle
主目录中安装软件，以实现冗余和更高的可用性。
公共IP 11.11.11.20 &crs1
11.11.11.21 &crs2
虚拟IP 11.11.11.22 &crs1-vip
11.11.11.23 &crs2-vip
私有IP 192.168.1.20 crs1-priv
192.168.1.21 crs2-priv
SCAN IP 11.11.11.25 crs-scan
备份DB/CRS信息
备份CRS_HOME, ORACLE_HOME
备份/etc/dbhome, oraInst.loc ,oratab &
/etc/oracle目录
备份orainventory &/etc/orainventory
备份/etc/init.d/init.crs /etc/init.d/init/init.crsd
&/etc/init.d/init.css
&/etc/init.d/init.evmd
orachk进行升级检查 (ID )
[oracle@crs1 orachk]$ ./orachk -u -o pre
Enter upgrade target version (valid versions are 11.2.0.3.0,
11.2.0.4.0, 12.1.0.1.0, 12.1.0.2.0):- 11.2.0.3.0
This computer is for [S]ingle instance database or part of a
[C]luster to run RAC database [S|C] [C]:C
Unable to determine nodes in cluster. &Do you
want to enter manually.[y/n][y]
Enter cluster node names delimited by comma.by default
localhost will be printed (eg. node2,node3,node4)
Checking ssh user equivalency settings on all nodes in
Node crs2 is configured for ssh user equivalency for oracle
Space available on crs1 at /home/oracle/orachk is 6988 KB and
required space is 102400 KB
Space available on crs1 at /home/oracle is 6988 KB and
required space is 20480 KB
Please make at least 10MB space available at above location
and retry to continue.[y/n][y]?
CRS binaries found at /u01/app/oracle/product/10.2.0/crs_1. Do
you want to set CRS_HOME to
/u01/app/oracle/product/10.2.0/crs_1?[y/n][y]y
Checking Status of Oracle Software Stack - Clusterware, ASM,
. . . . . . . . . . . . . . . .&
-------------------------------------------------------------------------------------------------------
&Oracle Stack Status &
-------------------------------------------------------------------------------------------------------
Host Name &CRS Installed
&ASM HOME & &
& RDBMS Installed &CRS UP
& &ASM UP &
&RDBMS UP &DB Instance Name
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------
& &Installed components summary
---------------------------------------------------------------------------------------------------------------------------------
GI_HOME & &
& & &ORACLE_HOME
&Database Names &
---------------------------------------------------------------------------------------------------------------------------------
Copying plug-ins
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . .&
. . . . . .&
Checking Grid Infrastructure and RDBMS upgrade readiness to
version 112030
Collections and audit checks log file
/home/oracle/orachk/orachk_crs1_041/log/orachk.log
Checking for prompts in /home/oracle/.bash_profile on crs1 for
oracle user...
Checking for prompts in /home/oracle/.bash_profile on crs2 for
oracle user...
Starting to run orachk in background on crs2
=============================================================
& Node name - crs1 &
=============================================================
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - OS Packages
Collecting - OS version
Collecting - Patches for Grid
Infrastructure&
Collecting - Patches for RDBMS Home&
Collecting - number of semaphore operations per semop system
Data collections completed. Checking best practices on
--------------------------------------------------------------------------------------
&INFO =& &
&Real World Network Bandwidth Guidelines
&INFO =& &
&Important Automatic Storage Management (ASM)
Notes and Technical White Papers
&INFO =& &
&Unattended Installation and Configuration
&INFO =& &
&Be aware of provided optional integrity
&INFO =& &
&Patching Notes by Release
&WARNING =& net.core.wmem_max Is NOT
Configured According to Recommendation
&WARNING =& net.core.rmem_max Is NOT
Configured According to Recommendation
&WARNING =& The number of async IO
descriptors is too low (/proc/sys/fs/aio-max-nr)
&INFO =& &
&See Detailed Report for Information about
Database Links Whenever Planning an Upgrade
&WARNING =& TNS_ADMIN environment variable
&WARNING =& ORACLE_HOME environment
variable is set
&FAIL =& &
&Pre-requisite Oracle Patch .2.0.5.2
CRS PSU) is not applied on CRS_HOME
/u01/app/oracle/product/10.2.0/crs_1
&FAIL =& &
&CRS and ASM Software owners are NOT the
&INFO =& &
&Minimizing Planned Downtime for Upgrades and
&INFO =& &
&Upgrade Related References
&INFO =& &
&Lifetime Support Policy and Product Certification
&INFO =& &
&Capture performance baseline, backup important
configuration files and batch, cron, DBMS_JOBS and DBMS_SCHEDULER
&INFO =& &
&During Upgrade Maintain Same GI Software
Ownership as CRS Prior to Upgrade
&INFO =& &
&Oracle 10g Client Connecting To Oracle 11g
Database Gets ORA-01017 invalid username/password
&INFO =& &
&Be Aware of New Instant Client for Simplified
Deployment
&INFO =& &
&Automatic Diagnostic Repository Helpful
&INFO =& &
&Oracle Software Download Sites
&INFO =& &
&Queries for Monitoring Object Recompilation
Before or After Upgrade
&INFO =& &
&Behavior Changes During/After Upgrade To Be Aware
&INFO =& &
&Execute rootupgrade.sh as the "real" root user,
&WARNING =& Applying 11.2.0.3.5 GI PSU
During Upgrade Before Running rootupgrade.sh Can Cause Upgrade To
&INFO =& &
&Steps to execute rootupgrade.sh
&FAIL =& &
&Oracle patch
is not applied
/u01/app/oracle/product/10.2.0/crs_1
&INFO =& &
&Save "Oracle Enterprise Manager Database Control"
files and data with the emdwgrd Utility before upgrading
&database.
&INFO =& &
&Information about Grid Infrastructure software
installation directory
Copying results from crs2 and generating report. This might
take a while. Be patient.
=============================================================
& Node name - crs2 &
=============================================================
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - OS Packages
Collecting - OS version
Collecting - Patches for Grid
Infrastructure&
Collecting - Patches for RDBMS Home&
Collecting - number of semaphore operations per semop system
Data collections completed. Checking best practices on
--------------------------------------------------------------------------------------
&WARNING =& net.core.wmem_max Is NOT
Configured According to Recommendation
&WARNING =& net.core.rmem_max Is NOT
Configured According to Recommendation
&WARNING =& The number of async IO
descriptors is too low (/proc/sys/fs/aio-max-nr)
&WARNING =& TNS_ADMIN environment variable
&WARNING =& ORACLE_HOME environment
variable is set
&FAIL =& &
&Pre-requisite Oracle Patch .2.0.5.2
CRS PSU) is not applied on CRS_HOME
/u01/app/oracle/product/10.2.0/crs_1
&FAIL =& &
&CRS and ASM Software owners are NOT the
&FAIL =& &
&Oracle patch
is not applied
/u01/app/oracle/product/10.2.0/crs_1
---------------------------------------------------------------------------------
Detailed report (html) -
/home/oracle/orachk/orachk_crs1_041/orachk_crs1_041.html
UPLOAD(if required) -
/home/oracle/orachk/orachk_crs1_041.zip
&以上红色部分都需要修复，详细查看orachk_crs1_041.zip
Complete Checklist for Manual Upgrades to 11gR2 (文档 ID
) &进行升级检查
10.2.0.4的检查&
使用runcluvfy.sh 进行检查
[oracle@crs1 grid]$ ./runcluvfy.sh stage -pre crsinst -n
&crs1,crs2
Preparing to Bootstrap &Please wait
...[oracle@crs1 grid]$ ./runcluvfy.sh stage -pre crsinst -n
&crs1,crs2
Performing pre-checks for cluster services
Checking node reachability...
Node reachability check passed from node "crs1"
Checking user equivalence...
User equivalence check passed for user "oracle"
Version of exectask could not be retrieved from node
No space left on device
Checking node connectivity...
Checking hosts config file...
Verification of the hosts config file successful
Node connectivity passed for subnet "11.11.11.0" with node(s)
PRVF-7617 : Node connectivity between "crs1 : 11.11.11.20" and
"crs2 : 11.11.11.21" failed
TCP connectivity check failed for subnet "11.11.11.0"
Node connectivity passed for subnet "192.168.1.0" with node(s)
PRVF-7617 : Node connectivity between "crs1 : 11.11.11.20" and
"crs2 : 192.168.1.21" failed
TCP connectivity check failed for subnet "192.168.1.0"
Interfaces found on subnet "11.11.11.0" that are likely
candidates for VIP are:
crs2 eth0:11.11.11.21
Interface subnet "11.11.11.0" does not have a gateway
Could not find a suitable set of interfaces for the private
interconnect
Node connectivity check failed
Checking multicast communication...
Checking subnet "11.11.11.0" for multicast communication with
multicast group "230.0.1.0"...
Check of subnet "11.11.11.0" for multicast communication with
multicast group "230.0.1.0" passed.
Checking subnet "192.168.1.0" for multicast communication with
multicast group "230.0.1.0"...
Check of subnet "192.168.1.0" for multicast communication with
multicast group "230.0.1.0" passed.
Check of multicast communication passed.
Checking ASMLib configuration.
Check for ASMLib configuration passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for
"crs2:/u01/app/oracle/product/10.2.0/crs_1"
Free disk space check passed for "crs2:/tmp"
Check for multiple users with UID value 1100
User existence check passed for "oracle"
Group existence check passed for "oinstall"
Group existence check passed for "dba"
Membership check for user "oracle" in group "oinstall" [as
Primary] passed
Membership check for user "oracle" in group "dba" passed
Run level check passed
Hard limits check passed for "maximum open file
descriptors"
Soft limits check passed for "maximum open file
descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check failed for "file-max"
Check failed on nodes:&
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check failed for "rmem_max"
Check failed on nodes:&
Kernel parameter check passed for "wmem_default"
Kernel parameter check failed for "wmem_max"
Check failed on nodes:&
Kernel parameter check failed for "aio-max-nr"
Check failed on nodes:&
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for
"compat-libstdc++-33(x86_64)"
Package existence check passed for
"elfutils-libelf(x86_64)"
PRVF-7584 : Multiple versions of package
"elfutils-libelf-devel" found on node crs2:
elfutils-libelf-devel(x86_64)-0.137-3.el5,elfutils-libelf-devel(i386)-0.137-3.el5
Package existence check passed for
"elfutils-libelf-devel"
Package existence check passed for "glibc-common"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "glibc-headers"
Package existence check passed for "gcc-c++(x86_64)"
Package existence check passed for
"libaio-devel(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for
"libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Check for multiple users with UID value 0
PRVF-5502 : Current group ID check cannot be performed
Current group ID check failed
Starting check for consistency of primary group of root
Check for consistency of root user's primary group
Starting Clock synchronization checks using Network Time
Protocol(NTP)...
NTP Configuration file check started...
NTP Configuration file check passed
No NTP Daemons or Services were found to be running
PRVF-5507 : NTP daemon or service is not running on any node
but NTP configuration file exists on the following node(s):
Clock synchronization check using Network Time Protocol(NTP)
Core file name pattern consistency check passed.
User "oracle" is not part of "root" group. Check passed
Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across
PRVF-5642 : Unable to create the directory
"/tmp/CVU_11.2.0.3.0_oracle/scratch"
File "/etc/resolv.conf" is not consistent across nodes
Time zone consistency check passed
Pre-check for cluster services setup was unsuccessful on all
the nodes.
OR 升级检查
./runcluvfy.sh &stage -pre crsinst -upgrade
-n crs1,crs2 -rolling -src_crshome /oracle/app/product/10.2.0/crs
-dest_crshome &/grid/oracle/app/product/10.2.0/crs
-dest_version 11.2.0.3.0 & &
配置/etc/hosts 11grac使用
[oracle@crs2 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 & &
& localhost.localdomain localhost
localhost6.localdomain6 localhost6
11.11.11.20 &crs1
11.11.11.21 &crs2
11.11.11.22 &crs1-vip
11.11.11.23 &crs2-vip
192.168.1.20 crs1-priv
192.168.1.21 crs2-priv
#########for 11g rac ########
11.11.11.20 &crs1
11.11.11.21 &crs2
11.11.11.22 &crs1-vip
11.11.11.23 &crs2-vip
192.168.1.20 crs1-priv
192.168.1.21 crs2-priv
11.11.11.25 crs-scan
升级clusterware
&上传clusterware介质到oracle目录，解压执行./runInstaller
选择两个节点&
由于没有用grid用户，选择group如下
选择安全的grid目录，区分与10gcrs目录
检查可用性 ，查询可以忽略图中错误
Checklist for PRVF-10037 : Failed to retrieve storage type for
xx on node xx (文档 ID )
INS-20802 PRVF-9802 PRVF-5184 PRVF-5186 After Successful
Upgrade to 11gR2 Grid Infrastructure (文档 ID )
[root@crs1 u01]# sh /u01/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle
The following environment variables are set as:
& & ORACLE_OWNER=
& & ORACLE_HOME=
&/u01/11.2.0/grid
Enter the full pathname of the local bin directory:
[/usr/local/bin]:&
The file "dbhome" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
The file "oraenv" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
[n]: Oracle root script execution aborted!
[root@crs1 u01]# sh /u01/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle
The following environment variables are set as:
& & ORACLE_OWNER=
& & ORACLE_HOME=
&/u01/11.2.0/grid
Enter the full pathname of the local bin directory:
[/usr/local/bin]:&
The file "dbhome" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying dbhome to
/usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying oraenv to
/usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying coraenv to
/usr/local/bin ...
Entries will be added to the /etc/oratab file as needed
Database Configuration Assistant when a database is
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file:
/u01/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
& root wallet
& root wallet cert
& root cert export
& peer wallet
& profile reader wallet
& pa wallet
& peer wallet keys
& pa wallet keys
& peer cert request
& pa cert request
& peer cert
& peer root cert TP
& profile reader root cert TP
& pa root cert TP
& peer pa cert TP
& pa peer cert TP
& profile reader pa cert TP
& profile reader peer cert TP
& peer user cert
& pa user cert
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ...
[root@crs2 u01]# sh /u01/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle
The following environment variables are set as:
& & ORACLE_OWNER=
& & ORACLE_HOME=
&/u01/11.2.0/grid
Enter the full pathname of the local bin directory:
[/usr/local/bin]:&
The file "dbhome" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying dbhome to
/usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying oraenv to
/usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.
&Overwrite it? (y/n)&
& &Copying coraenv to
/usr/local/bin ...
Entries will be added to the /etc/oratab file as needed
Database Configuration Assistant when a database is
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file:
/u01/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Start upgrade invoked..
Started to upgrade the Oracle Clusterware. This operation may
take a few minutes.
Started to upgrade the OCR.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Oracle Clusterware operating version was successfully set to
11.2.0.3.0
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ...
安装11g database 软件
./runInstaller
[root@crs1 bdump]# sh
/u01/oracle/product/11.2.0/dbhome_1/root.sh
Performing root user operation for Oracle
The following environment variables are set as:
& & ORACLE_OWNER=
& & ORACLE_HOME=
&/u01/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory:
[/usr/local/bin]:&
The contents of "dbhome" have not changed. No need to
overwrite.
The contents of "oraenv" have not changed. No need to
overwrite.
The contents of "coraenv" have not changed. No need to
overwrite.
Entries will be added to the /etc/oratab file as needed
Database Configuration Assistant when a database is
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@crs2 bdump]# sh
/u01/oracle/product/11.2.0/dbhome_1/root.sh
Performing root user operation for Oracle
The following environment variables are set as:
& & ORACLE_OWNER=
& & ORACLE_HOME=
&/u01/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory:
[/usr/local/bin]:&
The contents of "dbhome" have not changed. No need to
overwrite.
The contents of "oraenv" have not changed. No need to
overwrite.
The contents of "coraenv" have not changed. No need to
overwrite.
Entries will be added to the /etc/oratab file as needed
Database Configuration Assistant when a database is
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
升级单机数据库11.2.0.3到11.2.0.3 rac数据库。
将升级的11.2.0.3 数据库的存储挂载到新升级的rac环境中。
将单机数据库转换成rac库
& & & SQL&
@?/rdbms/admin/catclust.sql
SQL&@?/rdbms/admin/utlrp.sql
修改参数文件
&*.COMPATIBLE='11.2.0.0'
&*.control_files='/dev/raw/raw1000','/dev/raw/raw1100'
&*.core_dump_dest='/u01/app/oracle/diag/oracom/cdump'
&*.db_block_size=8192
&*.sga_max_size=900M
&*.db_cache_size=
&*.db_domain=''
&*.db_file_multiblock_read_count=16
&*.db_name='oracom'
&*.diagnostic_dest='/u01/app/oracle/'
&*.fast_start_mttr_target=300
&*.java_pool_size=0
&*.large_pool_size=2388608
&*.open_cursors=300
&*.pga_aggregate_target=100M
&*.processes=250
&*.query_rewrite_enabled='FALSE'
&*.remote_login_passwordfile='EXCLUSIVE'
&*.shared_pool_size=
&*.star_transformation_enabled='FALSE'
&*.timed_statistics=TRUE
&*.undo_management='AUTO'
&*.undo_retention=10800
&oracom1.undo_tablespace='UNDOTBS'
&oracom2.undo_tablespace='UNDOTBS2'
&oracom1.thread=1
&oracom2.thread=2
&oracom1.instance_name=oracom1
&oracom2.instance_name=oracom2
&oracom1.instance_number=1
&oracom2.instance_number=2
&*.cluster_database=true
&*.cluster_database_instances = 2
& &添加日志文件组
& & & alter
& & add logfile thread 2
& & group 3 '/dev/raw/raw900'
& & group 4 '/dev/raw/raw1500'
& & & alter
database enable public thread 2;
& & 添加undotbs表空间
& & & CREATE
UNDO TABLESPACE UNDOTBS2 DATAFILE '/dev/raw/raw500' SIZE 100M
&将数据库对象添加到CRS资源。
& & & srvctl add
database -d oracom -o
&$ORACLE_HOME&
& & & srvctl add
instance -d oracom -i oracom1 -n crs1
& & & srvctl add
instance -d oracom -i oracom2 -n crs2
& & 　验证CRS资源状态
& & $GI_HOME/bin/crsctl stat res
[root@crs1 rules.d]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME & & &
& & TARGET
&STATE & &
& &SERVER &
& & STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
&ONLINE & &
& crs1 & &
&ONLINE & &
& crs2 & &
& &OFFLINE OFFLINE
& &OFFLINE OFFLINE
& &OFFLINE OFFLINE
& &OFFLINE OFFLINE
ora.net1.network
&ONLINE & &
& crs1 & &
&ONLINE & &
& crs2 & &
&ONLINE & &
& crs1 & &
&ONLINE & &
& crs2 & &
ora.registry.acfs
& &OFFLINE OFFLINE
& &OFFLINE OFFLINE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
&ONLINE &ONLINE
& & & crs1
ora.crs1.vip
&ONLINE &ONLINE
& & & crs1
ora.crs2.vip
&ONLINE &ONLINE
& & & crs2
&ONLINE &ONLINE
& & & crs1
&ONLINE &ONLINE
& & & crs1
ora.oracom.db
&ONLINE &ONLINE
& & & crs1
& Open & &
&ONLINE &ONLINE
& & & crs2
& Open & &
ora.scan1.vip
&ONLINE &ONLINE
& & & crs1
至此升级完成。
百度云盘文档：
http://pan.baidu.com/s/1hqqxCjU
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。