oracle 10g rac + vmserver2.0 + suse9 sp4 （下）

 clusterware install   

检查安装

oracle@rac101:~/ora10g_soft/clusterware/cluvfy> ./runcluvfy.sh stage -pre crsinst -n rac101,rac102 -verbose

 

database install
****************

Directions
1. Unzip the file: gunzip
2. Extract the file: cpio -idmv <
3. Installation guides and general Oracle Database 10g documentation can be found here.
4. Review the certification matrix for this product here. oracle@rac101:~/ora10g_soft>


/u01/oracle/product/10g/db/root.sh
rac101:/u01/oracle/ora10g_soft/clusterware/rootpre # /u01/oracle/product/10g/db/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/oracle/product/10g/db

Enter 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 by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.



The following J2EE Applications have been deployed and are accessible at the URLs listed below.

iSQL*Plus URL:


iSQL*Plus DBA URL:
/dba

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

DBCA 创建数据库和ASM实例

DBCA 需要在 RAC 集群的所有节点上配置并运行 Oracle TNS 监听器进程，然后它才能创建集群化数据库。

数据库创建过程应只在集群的一个节点上执行！

 

我们将使用 DBCA 创建集群化数据库。

在执行 DBCA 前，请确保为 $ORACLE_BASE/product/10.2.0/db_1 环境正确设置了 $ORACLE_HOME 和 $PATH。

在试图开始创建集群化数据库之前，还应确保已安装的所有服务（Oracle TNS 监听器、CRS 进程等）正在运行。

（具体图形化的步骤省略）


问题：
*****
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

ORA-27125 while creating the DB instance on Kernel 2.6

 

In this Document

  Symptoms

  Cause

  Solution

  References

 

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1 - Release: 9.2 to 10.2

Linux x86

SUSE \ UnitedLinux x86-64

Linux Itanium

Checked for relevance on 07-Jun-2010

This Problem can be seen on the SUSE SLES9 linux distribution which runs on kernel '2.6.5-7.191'

Symptoms

While starting the database instance following error is encountered.

 

SQL> startup

ORA-27125: unable to create shared memory segment

Linux Error: 1: Operation not permitted

 

Cause

This is caused by '2.6.5-7.nnn' kernels requiring MLOCK privilege for hugetlb memory.

 

 

Solution

 

 

To enable use of "hugetlb memory", or to allow the init.ora parameter "lock_sga=true" to be used, do:

 

    --- Login as root

    --- # echo 1 > /proc/sys/vm/disable_cap_mlock

 

If you need to make this change persistent

 

    --- Login as root

    --- Edit /etc/sysctl.conf

    Add following lines

    # Oracle requires MLOCK priviledge for hugetlb memory.

    vm.disable_cap_mlock=1

    --- Execute the command

    #/etc/init.d/boot.sysctl start

    Setting current sysctl status from /etc/sysctl.conf

    vm.disable_cap_mlock = 1

    --- Dont forget to enable the service.

    chkconfig boot.sysctl on

 

 

References

BUG:4726024 - GETTING ORA-27125 WHEN TRYING TO STARTUP INSTANCE

NOTE:317139.1 - How to Configure SuSE SLES 9 / 10 32-bit for Very Large Memory with ramfs and HugePages

 

显示相关信息 相关的

产品

 

    Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

 

关键字

START INSTANCE; LOCK_SGA; SUSE; X86; SHARED MEMORY SEGMENTS

错误

ORA-27125; OPERATION NOT PERMITTED

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

关于PRKC-1002问题的解决办法

 

在VMWare Server 1.0.8中安装Oracle RAC时, 碰到到了PRKC-1002错误:

 

WARNING: Error while copying directory /u01/oracle/product/10.2.0/db_1 with exclude file list 'null' to nodes 'rac2'. [PRKC-1002 : All the submitted commands did not execute successfully]

 

到Oracle技术支持找到了问题的原因如何解决:

Cause

 

This is because the date on the local node is higher than the date on the remote node(s).

Solution

 

To fix this, set the times of the nodes to be the same.  You can do this with "ntpupdate " to sync the dates.

 

就是解决时间同步后即可. 尽管我安装VMWare的tools之后,并勾选vmware-toolbox的Miscellaneous Options选项,但节点1的时间还是比节点2的快十几秒. 参考了一下《大话Oracle RAC》这本书, 决定选用NTP服务来使时间同步. 刚开始我是用节点1来做NTP服务的,但做完后发现节点1的时间还是比节点2的快几秒,为了保守起见, 我用节点2来做NTP服务.

 

在节点2用root用记编辑/etc/ntp.conf,加入下面这段

 

## add for rac

server 127.127.1.0

fudge  127.127.1.0 stratum 11

driftfile /var/lib/ntp/drift

broadcastdelay 0.008

 

然后在节点1用root用记编辑/etc/ntp.conf,加入下面这段

 

## add for rac

server 192.168.1.131 prefer

driftfile /var/lib/ntp/drift

broadcastdelay 0.008

 

#注意是127.127.1.0而不是127.0.0.1,还有就是192.168.1.131 是节点一的IP地址

 

然后在两个节点执行下面的命令使NTP服务启动

 

/etc/init.d/ntpd start

 

若这样还不可以，那就要把安装数据库的节点1的时间调得比节点2慢点

 

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

vmware server 2.0共享磁盘

 

在VMware中创建共享磁盘

1、创建磁盘

 

在虚拟机软件的安装目录下，有个vmware-vdiskmanager.exe文件（老版本用plainmaker.exe），运行该命令：

 

D:\Program files\VMware\VMware Workstation>vmware-vdiskmanager.exe -c -s 20000MB -a lsilogic -t 2 d:\share\sharedisk.vmdk

 

以上命令在D盘的share文件夹下生成了个20GB的磁盘，有两个文件：

 

sharedisk-flat.vmdk

sharedisk.vmdk

 

 

2、配置虚拟机

 

在虚拟机器界面选择“Edit virtual machine settings”添加硬盘，选“Use a existing virtual disk”，添加sharedisk.vmdk，双击新加的磁盘，在弹出的磁盘属性窗选“advance”，为新加的硬盘选择虚拟设备节点：sharedisk.vmdk选定“SCSI 2:0”。

 

分别打开两台虚拟机目录中的vmx文件，在最后一行添加：

scsi2:0.shared="TRUE"

disk.locking="FALSE"

scsi2:0.SharedBus="Virtual"