RAC手工配置监听、ASM和创建数据库
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了RAC手工配置监听、ASM和创建数据库,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2472字,纯文字阅读大概需要4分钟。
内容图文
1.配置listenera.$Oracle_HOME/network/admin/listener.oraLISTENER1= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vi
1.配置listener
a.$Oracle_HOME/network/admin/listener.ora
LISTENER1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip.oracle.com)(PORT=1521)(IP=FIRST))
(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.oracle.com)(PORT=1521)(IP=FIRST))
)
b.$ORA_CRS_HOME/crs/public/ora.rac1.LISTENER1.lsnr.cap
NAME=ora.rac1.LISTENER1.lsnr
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for listener on node
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac1
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac1.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
c.crs_register ora.rac1.LISTENER1.lsnr
d.节点2,重复步骤a,b,c
2.创建ASM
a.$ORACLE_HOME/dbs/init+ASM1.ora
cluster_database=true
instance_type=asm
large_pool_size=12m
background_dump_dest=/u01/app/oracle/admin/+ASM/bdump
core_dump_dest=/u01/app/oracle/admin/+ASM/cdump
user_dump_dest=/u01/app/oracle/admin/+ASM/udump
asm_diskgroups='DATA','FLASH'
+ASM1.instance_number=1
+ASM2.instance_number=2
b.export ORACLE_SID=+ASM
sqlplus / as sysdba
startup nomount
create diskgroup DATA external redundancy disk '/dev/raw/raw1'
c.srvctl add asm -n rac1 -i +ASM1 -o $ORACLE_HOME -p spfile+ASM1.ora
d.节点2,,重复a, b, c
3.创建RAC数据库
a.新建单实例数据库
b.alter database add logfile thread 2 group 3('+DATA/RACDB/redo01a.rdo','+DATA/RACDB/redo01b.rdo') size 50M
alter database add logfile thread 2 group 3('+DATA/RACDB/redo01a.rdo','+DATA/RACDB/redo01b.rdo') size 50M
create undo tablespace UNDOTBS2 datafile '+DATA/RACDB/undotbs02.dbf') size 50M
alter database enable thread 2
c.initRACDB.ora
cluster_database=true
cluster_instances=2
RACDB1.thread=1
RACDB2.thread=2
RACDB1.undo_tablespace=undotbs1
RACDB2.undo_tablespace=undotbs2
RACDB1.instance_number=1
RACDB2.instance_number=2
d.srvctl add database -d RACDB -o /u01/app/oracle/product/10.2.0/db_1 -p initRACDB.ora
srvctl add instance -d RACDB -i RACDB1 -n rac1
srvctl add instance -d RACDB -i RACDB2 -n rac2
内容总结
以上是互联网集市为您收集整理的RAC手工配置监听、ASM和创建数据库全部内容,希望文章能够帮你解决RAC手工配置监听、ASM和创建数据库所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。