1) create oracle user and dba group.
oracle_home
rsh, .bash_profiles
[oracle@sun215c]$ more .rhosts
+
[oracle@sun215c]$ more .bash_profile
export ORACLE_BASE=/opt/oracle/9i
export PS1='[\u@\h]$ '
export ORACLE_HOME=/opt/oracle/9i/db
export ORACLE_SID=racg1
PATH=$PATH:/etc/vx/bin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/opt/VRTSat/bin:/sbin:/usr/sbin:$ORACLE_HOME/bin:/usr/local/bin
ORACLE_ADMIN=$ORACLE_HOME/admin
export ORACLE_ADMIN
PATH=$PATH:$ORACLE_HOME/bin:/opt/bin:/usr/cluster/bin:/etc/vx/bin:/opt/VRTSvxvm/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/sbin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/db/lib:/usr/lib:/usr/up/vortex/lib
export LD_LIBRARY_PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
MANPATH=/usr/man:/opt/VRTS/man:/opt/SYMClma/man/:$MANPATH
export PATH MANPATH
2) /etc/system
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmsl=1510
set semsys:seminfo_semmns=3010
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
3) create shared dg and vol
[root@sun215c /]#>vxdg -s init oradg ams_wms0_471 ams_wms0_472
[root@sun215c /]#>vxassist -g oradg make oravol 8g
[root@sun215c /]#>mkfs -F vxfs /dev/vx/rdsk/oradg/oravol
version 7 layout
16777216 sectors, 8388608 blocks of size 1024, log size 16384 blocks
largefiles supported
[root@sun215c /]#>vxassist -g oradg make orasrvvol 300M
[root@sun215c /]#>vxedit -g oradg set user=oracle group=dba mode=660 orasrvvol
[root@sun215c /]#>vxassist -g oradg make spfile 300M
[root@sun215c /]#>vxedit -g oradg set user=oracle group=dba mode=660 spfile
modify main.cf ; reboot both nodes
CFSMount ora_mount (
Critical = 0
MountPoint = "/oracle"
BlockDevice = "/dev/vx/dsk/oradg/oravol"
)
CVMVolDg oradata_vol (
Critical = 0
CVMDiskGroup = oradg
CVMVolume = { oravol }
CVMActivation = sw
)
ora_mount requires oradata_vol
oradata_vol requires vxfsckd
mkdir /oracle ;
chown -R oracle:dba /oracle ;
4) install rdbms and relink oracle
./installsfrac -configure -rsh
ls -rlt $ORACLE_HOME/bin/oracle
5) netca
[oracle@sun215c]$ netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
6) start gsd
[oracle@sun215c]$ gsdctl stat
GSD is not running on the local node
[oracle@sun215c]$ gsdctl start
Successfully started GSD on local node
[oracle@sun215d]$ gsdctl stat
GSD is not running on the local node
[oracle@sun215d]$
[oracle@sun215d]$ gsdctl start
Successfully started GSD on local node
检查srvcfg设置
检查/var/opt/oracle下srvConfig.loc文件,确保包含同样的链接:
srvconfig_loc=/dev/vx/rdsk/oradg/srvcfg
两边应该有同样的配置,否则gsd则不能启动.
[root@sun215c /]#>cd /var/opt/oracle
[root@sun215c oracle]#>ls -rlt
total 6
-rw-r--r-- 1 root other 57 Oct 9 14:43 oraInst.loc
-rw-rw-r-- 1 oracle other 698 Oct 9 15:01 oratab
-rw-rw-r-- 1 oracle other 43 Oct 9 15:01 srvConfig.loc
[root@sun215c oracle]#>more srvConfig.loc
srvconfig_loc=/dev/vx/rdsk/oradg/orasrvvol
[oracle@sun215d]$ pwd
/var/opt/oracle
[oracle@sun215d]$ ls -rtl
total 6
-rw-r--r-- 1 root other 57 Oct 9 14:43 oraInst.loc
-rw-rw-r-- 1 oracle other 698 Oct 9 15:01 oratab
-rw-rw-r-- 1 oracle other 43 Oct 9 15:01 srvConfig.loc
[oracle@sun215d]$ more srvConfig.loc
srvconfig_loc=/dev/vx/rdsk/oradg/orasrvvol
oraInst.loc
inventory_loc=/opt/oracle/9i/oraInventory
inst_group=dba
/var/opt
-rlt
total 18
drwxr-xr-x 2 root other 512 Apr 29 14:10 webconsole
drwxr-xr-x 2 root other 512 Sep 29 17:21 dbed_lic
drwxr-xr-x 4 root other 512 Oct 4 02:04 VRTSmh
drwxr-xr-x 3 root other 512 Oct 4 02:30 VRTSobc
drwxr-xr-x 3 root other 512 Oct 4 02:31 VRTSob
drwxr-xr-x 3 root other 512 Oct 4 02:48 VRTSdcli
drwxr-xr-x 3 root root 512 Oct 4 03:17 VRTSaa
drwxr-xr-x 4 root root 512 Oct 4 03:19 VRTSccg
drwxr-xr-x 2 root root 512 Oct 4 19:19 oracle
-rlt
total 6
-rw-r--r-- 1 root root 57 Oct 4 18:49 oraInst.loc
-rw-rw-r-- 1 oracle root 43 Oct 4 19:19 srvConfig.loc
-rw-r--r-- 1 oracle dba 723 Oct 4 20:12 oratab
建库的时候报:PRKR-1005:adding of cluster database $ORACLE_SID configuration failed,PRKR-1064:General Exception in OCR
[root@sun215c /]#>cd /var/opt
[root@sun215c opt]#>ls -rlt
total 14
drwxr-xr-x 2 root other 512 Oct 9 15:01 oracle
[root@sun215c opt]#>chown root:root oracle
7 ) dbca
##### create db scripts : /opt/oracle/9i/admin/racg/scripts
[oracle@sun215c]$ dbca -datafileDestination /oracle
PRKR-1005:adding of cluster database racg configuration failed, PRKR-1064:General Exception in OCR
SUN下安装ORACLE9208 RAC
上周四完成在SUN下安装ORACLE9208RAC,整个过程还算是顺利,把过程遇到问题和解决方法记录之:
系统环境
CPU:20*1.9G
MEM:130G
STORAGE:4T
1 误安装了legato组件
在把数据库软件rac9201安装好后,为了支持proc,重新运行oui选择program组件,此时系统自动把legato组件也给选中了!装起的时候才发现,为了保证系统的干净和稳定性,决定删除已经安装好的DB软件,重新安装软件,删除过程如下:
$./runInstaller --删除所有组件
$cd /var/opt/oracle/
$rm -rf *
$cd $ORACLE_HOME
$rm -rf *
$cd
$rm -rf oraInventory
2 建库的时候报:PRKR-1005:adding of cluster database $ORACLE_SID configuration failed,PRKR-1064:General Exception in OCR
解决办法:
#ls -l /var/opt/oracle/srvConfig.loc --发现权限有问题
#chown -R oracle:dba /var/opt/oracle/srvConfig.loc
#chmod 755 /var/opt/oracle/srvConfig.loc
$ORACLE_HOME/bin/gsdctl stat -查看gsdctl状态,如果已经启动,立停
$ORACLE_HOME/bin/gsdctl stop
$srvconfig -init -初始化srvconfig
$ORACLE_HOME/bin/gsdctl start -再次启动gsdctl并再次执行创建数据库
8) check
select HOST_NAME, INSTANCE_NAME from v$instance ;
[oracle@sun215c]$ sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.1.0 - Production on Sat Oct 9 16:15:26 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select HOST_NAME, INSTANCE_NAME from v$instance ;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
sun215c
racg1
[oracle@sun215d]$ sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.1.0 - Production on Sat Oct 9 16:15:44 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select HOST_NAME, INSTANCE_NAME from v$instance ;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
sun215d
racg2