首页 >

RAC手工配置监听、ASM和创建数据库

数据库|mysql教程RAC手工配置监听、ASM和创建数据库
Oracle教程,RAC手工配置监听、ASM和创建数据库,数
数据库-mysql教程
微信小程序源码论坛,苹果vscode关联git,ubuntu分屏重启,tomcat不编异类,sqlite可存储多少数据,崔庆才爬虫第二版pdf,php 颜色代码,仓山区seo介绍,情侣网站模板,手游中心模板lzw
1.配置listenera.$Oracle_HOME/network/admin/listener.oraLISTENER1= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vi
公交源码,vscode 太慢了,ubuntu系统怎么修改用户,jsp tomcat 发布,sqlite3统计,jq分页器插件下载,工作流 前端框架,爬虫实验总结分析,php 导出 csv,seo新手入手教程seo博客,网站下拉大菜单,网页导航头部下拉菜单,人才网网站模板,vb运动会管理系统代码,小程序会员源码lzw
苹果cms源码上传安装不了,ubuntu怎么安装图解,tomcat下9还是8,爬虫防跳转,主机PHP功能,栾城区工商seo技术要多少钱lzw

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和创建数据库
  • Oracle 10g RAC环境下创建物理DATAGUARD
  • Oracle 10g RAC环境下创建物理DATAGUARD | Oracle 10g RAC环境下创建物理DATAGUARD ...

    RAC手工配置监听、ASM和创建数据库
  • Oracle 中定位重要(消耗资源多)的SQL
  • Oracle 中定位重要(消耗资源多)的SQL | Oracle 中定位重要(消耗资源多)的SQL ...

    RAC手工配置监听、ASM和创建数据库
  • VMware+rhel5+Oracle 10g安装RAC的问题
  • VMware+rhel5+Oracle 10g安装RAC的问题 | VMware+rhel5+Oracle 10g安装RAC的问题 ...