在Suse Linux下 Oracle 11g 建庫指令碼-準備檔案系統及使用者oracle

lvcreate -L 5G -n lv_oradata     vg_oracle
lvcreate -L 2G -n lv_oraredo1    vg_oracle
lvcreate -L 2G -n lv_oraredo2    vg_oracle
lvcreate -L 5G -n lv_archive     vg_oracle


mkfs.ext3 -F /dev/mapper/vg_oracle-lv_archive 
mkfs.ext3 -F /dev/mapper/vg_oracle-lv_oradata 
mkfs.ext3 -F /dev/mapper/vg_oracle-lv_oraredo1 
mkfs.ext3 -F /dev/mapper/vg_oracle-lv_oraredo2 

mkdir /oraredo1
mkdir /oraredo2
mkdir /oradata
mkdir /archivelog

--開機自動掛載 
cat >> /etc/fstab   < /dev/mapper/vg_oracle-lv_archive           /archivelog     ext3 defaults 1 2
/dev/mapper/vg_oracle-lv_oradata           /oradata        ext3 defaults 1 2
/dev/mapper/vg_oracle-lv_oraredo1        /oraredo1       ext3 defaults 1 2
/dev/mapper/vg_oracle-lv_oraredo2        /oraredo2       ext3 defaults 1 2
EOF

useradd -m -d /oracle  -g oinstall -G dba,oper  oracle 
echo "oracle:oracle" | chpasswd 
chown -R oracle:oinstall /oraredo1
chown -R oracle:oinstall /oraredo2
chown -R oracle:oinstall /oradata
chown -R oracle:oinstall /flashrecovery
chown -R oracle:oinstall /archivelog