◆Oracle使用者的環境設定:
$ cat .profile
# Created for oracle RAC by ljg, 20091230 --- begin
#
umask 022
ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
CRS_HOME=/u01/crs/oracle/product/10/app;export CRS_HOME
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;export ORACLE_HOME
ORACLE_SID=eoms1;export ORACLE_SID
AIXTHREAD_SCOPE=S;export AIXTHREAD_SCOPE
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:$ORACLE_HOME/bin:$CRS_HOME/bin:.;export PATH
#
# Created for oracle RAC by ljg, 20091230 --- end
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
◆oracleRAC操作文法(4個層次):
1、服務、執行個體、資料庫:
srvctl status|start|stop service -d eoms -s TAF_EOMS_SERVER
srvctl status|start|stop instance -d eoms -i eoms1
srvctl status|start|stop database -d eoms
2、ASM執行個體:
srvctl status|start|stop asm -n sdwgrac1
3、nodeapps資源:
srvctl status|start|stop nodeapps -n sdwgrac1
4、crs:
crs_stat -t
crs_start res|-all
crs_stop res|-all
crsctl check|stop|start crs
/etc/init.crs start|stop
◆為ASM增加磁碟的操作步驟:
在盤陣側為ASM新添加vdisk後,在兩個節點執行以下步驟
cfgmgr:掃描硬體改動
lspv:檢查是否有新盤
lsattr -El hdiskn:查看新加盤的屬性
chdev -l hdiskn -a reserve_policy=no_reserve:把新加的盤設為共用
(如果有pvid,需要如下方式取消:chdev -l hdiskn -a pv=clear)
修改pv的屬性為oracle使用者使用:
chown oracle:dba /dev/rhdiskn
chmod 660 /dev/rhdiskn
最後在+ASM1執行個體添加磁碟:
$ export ORACLE_SID=+ASM1
$ sqlplus "/ as sysdba"
alter diskgroup DATA add disk '/dev/rhdiskn';
select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;
alter diskgroup DATA drop disk DATA_0001;
◆建立資料表空間的步驟:
create (bigfile) tablespace test_ljg datafile '+DATA0/pm/datafile/test_ljg' size 200m;
alter database datafile '+DATA0/pm/datafile/test_ljg' resize 300m;
drop tablespace test_ljg including contents and datafiles;