Oracle 12cR1 RAC 在VMware Workstation上安装(中)—图形界面安装

前端之家收集整理的这篇文章主要介绍了Oracle 12cR1 RAC 在VMware Workstation上安装(中)—图形界面安装前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

Oracle 12cR1 RAC 在VMware Workstation上安装(中)—图形界面安装

@H_301_7@1.1 图形界面安装

@H_301_7@1.1.1 安装GRID

@H_301_7@安装日志:/u01/app/oraInventory/logs/installActions2014-06-05_06-12-27AM.log

首先打开@H_301_7@Xmanager - Passive软件,或者直接以grid用户登录虚拟机,在虚拟机里边进行图形界面操作。

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ export DISPLAY=192.168.59.1:0.0

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ xhost +

@H_301_7@access control disabled,clients can connect from any host

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ cd /soft/grid/

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ ll

@H_301_7@total 80

@H_301_7@drwxr-xr-x 4 root root 4096 Jan 16 17:04 install

@H_301_7@-rwxr-xr-x 1 root root 34132 Jul 11 2014 readme.html

@H_301_7@drwxrwxr-x 2 root root 4096 Jul 7 2014 response

@H_301_7@drwxr-xr-x 2 root root 4096 Jul 7 2014 rpm

@H_301_7@-rwxr-xr-x 1 root root 5085 Dec 20 2013 runcluvfy.sh

@H_301_7@-rwxr-xr-x 1 root root 8534 Jul 7 2014 runInstaller

@H_301_7@drwxrwxr-x 2 root root 4096 Jul 7 2014 sshsetup

@H_301_7@drwxr-xr-x 14 root root 4096 Jul 7 2014 stage

@H_301_7@-rwxr-xr-x 1 root root 500 Feb 7 2013 welcome.html

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ ./runInstaller

@H_301_7@Starting Oracle Universal Installer...

@H_301_7@

@H_301_7@Checking Temp space: must be greater than 415 MB. Actual 2790 MB Passed

@H_301_7@Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed

@H_301_7@Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

@H_301_7@Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-16_08-41-48PM. Please wait ...[grid@raclhr-12cR1-N1 grid]$

@H_301_7@[grid@raclhr-12cR1-N1 grid]$

@H_301_7@

@H_301_7@

@H_301_7@

@H_301_7@1.1.1.1 开始安装Grid Infrastructure软件

依照上图设置好,单击“Next”按钮。

@H_301_7@选择Configure a Standard cluster,并选择“下一步”:

@H_301_7@1.1.1.2 选择安装类型

@H_412_403@

@H_412_403@依照上图设置好,单击“Next”按钮。

选择语言

@H_412_403@

依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.1.3 为集群命名

SCAN Name@H_301_7@/etc/hosts文件中设置一样,依照上图设置好,单击“Next”按钮。

@H_301_7@

@H_301_7@1.1.1.4 定义节点

@H_301_7@

@H_301_7@上图显示出安装程序所在的节点,节点名和@H_301_7@vip名必须小写,先点击Edit@H_301_7@修改其他节点需要手工添加Add按钮。@H_301_7@Hostname@H_301_7@Virtual IP Name文件@H_301_7@hosts中设置一样,依照上图设置好,单击O@H_301_7@K按钮。

@H_301_7@1.1.1.5 配置SSH用户等价

@H_301_7@

输入密码,按Setup按钮建立@H_301_7@SSH无密码互连接。如果在安装准备阶段手工配置了@H_301_7@SSH连接,直接点@H_301_7@Test按钮测试即可。依照上图设置好,单击@H_301_7@“Next”按钮。

@H_301_7@1.1.1.6 定义网卡

@H_301_7@1.1.1.7 @H_301_7@配置OCR和Voting disk

@H_301_7@

依照上图设置好,单击“Next”按钮。设置@H_301_7@D@H_301_7@isk group name 为@H_301_7@OCR@H_301_7@Redundancy选择External,单击Change Discovery Path按钮。

@H_301_7@

@H_301_7@指定OCR和@H_301_7@Voting disk存放位置@H_301_7@为/dev/asm*依照上图设置Disk Discovery Path为实际路径,单击OK按钮

@H_301_7@

@H_301_7@1.1.1.8 配置操作系统用户和组

@H_301_7@

@H_301_7@此处选择use same passwords for these accounts

@H_301_7@

单击Yes按钮。

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@点击Next”继续安装;

@H_301_7@

此处配置为:

@H_301_7@Oracle ASM administrator:asmadmin

@H_301_7@Oracle ASM DBA :asmdba

@H_301_7@Oracle ASM Operator:asmoper

@H_301_7@

@H_301_7@

@H_301_7@1.1.1.9 确认安装路径

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@点击Next”继续;

@H_301_7@1.1.1.10 安装前检查

@H_301_7@安装程序会检查系统环境是否符合要求,包括RPM包、磁盘空间、@H_301_7@SWAP、时钟同步等,任何一个条件没有通过,都会给出提示解决办法。

@H_301_7@

以上几项可忽略,选择检查框Ignore All,单击@H_301_7@“Next”按钮。

@H_301_7@

单击@H_301_7@Install按钮。

