安装nba2k14修改器为什么说date.bin没有放在一个目录
点击联系发帖人
时间：2017-09-04 15:10
共被编辑 4 次
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna%Ymd%.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho%Ymd%.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna%Ymd%.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho%Ymd%.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:crontabmysqlsql%Ymd%D:wampbinmysqlmysql5.5.24binmysqldump --opt -u root --password=123456 anna & E:crontabmysqlsql%Ymd%bbs_anna%Ymd%.sqlD:wampbinmysqlmysql5.5.24binmysqldump --opt -u root --password=123456 typecho & E:crontabmysqlsql%Ymd%bbs_typecho%Ymd%.sql@echo on
我要该，理由是：Linux + Oracle 11g R2 RAC 安装配置详细过程
我的图书馆
Linux + Oracle 11g R2 RAC 安装配置详细过程
Oracle Linux AS 5.5两台Oracle 11g R21、IP规划127.0.0.1 localhost.localdomain localhost#public ip192.168.10.211& rac1192.168.10.212 rac2#priv ip10.10.10.211& rac1prv10.10.10.212 rac2prv#vip ip192.168.10.213& rac1vip192.168.10.214 rac2vip#scan ip192.168.10.215& racscan2、磁盘规划&&& +CRS&&&&&&& 三个2G的盘+DGDATA&&&& 三个10G的盘+DGRECOVERY 两个5G的盘/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 oper/usr/sbin/groupadd -g 504 asmadmin/usr/sbin/groupadd -g 505 asmoper/usr/sbin/groupadd -g 506 asmdba/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid[root@ora1 ~]# id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)[root@ora1 ~]# id griduid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)mkdir /oracle/app/chown -R grid:oinstall /oracle/app/chmod -R 775 /oracle/app/mkdir -p /oracle/app/oraInventorychown -R grid:oinstall /oracle/app/oraInventorychmod -R 775 /oracle/app/oraInventorymkdir -p /oracle/app/gridmkdir -p /oracle/app/oraclechown -R grid:oinstall /oracle/app/gridchown -R oracle:oinstall /oracle/app/oraclechmod -R 775 /oracle/app/oraclechmod -R 775 /oracle/app/grid
passwd gridpasswd oracle2、操作系统版本：[root@rac1 ~]# lsb_release -aLSB Version:&&& :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarchDistributor ID: EnterpriseEnterpriseServerDescription:&&& Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)Release:&&&&&&& 5.5Codename:&&&&&& Carthage[root@rac1 ~]# uname -aLinux rac1 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT
i686 i386 GNU/Linux[root@rac1 ~]# 修改系统参数：vi /etc/security/limits.conf#ORACLE SETTINGgrid&&&&&&&&&&&&&&&& soft&&& nproc&& 2047 grid&&&&&&&&&&&&&&&& hard&&& nproc&& 16384grid&&&&&&&&&&&&&&&& soft&&& nofile& 1024grid&&&&&&&&&&&&&&&& hard&&& nofile& 65536oracle&&&&&&&&&&&&&& soft&&& nproc&& 2047oracle&&&&&&&&&&&&&& hard&&& nproc&& 16384oracle&&&&&&&&&&&&&& soft&&& nofile& 1024oracle&&&&&&&&&&&&&& hard&&& nofile& 65536
vi /etc/pam.d/login#ORACLE SETTINGsession&&& required&&&& pam_limits.so# vi /etc/sysctl.conf#ORACLE SETTINGfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 8net.ipv4.ip_local_port_range = net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586
gird时间同步所需要的设置(11gR2新增检查项)#Network Time Protocol Setting/sbin/service ntpd stopchkconfig ntpd offrm /etc/ntp.confmv /etc/ntp.conf to /etc/ntp.conf.org/dev/shm 共享内存不足的处理解决方法：例如：为了将/dev/shm的大小增加到1GB，修改/etc/fstab的这行：默认的： none&&&& /dev/shm&&&&&& tmpfs&& defaults&&&&&&& 0 0改成： none&&&& /dev/shm&&&&&& tmpfs&& defaults,size=1024m&&&&&&& 0 0size参数也可以用G作单位：size＝1G。重新mount /dev/shm使之生效：# mount -o remount /dev/shm或者：# umount /dev/shm# mount -a马上可以用"df -h"命令检查变化。
修改gird、oracle用户的.bash_profile文件：#grid 用户配置文件 ORACLE_HOSTNAME请自行设置TMP=/ export TMPTMPDIR=$TMP; export TMPDIRORACLE_SID=+ASM1; export ORACLE_SIDORACLE_BASE=/oracle/app/ export ORACLE_BASEORACLE_HOME=/oracle/app/grid/product/11.2.0; export ORACLE_HOMENLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMATTHREADS_FLAG= export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATHTHREADS_FLAG= export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATHif [ $USER = "oracle" ] || [ $USER = "grid" ]; then&&&&&&& if [ $SHELL = "/bin/ksh" ]; then&&&&&&&&&&& ulimit -p 16384&&&&&&&&&&&&& ulimit -n 65536& else&& ulimit -u 16384 -n 65536&&&&& fi&&& umask 022fi
#oracle用户配置文件 ORACLE_HOSTNAME请自行设置# Oracle Settings oracleTMP=/ export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/oracle/app/ export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOMEORACLE_SID=racdb1; export ORACLE_SIDORACLE_TERM= export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/ export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/ export CLASSPATHNLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMATNLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANGif [ $USER = "oracle" ] || [ $USER = "grid" ]; then&&&&&&& if [ $SHELL = "/bin/ksh" ]; then&&&&&&&& ulimit -p 16384&&&&&&&&&&&&& ulimit -n 65536&&&&&&& else&&&&&&&&&&&&& ulimit -u 16384 -n 65536&&&&&&& fi&&&&&&& umask 022fi
配置信任关系设置SSH，1).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙# ping rac2-eth0# ping rac2-eth1# su - oracle$ mkdir ~/.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa2).在副节点RAC2、RAC3上执行相同的操作，确保通信无阻# ping rac1-eth0# ping rac1-eth1# su - oracle$ mkdir ~/.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa3).在主节点RAC1上oracle用户执行以下操作$ cat ~/.ssh/id_rsa.pub && ./.ssh/authorized_keys$ cat ~/.ssh/id_dsa.pub && ./.ssh/authorized_keys$ ssh rac2 cat ~/.ssh/id_rsa.pub && ~/.ssh/authorized_keys$ ssh rac2 cat ~/.ssh/id_dsa.pub && ~/.ssh/authorized_keys$ scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys4).主节点RAC1上执行检验操作$ ssh rac1 date$ ssh rac2 date$ ssh rac3 date$ ssh rac1priv date$ ssh rac2priv date$ ssh rac3priv date
5).在副节点RAC2上执行检验操作$ ssh rac1 date$ ssh rac2 date$ ssh rac3 date$ ssh rac1priv date$ ssh rac2priv date$ ssh rac3priv date
安装ASMoracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpmoracleasmlib-2.0.4-1.el5.i386.rpmoracleasm-support-2.1.3-1.el5.i386.rpm
格式化硬盘
Disk /dev/sdd: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdd1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sde: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sde1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sdf: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdf1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sdg: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdg1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdh: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdh1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdi: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdi1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdj: 5368 MB,
bytes255 heads, 63 sectors/track, 652 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdj1&&&&&&&&&&&&&& 1&&&&&&&& 652&&&& 5237158+& 83& LinuxDisk /dev/sdk: 5368 MB,
bytes255 heads, 63 sectors/track, 652 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdk1&&&&&&&&&&&&&& 1&&&&&&&& 652&&&& 5237158+& 83& Linux
[root@ora1 ~]# /etc/init.d/oracleasm& configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver.& The following questions will determine whether the driver isloaded on boot and what permissions it will have.& The current valueswill be shown in brackets ('[]').& Hitting &ENTER& without typing ananswer will keep that current value.& Ctrl-C will abort.Default user to own the driver interface []: gridDefault group to own the driver interface []: asmadminStart Oracle ASM library driver on boot (y/n) [n]: yScan for Oracle ASM disks on boot (y/n) [y]: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [& OK& ]Scanning the system for Oracle ASMLib disks: [& OK& ]
创建asm盘&&& +CRS&&&&&&& 三个2G的盘+DGDATA&&&& 三个10G的盘+DGRECOVERY 两个5G的盘/dev/sdd:&& 2097152/dev/sde:&& 2097152/dev/sdf:&& 2097152/dev/sdg:& /dev/sdh:& /dev/sdi:& /dev/sdj:&& 5242880/dev/sdk:&& 5242880[root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS1 /dev/sdd1Marking disk "CRS1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS2 /dev/sde1Marking disk "CRS2" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS3 /dev/sdf1Marking disk "CRS3" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1 Marking disk "DATA1" as an ASM disk: [FAILED][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1Marking disk "DATA1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA2 /dev/sdh1Marking disk "DATA2" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA3 /dev/sdi1Marking disk "DATA3" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk REC1 /dev/sdj1Marking disk "REC1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk REC2 /dev/sdk1Marking disk "REC2" as an ASM disk: [& OK& ]
[root@ora2 asm]# /etc/init.d/oracleasm scandisks&&&&&&&&&&&&&&& Scanning the system for Oracle ASMLib disks: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm listdisksCRS1CRS2CRS3DATA1DATA2DATA3REC1REC2安装cvuqdisk包并验证在两个 Oracle RAC 节点上安装操作系统程序包 cvuqdisk。如果没有 cvuqdisk，集群验证实用程序就无法发现共享磁盘，当运行（手动运行或在 Oracle Grid Infrastructure 安装结束时自动运行）集群验证实用程序时，您会收到这样的错误消息：“Package cvuqdisk not installed”。使用适用于您的硬件体系结构（例如，x86_64 或 i386）的 cvuqdisk RPM。 cvuqdisk RPM 包含在 Oracle Grid Infrastructure 安装介质上的 rpm 目录中。设置环境变量 CVUQDISK_GRP，使其指向作为 cvuqdisk 的所有者所在的组（本文为 oinstall）：export CVUQDISK_GRP=oinstall使用 CVU 验证是否满足 Oracle 集群件要求记住要作为 grid 用户在将要执行 Oracle 安装的节点 (racnode1) 上运行。此外，必须为 grid 用户配置通过用户等效性实现的 SSH 连通性。
在grid软件目录里运行以下命令：./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbosePerforming pre-checks for cluster services setup Checking node reachability...
检查过程省略...
使用 CVU 验证硬件和操作系统设置./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbose[grid@rac1 grid]$ ./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbosePerforming post-checks for hardware and operating system setup Checking node reachability...
检查过程省略...
6、su - grid./runInstallerscan配置：cluster scan: sanclustersscanname:& racscanscanport:& 1521
/oracle/app/oraInventory/orainstRoot.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.
/oracle/app/grid/product/11.2.0/root.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: && Copying dbhome to /usr/local/bin ...&& Copying oraenv to /usr/local/bin ...&& Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 16:19:03: Parsing the host name 16:19:03: Checking for super user privileges 16:19:03: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.& root wallet& root wallet cert& root cert export& peer wallet& profile reader wallet& pa wallet& peer wallet keys& pa wallet keys& peer cert request& pa cert request& peer cert& pa cert& peer root cert TP& profile reader root cert TP& pa root cert TP& peer pa cert TP& pa peer cert TP& profile reader pa cert TP& profile reader peer cert TP& peer user cert& pa user certAdding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededASM created and started successfully.DiskGroup CRS created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-4256: Updating the profileSuccessful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.Successfully replaced voting disk group with +CRS.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS]Located 1 voting disk(s).CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'CRS-2677: Stop of 'ora.crsd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac1'CRS-2677: Stop of 'ora.cssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac1'CRS-2676: Start of 'ora.evmd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeededCRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeededrac1&&&&
16:31:27&&&& /oracle/app/grid/product/11.2.0/cdata/rac1/backup_127.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 971 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 14:32:28: Parsing the host name 14:32:28: Checking for super user privileges 14:32:28: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterCRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac2'CRS-2676: Start of 'ora.gipcd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac2'CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac2'CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'CRS-2676: Start of 'ora.diskmon' on 'rac2' succeededCRS-2676: Start of 'ora.cssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac2'CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'CRS-2676: Start of 'ora.drivers.acfs' on 'rac2' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac2'CRS-2676: Start of 'ora.asm' on 'rac2' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac2'CRS-2676: Start of 'ora.crsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac2'CRS-2676: Start of 'ora.evmd' on 'rac2' succeededrac2&&&&
14:37:51&&&& /oracle/app/grid/product/11.2.0/cdata/rac2/backup_751.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 1202 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[grid@rac2 ~]$ srvctl enable oc4jPRKO-2116 : OC4J is already enabled[grid@rac2 ~]$ srvctl start oc4j[grid@rac2 ~]$ srvctl enable nodeappsPRKO-2415 : VIP is already enabled on node(s): rac1,rac2PRKO-2416 : Network resource is already enabled.PRKO-2417 : ONS is already enabled on node(s): rac1,rac2PRKO-2418 : eONS is already enabled on node(s): rac1,rac2[grid@rac2 ~]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac1& 6、su - grid./runInstallerscan配置：cluster scan: sanclustersscanname:& racscanscanport:& 1521
/oracle/app/oraInventory/orainstRoot.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.
/oracle/app/grid/product/11.2.0/root.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: && Copying dbhome to /usr/local/bin ...&& Copying oraenv to /usr/local/bin ...&& Copying coraenv to /usr/local/bin ...
[ 本帖最后由 mfkqwyc86 于
07:53 编辑 ]
Oracle, 实验, Linux, 安装, 配置 收藏17 相关帖子 本版精华 SAP 客户的其他应收款如何做？需要配置什么吗?生成的科目是什么？ Oracle PL/SQL程序设计 下 第5版 张晓明[PDF][高清][书签] 如何手动产生一个日志 oracle9i rman备份是否支持异构恢复 关于oracle RMAN的几个问题 年薪20-70万 股票期权 上海美企多个Linux C++ C 开发职位 Intel,IBM,SAP,Oracle,Autodesk,个大猎头最新职位列表及福利待遇介绍 请教各位大神，哪里可以下载到Oracle 10 g 的Sparc版 Intel,IBM,SAP,Oracle,Autodesk,个大猎头最新职位列表及福利待遇介绍 给T5120安装Oracle 10出现问题，请教高手帮助。 【编辑中，希望大家多提意见，谢谢】优化资料~已经整理成了pdf文件，pub上的好的优化 无私奉献 企业级DBA--学习手册(中文版)体系结构,性能优化 突然35岁：捡点我的职业生涯 个人BLOG文章索引 itpub知识索引树-hanganalyze 使用总结 即将辞职的DBA，回顾我的DBA之路 本地表空间管理可以避免产生碎片？ ITPUB知识索引贴——物化视图 在web网站中大量采用存储过程性能讨论 [三思笔记]-手把手教你用vmware安装oracle10g RAC ################################################################################################君子务本，本立而道生。---mfkqwyc86,飞鹰工作室ITPUT个人空间：
-----------------------------------------------------------01.【Oracle RAC】Linux + Oracle 11g R2 RAC 安装配置详细过程& 02.【Oracle RAC】Oracle RAC更改VIP IP地址_2节点的实验& 03.【Oracle RAC】Oracle RAC删除一个节点_3节点的实验& 04.【Oracle RAC】Oracle RAC增加一个节点_3节点的实验& 05.【Oracle RAC+DG】Oracle RAC+ASM+DataGuard配置实验记录& 06.【Oracle RAC】Oracle RAC CRS、OCR、Voting破坏重建& 07.【Oracle 表分区管理】Oracle Partition表分区与分区索引几种方式的实验操作08.【IBM DB2表空间管理】db2表空间管理—实例讲解之精华& 09.【IBM DB2补丁升级】从v9.5.0.1升级到DB2 v9.5.0.6& 10.【中间件资料下载汇总】WebSphere,MQ,Portal,WebLogic资料下载汇总【PDF格式-共53类】&
&使用道具 举报 提升卡&置顶卡&变色卡&显身卡图灵社区出杂志了：码农！& |& 有关rpm的问题。跪求& |& 为什么这个命令会报错& |& 寻找服务器系统&&& &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 2# &发表于
09:54:29 |只看该作者 Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 16:19:03: Parsing the host name 16:19:03: Checking for super user privileges 16:19:03: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.& root wallet& root wallet cert& root cert export& peer wallet& profile reader wallet& pa wallet& peer wallet keys& pa wallet keys& peer cert request& pa cert request& peer cert& pa cert& peer root cert TP& profile reader root cert TP& pa root cert TP& peer pa cert TP& pa peer cert TP& profile reader pa cert TP& profile reader peer cert TP& peer user cert& pa user certAdding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededASM created and started successfully.DiskGroup CRS created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-4256: Updating the profileSuccessful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.Successfully replaced voting disk group with +CRS.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS]Located 1 voting disk(s).CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'CRS-2677: Stop of 'ora.crsd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac1'CRS-2677: Stop of 'ora.cssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac1'CRS-2676: Start of 'ora.evmd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeededCRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeededrac1&&&&
16:31:27&&&& /oracle/app/grid/product/11.2.0/cdata/rac1/backup_127.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 971 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 14:32:28: Parsing the host name 14:32:28: Checking for super user privileges 14:32:28: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterCRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac2'CRS-2676: Start of 'ora.gipcd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac2'CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac2'CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'CRS-2676: Start of 'ora.diskmon' on 'rac2' succeededCRS-2676: Start of 'ora.cssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac2'CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'CRS-2676: Start of 'ora.drivers.acfs' on 'rac2' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac2'CRS-2676: Start of 'ora.asm' on 'rac2' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac2'CRS-2676: Start of 'ora.crsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac2'CRS-2676: Start of 'ora.evmd' on 'rac2' succeededrac2&&&&
14:37:51&&&& /oracle/app/grid/product/11.2.0/cdata/rac2/backup_751.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 1202 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[grid@rac2 ~]$ srvctl enable oc4jPRKO-2116 : OC4J is already enabled[grid@rac2 ~]$ srvctl start oc4j[grid@rac2 ~]$ srvctl enable nodeappsPRKO-2415 : VIP is already enabled on node(s): rac1,rac2PRKO-2416 : Network resource is already enabled.PRKO-2417 : ONS is already enabled on node(s): rac1,rac2PRKO-2418 : eONS is already enabled on node(s): rac1,rac2[grid@rac2 ~]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac1&
资源组状态:crsctl status resource -t[grid@rac2 ~]$ crsctl status resource -t
NAME&&&&&&&&&& TARGET& STATE&&&&&&& SERVER&&&&&&&&&&&&&&&&&& STATE_DETAILS&&&&&& Local Resourcesora.CRS.dg&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.LISTENER.lsnr&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.asm&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& ora.eons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.gsd&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.net1.network&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.ons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.registry.acfs&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Cluster Resources
ora.LISTENER_SCAN1.lsnr&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.oc4j&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac2.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.scan1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& && 检查集群节点:olsnodes -l检查 Oracle 集群注册表 (OCR):ocrcheck[grid@rac1 ~]$& ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check succeeded&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&& Cluster registry integrity check succeeded&&&&&&&& Logical corruption check bypassed due to non-privileged user&& && [grid@rac2 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check failed&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&& Cluster registry integrity check failed&&&&&&&& Logical corruption check bypassed due to insufficient quorum检查表决磁盘:crsctl query css votedisk[grid@rac1 ~]$ crsctl query css votedisk##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& 589cfecbff651e64eeb281a (ORCL:CRS1) [CRS]Located 1 voting disk(s).
Oc4j,gsd服务默认是disable的，如果要启动，启用即可[node1:grid]srvctl status oc4jOC4J is disabled[node1: grid]srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node: node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2eONS is enabledeONS daemon is running on node: node1eONS daemon is running on node: node2[node1:grid]$srvctl enable oc4j[node1:grid]$srvctl start oc4j[node1:grid]$srvctl enable nodeapps[node1:grid]$srvctl start nodeapps重启grid cluster
为数据和快速恢复区创建 ASM 磁盘组:asmca
su - oracle./runInstaller[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= oracle&&& ORACLE_HOME=& /oracle/app/oracle/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@rac2 ~]# crs_stat -tSQL&Database log mode&&&&&&&&&&&&& Archive ModeAutomatic archival&&&&&&&&&&&& EnabledArchive destination&&&&&&&&&&& USE_DB_RECOVERY_FILE_DESTOldest online log sequence&&&& 11Next log sequence to archive&& 12Current log sequence&&&&&&&&&& 12
SQL& select max(sequence#) from v$archived_log
col NAME format a80
SQL&& select SEQUENCE#,NAME,FIRST_TIME, NEXT_TIME FROM v$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE#& NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& FIRST_TIME&& NEXT_TIME---------- -----------------------------&&&&&&& 11 +DG_RECOVERY/racdb/archivelog//thread_2_seq_11.257.&&&&&&&&&& 18-MAY-10&&& 18-MAY-10
--查看归档丢失的情况：
SELECT THREAD#,LOW_SEQUENCE#,HIGH_SEQUENCE# from v$archive_
--启动闪回
alter system set db_recovery_file_dest_size=2g scope=
alter system set db_recovery_file_dest='+DG_RECOVERY' scope=
alter database flashback ON;
SQL& show parameter recovery&&
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest&&&&&&&&&&&&&&& string&&&&& +DG_RECOVERYdb_recovery_file_dest_size&&&&&&&&&& big integer 2Grecovery_parallelism&&&&&&&&&&&&&&&& integer&&&& 0
[ 本帖最后由 mfkqwyc86 于
10:31 编辑 ] &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 3# &发表于
09:55:01 |只看该作者 tnsnames:& & RACDB1 =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (INSTANCE_NAME = racdb1)&&& )& )
RACDB =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))&&& (LOAD_BALANCE = yes)&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (FAILOVER_MODE =&&&&&&& (TYPE = SELECT)&&&&&&& (METHOD = BASIC)&&&&&&& (RETRIES = 180)&&&&&&& (DELAY = 5)&&&&& )&&& )& )
LISTENERS_RACDB =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))& )& LISTENERS_RACDB1 =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))& )
LISTENERS_RACDB2 =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))& )& & EXTPROC_CONNECTION_DATA =& (DESCRIPTION =&&& (ADDRESS_LIST =&&&&& (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))&&& )&&& (CONNECT_DATA =&&&&& (SID = PLSExtProc)&&&&& (PRESENTATION = RO)&&& )& )
RACDB2 =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (INSTANCE_NAME = racdb2)&&& )& )& & alter system set LOCAL_LISTENER = 'LISTENERS_RACDB1' scope=both sid='racdb1';alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb1';
alter system set LOCAL_LISTENER = 'LISTENERS_RACDB2' scope=both sid='racdb2';alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb2';
############################################10、配置启动归档及闪回
--先配归档才可以启动闪回
alter system set cluster_database=false scope=spfile
#alter system set db_recovery_file_dest='D:\oracle\flashdb' scope=
startup mount
alter system set cluster_database=true scope=spfile
startup &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 4# &发表于
09:55:38 |只看该作者 [root@rac2 ~]# crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.racdb.db&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b1.inst application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b2.inst application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....db_s.cs application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db1.srv application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db2.srv application&&& ONLINE&&& ONLINE&&& rac2&&&&&&&
与之前不同service名后，则数据库会自己变为新的service名字，如下：
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE------------------------------------ ----------- ------------------------------service_names&&&&&&&&&&&&&&&&&&&&&&& string&&&&& racdb_s
7、crs_stat -t
[oracle@rac2 bin]$ crs_stat -t&&&&&&&&&&&& Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&&
ALTER DISKGROUP RACDISK DROP DISK RACDISK_0001 REBALANCE POWER 11;
8、rac status
[oracle@rac2 bin]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.racdb.db&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....acdb.cs application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db1.srv application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db2.srv application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....b1.inst application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b2.inst application&&& ONLINE&&& ONLINE&&& rac2&&&&&
############################################9、listener.ora与tnsnames.ora
listener.ora:
LISTENER_RAC1 =& (DESCRIPTION_LIST =&&& (DESCRIPTION =&&&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521)(IP = FIRST))&&&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521)(IP = FIRST))&&& )& )
SID_LIST_LISTENER_RAC1 =& (SID_LIST =&&& (SID_DESC =&&&&& (SID_NAME = PLSExtProc)&&&&& (ORACLE_HOME = /oracle/app/product/10.2.0/db_1)&&&&& (PROGRAM = extproc)&&& )& ) &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 5# &发表于
09:56:19 |只看该作者 Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.DGDATA.dg& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....VERY.dg ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac2
su - oracle./dbca
手工配置services
(命令注册不能用与ＤＢ相同的service名)
srvctl add service -d &name& -s &service_name& -r &&preferred_list&& [-a &&available_list&&] [-P &TAF_policy&]
[root@rac1 backup]# srvctl add service -h&& Usage: srvctl add service -d &name& -s &service_name& -r &&preferred_list&& [-a &&available_list&&] [-P &TAF_policy&]&&& -d &name&&&&&&&&&&& Unique name for the database&&& -s &service&&&&&&&& Service name&&& -r &&pref_list&&&&& List of preferred instances&&& -a &&avail_list&&&& List of available instances&&& -P &TAF_policy&&&&& TAF policy (NONE, BASIC, or PRECONNECT)Usage: srvctl add service -d &name& -s &service_name& -u {-r &&new_pref_inst&& | -a &&new_avail_inst&&}&&& -d &name&&&&&&&&&&& Unique name for the database&&& -s &service&&&&&&&& Service name&&& -u&&&&&&&&&&&&&&&&& Add a new instance to service configuration&&& -r &new_pref_inst&& Name of new preferred instance&&& -a &new_avail_inst& Name of new available instance&&& -h&&&&&&&&&&&&&&&&& Print usage
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s racdb1 -a racdb2 -P BASIC
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s -r racdb1,racdb2 -P BASIC (建议) &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 6# &发表于
09:58:06 |只看该作者 su - oracle./runInstaller
[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.shRunning Oracle 11g root.sh script...
The following environment variables are set as:&&& ORACLE_OWNER= oracle&&& ORACLE_HOME=& /oracle/app/oracle/product/11.2.0
Enter the full pathname of the local bin directory: [/usr/local/bin]: The file &dbhome& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file &oraenv& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file &coraenv& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.
[root@rac2 ~]# crs_stat -t &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 7# &发表于
09:59:26 |只看该作者 检查集群节点:olsnodes -l
检查 Oracle 集群注册表 (OCR):
[grid@rac1 ~]$& ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check succeeded
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&& Cluster registry integrity check succeeded
&&&&&&&& Logical corruption check bypassed due to non-privileged user
&&&&&&&&&&&&&&&& &&&&&&&&&&&&&&&& [grid@rac2 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check failed
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&& Cluster registry integrity check failed
&&&&&&&& Logical corruption check bypassed due to insufficient quorum
检查表决磁盘:
crsctl query css votedisk
[grid@rac1 ~]$ crsctl query css votedisk##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& 589cfecbff651e64eeb281a (ORCL:CRS1) [CRS]Located 1 voting disk(s).
Oc4j,gsd服务默认是disable的，如果要启动，启用即可[node1:grid]srvctl status oc4jOC4J is disabled
[node1: grid]srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node: node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2eONS is enabledeONS daemon is running on node: node1eONS daemon is running on node: node2
[node1:grid]$srvctl enable oc4j[node1:grid]$srvctl start oc4j[node1:grid]$srvctl enable nodeapps[node1:grid]$srvctl start nodeapps
重启grid cluster
为数据和快速恢复区创建 ASM 磁盘组:asmca &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 8# &发表于
10:00:22 |只看该作者 资源组状态:crsctl status resource -t
[grid@rac2 ~]$ crsctl status resource -t--------------------------------------------------------------------------------NAME&&&&&&&&&& TARGET& STATE&&&&&&& SERVER&&&&&&&&&&&&&&&&&& STATE_DETAILS&&&&&& --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.CRS.dg&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.LISTENER.lsnr&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.asm&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& ora.eons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.gsd&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.net1.network&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.ons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.registry.acfs&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.oc4j&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac2.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.scan1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1 &
TA的最新馆藏[转]&[转]&
喜欢该文的人也喜欢}
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna%Ymd%.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho%Ymd%.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:\crontab\mysql\sql\%Ymd%D:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 anna & E:\crontab\mysql\sql\%Ymd%\bbs_anna%Ymd%.sqlD:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump --opt -u root --password=123456 typecho & E:\crontab\mysql\sql\%Ymd%\bbs_typecho%Ymd%.sql@echo on
只要新建一个目录就可以了，根据你的文件修改如下：@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"mkdir E:crontabmysqlsql%Ymd%D:wampbinmysqlmysql5.5.24binmysqldump --opt -u root --password=123456 anna & E:crontabmysqlsql%Ymd%bbs_anna%Ymd%.sqlD:wampbinmysqlmysql5.5.24binmysqldump --opt -u root --password=123456 typecho & E:crontabmysqlsql%Ymd%bbs_typecho%Ymd%.sql@echo on
我要该，理由是：Linux + Oracle 11g R2 RAC 安装配置详细过程
我的图书馆
Linux + Oracle 11g R2 RAC 安装配置详细过程
Oracle Linux AS 5.5两台Oracle 11g R21、IP规划127.0.0.1 localhost.localdomain localhost#public ip192.168.10.211& rac1192.168.10.212 rac2#priv ip10.10.10.211& rac1prv10.10.10.212 rac2prv#vip ip192.168.10.213& rac1vip192.168.10.214 rac2vip#scan ip192.168.10.215& racscan2、磁盘规划&&& +CRS&&&&&&& 三个2G的盘+DGDATA&&&& 三个10G的盘+DGRECOVERY 两个5G的盘/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 oper/usr/sbin/groupadd -g 504 asmadmin/usr/sbin/groupadd -g 505 asmoper/usr/sbin/groupadd -g 506 asmdba/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid[root@ora1 ~]# id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)[root@ora1 ~]# id griduid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)mkdir /oracle/app/chown -R grid:oinstall /oracle/app/chmod -R 775 /oracle/app/mkdir -p /oracle/app/oraInventorychown -R grid:oinstall /oracle/app/oraInventorychmod -R 775 /oracle/app/oraInventorymkdir -p /oracle/app/gridmkdir -p /oracle/app/oraclechown -R grid:oinstall /oracle/app/gridchown -R oracle:oinstall /oracle/app/oraclechmod -R 775 /oracle/app/oraclechmod -R 775 /oracle/app/grid
passwd gridpasswd oracle2、操作系统版本：[root@rac1 ~]# lsb_release -aLSB Version:&&& :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarchDistributor ID: EnterpriseEnterpriseServerDescription:&&& Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)Release:&&&&&&& 5.5Codename:&&&&&& Carthage[root@rac1 ~]# uname -aLinux rac1 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT
i686 i386 GNU/Linux[root@rac1 ~]# 修改系统参数：vi /etc/security/limits.conf#ORACLE SETTINGgrid&&&&&&&&&&&&&&&& soft&&& nproc&& 2047 grid&&&&&&&&&&&&&&&& hard&&& nproc&& 16384grid&&&&&&&&&&&&&&&& soft&&& nofile& 1024grid&&&&&&&&&&&&&&&& hard&&& nofile& 65536oracle&&&&&&&&&&&&&& soft&&& nproc&& 2047oracle&&&&&&&&&&&&&& hard&&& nproc&& 16384oracle&&&&&&&&&&&&&& soft&&& nofile& 1024oracle&&&&&&&&&&&&&& hard&&& nofile& 65536
vi /etc/pam.d/login#ORACLE SETTINGsession&&& required&&&& pam_limits.so# vi /etc/sysctl.conf#ORACLE SETTINGfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 8net.ipv4.ip_local_port_range = net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586
gird时间同步所需要的设置(11gR2新增检查项)#Network Time Protocol Setting/sbin/service ntpd stopchkconfig ntpd offrm /etc/ntp.confmv /etc/ntp.conf to /etc/ntp.conf.org/dev/shm 共享内存不足的处理解决方法：例如：为了将/dev/shm的大小增加到1GB，修改/etc/fstab的这行：默认的： none&&&& /dev/shm&&&&&& tmpfs&& defaults&&&&&&& 0 0改成： none&&&& /dev/shm&&&&&& tmpfs&& defaults,size=1024m&&&&&&& 0 0size参数也可以用G作单位：size＝1G。重新mount /dev/shm使之生效：# mount -o remount /dev/shm或者：# umount /dev/shm# mount -a马上可以用"df -h"命令检查变化。
修改gird、oracle用户的.bash_profile文件：#grid 用户配置文件 ORACLE_HOSTNAME请自行设置TMP=/ export TMPTMPDIR=$TMP; export TMPDIRORACLE_SID=+ASM1; export ORACLE_SIDORACLE_BASE=/oracle/app/ export ORACLE_BASEORACLE_HOME=/oracle/app/grid/product/11.2.0; export ORACLE_HOMENLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMATTHREADS_FLAG= export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATHTHREADS_FLAG= export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATHif [ $USER = "oracle" ] || [ $USER = "grid" ]; then&&&&&&& if [ $SHELL = "/bin/ksh" ]; then&&&&&&&&&&& ulimit -p 16384&&&&&&&&&&&&& ulimit -n 65536& else&& ulimit -u 16384 -n 65536&&&&& fi&&& umask 022fi
#oracle用户配置文件 ORACLE_HOSTNAME请自行设置# Oracle Settings oracleTMP=/ export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/oracle/app/ export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOMEORACLE_SID=racdb1; export ORACLE_SIDORACLE_TERM= export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/ export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/ export CLASSPATHNLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMATNLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANGif [ $USER = "oracle" ] || [ $USER = "grid" ]; then&&&&&&& if [ $SHELL = "/bin/ksh" ]; then&&&&&&&& ulimit -p 16384&&&&&&&&&&&&& ulimit -n 65536&&&&&&& else&&&&&&&&&&&&& ulimit -u 16384 -n 65536&&&&&&& fi&&&&&&& umask 022fi
配置信任关系设置SSH，1).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙# ping rac2-eth0# ping rac2-eth1# su - oracle$ mkdir ~/.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa2).在副节点RAC2、RAC3上执行相同的操作，确保通信无阻# ping rac1-eth0# ping rac1-eth1# su - oracle$ mkdir ~/.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa3).在主节点RAC1上oracle用户执行以下操作$ cat ~/.ssh/id_rsa.pub && ./.ssh/authorized_keys$ cat ~/.ssh/id_dsa.pub && ./.ssh/authorized_keys$ ssh rac2 cat ~/.ssh/id_rsa.pub && ~/.ssh/authorized_keys$ ssh rac2 cat ~/.ssh/id_dsa.pub && ~/.ssh/authorized_keys$ scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys4).主节点RAC1上执行检验操作$ ssh rac1 date$ ssh rac2 date$ ssh rac3 date$ ssh rac1priv date$ ssh rac2priv date$ ssh rac3priv date
5).在副节点RAC2上执行检验操作$ ssh rac1 date$ ssh rac2 date$ ssh rac3 date$ ssh rac1priv date$ ssh rac2priv date$ ssh rac3priv date
安装ASMoracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpmoracleasmlib-2.0.4-1.el5.i386.rpmoracleasm-support-2.1.3-1.el5.i386.rpm
格式化硬盘
Disk /dev/sdd: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdd1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sde: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sde1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sdf: 2147 MB,
bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdf1&&&&&&&&&&&&&& 1&&&&&&&& 261&&&& 2096451&& 83& LinuxDisk /dev/sdg: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdg1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdh: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdh1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdi: 10.7 GB,
bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdi1&&&&&&&&&&&&&& 1&&&&&&& 1305&&& && 83& LinuxDisk /dev/sdj: 5368 MB,
bytes255 heads, 63 sectors/track, 652 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdj1&&&&&&&&&&&&&& 1&&&&&&&& 652&&&& 5237158+& 83& LinuxDisk /dev/sdk: 5368 MB,
bytes255 heads, 63 sectors/track, 652 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes&& Device Boot&&&&& Start&&&&&&&& End&&&&& Blocks&& Id& System/dev/sdk1&&&&&&&&&&&&&& 1&&&&&&&& 652&&&& 5237158+& 83& Linux
[root@ora1 ~]# /etc/init.d/oracleasm& configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver.& The following questions will determine whether the driver isloaded on boot and what permissions it will have.& The current valueswill be shown in brackets ('[]').& Hitting &ENTER& without typing ananswer will keep that current value.& Ctrl-C will abort.Default user to own the driver interface []: gridDefault group to own the driver interface []: asmadminStart Oracle ASM library driver on boot (y/n) [n]: yScan for Oracle ASM disks on boot (y/n) [y]: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [& OK& ]Scanning the system for Oracle ASMLib disks: [& OK& ]
创建asm盘&&& +CRS&&&&&&& 三个2G的盘+DGDATA&&&& 三个10G的盘+DGRECOVERY 两个5G的盘/dev/sdd:&& 2097152/dev/sde:&& 2097152/dev/sdf:&& 2097152/dev/sdg:& /dev/sdh:& /dev/sdi:& /dev/sdj:&& 5242880/dev/sdk:&& 5242880[root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS1 /dev/sdd1Marking disk "CRS1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS2 /dev/sde1Marking disk "CRS2" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS3 /dev/sdf1Marking disk "CRS3" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1 Marking disk "DATA1" as an ASM disk: [FAILED][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1Marking disk "DATA1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA2 /dev/sdh1Marking disk "DATA2" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA3 /dev/sdi1Marking disk "DATA3" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk REC1 /dev/sdj1Marking disk "REC1" as an ASM disk: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm createdisk REC2 /dev/sdk1Marking disk "REC2" as an ASM disk: [& OK& ]
[root@ora2 asm]# /etc/init.d/oracleasm scandisks&&&&&&&&&&&&&&& Scanning the system for Oracle ASMLib disks: [& OK& ][root@ora2 asm]# /etc/init.d/oracleasm listdisksCRS1CRS2CRS3DATA1DATA2DATA3REC1REC2安装cvuqdisk包并验证在两个 Oracle RAC 节点上安装操作系统程序包 cvuqdisk。如果没有 cvuqdisk，集群验证实用程序就无法发现共享磁盘，当运行（手动运行或在 Oracle Grid Infrastructure 安装结束时自动运行）集群验证实用程序时，您会收到这样的错误消息：“Package cvuqdisk not installed”。使用适用于您的硬件体系结构（例如，x86_64 或 i386）的 cvuqdisk RPM。 cvuqdisk RPM 包含在 Oracle Grid Infrastructure 安装介质上的 rpm 目录中。设置环境变量 CVUQDISK_GRP，使其指向作为 cvuqdisk 的所有者所在的组（本文为 oinstall）：export CVUQDISK_GRP=oinstall使用 CVU 验证是否满足 Oracle 集群件要求记住要作为 grid 用户在将要执行 Oracle 安装的节点 (racnode1) 上运行。此外，必须为 grid 用户配置通过用户等效性实现的 SSH 连通性。
在grid软件目录里运行以下命令：./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbosePerforming pre-checks for cluster services setup Checking node reachability...
检查过程省略...
使用 CVU 验证硬件和操作系统设置./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbose[grid@rac1 grid]$ ./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbosePerforming post-checks for hardware and operating system setup Checking node reachability...
检查过程省略...
6、su - grid./runInstallerscan配置：cluster scan: sanclustersscanname:& racscanscanport:& 1521
/oracle/app/oraInventory/orainstRoot.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.
/oracle/app/grid/product/11.2.0/root.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: && Copying dbhome to /usr/local/bin ...&& Copying oraenv to /usr/local/bin ...&& Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 16:19:03: Parsing the host name 16:19:03: Checking for super user privileges 16:19:03: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.& root wallet& root wallet cert& root cert export& peer wallet& profile reader wallet& pa wallet& peer wallet keys& pa wallet keys& peer cert request& pa cert request& peer cert& pa cert& peer root cert TP& profile reader root cert TP& pa root cert TP& peer pa cert TP& pa peer cert TP& profile reader pa cert TP& profile reader peer cert TP& peer user cert& pa user certAdding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededASM created and started successfully.DiskGroup CRS created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-4256: Updating the profileSuccessful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.Successfully replaced voting disk group with +CRS.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS]Located 1 voting disk(s).CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'CRS-2677: Stop of 'ora.crsd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac1'CRS-2677: Stop of 'ora.cssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac1'CRS-2676: Start of 'ora.evmd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeededCRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeededrac1&&&&
16:31:27&&&& /oracle/app/grid/product/11.2.0/cdata/rac1/backup_127.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 971 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 14:32:28: Parsing the host name 14:32:28: Checking for super user privileges 14:32:28: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterCRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac2'CRS-2676: Start of 'ora.gipcd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac2'CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac2'CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'CRS-2676: Start of 'ora.diskmon' on 'rac2' succeededCRS-2676: Start of 'ora.cssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac2'CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'CRS-2676: Start of 'ora.drivers.acfs' on 'rac2' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac2'CRS-2676: Start of 'ora.asm' on 'rac2' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac2'CRS-2676: Start of 'ora.crsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac2'CRS-2676: Start of 'ora.evmd' on 'rac2' succeededrac2&&&&
14:37:51&&&& /oracle/app/grid/product/11.2.0/cdata/rac2/backup_751.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 1202 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[grid@rac2 ~]$ srvctl enable oc4jPRKO-2116 : OC4J is already enabled[grid@rac2 ~]$ srvctl start oc4j[grid@rac2 ~]$ srvctl enable nodeappsPRKO-2415 : VIP is already enabled on node(s): rac1,rac2PRKO-2416 : Network resource is already enabled.PRKO-2417 : ONS is already enabled on node(s): rac1,rac2PRKO-2418 : eONS is already enabled on node(s): rac1,rac2[grid@rac2 ~]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac1& 6、su - grid./runInstallerscan配置：cluster scan: sanclustersscanname:& racscanscanport:& 1521
/oracle/app/oraInventory/orainstRoot.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.
/oracle/app/grid/product/11.2.0/root.sh[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is complete.[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: && Copying dbhome to /usr/local/bin ...&& Copying oraenv to /usr/local/bin ...&& Copying coraenv to /usr/local/bin ...
[ 本帖最后由 mfkqwyc86 于
07:53 编辑 ]
Oracle, 实验, Linux, 安装, 配置 收藏17 相关帖子 本版精华 SAP 客户的其他应收款如何做？需要配置什么吗?生成的科目是什么？ Oracle PL/SQL程序设计 下 第5版 张晓明[PDF][高清][书签] 如何手动产生一个日志 oracle9i rman备份是否支持异构恢复 关于oracle RMAN的几个问题 年薪20-70万 股票期权 上海美企多个Linux C++ C 开发职位 Intel,IBM,SAP,Oracle,Autodesk,个大猎头最新职位列表及福利待遇介绍 请教各位大神，哪里可以下载到Oracle 10 g 的Sparc版 Intel,IBM,SAP,Oracle,Autodesk,个大猎头最新职位列表及福利待遇介绍 给T5120安装Oracle 10出现问题，请教高手帮助。 【编辑中，希望大家多提意见，谢谢】优化资料~已经整理成了pdf文件，pub上的好的优化 无私奉献 企业级DBA--学习手册(中文版)体系结构,性能优化 突然35岁：捡点我的职业生涯 个人BLOG文章索引 itpub知识索引树-hanganalyze 使用总结 即将辞职的DBA，回顾我的DBA之路 本地表空间管理可以避免产生碎片？ ITPUB知识索引贴——物化视图 在web网站中大量采用存储过程性能讨论 [三思笔记]-手把手教你用vmware安装oracle10g RAC ################################################################################################君子务本，本立而道生。---mfkqwyc86,飞鹰工作室ITPUT个人空间：
-----------------------------------------------------------01.【Oracle RAC】Linux + Oracle 11g R2 RAC 安装配置详细过程& 02.【Oracle RAC】Oracle RAC更改VIP IP地址_2节点的实验& 03.【Oracle RAC】Oracle RAC删除一个节点_3节点的实验& 04.【Oracle RAC】Oracle RAC增加一个节点_3节点的实验& 05.【Oracle RAC+DG】Oracle RAC+ASM+DataGuard配置实验记录& 06.【Oracle RAC】Oracle RAC CRS、OCR、Voting破坏重建& 07.【Oracle 表分区管理】Oracle Partition表分区与分区索引几种方式的实验操作08.【IBM DB2表空间管理】db2表空间管理—实例讲解之精华& 09.【IBM DB2补丁升级】从v9.5.0.1升级到DB2 v9.5.0.6& 10.【中间件资料下载汇总】WebSphere,MQ,Portal,WebLogic资料下载汇总【PDF格式-共53类】&
&使用道具 举报 提升卡&置顶卡&变色卡&显身卡图灵社区出杂志了：码农！& |& 有关rpm的问题。跪求& |& 为什么这个命令会报错& |& 寻找服务器系统&&& &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 2# &发表于
09:54:29 |只看该作者 Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 16:19:03: Parsing the host name 16:19:03: Checking for super user privileges 16:19:03: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.& root wallet& root wallet cert& root cert export& peer wallet& profile reader wallet& pa wallet& peer wallet keys& pa wallet keys& peer cert request& pa cert request& peer cert& pa cert& peer root cert TP& profile reader root cert TP& pa root cert TP& peer pa cert TP& pa peer cert TP& profile reader pa cert TP& profile reader peer cert TP& peer user cert& pa user certAdding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededASM created and started successfully.DiskGroup CRS created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-4256: Updating the profileSuccessful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.Successfully replaced voting disk group with +CRS.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS]Located 1 voting disk(s).CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'CRS-2677: Stop of 'ora.crsd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac1'CRS-2677: Stop of 'ora.cssd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac1'CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac1'CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'CRS-2676: Start of 'ora.diskmon' on 'rac1' succeededCRS-2676: Start of 'ora.cssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac1'CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac1'CRS-2676: Start of 'ora.crsd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac1'CRS-2676: Start of 'ora.evmd' on 'rac1' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac1'CRS-2676: Start of 'ora.asm' on 'rac1' succeededCRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeededCRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeededrac1&&&&
16:31:27&&&& /oracle/app/grid/product/11.2.0/cdata/rac1/backup_127.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 971 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= grid&&& ORACLE_HOME=& /oracle/app/grid/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 14:32:28: Parsing the host name 14:32:28: Checking for super user privileges 14:32:28: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsCreating trace directoryLOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'..Operation successful.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is startingCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterCRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gipcd' on 'rac2'CRS-2676: Start of 'ora.gipcd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'rac2'CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeededCRS-2672: Attempting to start 'ora.cssd' on 'rac2'CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'CRS-2676: Start of 'ora.diskmon' on 'rac2' succeededCRS-2676: Start of 'ora.cssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'rac2'CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'CRS-2676: Start of 'ora.drivers.acfs' on 'rac2' succeededCRS-2672: Attempting to start 'ora.asm' on 'rac2'CRS-2676: Start of 'ora.asm' on 'rac2' succeededCRS-2672: Attempting to start 'ora.crsd' on 'rac2'CRS-2676: Start of 'ora.crsd' on 'rac2' succeededCRS-2672: Attempting to start 'ora.evmd' on 'rac2'CRS-2676: Start of 'ora.evmd' on 'rac2' succeededrac2&&&&
14:37:51&&&& /oracle/app/grid/product/11.2.0/cdata/rac2/backup_751.olrConfigure Oracle Grid Infrastructure for a Cluster ... succeededUpdating inventory properties for clusterwareStarting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.&& Actual 1202 MB&&& PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory'UpdateNodeList' was successful.
[grid@rac2 ~]$ srvctl enable oc4jPRKO-2116 : OC4J is already enabled[grid@rac2 ~]$ srvctl start oc4j[grid@rac2 ~]$ srvctl enable nodeappsPRKO-2415 : VIP is already enabled on node(s): rac1,rac2PRKO-2416 : Network resource is already enabled.PRKO-2417 : ONS is already enabled on node(s): rac1,rac2PRKO-2418 : eONS is already enabled on node(s): rac1,rac2[grid@rac2 ~]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac1&
资源组状态:crsctl status resource -t[grid@rac2 ~]$ crsctl status resource -t
NAME&&&&&&&&&& TARGET& STATE&&&&&&& SERVER&&&&&&&&&&&&&&&&&& STATE_DETAILS&&&&&& Local Resourcesora.CRS.dg&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.LISTENER.lsnr&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.asm&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& ora.eons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.gsd&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.net1.network&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.ons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.registry.acfs&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Cluster Resources
ora.LISTENER_SCAN1.lsnr&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.oc4j&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac2.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.scan1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& && 检查集群节点:olsnodes -l检查 Oracle 集群注册表 (OCR):ocrcheck[grid@rac1 ~]$& ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check succeeded&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&& Cluster registry integrity check succeeded&&&&&&&& Logical corruption check bypassed due to non-privileged user&& && [grid@rac2 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check failed&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured&&&&&&&& Cluster registry integrity check failed&&&&&&&& Logical corruption check bypassed due to insufficient quorum检查表决磁盘:crsctl query css votedisk[grid@rac1 ~]$ crsctl query css votedisk##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& 589cfecbff651e64eeb281a (ORCL:CRS1) [CRS]Located 1 voting disk(s).
Oc4j,gsd服务默认是disable的，如果要启动，启用即可[node1:grid]srvctl status oc4jOC4J is disabled[node1: grid]srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node: node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2eONS is enabledeONS daemon is running on node: node1eONS daemon is running on node: node2[node1:grid]$srvctl enable oc4j[node1:grid]$srvctl start oc4j[node1:grid]$srvctl enable nodeapps[node1:grid]$srvctl start nodeapps重启grid cluster
为数据和快速恢复区创建 ASM 磁盘组:asmca
su - oracle./runInstaller[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:&&& ORACLE_OWNER= oracle&&& ORACLE_HOME=& /oracle/app/oracle/product/11.2.0Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@rac2 ~]# crs_stat -tSQL&Database log mode&&&&&&&&&&&&& Archive ModeAutomatic archival&&&&&&&&&&&& EnabledArchive destination&&&&&&&&&&& USE_DB_RECOVERY_FILE_DESTOldest online log sequence&&&& 11Next log sequence to archive&& 12Current log sequence&&&&&&&&&& 12
SQL& select max(sequence#) from v$archived_log
col NAME format a80
SQL&& select SEQUENCE#,NAME,FIRST_TIME, NEXT_TIME FROM v$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE#& NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& FIRST_TIME&& NEXT_TIME---------- -----------------------------&&&&&&& 11 +DG_RECOVERY/racdb/archivelog//thread_2_seq_11.257.&&&&&&&&&& 18-MAY-10&&& 18-MAY-10
--查看归档丢失的情况：
SELECT THREAD#,LOW_SEQUENCE#,HIGH_SEQUENCE# from v$archive_
--启动闪回
alter system set db_recovery_file_dest_size=2g scope=
alter system set db_recovery_file_dest='+DG_RECOVERY' scope=
alter database flashback ON;
SQL& show parameter recovery&&
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest&&&&&&&&&&&&&&& string&&&&& +DG_RECOVERYdb_recovery_file_dest_size&&&&&&&&&& big integer 2Grecovery_parallelism&&&&&&&&&&&&&&&& integer&&&& 0
[ 本帖最后由 mfkqwyc86 于
10:31 编辑 ] &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 3# &发表于
09:55:01 |只看该作者 tnsnames:& & RACDB1 =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (INSTANCE_NAME = racdb1)&&& )& )
RACDB =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))&&& (LOAD_BALANCE = yes)&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (FAILOVER_MODE =&&&&&&& (TYPE = SELECT)&&&&&&& (METHOD = BASIC)&&&&&&& (RETRIES = 180)&&&&&&& (DELAY = 5)&&&&& )&&& )& )
LISTENERS_RACDB =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))& )& LISTENERS_RACDB1 =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))& )
LISTENERS_RACDB2 =& (ADDRESS_LIST =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))& )& & EXTPROC_CONNECTION_DATA =& (DESCRIPTION =&&& (ADDRESS_LIST =&&&&& (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))&&& )&&& (CONNECT_DATA =&&&&& (SID = PLSExtProc)&&&&& (PRESENTATION = RO)&&& )& )
RACDB2 =& (DESCRIPTION =&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))&&& (CONNECT_DATA =&&&&& (SERVER = DEDICATED)&&&&& (SERVICE_NAME = racdb)&&&&& (INSTANCE_NAME = racdb2)&&& )& )& & alter system set LOCAL_LISTENER = 'LISTENERS_RACDB1' scope=both sid='racdb1';alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb1';
alter system set LOCAL_LISTENER = 'LISTENERS_RACDB2' scope=both sid='racdb2';alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb2';
############################################10、配置启动归档及闪回
--先配归档才可以启动闪回
alter system set cluster_database=false scope=spfile
#alter system set db_recovery_file_dest='D:\oracle\flashdb' scope=
startup mount
alter system set cluster_database=true scope=spfile
startup &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 4# &发表于
09:55:38 |只看该作者 [root@rac2 ~]# crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.racdb.db&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b1.inst application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b2.inst application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....db_s.cs application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db1.srv application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db2.srv application&&& ONLINE&&& ONLINE&&& rac2&&&&&&&
与之前不同service名后，则数据库会自己变为新的service名字，如下：
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE------------------------------------ ----------- ------------------------------service_names&&&&&&&&&&&&&&&&&&&&&&& string&&&&& racdb_s
7、crs_stat -t
[oracle@rac2 bin]$ crs_stat -t&&&&&&&&&&&& Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&&
ALTER DISKGROUP RACDISK DROP DISK RACDISK_0001 REBALANCE POWER 11;
8、rac status
[oracle@rac2 bin]$ crs_stat -tName&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ------------------------------------------------------------ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.racdb.db&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....acdb.cs application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db1.srv application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....db2.srv application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....b1.inst application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....b2.inst application&&& ONLINE&&& ONLINE&&& rac2&&&&&
############################################9、listener.ora与tnsnames.ora
listener.ora:
LISTENER_RAC1 =& (DESCRIPTION_LIST =&&& (DESCRIPTION =&&&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521)(IP = FIRST))&&&&& (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521)(IP = FIRST))&&& )& )
SID_LIST_LISTENER_RAC1 =& (SID_LIST =&&& (SID_DESC =&&&&& (SID_NAME = PLSExtProc)&&&&& (ORACLE_HOME = /oracle/app/product/10.2.0/db_1)&&&&& (PROGRAM = extproc)&&& )& ) &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 5# &发表于
09:56:19 |只看该作者 Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&& ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.DGDATA.dg& ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....VERY.dg ora....up.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....N1.lsnr ora....er.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.eons&&&&&& ora.eons.type& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.gsd&&&&&&& ora.gsd.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....network ora....rk.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.oc4j&&&&&& ora.oc4j.type& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.ons&&&&&&& ora.ons.type&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM1.asm application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& ora....t1.type ONLINE&&& ONLINE&&& rac2&&&&&&& ora....ry.acfs ora....fs.type ONLINE&&& ONLINE&&& rac1&&&&&&& ora.scan1.vip& ora....ip.type ONLINE&&& ONLINE&&& rac2
su - oracle./dbca
手工配置services
(命令注册不能用与ＤＢ相同的service名)
srvctl add service -d &name& -s &service_name& -r &&preferred_list&& [-a &&available_list&&] [-P &TAF_policy&]
[root@rac1 backup]# srvctl add service -h&& Usage: srvctl add service -d &name& -s &service_name& -r &&preferred_list&& [-a &&available_list&&] [-P &TAF_policy&]&&& -d &name&&&&&&&&&&& Unique name for the database&&& -s &service&&&&&&&& Service name&&& -r &&pref_list&&&&& List of preferred instances&&& -a &&avail_list&&&& List of available instances&&& -P &TAF_policy&&&&& TAF policy (NONE, BASIC, or PRECONNECT)Usage: srvctl add service -d &name& -s &service_name& -u {-r &&new_pref_inst&& | -a &&new_avail_inst&&}&&& -d &name&&&&&&&&&&& Unique name for the database&&& -s &service&&&&&&&& Service name&&& -u&&&&&&&&&&&&&&&&& Add a new instance to service configuration&&& -r &new_pref_inst&& Name of new preferred instance&&& -a &new_avail_inst& Name of new available instance&&& -h&&&&&&&&&&&&&&&&& Print usage
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s racdb1 -a racdb2 -P BASIC
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s -r racdb1,racdb2 -P BASIC (建议) &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 6# &发表于
09:58:06 |只看该作者 su - oracle./runInstaller
[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.shRunning Oracle 11g root.sh script...
The following environment variables are set as:&&& ORACLE_OWNER= oracle&&& ORACLE_HOME=& /oracle/app/oracle/product/11.2.0
Enter the full pathname of the local bin directory: [/usr/local/bin]: The file &dbhome& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying dbhome to /usr/local/bin ...The file &oraenv& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying oraenv to /usr/local/bin ...The file &coraenv& already exists in /usr/local/bin.& Overwrite it? (y/n) [n]: y&& Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.
[root@rac2 ~]# crs_stat -t &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 7# &发表于
09:59:26 |只看该作者 检查集群节点:olsnodes -l
检查 Oracle 集群注册表 (OCR):
[grid@rac1 ~]$& ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check succeeded
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&& Cluster registry integrity check succeeded
&&&&&&&& Logical corruption check bypassed due to non-privileged user
&&&&&&&&&&&&&&&& &&&&&&&&&&&&&&&& [grid@rac2 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :&&&&&&&& Version&&&&&&&&&&&&&&&&& :&&&&&&&&& 3&&&&&&&& Total space (kbytes)&&&& :&&&& 262120&&&&&&&& Used space (kbytes)&&&&& :&&&&&& 2404&&&&&&&& Available space (kbytes) :&&&& 259716&&&&&&&& ID&&&&&&&&&&&&&&&&&&&&&& : &&&&&&&& Device/File Name&&&&&&&& :&&&&&& +CRS&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File integrity check failed
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Device/File not configured
&&&&&&&& Cluster registry integrity check failed
&&&&&&&& Logical corruption check bypassed due to insufficient quorum
检查表决磁盘:
crsctl query css votedisk
[grid@rac1 ~]$ crsctl query css votedisk##& STATE&&& File Universal Id&&&&&&&&&&&&&&& File Name Disk group--& -----&&& -----------------&&&&&&&&&&&&&&& --------- ---------1. ONLINE&& 589cfecbff651e64eeb281a (ORCL:CRS1) [CRS]Located 1 voting disk(s).
Oc4j,gsd服务默认是disable的，如果要启动，启用即可[node1:grid]srvctl status oc4jOC4J is disabled
[node1: grid]srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node: node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2eONS is enabledeONS daemon is running on node: node1eONS daemon is running on node: node2
[node1:grid]$srvctl enable oc4j[node1:grid]$srvctl start oc4j[node1:grid]$srvctl enable nodeapps[node1:grid]$srvctl start nodeapps
重启grid cluster
为数据和快速恢复区创建 ASM 磁盘组:asmca &&&使用道具 举报 显身卡 &
mfkqwyc86 mfkqwyc86 当前离线 UID9664900阅读权限20帖子224精华贴数1技术排名3188 技术积分874 社区排名10484 社区积分30 注册时间& IP卡& 狗仔卡 注册会员
飞鹰工作室
精华贴数1技术积分874 社区积分30 注册时间论坛徽章:2加好友 发消息& 8# &发表于
10:00:22 |只看该作者 资源组状态:crsctl status resource -t
[grid@rac2 ~]$ crsctl status resource -t--------------------------------------------------------------------------------NAME&&&&&&&&&& TARGET& STATE&&&&&&& SERVER&&&&&&&&&&&&&&&&&& STATE_DETAILS&&&&&& --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.CRS.dg&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.LISTENER.lsnr&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.asm&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&& Started&&&&&&&&&&&& ora.eons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.gsd&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.net1.network&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.ons&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.registry.acfs&&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.oc4j&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.rac2.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& ora.scan1.vip&&&&& 1&&&&&&& ONLINE& ONLINE&&&&&& rac1 &
TA的最新馆藏[转]&[转]&
喜欢该文的人也喜欢}
我要回帖
更多关于 2k14bin文件放在哪 的文章
更多推荐
- ·Win11中将网易下载163邮箱到桌面放到桌面？
- ·货主企业如何实现煤炭运销管理系统水运物流精细化管理？
- ·那个有查找朋友软件是干嘛的知道这个是什么软件吗？急
- ·购买抽油烟机买哪个牌子经济又实惠时，哪些品牌性价比高且划算？
- ·网红猫表情包|猫咪一个猫扭头惊讶的表情包张嘴表情包|一只胖猫双下巴表情包萌萌哒的猫咪表情包来一波
- ·EDG围棋对战文字解说NB解说是谁
- ·崩坏学园2装备图鉴温泉关的荣光属性图鉴 温泉关的荣光怎么样
- ·谁知道超级整蛊霸王 电影用的是那个我心永恒的版本
- ·魂斗罗归来紫色装备70级紫A装备分解能得到多少万能碎片？
- ·这个是什么跑酷游戏手机
- ·求一个三国志11逐鹿天地1.3的最新mod
- ·求能在WIN7 64位运行的MOD,如精忠报国岳飞传传、姜维传等
- ·各位道友，请问掌上英雄杀5星好友什么比赛只能用基
- ·剑神带剑魂带妖刀还是荒古光光跟锤子哪个好
- ·求权利的权利游戏第一季资源源
- ·谁知道哪里能学到日本古剑术剑术心形刀流？
- ·索尼X9000A和小米和索尼电视哪个好电视3有什么区别
- ·dnfdnf剑魂怎么打出伤害8个9的伤害?
- ·阿狸魔法少女皮肤的哪个皮肤最漂亮？
- ·新人求助，关于外接生化危机4手柄问题题
- ·安装nba2k14修改器为什么说date.bin没有放在一个目录
- ·太极武当是武当山学太极拳的演出吗，好看吗
- ·这个是什么跑酷游戏手机
- ·如何才能不焦虑打麻将很多人
- ·谁帮我申请个QQ号，带上免费微信号带密码.txt，我没手机卡，谢谢
- ·这怎么弄啊，亲爱的我还在这里70章们，怎么重启都不行
- ·iphone手机照片备份备份的照片在照片里看不到啊。
- ·求数码宝贝第5部国语版一部国语版
- ·影驰gtx770四星黑将将 2G 请问这个显卡还能用不。 能和现在哪个卡 相比较。
- ·移动空调外机噪音大的噪音比分体机大吗？
- ·几个淘宝一个打印机怎么怎样绑定打印机
- ·手机宝马导航实时路况可以定位但是不自动更新路况信息
- ·手机上用什么软件能做图片带字把图片上的字抠下来，然后复制黏贴到另外一个地方？
- ·请问萍果x误充50到ID能退钱吗?
