在vmware下配置ORACLE的RAC+DG
在vmware下配置ORACLE的RAC+DG我用虚拟机装了rac+ a Single Instance Physical Standby 已经配置成功了。并能进行自动的切换.我在这里就先贴一个,其实这个帖子我在这个联接很久就发布。但是还有好多朋友没有发现(http:/www。itpub。net/viewthread. 。. 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 fail。127。0。0.1 localhosts192.168。20。152 rac2 -RAC2主库192。168.20.151 rac1 -RAC1主库10.10。10.2 rac2priv10.10。10.1 rac1priv192。168。20.139 pri-rac -DATAGUARD的备用库2安装配置好ORACLE9I RAC的数据库和数据库软件能正常的启动和关闭数据库 INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME STATUS- - - - - 2 2 devdb2 rac2 OPEN 1 1 devdb1 rac1 OPENSQL l 1* select inst_id,instance_number,instance_name,host_name,status from gvinstanceSQL /COMP_ID COMP_NAME VERSION STATUS- - - -CATALOG Oracle9i Catalog Views 9。2.0。4。0 VALIDCATPROC Oracle9i Packages and Types 9。2.0.4.0 VALIDOWM Oracle Workspace Manager 9。2。0.1。0 VALIDJAVAVM JServer JAVA Virtual Machine 9。2.0.4.0 VALIDXML Oracle XDK for Java 9。2。0.6。0 VALIDCATJAVA Oracle9i Java Packages 9.2.0.4.0 VALIDORDIM Oracle interMedia 9.2.0.4。0 VALIDSDO Spatial 9。2.0。4。0 LOADEDCONTEXT Oracle Text 9.2。0.4。0 VALIDXDB Oracle XML Database 9.2.0。4。0 VALIDWK Oracle Ultra Search 9。2.0.4。0 VALIDCOMP_ID COMP_NAME VERSION STATUS- - - -ODM Oracle Data Mining 9。2。0。1。0 LOADEDAPS OLAP Analytic Workspace 9.2。0.4.0 LOADEDXOQ Oracle OLAP API 9。2.0.4。0 LOADEDAMD OLAP Catalog 9.2.0.4。0 VALIDRAC Oracle9i Real Application Clusters 9.2。0.4。0 VALID16 rows selected。SQL> l 1* select comp_id,comp_name,version,status from dba_registry3安装配置好备用库上的数据库软件和配置好数据库的环境变量这些文件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 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=devdb2 export ORACLE_TERM=xterm export LD_ASSUME_KERNEL=2。4。19 export THREADS_FLAG=native 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 export DBCA_RAW_CONFIG=/home/oracle/DBCA_RAW_CONFIG。txtunset USERNAMEPRIRAC备用库的环境变量oracleprirac 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_BASE 可以定位到盘阵上/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=native 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 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 = PLSExtProc) (ORACLE_HOME = /home/oracle/product/9.2。