五、1.安装数据库软件

[oracle&＃64;rac1 ~]$ ls

10201_clusterware_linux32.zip clusterware ocfs2

10201_database_linux32.zip Desktop oracleasm

[oracle&＃64;rac1 ~]$ unzip 10201_database_linux32.zip

[oracle&＃64;rac1 ~]$ database/runInstaller

Select All

只安装数据库软件

Install

以root用户执行如下两个脚本

[oracle&＃64;rac1 logs]$ su -

Password:

[root&＃64;rac1 ~]# /db/oracle/product/10.2.0/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER&＃61; oracle

ORACLE_HOME&＃61; /db/oracle/product/10.2.0/db_1

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

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

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

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

Creating /etc/oratab file...

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&＃64;rac2 ~]# /db/oracle/product/10.2.0/db_1/root.sh

运行完后点击上图中的OK

Exit

YES

2、 配置监听

[oracle&＃64;rac1 ~]$ netca

Select all nodes

clip_image030

finish

3、 配置自动存储管理

[oracle&＃64;rac1 ~]$ dbca –configureAsm /*

点击next

Select all&＃xff0c;

设置sys密码&＃xff0c;将spfile的路径改为/crs/spfile&＃43;ASM.ora

Create new

输入data,选择External,选中ORACL:DATA,ok

Create new

输入flash,选择External,选中ORCL:FLASH

FINISH

4、 创建RAC数据库

点击OK

正在创建数据库

[oracle&＃64;rac2 admin]$ crs_stat –t /*查看集群状态

5、 配置LOCAL——LISTENER参数

[oracle&＃64;rac2 admin]$vi $ORACLE_HOME/network/admin/tnsnames.ora /*添加如下内容

LISTENERS_local&＃61;

(ADDRESS_LIST&＃61;

(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;rac2-vip)(PORT&＃61;1521)

)

[oracle&＃64;rac1 /]$vi $ORACLE_HOME/network/admin/tnsnames.ora

LISTENERS_local&＃61;

(ADDRESS_LIST&＃61;

(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;rac1-vip)(PORT&＃61;1521)

)

SQL>alter system set local_listener&＃61;listeners_local;

$srvctl stop database –d orcl

$srvctl start database –d orcl

$crs_stat –t

SQL>archive log list;

SQL>alter system set log_archive_dest_1&＃61;’location&＃61;use_db_recovery_file_dest’;

关机顺序&＃xff1a;

停止节点1&＃xff08;rac1&＃xff09;的dbconsole $emctl stop dbconsole

停止节点2&＃xff08;rac2&＃xff09;的dbconsole $emctl stop dbconsole

停止节点1的isqlplus $isqlplusctl stop

停止节点2的isqlplus $isqlplusctl stop

关闭数据库 $srvctl stop database –d orcl

查看集群状态 $crs_stat –t

关闭节点1的asm $srvctl stop asm –n rac1

查看集群状态 $crs_stat –t

关闭节点2的asm $srvctl stop asm –n rac2

关闭节点1的监听 $srvctl stop listener –n rac1

关闭节点2的监听 $srvctl stop listener –n rac2

$srvctl stop nodeapps –n rac1

$srvctl stop nodeapps –n rac2

Technorati 标签: oracLE RAC