Linux platform Oracle 10GR2 (10.2.0.5) RAC installation PART3:DB installation and upgrade

Linux platform Oracle 10GR2 (10.2.0.5) RAC installation PART3:DB installation and upgrade
Environment: OEL 5.7 + Oracle 10.2.0.5 RAC

5. Installing database Software

• 5.1 Unpacking the installation media
• 5.2 Start installing the DB software
• 5.3 Root User execution script

6. Upgrading database Software

• 6.1 Upgrading the DB software
• 6.2 Root User Execution script

7. Create a Database

• 7.1 Creating a listener
• 7.2 Creating ASM
• 7.3 Creating a Database

Linux platform Oracle 10gr2 RAC Installation Guide:
Part1:linux platform Oracle 10GR2 (10.2.0.5) RAC installation PART1: Prepare for work
Part2:linux platform Oracle 10GR2 (10.2.0.5) RAC installation Part2:clusterware installation and upgrade
Part3:linux platform Oracle 10GR2 (10.2.0.5) RAC installation PART3:DB installation and upgrade

5. Install database software 5.1 Unzip the installation media

[[email protected] ~]$ cd /u01/media/[[email protected] media]$ gunzip 10201_database_linux_x86_64.cpio.gz [[email protected] media]$ cpio -idmv < 10201_database_linux_x86_64.cpio [[email protected] media]$ cd database/[[email protected] database]$ lsdoc  install  response  runInstaller  stage  welcome.html[[email protected] database]$ cd install/[[email protected] install]$ lsaddLangs.sh  addNode.sh  images  lsnodes  oneclick.properties  oraparam.ini  oraparamsilent.ini  resource  response  unzip[[email protected] install]$ vi oraparam.ini #找到“[Certified Versions]”这里，行尾添加redhat-5，保存退出[Certified Versions]Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2,redhat-5

5.2 Start installing the DB software

Use Xquartz to connect to Node 1 and start calling the graphics installation DB software.

[[email protected] database]$ pwd/u01/media/database[[email protected] database]$ lsdoc  install  response  runInstaller  stage  

5.3 Root User execution script

Root users follow the prompts to execute the script @all nodes

/u01/app/oracle/product/10.2.0.5/dbhome_1/root.sh

Then proceed to the next step, prompting to complete the installation:

The following J2EE Applications have been deployed and are accessible at the URLs listed below.iSQL*Plus URL:http://oradb27:5561/isqlplusiSQL*Plus DBA URL:http://oradb27:5561/isqlplus/dba

Here, complete the software installation of DB 10.2.0.1.

6. Upgrade Database software 6.1 Upgrade DB software

[[email protected] Disk1]$ pwd/u01/media/Disk1[[email protected] Disk1]$ lsinstall  patch_note.htm  response  runInstaller  

6.2 Root User execution script @all nodes

Root user execution Script @all nodes

/u01/app/oracle/product/10.2.0.5/dbhome_1/root.sh

When the execution is complete, return to the graphical interface to complete the installation:

The iSQL*Plus URL is:http://oradb27:5560/isqlplusThe iSQL*Plus DBA URL is:http://oradb27:5560/isqlplus/dba

Here, the DB software was successfully upgraded to version 10.2.0.5.

7. Create a database 7.1 create a listener

NETCA Create a listener.

After successful viewing the cluster resources, there are more monitoring resources:

[[email protected] Disk1]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora....27.lsnr application    0/5    0/0    ONLINE    ONLINE    oradb27     ora....b27.gsd application    0/5    0/0    ONLINE    ONLINE    oradb27     ora....b27.ons application    0/3    0/0    ONLINE    ONLINE    oradb27     ora....b27.vip application    0/0    0/0    ONLINE    ONLINE    oradb27     ora....28.lsnr application    0/5    0/0    ONLINE    ONLINE    oradb28     ora....b28.gsd application    0/5    0/0    ONLINE    ONLINE    oradb28     ora....b28.ons application    0/3    0/0    ONLINE    ONLINE    oradb28     ora....b28.vip application    0/0    0/0    ONLINE    ONLINE    oradb28     

