第一次,没想到成功了,小计于此:
ms集群:
操作系统用户:
oracle
密码:
xxxxxx
oracle数据库的用户:
sys/system/dbsnmp/sysman
密码统一为:
xxxxxxxx
SID:
xxx1 在 racb 服务器上
xxx2 在 raca 服务器上
raca:10.xx.xx70
racb:10.xx.xx.71
racascan ip1:10.xx.xx.80
racbscan ip2:10.xx.xx.81
心跳ip:90.10.10.70
心跳ip:90.10.10.71
racaVIP ip1:10.xx.xx.78
racbVIP ip2:10.xx.xx79
仲裁盘:5个400M的raw盘raw1-raw5
数据存储盘:RACDB_DATA 4个2T加1个1T
设置:
ClusterName:rac
scan name:racscan
Oracle ASM[SYS ASMSNMP]密码xxxxxxxxxxxxx
oracle base:/u01/base/oracle
software Location:/u01/oracle/11g
ORACLE_OWNER=oracle
ORACLE_HOME=/u01/oracle/11g
Database Administrator(OSDBA)Gruop : dba
DataBase Operator(OSOPER)Group(Optional):oinstall
racb和raca:
Global Database Name:xxxx
SID prefix:xxxx
oracle数据库的用户:
sys/system/dbsnmp/sysman
密码统一为:
xxxxxxxxxxxxxxxxxxxxxxxxxx
FRA Area:+FRA
FRA Size:512000M[建议90%,但只用了55%,默认才4747]
mem:50%
Processes:256[原先150]
Database Character set:ZHS16GBK-GBK 16-bit Simplified Chinese
National Character set:UTF-8
Generate Database Create Script:
/u01/base/oracle/admin/xxxx1/script
数据库定义备份HTML:
/u01/base/oracle/11g/dbinit.html
Global Database Name:xxx
System Identifier(SID) prefix:xxx
Server Parameter File name:+RAC_DATA/xxx/spfilemsga.ora
the Dtabase Control URL :https://racb.xxx.com:1158/em
sys/system可用。其余账户锁定
SID:
xxx1 at racb
xxx2 at raca
本地测试:
sqlplus system/密码@xxxx
show sga;
select * from gv$instance;
ok