4.安装ORACLE 资料库软件
Select all.
同时用SSH Connectivity ,输入 ORACLE的密码,setup.
在二个节点都运行
4.1用DBCA建立资料库
之前可用grid用户建立一磁盘组fra,用asmca建立。
select instance_name,host_name from gv$instance;
SQL> select instance_name from gv$instance;
INSTANCE_NAME
----------------
orcl1
orcl2
[grid@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rac01
ora.FRA.dg ora....up.type ONLINE ONLINE rac01
ora....ER.lsnr ora....er.type ONLINE ONLINE rac01
ora....N1.lsnr ora....er.type ONLINE ONLINE rac01
ora.asm ora.asm.type ONLINE ONLINE rac01
ora.cvu ora.cvu.type ONLINE ONLINE rac01
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac01
ora.oc4j ora.oc4j.type ONLINE ONLINE rac01
ora.ons ora.ons.type ONLINE ONLINE rac01
ora.orcl.db ora....se.type ONLINE ONLINE rac01
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application OFFLINE OFFLINE
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip ora....t1.type ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application OFFLINE OFFLINE
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip ora....t1.type ONLINE ONLINE rac02
ora....ry.acfs ora....fs.type ONLINE ONLINE rac01
ora.scan1.vip ora....ip.type ONLINE ONLINE rac01
----------------------------------------------完成---------------------------------------
4.2 客户端的链接
安装完后,应该还不能链接,会出现如下错误
解决方法:
在1节点
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.201)(PORT = 1521))' scope=both sid='orcl1';
System altered.
在2节点
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.202)(PORT = 1521))' scope=both sid='orcl2';
System altered.
----------------------------------------end-------------------------------------
最后感谢刘大Maclean Liu(和mfkqwyc86。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/203348/viewspace-1253977/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/203348/viewspace-1253977/