Oracle 11.2.0.3.0 RAC GI_DB upgrade to 11.2.0.4.0
Preface
Still we often say that sentence: the production environment must remember to backup~~~
The following environment, is my test environment, there is no backup~
Upgrade Grid Infrastructure 1
1.1 upgrade preparation
1.1.1 software for
This of course needless to say: download, upload to server, decompression
The new HOME 1.1.2 new GI
mkdir -p /u01/app/11.2.0.4/grid
chown -R grid:oinstall /u01/app/11.2.0.4
chmod -R 775 /u01/app/11.2.0.4
The name 1.1.3 two Node
[root@RAC01 ~]# cat /etc/hosts
# Do not remove the following line, or variousprograms
# that require network functionality willfail.
127.0.0.1 localhostlocalhost.localdomain localhost
::1 localhost6.localdomain6localhost6
#Eth0 Public
10.0.0.240 RAC01
10.0.0.242 RAC02
#Virtual IP
10.0.0.241 RAC01-VIP
10.0.0.243 RAC02-VIP
#Eth1 Private
172.30.1.1 RAC01-PRIV
172.30.1.2 RAC02-PRIV
#Scan
10.0.0.244 RACSCAN
1.1.4 upgrade before CUV examination (recommended)
[root@RAC01 app]# su - grid
[grid@RAC01 ~]$ /software/grid/runcluvfy.sh stage -pre crsinst-upgrade -n rac01,rac02 -rolling -src_crshome /u01/app/11.2.0/grid-dest_crshome /u01/app/11.2.0.4/grid -dest_version 11.2.0.4.0
If you check out the error, please according to the prompt repair.
1.2 upgrade
To ensure the normal operation of all nodes of the GI
[grid@RAC01 ~]# su – grid
[grid@RAC01 ~]$ unset ORACLE_HOME
[grid@RAC01 ~]$ unset ORACLE_BASE
[grid@RAC01 ~]$ unset ORACLE_SID
[grid@Oracle-LAB ~]$ cd /software/grid/
[grid@Oracle-LAB grid]$ ./runInstaller
Note: if the error occurred in the above step on the point of "Next":
The first: the first on two NODE test SSH, such as:
[grid@rac01 ~]$ sshrac02 date
Fri Jan 10 17:34:55 CST 2014
Second: if the above can not be SSH, input the GRID account password in "SSH Connectivity" in the first, then test, if the SETUP is successful, but TEST still reported the error, it may be because the Node Name case cause, need to execute the following command, the command format is as follows:
$ /oui/bin/runInstaller -updateNodelistORACLE_HOME= "CLUSTER_NODES={racnode1,racnode2}" CRS=true
An example:
[grid@rac01 grid]$ cd /u01/app/11.2.0/grid/oui/bin/
[grid@rac01 bin]$ ./runInstaller -updateNodelistORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES=rac01,rac02" CRS=true
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500MB. Actual 5633 MB Passed
The inventory pointer is located at/etc/oraInst.loc
The inventory is located at/u01/app/oraInventory
'UpdateNodeList' was successful.
Implementation of the above command, re execution[grid@Oracle-LAB grid]$ ./runInstaller
You'll find out Node Name from uppercase to lowercase, and "Next" can be a. 
According to the above instructions respectively in RAC01, RAC02:
[root@rac01 ~]#/u01/app/11.2.0.4/grid/rootupgrade.sh
[root@rac02 ~]#/u01/app/11.2.0.4/grid/rootupgrade.sh
After the completion of operation in the current GRID account: crsctlquery has softwareversion to view the current version information.
[grid@Oracle-LAB grid]$ crsctl query hassoftwareversion
Oracle High Availability Services version onthe local node is [11.2.0.4.0]
When the following error, as long as the PING SCAN IP can be ignored. 
1.1 modified Grid account under the ORACLE_HOME value
[root@rac01/]# gedit /home/grid/.bash_profile
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/11.2.0.4/grid
PATH=$PATH:$ORACLE_HOME/bin
export PATH ORACLE_SID ORACLE_BASE ORACLE_HOME
[root@rac02/]# gedit /home/grid/.bash_profile
ORACLE_SID=+ASM2
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/11.2.0.4/grid
PATH=$PATH:$ORACLE_HOME/bin
export PATH ORACLE_SID ORACLE_BASE ORACLE_HOME
1.2 restart Oracle
[root@rac01 /]# cd/u01/app/11.2.0.4/grid/bin
[root@rac01 bin]# ./crsctlstop cluster –all
[root@rac01 bin]# ./crsctlstart cluster -all
Reboot check version:
[root@rac01 bin]# ./crsctlquery crs activeversion
Oracle Clusterware active version on thecluster is [11.2.0.4.0]
2 upgrade database software
2.1 upgrade preparation
2.1.1 software for
This of course needless to say: download, upload to server, decompression
Note: to emphasize again: please backup the production environment before upgrading！！
The new HOME 2.1.2 RAC respectively on all nodes in the new DB software
mkdir -p/u01/app/oracle/product/11.2.0.4/dbhome_1
chown -R oracle:oinstall/u01/app/oracle/product/11.2.0.4
chmod -R 775 /u01/app/oracle/product/11.2.0.4
2.1.3 check the Oracle software version
[oracle@Oracle-LAB ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on MonJan 6 13:08:12 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic StorageManagement, OLAP, Data Mining
and Real Application Testing options
2.1.4 backup database
No details.
2.2 upgrade
[oracle@rac01 ~]$ unset ORACLE_BASE
[oracle@ rac01 ~]$ unset ORACLE_HOME
[oracle@ rac01 ~]$ unset ORACLE_SID
[oracle@ rac01 ~]$ cd /software/database/
The following error can be ignored, this is mainly because in DNS does not correspond to Node records, will not affect the application and operation of database software.
[root@rac01 /]# /u01/app/oracle/product/11.2.0.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are setas:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.4/dbhome_1
Enter the full pathname of the local bindirectory: [/usr/local/bin]:
The contents of "dbhome" have notchanged. No need to overwrite.
The contents of "oraenv" have notchanged. No need to overwrite.
The contents of "coraenv" have notchanged. No need to overwrite.
Entries will be added to the /etc/oratab fileas needed by
Database Configuration Assistant when adatabase is created
Finished running generic part of root script.
Now product-specific root actions will beperformed.
Finished product-specific root actions.
[root@rac02 /]#/u01/app/oracle/product/11.2.0.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are setas:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.4/dbhome_1
Enter the full pathname of the local bindirectory: [/usr/local/bin]:
The contents of "dbhome" have notchanged. No need to overwrite.
The contents of "oraenv" have notchanged. No need to overwrite.
The contents of "coraenv" have notchanged. No need to overwrite.
Entries will be added to the /etc/oratab fileas needed by
Database Configuration Assistant when adatabase is created
Finished running generic part of root script.
Now product-specific root actions will beperformed.
Finished product-specific root actions.
After running this script, you can next, and then finish the installation.
3 upgrade database
The previous 3.1 upgrade
To upgrade before the inspection of the implementation of utlu112i.sql in a new directory:
[root@Oracle-LAB~]# su - oracle
[oracle@Oracle-LAB~]$ /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 6 13:33:40 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bitProduction
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> @/u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 01-06-2014 13:34:41
Oracle Database 11.2 Pre-Upgrade Information Tool 01-13-2014 16:02:16
Script Version: 11.2.0.4.0 Build: 001
.**********************************************************************
Database:
**********************************************************************
--> name: RACORCL
--> version: 11.2.0.3.0
--> compatible: 11.2.0.0.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V14
.**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 938 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 829 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 310 MB
.**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
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:
-- No update parameter changes are required.
.--> If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.**********************************************************************
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 orspfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.**********************************************************************
Components: [The following database components will be upgraded orinstalled]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> The "cluster_database" parameter is currently"TRUE"
.... and must be set to "FALSE" prior to running a manualupgrade.
WARNING: --> Your recycle bin is turned on and currently contains noobjects.
.... Because it is REQUIRED that the recycle bin be empty prior toupgrading
.... and your recycle bin is turned on, you may need to execute thecommand:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
WARNING: --> Database contains schemas with objects dependent onDBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure NetworkACLs.
.... USER APEX_030200 has dependent objects.
.**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTEdbms_stats.gather_dictionary_stats;
**********************************************************************
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.
**********************************************************************
3.2 run DBUA to upgrade the database
To Oracle user, enter a new directory to run DBUA.
[root@rac01/]# su - oracle
[root@Oracle-LAB~]$ cd /u01/app/oracle/product/11.2.0.4/dbhome_1/bin
[oracle@Oracle-LABbin]$ ./dbua
3.3 modified Oracle account ORACLE_HOME
[root@rac01/]# gedit /home/oracle/.bash_profile
ORACLE_SID=RACORCL1 #The second node is ORCL2
ORACLE_UNQNAME=RACORCL #If not specified, EM does not come
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin
export PATH ORACLE_SID ORACLE_BASE ORACLE_HOMEORACLE_UNQNAME
[root@rac02 /]# gedit/home/oracle/.bash_profile
ORACLE_SID=ORCL2 #The second node is ORCL2
ORACLE_UNQNAME=RACORCL #If not specified, EM does not come
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin
export PATH ORACLE_SID ORACLE_BASE ORACLE_HOMEORACLE_UNQNAME
Restart the database service:
[root@rac02 /]# /u01/app/11.2.0.4/grid/bin/crsctl stop cluster-all
[root@rac02 /]# /u01/app/11.2.0.4/grid/bin/crsctl start cluster-all
No comments:
Post a Comment