Oracle Study-aix6.1 Building Oracle 10GR2 RAC (5)

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (5)

First, install Oracle software

Install as Oracle:

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401111416770?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401111440223?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

After the Oracle software installation is complete, run the "root.sh" script to complete the Oracle installation!

Second, configure the network (Listener)

Configure the network via NETCA:

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401112504337?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

[[email protected] Disk1] $lsnrctl status

Lsnrctl for ibm/aix risc system/6000: version 10.2.0.1.0 - production  on 16-MAR-2016 17:39:24Copyright  (c)  1991, 2005, oracle.  all  rights reserved. connecting to  (address= (protocol=tcp) (host=) (port=1521)) status of the  LISTENER------------------------alias                      LISTENER_AIX203Version                    tnslsnr for ibm/ aix risc system/6000: version 10.2.0.1.0 - productionstart date                 16-MAR-2016  17:06:09uptime                     0 days 0 hr. 33 min. 14 sectrace level                offSecurity                   ON: Local OS  authenticationsnmp                       onlistener parameter file   /u01/app/oracle /product/10.2.0/db_1/network/admin/listener.oralistener log file          /u01/app/oracle/product/10.2.0/db_1/network/log/listener_aix203.loglistening endpoints  Summary...   (description= (address= (protocol=tcp) (host=192.168.8.251) (port=1521))    ( Description= (address= (protocol=tcp) (host=192.168.8.203) (port=1521)) services summary ... service  "Plsextproc"  has&nbsP;1 instance (s) .  instance  "Plsextproc", status unknown, has 1  Handler (s)  for this service ... The command completed successfully

Iii. building a library through DBCA

To build the repository for your work:

Because database is through raw storage, the following preparations are required for management convenience when building a library:

1) Create a raw link file

[[Email protected] Oracle] $mkdir-P Oradata/prod
[[Email protected] Oracle] $ls
Orainventory Oradata Product
[[Email protected] ~] $cat mkln.sh

ln -s /dev/rsystem           /u01/app/oracle/ oradata/prod/system01.dbfln -s /dev/rsysaux            /u01/app/oracle/oradata/prod/sysaux01.dbfln -s /dev/rusers             /u01/app/oracle/oradata/prod/users01.dbfln -s /dev/ Rundotbs1         /u01/app/oracle/oradata/prod/undotbs01.dbf  ln -s /dev/rundotbs2         /u01/app/oracle/ oradata/prod/undotbs02.dbfln -s /dev/rtemp              /u01/app/oracle/oradata/prod/temp01.dbfln -s /dev/rcontrol1_1          /u01/app/oracle/oradata/prod/control01.ctlln -s /dev/ rcontrol2_2         /u01/app/oracle/oradata/prod/control02.ctlln -s /dev/rcontrol3_3          /u01/app/oracle/oradata/prod/control03.ctlln -s /dev/ Rredo1_1          /u01/app/oracle/oradata/prod/log11.logln  -s /dev/rredo1_2          /u01/app/oracle/oradata /prod/log12.logln -s /dev/rredo2_1          /u01/ app/oracle/oradata/prod/log21.logln -s /dev/rredo2_2           /u01/app/oracle/oradata/prod/log22.logln -s /dev/rindex             /u01/app/oracle/oradata/prod/index01.dbfln -s /dev/rspfile            /u01/app/oracle/oradata/prod/spfile01ln  -s /dev/rexamplE          /u01/app/oracle/oradata/prod/example01.dbf 

[[Email protected] ~] $sh mkln.sh

[[Email protected] ~] $ls-L/u01/app/oracle/oradata/prod/
Total 0
L

rwxrwxrwx    1 oracle   oinstall          16 mar 16 17:49 control01.ctl -> /dev/rcontrol1_1lrwxrwxrwx     1 oracle   oinstall          16 Mar 16 17:49 control02.ctl -> /dev/rcontrol2_2lrwxrwxrwx     1 oracle   oinstall          16 Mar 16 17:49 control03.ctl -> /dev/rcontrol3_3lrwxrwxrwx     1 oracle   oinstall         13  Mar 16 17:49 example01.dbf -> /dev/rexamplelrwxrwxrwx     1 oracle   oinstall         11 mar  16 17:49 index01.dbf -> /dev/rindexlrwxrwxrwx    1 oracle   oinstall          13 Mar 16 17:49 log11.log ->  /dev/rredo1_1lrwxrwxrwx    1 oracle   oinstall          13 mar 16 17:49 log12.log -> /dev/rredo1_ 2lrwxrwxrwx    1 oracle   oinstall          13 Mar 16 17:49 log21.log -> /dev/rredo2_1lrwxrwxrwx     1 oracle   oinstall          13 Mar 16 17:49 log22.log -> /dev/rredo2_2lrwxrwxrwx     1 oracle   oinstall         12 mar  16 17:49 spfile01 -> /dev/rspfilelrwxrwxrwx    1 oracle    Oinstall         12 mar 16 17:49 sysaux01.dbf  -> /dev/rsysauxlrwxrwxrwx    1 oracle   oinstall          12 Mar 16 17:49 system01.dbf ->  /dev/rsystemlrwxrwxrwx    1 oracle   oinstall          10 mar 16 17:49 temp01.dbf -> /dev/ rtemplrwxrwxrwx    1 oracle   oinstall          14 mar 16 17:49 undotbs01.dbf -> /dev/ rundotbs1lrwxrwxrwx    1 oracle   oinstall          14 mar 16 17:49 undotbs02.dbf -> /dev/rundotbs2lrwxrwxrwx    1  Oracle   oinstall         11 mar 16  17:49 users01.dbf -> /dev/rusers

2) Establish raw storage mappings
[[email protected] ~] $cat map.txt 

