（二）在Unix下Oracle 11g 建库脚本 bsb

#-----------------------------------------------------------------#
# Oracle AIX HA 脚本生成，在主备机以 root 执行
#-----------------------------------------------------------------#
cat > /usr/hascripts/start.sh exit 0
!

cat > /usr/hascripts/stop.sh exit 0
!

cat > /usr/hascripts/ora_start.sh sqlplus / as sysdba <startup 
EOF
!

cat > /usr/hascripts/ora_stop.sh shutdown immediate
EOF
lsnrctl stop 
!

chmod 777 /usr/hascripts/*.sh 

cat >> /etc/hosts <#add for oracle em
40.1.243.126 FXIPDB
!

#--修改oracle密码 
echo 'oracle:Bsbapp12#'  | chpasswd -f  NOCHECK

#------------------------------------------------------------#
# Oracle建库后，同步备机，oracle用户执行  
#------------------------------------------------------------#
#主机执行
cat > /oracle/oraput.sh <ORACLE_SID=fssdb
cd /oracle/product
tar -cvf orabase.tar admin cfgtoollogs checkpoints diag
ftp -i -n 40.1.59.2 bin
cd /oracle/product
put orabase.tar
lcd /oracle/product/11.2.3/dbs
cd /oracle/product/11.2.3/dbs
put init${ORACLE_SID}.ora 
put orapw${ORACLE_SID}
cd /oracle/product/11.2.3/network/admin
lcd /oracle/product/11.2.3/network/admin 
put listener.ora
cd /home/oracle
lcd /home/oracle
put .profile 
!
EOF


chmod 777 /oracle/oraput.sh
/oracle/oraput.sh


#备机执行：
cd /oracle/product
tar -xvf orabase.tar 
#------------------------------------------------#