提示1:如果执行dbca时遇到connect to ":....",No protocol specified,可以先尝试su - root,然后执行xhost +,然后再回到oracle用户下执行dbca。
提示2:本步操作可以在当前RAC环境中的任意节点上执行,注意是当前RAC环境中的节点,不是要添加实例的节点上执行哟,这里三思选择在jssdbn1上执行。
接下来,需要定义一些与实例相关的文件,比较UNDO、REDOLOG等,想省事的话此处保持默认即可,因为这些信息如果发现不合适,后期也都是可调的。确认无误后,点击FINISH按钮:
[oracle@jssdbn1 admin]$ /data/ora10g/product/10.2.0/crs_1/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.jssdb.db application ONLINE ONLINE jssdbn2
ora....n1.inst application ONLINE ONLINE jssdbn1
ora....n2.inst application ONLINE ONLINE jssdbn2
ora....n3.inst application ONLINE ONLINE jssdbn3
ora....SM1.asm application ONLINE ONLINE jssdbn1
ora....N1.lsnr application ONLINE ONLINE jssdbn1
ora....bn1.gsd application ONLINE ONLINE jssdbn1
ora....bn1.ons application ONLINE ONLINE jssdbn1
ora....bn1.vip application ONLINE ONLINE jssdbn1
ora....SM2.asm application ONLINE ONLINE jssdbn2
ora....N2.lsnr application ONLINE ONLINE jssdbn2
ora....bn2.gsd application ONLINE ONLINE jssdbn2
ora....bn2.ons application ONLINE ONLINE jssdbn2
ora....bn2.vip application ONLINE ONLINE jssdbn2
ora....SM3.asm application ONLINE ONLINE jssdbn3
ora....N3.lsnr application ONLINE ONLINE jssdbn3
ora....bn3.gsd application ONLINE ONLINE jssdbn3
ora....bn3.ons application ONLINE ONLINE jssdbn3
ora....bn3.vip application ONLINE ONLINE jssdbn3
SQL> select inst_id,instance_name,version,startup_time,status from gv$instance;
INST_ID INSTANCE_NAME VERSION STARTUP_T STATUS
---------- ---------------- ----------------- --------- ------------
1 jssdbn1 10.2.0.1.0 16-NOV-09 OPEN
3 jssdbn3 10.2.0.1.0 16-NOV-09 OPEN
2 jssdbn2 10.2.0.1.0 16-NOV-09 OPEN