system=/u01/app/oracle/oradata/prod/system01.dbf      sysaux=/u01/app/oracle/ oradata/prod/sysaux01.dbfusers=/u01/app/oracle/oradata/prod/users01.dbf            undotbs1=/u01/app/oracle/oradata/prod/undotbs01.dbf          undotbs2=/u01/app/oracle/oradata/prod/undotbs02.dbf        temp=/u01/app/oracle/oradata/prod/temp01.dbf           control1=/u01/app/oracle/oradata/prod/control01.ctl      control2=/ u01/app/oracle/oradata/prod/control02.ctl      control3=/u01/app/oracle/oradata/ Prod/control03.ctl       redo1_1=/u01/app/oracle/oradata/prod/log11.log        redo1_2=/u01/app/oracle/oradata/prod/log12.log      redo2_1=/u01/app/oracle/oradata/prod/log21.log          redo2_2=/u01/app/oracle/ oradata/prod/log22.log       index=/u01/app/oracle/oradata/prod/ index01.dbfspfile=/u01/app/oracle/oradata/prod/spfile01       example=/u01/ App/oracle/oradata/prod/example01.dbf

When installing, the database chooses "bare device"

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401112628087?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401112702291?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20160401112732619?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Iv. Verification

[[email protected] ~] $crs _stat-t

name           type            Target    State     Host         ------------------------------------------------------------ora .... 03.lsnr application    online    online     aix203      ora.aix203.gsd application    online     ONLINE    aix203      ora.aix203.ons  application    online    online    aix203       ora.aix203.vip application    ONLINE     online    aix203      ora .... 04.lsnr application    online    online    aix204       ora.aix204.gsd application    online    online     aix204      ora.aix204.ons application    online     online    aix204      ora.aix204.vip  application    online    online    aix204       ora.prod.db    application     Online    online    aix204      ora .... d1.inst application    online    online     aix203      ora....d2.inst application    online     online    aix204 

Connect and access the database:
[[Email protected] ~] $sqlplus '/as sysdba '
Sql*plus:release 10.2.0.1.0-production on Wed Mar 16 18:12:43 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the partitioning, Real application Clusters, OLAP and Data Mining options
Sql> select Instance_name,status from Gv$instance;

instance_name STATUS----------------------------prod1 OPENprod2 OPEN

Sql> select name from V$datafile;

NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/ prod/system01.dbf/u01/app/oracle/oradata/prod/undotbs01.dbf/u01/app/oracle/oradata/prod/sysaux01.dbf/u01/app/ oracle/oradata/prod/users01.dbf/u01/app/oracle/oradata/prod/example01.dbf/u01/app/oracle/oradata/prod/ Undotbs02.dbf6 rows selected.

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1759139

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (5)