以文本方式查看主题 - 计算机科学论坛 (http://bbs.xml.org.cn/index.asp) -- 『 操作系统原理 』 (http://bbs.xml.org.cn/list.asp?boardid=63) ---- 在Solaris 10 X86上安装Oracle 10g RAC详解 (2) [转帖] (http://bbs.xml.org.cn/dispbbs.asp?boardid=63&rootid=&id=45018) |
-- 作者:菜籽 -- 发布时间:4/7/2007 2:00:00 PM -- 在Solaris 10 X86上安装Oracle 10g RAC详解 (2) [转帖] http://blog.csdn.net/longrujun/archive/2006/04/25/677189.aspx 6,接下来就进入到安装界面,可以看到Oracle安装到了所有节点
同样,安装后期会提示用户在所有节点上以root身份运行脚本root.sh,这时在RAC1运行是还要进行VIP配置。
<root:RAC1>/u01/app/oracle/product/10.1.0.3/oracle/root.sh Running Oracle10 root.sh script...
ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/10.1.0.3/oracle
Creating /usr/local/bin directory... Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...
Entries will be added to the /var/opt/oracle/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. 此时Oracle安装程序会进行VIP配置,需要选择网络接口和各个节点的虚拟地址
配置完成后会出现显示整个配置的结果:
Running Oracle10 root.sh script...
ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/10.1.0.3/oracle
Creating /usr/local/bin directory... Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...
Adding entry to /var/opt/oracle/oratab file... Entries will be added to the /var/opt/oracle/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.
CRS resources are already configured 以上步骤完成后,整个Oracle 10g的安装就完成了。
下面我们还需要进行Oracle网络服务的配置,具体步骤如下:
Oracle Net Services Configuration: 1, 在网络服务配置时选择”Cluster configuration”,如下图所示:
2,选中需要进行配置的节点,这里选中RAC1和RAC2。
在所有节点上创建数据库
<root:RAC1>cd ORACLE <root:RAC1>mkdir db <root:RAC1>chown oracle:root db <root:RAC1>cd db <root:RAC1>ls <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s0 system <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s1 sysaux <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s3 undotbs1 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s4 undotbs2 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s5 temp <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s0 example <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s1 users <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s3 redo1_1 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s4 redo1_2 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s5 redo2_1 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s6 redo2_2 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s7 spfile <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s3 control1 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s4 control2 <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s5 pwdfile <root:RAC1>pwd /ORACLE/db <root:RAC1>chown -RL oracle:dba * <root:RAC1>chmod -R 660 *
将以上的目录做为创建数据库所需raw devices的配置文件,具体步骤为:
system=/ORACLE/db/system sysaux=/ORACLE/db/sysaux example=/ORACLE/db/example users=/ORACLE/db/users temp=/ORACLE/db/temp undotbs1=/ORACLE/db/undotbs1 undotbs2=/ORACLE/db/undotbs2 redo1_1=/ORACLE/db/redo1_1 redo1_2=/ORACLE/db/redo1_2 redo2_1=/ORACLE/db/redo2_1 redo2_2=/ORACLE/db/redo2_2 control1=/ORACLE/db/control1 control2=/ORACLE/db/control2 spfile=/ORACLE/db/spfile pwdfile=/ORACLE/db/pwdfile
DBCA_RAW_CONFIG=/u01/app/oracle/oradata/tree/tree_raw.conf export DBCA_RAW_CONFIG
RAC1, ORACLE_SID=tree1 export ORACLE_SID RAC2, ORACLE_SID=tree2 export ORACLE_SID
以oracle用户来创建一个Cluster数据库,具体步骤如下: <oracle:RAC1>dbca
然后选择创建一个数据库并随后在节点选择时选中两个节点RAC1和RAC2.
以后的步骤中需要设定密码,设定存储和恢复机制以及数据库内容和服务,这里按照缺省值设定即可。
随后要设置数据库的初始参数,在此,根据机器的内存大小,设定SGA为800M,PGA 为200M,用户可根据具体的环境来设定相应的大小
在此我们还可以来起动并验证一下刚刚创建的数据库 ------------------------------------------------ oracle:RAC1>srvctl status database -d tree Instance tree1 is running on node rac1 Instance tree2 is running on node rac2
VIP is running on node: RAC1 GSD is running on node: RAC1 Listener is running on node: RAC1 ONS daemon is running on node: RAC1
VIP is running on node: RAC2 GSD is running on node: RAC2 Listener is running on node: RAC2 ONS daemon is running on node: RAC2
Instance tree1 is not running on node rac1 Instance tree2 is not running on node rac2
VIP is running on node: RAC1 GSD is running on node: RAC1 Listener is running on node: RAC1 ONS daemon is running on node: RAC1
VIP is running on node: RAC2 GSD is running on node: RAC2 Listener is running on node: RAC2 ONS daemon is running on node: RAC2
<oracle:RAC1>srvctl status database -d tree Instance tree1 is running on node rac1 Instance tree2 is running on node rac2
Connected. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup
Fixed Size 781424 bytes Variable Size 221254544 bytes Database Buffers 616562688 bytes Redo Buffers 262144 bytes Database mounted. Database opened. SQL> SELECT * FROM V$ACTIVE_INSTANCES;
----------- ------------------------------------------------------------ 1 RAC1:tree1 2 RAC2:tree2
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options
for AIX-Based Systems, Apple Mac OS X, hp HP-UX, hp Tru64 UNIX, Linux, Solaris Operating System, and Windows Platforms Part No. B10766-08 |
W 3 C h i n a ( since 2003 ) 旗 下 站 点 苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》 |
62.500ms |