Shulou(Shulou.com)06/01 Report--

Upgrade the oracle rac environment, oracle used to be version 10.2.0.1, now version 10.2.0.5. First, you must install oracle cluster cluster software, and then download oracle 10.2.0.5 software package to patch.

Oracle cluster installation address: http://tongcheng.blog.51cto.com/6214144/1872157

Oracle database installation address: http://tongcheng.blog.51cto.com/6214144/1872157

Oracle 10.2.0.5 download address: http://aru-llnw-dl.oracle.com/aaruna03/vol/patch36/PLATFORM/CORE/Linux-x86-64/R80102050/p8202632_10205_Linux-x86-64.zip?params=UlZPbFZSMlBFVVVyRWt1dldva3hjUTphcnU9MTI1NDA4MjQmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwMzAxODQzJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTI0OTg1Nzg2NiZjb250ZXh0PUFAMTArSEBhYXJ1MjAzLm9yYWNsZS5jb20rUEA%40&e=1292124852&h=3e16aa21f55a3b257d06fc462b94eeeb

1. Check the current crs version (take a look at both nodes)

[oracle@rac10g01 ~] $crsctl query crs softwareversion

CRS software version on node [rac10g01] is [10.2.0.1.0]

[oracle@rac10g01 ~] $crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.1.0]

[oracle@rac10g01 ~] $

two。 Install the upgrade package

[oracle@rac10g01 ~] $unzip p8202632_10205_Linux-x86-64.zip

[oracle@rac10g01 ~] $cd Disk1/

[oracle@rac10g01 Disk1] $ll

Total 188

Drwxr-xr-x 4 oracle oinstall 4096 Apr 29 2010 install

-rwxr-xr-x 1 oracle oinstall 171131 Apr 29 2010 patch_note.htm

Drwxr-xr-x 2 oracle oinstall 4096 Apr 29 2010 response

-rwxr-xr-x 1 oracle oinstall 3927 Apr 29 2010 runInstaller

Drwxr-xr-x 11 oracle oinstall 4096 Apr 29 2010 stage

[oracle@rac10g01 Disk1] $. / runInstaller

Shut down the crs service on both nodes, and then execute the root102.sh script

Rac10g01 node:

[root@rac10g01 ~] # / u01/oracle/product/10.2.0.1/crs_1/bin/crsctl stop crs

Stopping resources.

Error while stopping resources. Possible cause: CRSD is down.

Stopping CSSD.

Unable to communicate with the CSS daemon.

[root@rac10g01 ~] # sh / u01/oracle/product/10.2.0.1/crs_1/install/root102.sh

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to / u01/oracle/product/10.2.0.1/crs_1

Relinking some shared libraries.

Relinking of patched files is complete.

WARNING: directory'/ u01Accord is not owned by root 10.2.0.1'

WARNING: directory'/ u01max oracleUniverse product'is not owned by root

WARNING: directory'/ u01 bind oracle'is not owned by root

WARNING: directory'/ u01' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/ etc/profile: line 61: ulimit: open files: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

This may take a while on some systems.

.

10205 patch successfully applied.

Clscfg: EXISTING configuration version 3 detected.

Clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

Node:

Node 1: rac10g01 rac10g01-priv rac10g01

Creating OCR keys for user 'root', privgrp' root'..

Operation successful.

Clscfg-upgrade completed successfully

Creating'/ u01qoracleUniverse produce with data used for CRS conf iguration 10.2.0.1According to CRASTRAN1According to install _

Setting CRS configuration values in / u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs

[root@rac10g01 ~] #

Rac10g02 node:

[root@rac10g02 ~] # / u01/oracle/product/10.2.0.1/crs_1/bin/crsctl stop crs

Stopping resources.

Error while stopping resources. Possible cause: CRSD is down.

Stopping CSSD.

Unable to communicate with the CSS daemon.

[root@rac10g02 ~] # sh / u01/oracle/product/10.2.0.1/crs_1/install/root102.sh

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to / u01/oracle/product/10.2.0.1/crs_1

Relinking some shared libraries.

Relinking of patched files is complete.

WARNING: directory'/ u01Accord is not owned by root 10.2.0.1'

WARNING: directory'/ u01max oracleUniverse product'is not owned by root

WARNING: directory'/ u01 bind oracle'is not owned by root

WARNING: directory'/ u01' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/ etc/profile: line 61: ulimit: open files: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

This may take a while on some systems.

.

10205 patch successfully applied.

Clscfg: EXISTING configuration version 3 detected.

Clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

Node:

Node 2: rac10g02 rac10g02-priv rac10g02

