Oracle Study之-AIX6.1構建Oracle 10gR2 RAC(5)

標籤：oracle

Oracle Study之-AIX6.1構建Oracle 10gR2 RAC(5)

一、安裝Oracle軟體

以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;" />

Oracle軟體安裝完成後，運行“root.sh”指令碼，完成Oracle安裝！

二、配置網路（Listener）

通過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 1 instance(s).  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully

三、通過DBCA建庫

建庫準備工作：

    由於DataBase是通過raw儲存，在建庫時為管理方便需做以下準備工作：

1）建立raw的連結檔案

[[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）建立raw儲存映射
[[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

在安裝時，DataBase選擇“裸裝置”

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;" />

四、驗證

[[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

串連和訪問資料庫：
[[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.

本文出自 “天涯客的blog” 部落格，請務必保留此出處http://tiany.blog.51cto.com/513694/1759139

Oracle Study之-AIX6.1構建Oracle 10gR2 RAC(5)