ORACLE12C RAC For RHEL6.5 linux 配置注意事项

国庆节前,完成VMWRE WORKSTATION RHEL linux环境下,ORACEL12C RAC环境的安装,在安装地程中,虽然参考一些网上一些技术文档,但发现在实际配置过程中,还是有一要特别注意的地方,因而记录下来,方便日后,查证。、

关于共享磁盘的创建:

在虚拟机里,创建一个三个硬盘,一个是DATA(数据盘),一个是ocr_vote(投票仲裁盘),一个是FRA(快速恢复盘),分别是:8g,10g,10g, 建议这三个硬盘并建立在同一个sharestore文件夹下。

创建过程中,选择:立即分配所有磁盘空间 以及将虚拟磁盘存储为单个文件。

创建磁盘后,打开虚拟机设置,选择硬盘,点击右下角的高级,在虚拟设备节点,下拉框,选择SCIS1:X 硬盘(SCSI),第一个新增的硬盘就是:SCIS1:0 硬盘2(SCSI), 第二个新增的硬盘就是:SCIS1:1 硬盘3(SCSI), 第三个新增的硬盘就是:SCIS1:2 硬盘4(SCSI)。 模式就 选 独立 ,选 永久.

建多一个网络适本器:网络适配器2 的网络连接状态选自定义(U):特定虚拟网络:VMnet2. 配置RAC环境的每台机都要建.

关于共享磁盘的设置:

在一台机创建并设置三个硬盘后,打开这台机机虚机的vmx文件,加上以下内容,方便另外一台机正常访问这台机新增的三个硬盘。特别要注意,加以下文件内容时,要关掉VMWARE WORKSTION,而不是只关掉虚拟机。如果只是关掉虚拟机,而不是关掉VMWARE。改完vmx文件后,再重启虚拟机,会报字典错误。

fileSearchPath = “.”

scsi1.present = “TRUE”

scsi1.virtualDev = “lsilogic”

scsil.sharedBus = “VIRTUAL”

scsi1:0.present = “TRUE”

scsi1:0.mode = “independent-persistent”

scsi1:0.fileName = “E:\ShareStore\rac12c\ocr_vote.vmdk”

scsi1:0.deviceType = “disk”

scsi1:0.redo = “”

scsi1:1.present = “TRUE”

scsi1:1.mode = “independent-persistent”

scsi1:1.fileName = “E:\ShareStore\rac12c\data.vmdk”

scsi1:1.deviceType = “disk”

scsi1:1.redo = “”

scsi1:2.present = “TRUE”

scsi1:2.mode = “independent-persistent”

scsi1:2.fileName = “E:\ShareStore\rac12c\fra.vmdk”

scsi1:2.deviceType = “disk”

scsi1:2.redo = “”

阅读更多

DBCA 创建 MGMTDB数据库失败的问题解决

Completing Database Creation
DBCA_PROGRESS : 68%
DBCA_PROGRESS : 79%
ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

DBCA_PROGRESS : DBCA Operation failed.

WARNING: Skipping line: 79% complete
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: DBCA Operation failed.
WARNING: Skipping line: DBCA Operation failed.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: Look at the log file “/grid/set/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb.log” for further details.
WARNING: Skipping line: Look at the log file “/grid/set/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb.log” for further details.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management RepositoINFO: Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository

解决办法:调整/dev/shm 的大小为2G以上,再手动执行MGMTDB的创建命令。

 

 

Oracle12C MGMTDB数据库创建失败的问题解决

grid@node01 grid]$ dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName OCR -datafileJarLocation /grid/app/grid/12.1.0/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
Cannot create directory “/grid/app/grid/cfgtoollogs/dbca”.
The ORACLE_BASE value in your environment “/grid/app/grid” is different from the one specified during installation “/grid/set/grid”. DBCA uses ORACLE_BASE value from environment variable to derive default file locations and initialization parameters for the database. Are you sure you want to use the new ORACLE_BASE setting?
Error writing into silent log — /grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM (No such file or directory)

+OCR has enough space. Required space is 1566 MB , available space is 6366 MB.
File Validations Successful.
Error writing into silent log — /grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM (No such file or directory)

Validation of server pool succeeded.
Error writing into silent log — /grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM (No such file or directory)
Cannot create directory “/grid/app/grid/cfgtoollogs/dbca/_mgmtdb”.
Error writing into silent log — /grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM (No such file or directory)
Error in file copy from </grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM> to </grid/app/grid/cfgtoollogs/dbca/_mgmtdb.log>
Look at the log file “/grid/app/grid/cfgtoollogs/dbca/silent.log_2018-09-29_11-19-27-PM” for further details.

 

解决办法:

[root@node01 ~]# chown grid:oinstall /grid/app/grid/

[grid@node01 ~]$ dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName OCR -datafileJarLocation /grid/app/grid/12.1.0/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
Registering database with Oracle Grid Infrastructure
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete