合 一步一步在RHEL6.5+VMware Workstation上搭建 Oracle 12cR1的rac集群环境详细教程
Tags： Oracle高可用rac集群部署VMware WorkStationRHEL6.512cR1
👉 本文共约17574个字，系统预计阅读时间或需67分钟。
目录
- 图形界面安装
- 安装GRID
- 开始安装Grid Infrastructure软件
- 选择安装类型
- 为集群命名
- 定义节点
- 配置SSH用户等价
- 定义网卡
- 配置OCR和Voting disk
- 配置操作系统用户和组
- 确认安装路径
- 安装前检查
- 52%拷贝到节点2
- 81% 执行root.sh
- 91%创建MGMTDB
- 校验
- 创建DATA和FRA磁盘组
- 停止MGMTDB
- Database安装与配置
- 安装数据库
- 仅安装软件
- 安装集群数据库
- 配置SSH用户等价
- 选择语言
- 选择安装企业版
- 确认安装路径
- 配置操作系统用户和组
- 安装前检查
- 44%的rman工具
- 65%的时候很慢
- 95%执行root.sh
- 使用DBCA创建数据库
- 进入欢迎界面，选择创建RAC库
- 确定数据库名及数据库实例名
- 选择数据库管理特征和验证特性
- 选择数据库存储特征
- 选择数据库组件
- 配置有关的初始化参数
- 进行安装
- 日志路径
- 验证
- 卸载
图形界面安装
安装GRID
安装日志：/u01/app/oraInventory/logs/installActions2014-06-05_06-12-27AM.log
首先打开Xmanager - Passive软件，或者直接以grid用户登录虚拟机，在虚拟机里边进行图形界面操作。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [grid@raclhr-12cR1-N1 ~]$ export DISPLAY=192.168.59.1:0.0 [grid@raclhr-12cR1-N1 ~]$ xhost + access control disabled, clients can connect from any host [grid@raclhr-12cR1-N1 ~]$ cd /soft/grid/ [grid@raclhr-12cR1-N1 grid]$ ll total 80 drwxr-xr-x 4 root root 4096 Jan 16 17:04 install -rwxr-xr-x 1 root root 34132 Jul 11 2014 readme.html drwxrwxr-x 2 root root 4096 Jul 7 2014 response drwxr-xr-x 2 root root 4096 Jul 7 2014 rpm -rwxr-xr-x 1 root root 5085 Dec 20 2013 runcluvfy.sh -rwxr-xr-x 1 root root 8534 Jul 7 2014 runInstaller drwxrwxr-x 2 root root 4096 Jul 7 2014 sshsetup drwxr-xr-x 14 root root 4096 Jul 7 2014 stage -rwxr-xr-x 1 root root 500 Feb 7 2013 welcome.html [grid@raclhr-12cR1-N1 grid]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 415 MB. Actual 2790 MB Passed Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-16_08-41-48PM. Please wait ...[grid@raclhr-12cR1-N1 grid]$ [grid@raclhr-12cR1-N1 grid]$ |
开始安装Grid Infrastructure软件
依照上图设置好，单击“Next”按钮。
选择Configure a Standard cluster，并选择“下一步”：
选择安装类型
依照上图设置好，单击“Next”按钮。
选择语言
依照上图设置好，单击“Next”按钮。
为集群命名
SCAN Name和/etc/hosts文件中设置一样，依照上图设置好，单击“Next”按钮。
定义节点
上图显示出安装程序所在的节点，节点名和vip名必须小写，先点击Edit修改，其他节点需要手工添加。按Add按钮。Hostname、Virtual IP Name和文件hosts中设置一样，依照上图设置好，单击OK按钮。
配置SSH用户等价
输入密码，按Setup按钮建立SSH无密码互连接。如果在安装准备阶段手工配置了SSH连接，直接点Test按钮测试即可。依照上图设置好，单击“Next”按钮。
定义网卡
配置OCR和Voting disk
依照上图设置好，单击“Next”按钮。设置Disk group name 为OCR，Redundancy选择External，单击Change Discovery Path按钮。
指定OCR和Voting disk存放位置为/dev/asm*，依照上图设置Disk Discovery Path为实际路径，单击OK按钮。
配置操作系统用户和组
此处选择use same passwords for these accounts
单击Yes按钮。
依照上图设置好，单击“Next”按钮。
点击“Next”继续安装；
此处配置为：
Oracle ASM administrator :asmadmin
Oracle ASM DBA :asmdba
Oracle ASM Operator :asmoper
确认安装路径
依照上图设置好，单击“Next”按钮。
依照上图设置好，单击“Next”按钮。
点击“Next”继续；
安装前检查
安装程序会检查系统环境是否符合要求，包括RPM包、磁盘空间、SWAP、时钟同步等，任何一个条件没有通过，都会给出提示和解决办法。
以上几项可忽略，选择检查框Ignore All，单击“Next”按钮。
单击“Install”按钮。
52%拷贝到节点2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | [grid@raclhr-12cR1-N1 grid]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.5G 52% / tmpfs 1000M 72K 1000M 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 578M 2.3G 21% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 70M 2.8G 3% /home /dev/mapper/vg_orasoft-lv_orasoft_u01 20G 6.7G 12G 36% /u01 .host:/ 331G 234G 97G 71% /mnt/hgfs /dev/mapper/vg_orasoft-lv_orasoft_soft 20G 11G 8.6G 54% /soft [grid@raclhr-12cR1-N1 grid]$ [root@raclhr-12cR1-N2 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.5G 52% / tmpfs 1000M 72K 1000M 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 80M 2.8G 3% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home /dev/mapper/vg_orasoft-lv_orasoft_u01 20G 5.3G 14G 29% /u01 .host:/ 331G 234G 97G 71% /mnt/hgfs /dev/mapper/vg_orasoft-lv_orasoft_soft 20G 172M 19G 1% /soft [root@raclhr-12cR1-N2 ~]# |
81% 执行root.sh
出现以上窗口时，不要关闭Execute Configuration scripts窗口，切换到节点1和节点2的root用户，先在节点1运行以root用户执行orainstRoot.sh，运行完后再到节点2运行：
1 | /u01/app/oraInventory/orainstRoot.sh |
以root用户在节点1上运行root.sh，然后再节点2上运行root.sh：
1 | /u01/app/12.1.0/grid_1/root.sh |
若root.sh执行失败，则重新执行root.sh的步骤如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | ---$ORACLE_HOME 为GRID_HOME的路径,执行之前最好先手动把数据库资源关闭 日志地址：$ORACLE_HOME/cfgtoollogs/crsconfig/ 重置的日志文件：hadelete.log root.sh脚本日志：rootcrs_rac2.log --------------① 脚本方式 ---执行失败，重新执行root.sh脚本 $ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose --$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg dd if=/dev/zero of=/dev/rhdiskN bs=1024k count=1024 lquerypv -h /dev/rhdisk5 $ORACLE_HOME/root.sh $ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose --$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg $ORACLE_HOME/root.sh ---$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose执行完成之后需要删除如下的文件 ls -l $ORACLE_BASE/Clusterware/ckptGridHA* find $ORACLE_HOME/gpnp/* -type f find $ORACLE_HOME/gpnp/* -type f -exec rm -rf {} \; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | [grid@raclhr-12cR1-N1 grid]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.OCR.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.asm ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE ora.net1.network ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.ons ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.MGMTLSNR 1 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.oc4j 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n2.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.scan1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE -------------------------------------------------------------------------------- [grid@raclhr-12cR1-N1 grid]$ |
91%创建MGMTDB
等到运行完root.sh，切换回Execute Configuration scripts窗口单击“OK”按钮。
创建MGMTDB，数据存储在OCR磁盘组。从后台进程(ps -ef|grep mgmt)找到了如下的SQL语句：
1 2 | dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName OCR -datafileJarLocation /u01/app/12.1.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | [root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 6144 5847 0 5847 0 Y OCR/ [root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 6144 4318 0 4318 0 Y OCR/ [root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 6144 1733 0 1733 0 Y OCR/ [root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 6144 1682 0 1682 0 Y OCR/ [root@raclhr-12cR1-N2 ~]# |
创建完成后：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | [grid@raclhr-12cR1-N1 grid]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.OCR.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.asm ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE ora.net1.network ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.ons ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.MGMTLSNR 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.146.43 192.1 68.2.100,STABLE ora.cvu 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.mgmtdb 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE ora.oc4j 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n2.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.scan1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE -------------------------------------------------------------------------------- [grid@raclhr-12cR1-N1 grid]$ [grid@raclhr-12cR1-N1 grid]$ ps -ef|grep pmon grid 21105 1 0 Jan16 ? 00:00:00 asm_pmon_+ASM1 grid 36779 1 0 00:33 ? 00:00:00 mdb_pmon_-MGMTDB grid 44574 12846 0 00:45 pts/0 00:00:00 grep pmon [grid@raclhr-12cR1-N1 grid]$ ps -ef|grep MGMTDB | wc -l 41 [grid@raclhr-12cR1-N1 grid]$ |
单击“Next”按钮。
单击Yes按钮。
单击Close按钮。
校验
确认Grid安装成功
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | [grid@raclhr-12cR1-N2 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.OCR.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.asm ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE ora.net1.network ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.ons ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.MGMTLSNR 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.146.43 192.1 68.2.100,STABLE ora.cvu 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.mgmtdb 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE ora.oc4j 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.raclhr-12cr1-n1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n2.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.scan1.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- [grid@raclhr-12cR1-N2 ~]$ [grid@raclhr-12cR1-N2 ~]$ crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 645b7b8eacd94fd1bfdc8466045e5c65 (/dev/asm-diskc) [OCR] Located 1 voting disk(s). [grid@raclhr-12cR1-N2 ~]$ ocrcheck Status of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1456 Available space (kbytes) : 408112 ID : 660744490 Device/File Name : +OCR 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@raclhr-12cR1-N2 ~]$ [grid@raclhr-12cR1-N2 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [grid@raclhr-12cR1-N2 ~]$ [grid@raclhr-12cR1-N2 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 6144 1682 0 1682 0 Y OCR/ ASMCMD> lsdsk -p --discovery Group_Num Disk_Num Incarn Mount_Stat Header_Stat Mode_Stat State Path 1 0 3915929494 CACHED MEMBER ONLINE NORMAL /dev/asm-diskc 0 1 0 CLOSED CANDIDATE ONLINE NORMAL /dev/asm-diskd 0 0 0 CLOSED CANDIDATE ONLINE NORMAL /dev/asm-diske ASMCMD> [grid@raclhr-12cR1-N2 ~]$ $ORACLE_HOME/bin/kfod disks=all s=true ds=true -------------------------------------------------------------------------------- Disk Size Header Path Disk Group User Group ================================================================================ 1: 6144 Mb MEMBER /dev/asm-diskc OCR grid asmadmin 2: 10240 Mb CANDIDATE /dev/asm-diskd # grid asmadmin 3: 10240 Mb CANDIDATE /dev/asm-diske # grid asmadmin -------------------------------------------------------------------------------- ORACLE_SID ORACLE_HOME ================================================================================ +ASM1 /u01/app/12.1.0/grid +ASM2 /u01/app/12.1.0/grid |
创建DATA和FRA磁盘组
以 grid 用户执行 asmca 命令
使用asmca，创建DATA和FRA两个磁盘组。
点击Create按钮：
如上图，点击OK：
DATA创建成功，相同步骤创建FRA磁盘组。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | [grid@raclhr-12cR1-N2 ~]$ $ORACLE_HOME/bin/kfod disks=all s=true ds=true -------------------------------------------------------------------------------- Disk Size Header Path Disk Group User Group ================================================================================ 1: 6144 Mb MEMBER /dev/asm-diskc OCR grid asmadmin 2: 10240 Mb MEMBER /dev/asm-diskd DATA grid asmadmin 3: 10240 Mb MEMBER /dev/asm-diske FRA grid asmadmin -------------------------------------------------------------------------------- ORACLE_SID ORACLE_HOME ================================================================================ +ASM1 /u01/app/12.1.0/grid +ASM2 /u01/app/12.1.0/grid [grid@raclhr-12cR1-N2 ~]$ [grid@raclhr-12cR1-N2 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.FRA.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.LISTENER.lsnr ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.OCR.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.asm ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE ora.net1.network ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.ons ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.MGMTLSNR 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.146.43 192.1 68.2.100,STABLE ora.cvu 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.mgmtdb 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE ora.oc4j 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.raclhr-12cr1-n1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n2.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.scan1.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- [grid@raclhr-12cR1-N2 ~]$ |
停止MGMTDB
由于是在虚拟机上，内存不足，所以建议先把MGMTDB库停掉。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | [grid@raclhr-12cR1-N1 ~]$ srvctl stop mgmtdb [grid@raclhr-12cR1-N1 ~]$ srvctl status mgmtdb Database is enabled Database is not running. [grid@raclhr-12cR1-N1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.FRA.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.LISTENER.lsnr ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.OCR.dg ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.asm ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE ora.net1.network ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.ons ONLINE ONLINE raclhr-12cr1-n1 STABLE ONLINE ONLINE raclhr-12cr1-n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.MGMTLSNR 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.20.104 192.1 68.2.100,STABLE ora.cvu 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.lhrrac.db 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE 2 ONLINE ONLINE raclhr-12cr1-n2 Open,STABLE ora.mgmtdb 1 OFFLINE OFFLINE Instance Shutdown,ST ABLE ora.oc4j 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE ora.raclhr-12cr1-n2.vip 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE ora.scan1.vip 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE -------------------------------------------------------------------------------- [grid@raclhr-12cR1-N1 ~]$ [grid@raclhr-12cR1-N2 oracle]$ ORACLE_SID=-MGMTDB [grid@raclhr-12cR1-N2 oracle]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 11:46:18 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. |
Database安装与配置
安装数据库
日志：tail -f /u01/app/oraInventory/logs/installActions2014-06-05_01-30-25AM.log
以Oracle 用户在rac1上安装：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | [oracle@raclhr-12cR1-N1 ~]$ export DISPLAY=192.168.59.1:0.0 [oracle@raclhr-12cR1-N1 ~]$ xhost + access control disabled, clients can connect from any host [oracle@raclhr-12cR1-N1 ~]$ cd /soft/database/ [oracle@raclhr-12cR1-N1 database]$ ll total 72 drwxr-xr-x 4 root root 4096 Jan 16 17:04 install -rwxr-xr-x 1 root root 34132 Jul 11 2014 readme.html drwxrwxr-x 2 root root 4096 Jul 7 2014 response drwxr-xr-x 2 root root 4096 Jul 7 2014 rpm -rwxr-xr-x 1 root root 8533 Jul 7 2014 runInstaller drwxrwxr-x 2 root root 4096 Jul 7 2014 sshsetup drwxr-xr-x 14 root root 4096 Jul 7 2014 stage -rwxr-xr-x 1 root root 500 Feb 7 2013 welcome.html [oracle@raclhr-12cR1-N1 database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 2783 MB Passed Checking swap space: must be greater than 150 MB. Actual 1732 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-17_09-54-27AM. Please wait ...[oracle@raclhr-12cR1-N1 database]$ [oracle@raclhr-12cR1-N1 database]$ |
安装oracle database软件
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