@H_301_7@1.1.1.11 @H_301_7@52%拷贝到节点2

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ df -h

@H_301_7@Filesystem Size Used Avail Use% Mounted on

@H_301_7@/dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.5G 52% /

@H_301_7@tmpfs 1000M 72K 1000M 1% /dev/shm

@H_301_7@/dev/sda1 194M 35M 150M 19% /boot

@H_301_7@/dev/mapper/vg_rootlhr-Vol01 3.0G 578M 2.3G 21% /tmp

@H_301_7@/dev/mapper/vg_rootlhr-Vol03 3.0G 70M 2.8G 3% /home

@H_301_7@/dev/mapper/vg_orasoft-lv_orasoft_u01 20G 6.7G 12G 36% /u01

@H_301_7@.host:/ 331G 234G 97G 71% /mnt/hgfs

@H_301_7@/dev/mapper/vg_orasoft-lv_orasoft_soft 20G 11G 8.6G 54% /soft

@H_301_7@[grid@raclhr-12cR1-N1 grid]$

@H_301_7@[root@raclhr-12cR1-N2 ~]# df -h

@H_301_7@Filesystem Size Used Avail Use% Mounted on

@H_301_7@/dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.5G 52% /

@H_301_7@tmpfs 1000M 72K 1000M 1% /dev/shm

@H_301_7@/dev/sda1 194M 35M 150M 19% /boot

@H_301_7@/dev/mapper/vg_rootlhr-Vol01 3.0G 80M 2.8G 3% /tmp

@H_301_7@/dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home

@H_301_7@/dev/mapper/vg_orasoft-lv_orasoft_u01 20G 5.3G 14G 29% /u01

@H_301_7@.host:/ 331G 234G 97G 71% /mnt/hgfs

@H_301_7@/dev/mapper/vg_orasoft-lv_orasoft_soft 20G 172M 19G 1% /soft

@H_301_7@[root@raclhr-12cR1-N2 ~]#

@H_301_7@

@H_301_7@1.1.1.12 81% 执行root.sh

@H_301_7@

出现以上窗口时,不要关闭Execute Configuration scripts窗口,切换到节点1和节点2root用户,先在节点1@H_301_7@运行root用户执行orainstRoot.sh,运行完后再到节点2运行:

@H_301_7@/u01/app/oraInventory/orainstRoot.sh

root用户@H_301_7@在节点1上运行root.sh@H_301_7@然后再节点2上运行@H_301_7@root.sh

@H_301_7@/u01/app/12.1.0/grid_1/root.sh

@H_301_7@root.sh执行失败,则重新执行@H_301_7@root.sh的步骤如下:

@H_301_7@---$ORACLE_HOME 为@H_301_7@GRID_HOME的路径@H_301_7@,执行之前最好先手动把数据库资源关闭

@H_301_7@日志地址:@H_301_7@$ORACLE_HOME/cfgtoollogs/crsconfig/

@H_301_7@重置的日志文件@H_301_7@hadelete.log

@H_301_7@root.sh脚本日志:@H_301_7@rootcrs_rac2.log

@H_301_7@

@H_301_7@--------------① 脚本方式

@H_301_7@---执行失败,重新执行@H_301_7@root.sh脚本

@H_301_7@$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose

@H_301_7@--$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg

@H_301_7@dd if=/dev/zero of=/dev/rhdiskN bs=1024k count=1024

@H_301_7@lquerypv -h /dev/rhdisk5

@H_301_7@$ORACLE_HOME/root.sh

@H_301_7@

@H_301_7@

@H_301_7@$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose

@H_301_7@--$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg

@H_301_7@$ORACLE_HOME/root.sh

@H_301_7@

@H_301_7@---$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose执行完成之后需要删除如下的文件

@H_301_7@ls -l $ORACLE_BASE/Clusterware/ckptGridHA*