Creating OCR keys for user 'root', privgrp' root'..

Operation successful.

Clscfg-upgrade completed successfully

Creating'/ u01qoracleUniverse produce with data used for CRS configuration 10.2.0.1According to CRASTRAN1According to install _

Setting CRS configuration values in / u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs

[root@rac10g02 ~] #

Exit after the execution of the script

3. Verify the version of crs

[oracle@rac10g01 ~] $crsctl query crs softwareversion

CRS software version on node [rac10g01] is [10.2.0.5.0]

[oracle@rac10g01 ~] $crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.5.0]

[oracle@rac10g01 ~] $

4. Verify the status of each crs service

[oracle@rac10g01] $crs_stat-t

Name Type Target State Host

Ora....g01.gsd application ONLINE ONLINE rac10g01

Ora....g01.ons application ONLINE ONLINE rac10g01

Ora....g01.vip application ONLINE ONLINE rac10g01

Ora....g02.gsd application ONLINE ONLINE rac10g02

Ora....g02.ons application ONLINE ONLINE rac10g02

Ora....g02.vip application ONLINE ONLINE rac10g02

[oracle@rac10g01 ~] $

5. Check the version information of oracle database

[oracle@rac10g02 ~] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0-Production on Tue Nov 15 17:42:35 2016

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL > exit

Disconnected

[oracle@rac10g02 ~] $

6. Upgrade oracle database software

The current oracle database is 10.2.0.1, download the 10.2.0.5 patch pack to upgrade. The premise is to install version 10.2.0.1 first.

[oracle@rac10g01 ~] $cd Disk1/

[oracle@rac10g01 Disk1] $. / runInstaller

Rac10g01 node:

[root@rac10g01 ~] # sh / u01/oracle/product/10.2.0.1/db_1/root.sh

Running Oracle 10g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / u01/oracle/product/10.2.0.1/db_1

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

The file "dbhome" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying dbhome to / usr/local/bin...

The file "oraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying oraenv to / usr/local/bin...

The file "coraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying coraenv to / usr/local/bin...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

[root@rac10g01 ~] #

Rac10g02 node:

[root@rac10g02 ~] # sh / u01/oracle/product/10.2.0.1/db_1/root.sh

Running Oracle 10g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / u01/oracle/product/10.2.0.1/db_1

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

The file "dbhome" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying dbhome to / usr/local/bin...

The file "oraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying oraenv to / usr/local/bin...

The file "coraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying coraenv to / usr/local/bin...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

[root@rac10g02 ~] #

7. Verify the version of oracle database

[oracle@rac10g01 Disk1] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0-Production on Tue Nov 15 18:09:09 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL >

8. Create a database

[root@rac10g01 ~] # xhost +

Access control disabled, clients can connect from any host

[root@rac10g01 ~] # su-oracle

[oracle@rac10g01 ~] $dbca

8. Verify that the installation is successful

Rac10g01 node:

[oracle@rac10g01] $crs_stat-t

Name Type Target State Host

Ora.rac10g.db application ONLINE ONLINE rac10g01

Ora....ac10.cs application ONLINE ONLINE rac10g02

Ora....0g1.srv application ONLINE ONLINE rac10g01

Ora....0g2.srv application ONLINE ONLINE rac10g02

Ora....g1.inst application ONLINE ONLINE rac10g01

Ora....g2.inst application ONLINE ONLINE rac10g02

Ora....SM1.asm application ONLINE ONLINE rac10g01

Ora....01.lsnr application ONLINE ONLINE rac10g01

Ora....g01.gsd application ONLINE ONLINE rac10g01

Ora....g01.ons application ONLINE ONLINE rac10g01

Ora....g01.vip application ONLINE ONLINE rac10g01

Ora....SM2.asm application ONLINE ONLINE rac10g02

Ora....02.lsnr application ONLINE ONLINE rac10g02

Ora....g02.gsd application ONLINE ONLINE rac10g02

Ora....g02.ons application ONLINE ONLINE rac10g02

Ora....g02.vip application ONLINE ONLINE rac10g02

[oracle@rac10g01 ~] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0-Production on Tue Nov 15 21:53:40 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

And Real Application Testing options

SQL > create table t (a number)

Table created.

SQL > insert into t values (1)

1 row created.

SQL > commit

Commit complete.

SQL > select * from t

A

-

one

SQL >

Rac10g02 node:

[oracle@rac10g02 ~] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0-Production on Tue Nov 15 21:56:06 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

And Real Application Testing options

SQL > select * from t

A

-

one

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.