《在vmware下配置ORACLE的RAC+DG.doc》由会员分享，可在线阅读，更多相关《在vmware下配置ORACLE的RAC+DG.doc（37页珍藏版）》请在金锄头文库上搜索。
1、在vmware下配置ORACLE的RAC+DG我用虚拟机装了rac+ a Single Instance Physical Standby已经配置成功了。并能进行自动的切换.我在这里就先贴一个,其实这个帖子我在这个联接很久就发布.但是还有好多朋友没有发现(http:/ . p;extra=&page=6)一、系统的准备工作1对系统IP地址的规划oraclerac2 dbs$ cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will
2、fail.127.0.0.1 localhosts192.168.20.152rac2 -RAC2主库192.168.20.151rac1 -RAC1主库10.10.10.2 rac2-priv10.10.10.1 rac1-priv192.168.20.139pri-rac -DATAGUARD的备用库2安装配置好ORACLE9I RAC的数据库和数据库软件能正常的启动和关闭数据库 INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME STATUS- - - - - 2 2 devdb2 rac2 OPEN 1 1 devdb1 rac1 OPENS
3、QL l1* select inst_id,instance_number,instance_name,host_name,status from gv$instanceSQL /COMP_IDCOMP_NAME VERSION STATUS- - - -CATALOGOracle9i Catalog Views 9.2.0.4.0VALIDCATPROCOracle9i Packages and Types 9.2.0.4.0VALIDOWM Oracle Workspace Manager 9.2.0.1.0VALIDJAVAVM JServer JAVA Virtual Machine
4、9.2.0.4.0VALIDXML Oracle XDK for Java 9.2.0.6.0VALIDCATJAVAOracle9i Java Packages 9.2.0.4.0VALIDORDIM Oracle interMedia 9.2.0.4.0VALIDSDO Spatial 9.2.0.4.0LOADEDCONTEXTOracle Text 9.2.0.4.0VALIDXDB Oracle XML Database 9.2.0.4.0VALIDWK Oracle Ultra Search 9.2.0.4.0VALIDCOMP_IDCOMP_NAME VERSION STATUS
5、- - - -ODM Oracle Data Mining 9.2.0.1.0LOADEDAPS OLAP Analytic Workspace 9.2.0.4.0LOADEDXOQ Oracle OLAP API 9.2.0.4.0LOADEDAMD OLAP Catalog 9.2.0.4.0VALIDRAC Oracle9i Real Application Clusters9.2.0.4.0VALID16 rows selected.SQL l1* select comp_id,comp_name,version,status from dba_registry3安装配置好备用库上的数
6、据库软件和配置好数据库的环境变量这些文件RAC1和RAC2上的环境变量oraclerac2 dbs$ cat /home/oracle/.bash_profile# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHPATH=$PATH:$HOME/bin #ORACLE_BASE 可以定位到盘阵上/data export ORACL
7、E_BASE=/home/oracle/product export ORACLE_HOME=/home/oracle/product/9.2.0.4 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin export ORACLE_OWNER=oracle export ORACLE_SID=devdb2 export ORACLE_TERM=xterm export LD_ASSUME_KERNEL=2.4.19 export THREADS_FLAG=native export LD_LIBRARY_PATH=
8、$LD_LIBRARY_PATH:$ORACLE_HOME/lib export NLS_LANG=American_america.zhs16gbk # export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data #export DISPLAY=:0 #export LANG=en_US #export GDM_LANG= en_US #export LC= en_US #export PATH export DBCA_RAW_CONFIG=/ho
9、me/oracle/DBCA_RAW_CONFIG.txtunset USERNAMEPRI-RAC备用库的环境变量oraclepri-rac devdb$ cat /home/oracle/.bash_profile# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHPATH=$PATH:$HOME/bin #ORACLE_BAS
10、E 可以定位到盘阵上/data export ORACLE_BASE=/home/oracle/product export ORACLE_HOME=/home/oracle/product/9.2.0.4 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin export ORACLE_OWNER=oracle export ORACLE_SID=devdb export ORACLE_TERM=xterm export LD_ASSUME_KERNEL=2.4.19 export THREADS_FLAG=nat
11、ive export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export NLS_LANG=American_america.zhs16gbk # export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data #export DISPLAY=:0 #export LANG=en_US #export GDM_LANG= en_US #export LC= en_US #export PATH
12、 export DBCA_RAW_CONFIG=/home/oracle/DBCA_RAW_CONFIG.txtunset USERNAME4安装配置RAC1，RAC2，PRI-RAC主机网络listener.ora文件和tnsnames.ora文件在RAC1和RAC2上的listener.ora和tnsnames.ora文件这个是RAC2的listener.ora文件内容oraclerac2 admin$ cat listener.ora# LISTENER.ORA.RAC2 Network Configuration File: /home/oracle/product/9.2.0.4/network/admin/listener.ora.rac2# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521) ) )SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (SID_NAME = PLSExtPro