7.2 Creating ASM

DBCA Configure the ASM Disk group and add the Data,fra disk group.

ASM instances are created during the configuration of ASM disk groups, and after successful viewing of cluster resources, there are already more ASM instance resources:

[[email protected] Disk1]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    oradb27     ora....27.lsnr application    0/5    0/0    ONLINE    ONLINE    oradb27     ora....b27.gsd application    0/5    0/0    ONLINE    ONLINE    oradb27     ora....b27.ons application    0/3    0/0    ONLINE    ONLINE    oradb27     ora....b27.vip application    0/0    0/0    ONLINE    ONLINE    oradb27     ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    oradb28     ora....28.lsnr application    0/5    0/0    ONLINE    ONLINE    oradb28     ora....b28.gsd application    0/5    0/0    ONLINE    ONLINE    oradb28     ora....b28.ons application    0/3    0/0    ONLINE    ONLINE    oradb28     ora....b28.vip application    0/0    0/0    ONLINE    ONLINE    oradb28  

7.3 Creating a Database

DBCA Create a database.

After the creation is complete, view the cluster resources with the database instance resources and database resources:

[[email protected] disk1]$ crs_stat-t-vname Type r/ra f/ft Target State Host    ----------------------------------------------------------------------ora.jyrac.db application 0/0 0/1 ONLINE Online oradb28 ora....c1.inst application 0/5 0/0 online online oradb27 ora....c2.inst Applica tion 0/5 0/0 online online oradb28 ora .... SM1.ASM application 0/5 0/0 online online oradb27 ora ....    27.lsnr application 0/5 0/0 Online online oradb27 ora....b27.gsd application 0/5 0/0 ONLINE Online oradb27 ora....b27.ons application 0/3 0/0 online online oradb27 ora....b27.vip applicat Ion 0/0 0/0 Online online oradb27 ora .... SM2.ASM application 0/5 0/0 online online oradb28 ora .... 28.lsnr application 0/5 0/0 Online online oradb28 ora....b28.gsd application 0/5 0/0 OnliNE online oradb28 ora....b28.ons application 0/3 0/0 online online oradb28 ora....b28.vip app  Lication 0/0 0/0 Online online oradb28 [[email protected] disk1]$

Verify the current database version and availability:

[[email protected] disk1]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-production on Tue Jan 3 20:59:21 2017Cop  Yright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part Itioning, real application Clusters, OLAP, Data miningand Real application testing optionssql> Select Open_mode from v$ Database;open_mode----------READ writesql> sql> col comp_name for a45sql> set linesize 120sql> Select Comp_na Me, status, version from Dba_registry; Comp_name STATUS VERSION---------------------------------------------                  ----------------------------------------------------Spatial VALID                                  10.2.0.5.0Oracle intermedia VALID 10.2.0.5.0OLAP Catalog      VALID 10.2.0.5.0Oracle Enterprise Manager               VALID 10.2.0.5.0Oracle XML Database VALID 10.2.                      0.5.0Oracle Text VALID 10.2.0.5.0Oracle Expression Filter VALID 10.2.0.5.0Oracle Rules Manager VALID 10.2.0.5.0Or                            Acle Workspace Manager VALID 10.2.0.5.0Oracle Data Mining                                      VALID 10.2.0.5.0Oracle Database Catalog views VALID 10.2.0.5.0comp_name STATUS VERSION------------------------------------------------------ -------------------------------------------Oracle Database Packages and Types VALID 10.2.0.5.                                    0JServer JAVA Virtual Machine VALID 10.2.0.5.0Oracle XDK               VALID   10.2.0.5.0Oracle Database Java Packages VALID 10.2.0.5.0OLAP Analytic Workspace VALID 10.2.0.5.0Oracle OLAP API VALID 10.2 .0.5.0Oracle Real Application Clusters VALID 10.2.0.5.018 rows selected.

At this point, the Linux platform Oracle 10GR2 (10.2.0.5) RAC installation series has been completed.

Linux platform Oracle 10GR2 (10.2.0.5) RAC installation PART3:DB installation and upgrade