@H_301_7@find $ORACLE_HOME/gpnp/* -type f

@H_301_7@find $ORACLE_HOME/gpnp/* -type f -exec rm -rf {} \;

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 Started,STABLE

@H_301_7@ora.net1.network

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.ons

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Cluster Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER_SCAN1.lsnr

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.MGMTLSNR

@H_301_7@ 1 OFFLINE OFFLINE STABLE

@H_301_7@ora.cvu

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[grid@raclhr-12cR1-N1 grid]$

@H_301_7@

@H_301_7@1.1.1.13 91%创建MGMTDB

等到运行完root.sh,切换回@H_301_7@Execute Configuration scripts窗口单击@H_301_7@“OK”按钮。

@H_301_7@创建MGMTDB@H_301_7@数据存储在OCR磁盘组。从后台进程@H_301_7@(ps -ef|grep mgmt)找到了如下的@H_301_7@sql语句:

@H_301_7@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

@H_301_7@

@H_301_7@[root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg

@H_301_7@State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

@H_301_7@MOUNTED EXTERN N 512 4096 1048576 6144 5847 0 5847 0 Y OCR/

@H_301_7@[root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg

@H_301_7@State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

@H_301_7@MOUNTED EXTERN N 512 4096 1048576 6144 4318 0 4318 0 Y OCR/

@H_301_7@[root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg

@H_301_7@State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

@H_301_7@MOUNTED EXTERN N 512 4096 1048576 6144 1733 0 1733 0 Y OCR/

@H_301_7@[root@raclhr-12cR1-N2 ~]# su - grid asmcmd lsdg

@H_301_7@State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

@H_301_7@MOUNTED EXTERN N 512 4096 1048576 6144 1682 0 1682 0 Y OCR/

@H_301_7@[root@raclhr-12cR1-N2 ~]#

@H_301_7@

@H_301_7@

创建完成后:

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ora.net1.network

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.ons

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Cluster Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER_SCAN1.lsnr

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.MGMTLSNR

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.146.43 192.1

@H_301_7@ 68.2.100,STABLE

@H_301_7@ora.cvu

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.mgmtdb

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[grid@raclhr-12cR1-N1 grid]$

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ ps -ef|grep pmon

@H_301_7@grid 21105 1 0 Jan16 ? 00:00:00 asm_pmon_+ASM1

@H_301_7@grid 36779 1 0 00:33 ? 00:00:00 mdb_pmon_-MGMTDB

@H_301_7@grid 44574 12846 0 00:45 pts/0 00:00:00 grep pmon

@H_301_7@[grid@raclhr-12cR1-N1 grid]$ ps -ef|grep MGMTDB | wc -l

@H_301_7@41

@H_301_7@[grid@raclhr-12cR1-N1 grid]$

@H_301_7@

@H_301_7@

单击“Next”按钮。

单击Yes按钮。

单击Close按钮。

@H_301_7@1.1.1.14 校验

@H_301_7@确认Grid安装成功

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ora.net1.network

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.ons

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Cluster Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER_SCAN1.lsnr

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.MGMTLSNR

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.146.43 192.1

@H_301_7@ 68.2.100,STABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[grid@raclhr-12cR1-N2 ~]$

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ crsctl query css votedisk

@H_301_7@## STATE File Universal Id File Name Disk group

@H_301_7@-- ----- ----------------- --------- ---------

@H_301_7@1. ONLINE 645b7b8eacd94fd1bfdc8466045e5c65 (/dev/asm-diskc) [OCR]

@H_301_7@Located 1 voting disk(s).

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ ocrcheck

@H_301_7@Status of Oracle Cluster Registry is as follows :

@H_301_7@ Version : 4

@H_301_7@ Total space (kbytes) : 409568

@H_301_7@ Used space (kbytes) : 1456

@H_301_7@ Available space (kbytes) : 408112

@H_301_7@ ID : 660744490

@H_301_7@ Device/File Name : +OCR

@H_301_7@ Device/File integrity check succeeded

@H_301_7@

@H_301_7@ Device/File not configured

@H_301_7@

@H_301_7@ Device/File not configured

@H_301_7@

@H_301_7@ Device/File not configured

@H_301_7@

@H_301_7@ Device/File not configured

@H_301_7@

@H_301_7@ Cluster registry integrity check succeeded

@H_301_7@

@H_301_7@ Logical corruption check bypassed due to non-privileged user

@H_301_7@

@H_301_7@[grid@raclhr-12cR1-N2 ~]$

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ crsctl check crs

@H_301_7@CRS-4638: Oracle High Availability Services is online

@H_301_7@CRS-4537: Cluster Ready Services is online

@H_301_7@CRS-4529: Cluster Synchronization Services is online

@H_301_7@CRS-4533: Event Manager is online

@H_301_7@[grid@raclhr-12cR1-N2 ~]$

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ asmcmd

@H_301_7@ASMCMD> lsdg

@H_301_7@State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

@H_301_7@MOUNTED EXTERN N 512 4096 1048576 6144 1682 0 1682 0 Y OCR/

@H_301_7@ASMCMD> lsdsk -p --discovery

@H_301_7@Group_Num Disk_Num Incarn Mount_Stat Header_Stat Mode_Stat State Path

@H_301_7@ 1 0 3915929494 CACHED MEMBER ONLINE NORMAL /dev/asm-diskc

@H_301_7@ 0 1 0 CLOSED CANDIDATE ONLINE NORMAL /dev/asm-diskd

@H_301_7@ 0 0 0 CLOSED CANDIDATE ONLINE NORMAL /dev/asm-diske

@H_301_7@ASMCMD>

@H_301_7@

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ $ORACLE_HOME/bin/kfod disks=all s=true ds=true

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Disk Size Header Path Disk Group User Group

@H_301_7@================================================================================

@H_301_7@ 1: 6144 Mb MEMBER /dev/asm-diskc OCR grid asmadmin

@H_301_7@ 2: 10240 Mb CANDIDATE /dev/asm-diskd # grid asmadmin

@H_301_7@ 3: 10240 Mb CANDIDATE /dev/asm-diske # grid asmadmin

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ORACLE_SID ORACLE_HOME

@H_301_7@================================================================================

@H_301_7@ +ASM1 /u01/app/12.1.0/grid

@H_301_7@ +ASM2 /u01/app/12.1.0/grid

@H_301_7@

@H_301_7@

@H_301_7@

@H_301_7@1.1.2 创建@H_301_7@DATA和FRA磁盘组

grid 用户执行 asmca 命令

使用asmca@H_301_7@创建DATA和@H_301_7@F@H_301_7@RA两个磁盘组。

@H_301_7@

@H_301_7@

@H_301_7@点击Create按钮:

@H_301_7@如上图,点击OK

@H_301_7@DATA创建成功,相同步骤创建FRA磁盘组。

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ $ORACLE_HOME/bin/kfod disks=all s=true ds=true

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Disk Size Header Path Disk Group User Group

@H_301_7@================================================================================

@H_301_7@ 1: 6144 Mb MEMBER /dev/asm-diskc OCR grid asmadmin

@H_301_7@ 2: 10240 Mb MEMBER /dev/asm-diskd DATA grid asmadmin

@H_301_7@ 3: 10240 Mb MEMBER /dev/asm-diske FRA grid asmadmin

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ORACLE_SID ORACLE_HOME

@H_301_7@================================================================================

@H_301_7@ +ASM1 /u01/app/12.1.0/grid

@H_301_7@ +ASM2 /u01/app/12.1.0/grid

@H_301_7@[grid@raclhr-12cR1-N2 ~]$

@H_301_7@[grid@raclhr-12cR1-N2 ~]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.DATA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.FRA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[grid@raclhr-12cR1-N2 ~]$

@H_301_7@

@H_301_7@

@H_301_7@1.1.3 停止MGMTDB

@H_301_7@由于是在虚拟机上,内存不足,所以建议先把MGMTDB库停掉。

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ srvctl stop mgmtdb

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ srvctl status mgmtdb

@H_301_7@Database is enabled

@H_301_7@Database is not running.

@H_301_7@[grid@raclhr-12cR1-N1 ~]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.DATA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.FRA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ora.net1.network

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.ons

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Cluster Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER_SCAN1.lsnr

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.MGMTLSNR

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 169.254.20.104 192.1

@H_301_7@ 68.2.100,STABLE

@H_301_7@ora.cvu

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.lhrrac.db

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 Open,STABLE

@H_301_7@ 2 ONLINE ONLINE raclhr-12cr1-n2 Open,STABLE

@H_301_7@ora.mgmtdb

@H_301_7@ 1 OFFLINE OFFLINE Instance Shutdown,ST

@H_301_7@ ABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[grid@raclhr-12cR1-N1 ~]$

@H_301_7@[grid@raclhr-12cR1-N2 oracle]$ ORACLE_SID=-MGMTDB

@H_301_7@[grid@raclhr-12cR1-N2 oracle]$ sqlplus / as sysdba

@H_301_7@

@H_301_7@sql*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 11:46:18 2017

@H_301_7@

@H_301_7@Copyright (c) 1982,2014,Oracle. All rights reserved.

@H_301_7@

@H_301_7@Connected to an idle instance.

@H_301_7@

@H_301_7@1.1.4 Database安装与配置

@H_301_7@1.1.4.1 安装数据库

@H_301_7@日志:tail -f /u01/app/oraInventory/logs/installActions2014-06-05_01-30-25AM.log

@H_301_7@

@H_301_7@Oracle 用户@H_301_7@rac1上安装:

@H_301_7@[oracle@raclhr-12cR1-N1 ~]$ export DISPLAY=192.168.59.1:0.0

@H_301_7@[oracle@raclhr-12cR1-N1 ~]$ xhost +

@H_301_7@access control disabled,clients can connect from any host

@H_301_7@[oracle@raclhr-12cR1-N1 ~]$ cd /soft/database/

@H_301_7@[oracle@raclhr-12cR1-N1 database]$ ll

@H_301_7@total 72

@H_301_7@drwxr-xr-x 4 root root 4096 Jan 16 17:04 install

@H_301_7@-rwxr-xr-x 1 root root 34132 Jul 11 2014 readme.html

@H_301_7@drwxrwxr-x 2 root root 4096 Jul 7 2014 response

@H_301_7@drwxr-xr-x 2 root root 4096 Jul 7 2014 rpm

@H_301_7@-rwxr-xr-x 1 root root 8533 Jul 7 2014 runInstaller

@H_301_7@drwxrwxr-x 2 root root 4096 Jul 7 2014 sshsetup

@H_301_7@drwxr-xr-x 14 root root 4096 Jul 7 2014 stage

@H_301_7@-rwxr-xr-x 1 root root 500 Feb 7 2013 welcome.html

@H_301_7@[oracle@raclhr-12cR1-N1 database]$ ./runInstaller

@H_301_7@Starting Oracle Universal Installer...

@H_301_7@

@H_301_7@Checking Temp space: must be greater than 500 MB. Actual 2783 MB Passed

@H_301_7@Checking swap space: must be greater than 150 MB. Actual 1732 MB Passed

@H_301_7@Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

@H_301_7@Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-17_09-54-27AM. Please wait ...[oracle@raclhr-12cR1-N1 database]$

@H_301_7@[oracle@raclhr-12cR1-N1 database]$

@H_301_7@

@H_301_7@

@H_301_7@

@H_301_7@安装oracle database软件

@H_301_7@

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@

单击Yes按钮。

@H_301_7@1.1.4.2 仅安装软件

@H_301_7@选择在安装过程中是否建库。这里选择仅安装软件,安装完成后再建库,建库过程详见第6章。

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.4.3 安装集群数据库

@H_301_7@

依照上图设置好,按SSH Connectivity按钮。

@H_301_7@1.1.4.4 配置SSH用户等价

@H_301_7@

@H_301_7@点击Test”进行测试SSH然后单击“Next”按钮。

@H_301_7@1.1.4.5 选择语言

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.4.6 选择安装企业版

@H_301_7@

依照上图设置好,单击@H_301_7@NEXT按钮。

@H_301_7@1.1.4.7 确认安装路径

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.4.8 配置操作系统用户和组

@H_301_7@

依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.4.9 安装前检查

@H_301_7@

以上两项可忽略,选择检查框Ignore All,单击@H_301_7@“Next”按钮。

@H_301_7@选择@H_301_7@Yes”,

@H_301_7@

单击“Next”按钮。

@H_301_7@1.1.4.10 @H_301_7@44%的rman工具

@H_301_7@44% 的@H_301_7@rman工具的时候很慢,,,,,主要看@H_301_7@OS的内存大小和机器性能了。。。

@H_301_7@

@H_301_7@1.1.4.11 65%的时候很慢

这个时候在@H_301_7@copy到@H_301_7@rac2上,可以查看大小来确定是否挂起,等待向其他节点复制。

@H_301_7@1.1.4.12 95%执行root.sh

@H_301_7@

不要关闭Execute Configuration scripts窗口,切换到节点@H_301_7@1和节点@H_301_7@2root用户Terminal终端窗口,@H_301_7@root.sh先在节点@H_301_7@1运行,运行完后再到节点@H_301_7@2运行:

@H_301_7@/u01/app/oracle/product/12.1.0/dbhome_1/root.sh

等到运行完root.sh,切换回@H_301_7@Execute Configuration scripts窗口单击@H_301_7@“OK”按钮。

@H_301_7@

@H_301_7@单击Close按钮。

@H_301_7@1.1.5 使用DBCA创建数据库

@H_301_7@

@H_301_7@Oracle 用户下在节点一操作:

@H_301_7@

@H_301_7@

节点1运行@H_301_7@dbca图形化安装程序创建数据库

su - oracle

@H_301_7@export DISPLAY=$IP:0.0

cd /oracle/app/oracle/product/11.2.0/dbhome/bin

./dbca

@H_301_7@

@H_301_7@1.1.5.1 进入欢迎界面,选择创建RAC

@H_301_7@

依照上图设置好,单击“Next”按钮。

也可以选择默认配置,如下图:

@H_301_7@

这里选择高级模式,单击“Next”按钮。

@H_301_7@

@H_301_7@选择用户自定义(Custom Database)方式,采用定制的方法才创建数据库。单击“@H_301_7@Next”按钮。

@H_301_7@1.1.5.2 确定数据库名及数据库实例名

@H_301_7@

@H_301_7@根据应用需求,输入的Database Name和@H_301_7@SID依照上图设置好,单击“Next”按钮。@H_301_7@Global Database Name和@H_301_7@SID Prefix名字一致。

注意:Oracle @H_301_7@12c支持Oracle_SID的长度为@H_301_7@12位,@H_301_7@db_name的长度为@H_301_7@8

@H_301_7@选择需要安装数据库Node节点,选择完成后点击“@H_301_7@Next”继续。

@H_301_7@1.1.5.3 选择数据库管理特征和验证特性

@H_301_7@点击Next”继续。

@H_301_7@

Password=@H_301_7@oracleMODE,依照上图设置好,单击“Next”按钮。

@H_301_7@1.1.5.4 选择数据库存储特征

@H_301_7@

@H_301_7@设置存储类型:选择ASM

@H_301_7@设置数据存放方式:选择"Use Common Location for All Database Files:"

@H_301_7@Files Location:+DATA

单击“Next”按钮

@H_301_7@1.1.5.5 选择数据库组件

@H_301_7@

@H_301_7@

用户根据实际应用需要选择组件

@H_301_7@点击Next”继续配置。

@H_301_7@1.1.5.6 配置有关的初始化参数

注意:数据块大小,字符集参数,在建立实例后将不能被修改。所以在安装实例时,一定要确认设置的正确性。

@H_301_7@

@H_301_7@设置SGA+PGA使用@H_301_7@70-80% 的物理内存,对于@H_301_7@SGA可配置@H_301_7@(SGA+PGA)@H_301_7@80%@H_301_7@PGA@H_301_7@(SGA+PGA)@H_301_7@20%

推荐:@H_301_7@SGA=物理内存×@H_301_7@0.7×@H_301_7@0.8

@H_301_7@ PGA=物理内存×@H_301_7@0.7×@H_301_7@0.2

单击“Next”按钮。

@H_301_7@

@H_301_7@设置@H_301_7@进程数量,processs设置为@H_301_7@5@H_301_7@000。依照上图设置好,单击“Next”按钮。

@H_301_7@

@H_301_7@设置@H_301_7@Database Character Set”为需求设置,“@H_301_7@National Character Set”为“@H_301_7@AL16UTF16@H_301_7@编码(与项目组确认是否有使用nchar/nvarchar类型,确认编码依照上图设置好,单击“Next”按钮。

@H_301_7@连接模式选择“专用服务器模式”,点击“Next”继续。

@H_301_7@

注意:数据块大小,字符集参数,在建立实例后将不能被修改。所以在安装实例时,一定要确认设置的正确性。

@H_301_7@1.1.5.7 进行安装

@H_301_7@

查看上图中的报错是由于一个@H_301_7@SCAN IP导致,可以忽略所有,然后点击“@H_301_7@Next”继续安装@H_301_7@DBCA自动配置完两个节点Database@H_301_7@$ORACLE_HOME/network/admin/tnsnames.ora

@H_301_7@

@H_301_7@1.1.5.8 日志路径

@H_301_7@可以查看dbca建库日志

@H_301_7@

@H_301_7@路径:/u01/app/oracle/cfgtoollogs/dbca/racdb

@H_301_7@tail -f /u01/app/oracle/cfgtoollogs/dbca/racdb/trace.log

@H_301_7@

@H_301_7@1.1.5.9 验证

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ crsctl stat res -t

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Name Target State Server State details

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Local Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.DATA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.FRA.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.LISTENER.lsnr

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.OCR.dg

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.asm

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 Started,STABLE

@H_301_7@ora.net1.network

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.ons

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@Cluster Resources

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@ora.LISTENER_SCAN1.lsnr

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.MGMTLSNR

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 169.254.166.174 192.

@H_301_7@ 168.2.101,STABLE

@H_301_7@ora.cvu

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.lhr12crac.db

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 Open,ST

@H_301_7@ ABLE

@H_301_7@ora.oc4j

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.raclhr-12cr1-n1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n1 STABLE

@H_301_7@ora.raclhr-12cr1-n2.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@ora.scan1.vip

@H_301_7@ 1 ONLINE ONLINE raclhr-12cr1-n2 STABLE

@H_301_7@--------------------------------------------------------------------------------

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ crsctl check cluster

@H_301_7@CRS-4537: Cluster Ready Services is online

@H_301_7@CRS-4529: Cluster Synchronization Services is online

@H_301_7@CRS-4533: Event Manager is online

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl status database -d lhr12crac

@H_301_7@Instance lhr12cra1 is running on node raclhr-12cr1-n1

@H_301_7@Instance lhr12cra2 is running on node raclhr-12cr1-n2

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl status nodeapps

@H_301_7@VIP raclhr-12cr1-n1-vip is enabled

@H_301_7@VIP raclhr-12cr1-n1-vip is running on node: raclhr-12cr1-n1

@H_301_7@VIP raclhr-12cr1-n2-vip is enabled

@H_301_7@VIP raclhr-12cr1-n2-vip is running on node: raclhr-12cr1-n2

@H_301_7@Network is enabled

@H_301_7@Network is running on node: raclhr-12cr1-n1

@H_301_7@Network is running on node: raclhr-12cr1-n2

@H_301_7@ONS is enabled

@H_301_7@ONS daemon is running on node: raclhr-12cr1-n1

@H_301_7@ONS daemon is running on node: raclhr-12cr1-n2

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config nodeapps

@H_301_7@Network 1 exists

@H_301_7@Subnet IPv4: 192.168.59.0/255.255.255.0/eth0,static

@H_301_7@Subnet IPv6:

@H_301_7@Ping Targets:

@H_301_7@Network is enabled

@H_301_7@Network is individually enabled on nodes:

@H_301_7@Network is individually disabled on nodes:

@H_301_7@VIP exists: network number 1,hosting node raclhr-12cr1-n1

@H_301_7@VIP Name: raclhr-12cr1-n1-vip

@H_301_7@VIP IPv4 Address: 192.168.59.162

@H_301_7@VIP IPv6 Address:

@H_301_7@VIP is enabled.

@H_301_7@VIP is individually enabled on nodes:

@H_301_7@VIP is individually disabled on nodes:

@H_301_7@VIP exists: network number 1,hosting node raclhr-12cr1-n2

@H_301_7@VIP Name: raclhr-12cr1-n2-vip

@H_301_7@VIP IPv4 Address: 192.168.59.163

@H_301_7@VIP IPv6 Address:

@H_301_7@VIP is enabled.

@H_301_7@VIP is individually enabled on nodes:

@H_301_7@VIP is individually disabled on nodes:

@H_301_7@ONS exists: Local port 6100,remote port 6200,EM port 2016,Uses SSL false

@H_301_7@ONS is enabled

@H_301_7@ONS is individually enabled on nodes:

@H_301_7@ONS is individually disabled on nodes:

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config database -d lhr12crac -a

@H_301_7@Database unique name: lhr12crac

@H_301_7@Database name: lhr12cra

@H_301_7@Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1

@H_301_7@Oracle user: oracle

@H_301_7@Spfile: +DATA/LHR12CRAC/PARAMETERFILE/spfile.278.933512629

@H_301_7@Password file: +DATA/LHR12CRAC/PASSWORD/pwdlhr12crac.266.933512143

@H_301_7@Domain:

@H_301_7@Start options: open

@H_301_7@Stop options: immediate

@H_301_7@Database role: PRIMARY

@H_301_7@Management policy: AUTOMATIC

@H_301_7@Server pools:

@H_301_7@Disk Groups: DATA,FRA

@H_301_7@Mount point paths:

@H_301_7@Services:

@H_301_7@Type: RAC

@H_301_7@Start concurrency:

@H_301_7@Stop concurrency:

@H_301_7@Database is enabled

@H_301_7@Database is individually enabled on nodes:

@H_301_7@Database is individually disabled on nodes:

@H_301_7@OSDBA group: dba

@H_301_7@OSOPER group: oinstall

@H_301_7@Database instances: lhr12cra1,lhr12cra2

@H_301_7@Configured nodes: raclhr-12cr1-n1,raclhr-12cr1-n2

@H_301_7@Database is administrator managed

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl status asm

@H_301_7@ASM is running on raclhr-12cr1-n2,raclhr-12cr1-n1

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config asm -a

@H_301_7@ASM home: <CRS home>

@H_301_7@Password file: +OCR/orapwASM

@H_301_7@ASM listener: LISTENER

@H_301_7@ASM is enabled.

@H_301_7@ASM is individually enabled on nodes:

@H_301_7@ASM is individually disabled on nodes:

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl status listener

@H_301_7@Listener LISTENER is enabled

@H_301_7@Listener LISTENER is running on node(s): raclhr-12cr1-n2,raclhr-12cr1-n1

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config listener -a

@H_301_7@Name: LISTENER

@H_301_7@Type: Database Listener

@H_301_7@Network: 1,Owner: grid

@H_301_7@Home: <CRS home>

@H_301_7@ /u01/app/12.1.0/grid on node(s) raclhr-12cr1-n2,raclhr-12cr1-n1

@H_301_7@End points: TCP:1521

@H_301_7@Listener is enabled.

@H_301_7@Listener is individually enabled on nodes:

@H_301_7@Listener is individually disabled on nodes:

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config nodeapps -a -g -s -l

@H_301_7@PRKO-2207 : Warning:-gsdonly option has been deprecated and will be ignored.

@H_301_7@Warning:-listener option has been deprecated and will be ignored.

@H_301_7@Network 1 exists

@H_301_7@Subnet IPv4: 192.168.59.0/255.255.255.0/eth0,Uses SSL false

@H_301_7@ONS is enabled

@H_301_7@ONS is individually enabled on nodes:

@H_301_7@ONS is individually disabled on nodes:

@H_301_7@Name: LISTENER

@H_301_7@Type: Database Listener

@H_301_7@Network: 1,raclhr-12cr1-n1

@H_301_7@End points: TCP:1521

@H_301_7@Listener is enabled.

@H_301_7@Listener is individually enabled on nodes:

@H_301_7@Listener is individually disabled on nodes:

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl status scan

@H_301_7@SCAN VIP scan1 is enabled

@H_301_7@SCAN VIP scan1 is running on node raclhr-12cr1-n2

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ srvctl config scan

@H_301_7@SCAN name: raclhr-12cR1-scan,Network: 1

@H_301_7@Subnet IPv4: 192.168.59.0/255.255.255.0/eth0,static

@H_301_7@Subnet IPv6:

@H_301_7@SCAN 0 IPv4 VIP: 192.168.59.164

@H_301_7@SCAN VIP is enabled.

@H_301_7@SCAN VIP is individually enabled on nodes:

@H_301_7@SCAN VIP is individually disabled on nodes:

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ cluvfy comp clocksync -verbose

@H_301_7@

@H_301_7@Verifying Clock Synchronization across the cluster nodes

@H_301_7@

@H_301_7@Checking if Clusterware is installed on all nodes...

@H_301_7@Oracle Clusterware is installed on all nodes.

@H_301_7@

@H_301_7@Checking if CTSS Resource is running on all nodes...

@H_301_7@Check: CTSS Resource running on all nodes

@H_301_7@ Node Name Status

@H_301_7@ ------------------------------------ ------------------------

@H_301_7@ raclhr-12cr1-n1 passed

@H_301_7@CTSS resource check passed

@H_301_7@

@H_301_7@Querying CTSS for time offset on all nodes...

@H_301_7@Query of CTSS for time offset passed

@H_301_7@

@H_301_7@Check CTSS state started...

@H_301_7@Check: CTSS state

@H_301_7@ Node Name State

@H_301_7@ ------------------------------------ ------------------------

@H_301_7@ raclhr-12cr1-n1 Active

@H_301_7@CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...

@H_301_7@Reference Time Offset Limit: 1000.0 msecs

@H_301_7@Check: Reference Time Offset

@H_301_7@ Node Name Time Offset Status

@H_301_7@ ------------ ------------------------ ------------------------

@H_301_7@ raclhr-12cr1-n1 0.0 passed

@H_301_7@

@H_301_7@Time offset is within the specified limits on the following set of nodes:

@H_301_7@"[raclhr-12cr1-n1]"

@H_301_7@Result: Check of clock time offsets passed

@H_301_7@

@H_301_7@

@H_301_7@Oracle Cluster Time Synchronization Services check passed

@H_301_7@

@H_301_7@Verification of Clock Synchronization across the cluster nodes was successful.

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ ORACLE_SID=lhr12cra1

@H_301_7@[oracle@raclhr-12cR1-N1 bin]$ sqlplus / as sysdba

@H_301_7@

@H_301_7@sql*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 13:52:17 2017

@H_301_7@

@H_301_7@Copyright (c) 1982,Oracle. All rights reserved.

@H_301_7@

@H_301_7@

@H_301_7@Connected to:

@H_301_7@Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

@H_301_7@With the Partitioning,Real Application Clusters,Automatic Storage Management,OLAP,

@H_301_7@Advanced Analytics and Real Application Testing options

@H_301_7@

@H_301_7@sql> set line 9999

@H_301_7@sql> show parameter cluster

@H_301_7@

@H_301_7@NAME TYPE VALUE

@H_301_7@------------------------------------ ---------------------- ------------------------------

@H_301_7@cluster_database boolean TRUE

@H_301_7@cluster_database_instances integer 2

@H_301_7@cluster_interconnects string

@H_301_7@sql> col host_name format a20

@H_301_7@sql> set linesize 200

@H_301_7@sql> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;

@H_301_7@

@H_301_7@INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_STATE INSTANCE_ROLE

@H_301_7@-------------------------------- -------------------- ---------------------------------- ------------------- ------------------------ ------------------ ------------------------------------

@H_301_7@DATABASE_STATUS

@H_301_7@----------------------------------

@H_301_7@lhr12cra1 raclhr-12cR1-N1 12.1.0.2.0 2017-01-17 13:05:14 OPEN NORMAL PRIMARY_INSTANCE

@H_301_7@ACTIVE

@H_301_7@

@H_301_7@lhr12cra2 raclhr-12cR1-N2 12.1.0.2.0 2017-01-17 13:05:59 OPEN NORMAL PRIMARY_INSTANCE

@H_301_7@ACTIVE

@H_301_7@

@H_301_7@

@H_301_7@sql>

@H_301_7@

@H_301_7@

@H_301_7@1.2 卸载

下面卸载掉之前安装好的集群,采用静默安装的方式来安装集群并创建数据库

@H_301_7@kill -9 `ps -ef|grep d.bin| grep -v grep | awk '{print $2}'`

@H_301_7@rm -rf /etc/ora*

@H_301_7@rm -rf /var/tmp/.oracle

@H_301_7@rm -rf /tmp/*

@H_301_7@rm -rf /u01/app/

@H_301_7@修改 @H_301_7@/etc/inittab 删除以下三行@H_301_7@.

@H_301_7@h1:2:respawn:/etc/init.evmd run >/dev/null 2>&1

@H_301_7@h2:2:respawn:/etc/init.cssd fatal >/dev/null 2>&1

@H_301_7@h3:2:respawn:/etc/init.crsd run >/dev/null 2>&1

@H_301_7@dd if=/dev/zero of=/dev/asm-diskc bs=104857600 count=1

@H_301_7@

重新创建相关路径:

@H_301_7@mkdir -p /u01/app/oracle

@H_301_7@mkdir -p /u01/app/grid

@H_301_7@mkdir -p /u01/app/12.1.0/grid

@H_301_7@mkdir -p /u01/app/oracle/product/12.1.0/dbhome_1

@H_301_7@chown -R grid:oinstall /u01/app/grid

@H_301_7@chown -R grid:oinstall /u01/app/12.1.0

@H_301_7@chown -R oracle:oinstall /u01/app/oracle

@H_301_7@chmod -R 775 /u01

@H_301_7@

@H_301_7@mkdir -p /u01/app/oraInventory

@H_301_7@chown -R grid:oinstall /u01/app/oraInventory

@H_301_7@chmod -R 775 /u01/app/oraInventory

@H_301_7@

@H_301_7@然后重启2台主机。

@H_301_7@

About Me

...............................................................................................................................

@H_301_7@本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用

@H_301_7@本文在itpubhttp://blog.itpub.net/26736162)、博客http://www.cnblogs.com/lhrbest和个人微信公众号(xiaomaimiaolhr)上有同步更新

@H_301_7@本文itpub地址:http://blog.itpub.net/26736162/viewspace-2132772/

@H_301_7@本文博客园地址:http://www.cnblogs.com/lhrbest/p/6337508.html

@H_301_7@本文pdf小麦苗云盘地址:http://blog.itpub.net/26736162/viewspace-1624453/

@H_301_7@● QQ群:230161599 微信群:私聊

@H_301_7@联系我请加QQ好友(642808185),注明添加缘由

@H_301_7@2017-01-12 08:00 ~ 2016-01-21 24:00农行完成

@H_301_7@文章内容来源于小麦苗的学习笔记,部分整理自网络,若有侵权或不当之处还请谅解

@H_301_7@版权所有,欢迎分享本文,转载请保留出处

...............................................................................................................................

拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号:xiaomaimiaolhr,扫描右边二维码加入小麦苗的QQ群,学习最实用的数据库技术。

猜你在找的Oracle相关文章