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

cat > /usr/hascripts/stop.sh < su - oracle -c "/usr/hascripts/ora_stop.sh"
exit 0
!

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

cat > /usr/hascripts/ora_stop.sh < sqlplus / as sysdba < 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 < user oracle Bsbapp12#
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
#------------------------------------------------#

ITPub博客

（二）在Unix下Oracle 11g 建库脚本 bsb_oracle_create_db.sh 备机同步及HA脚本生成

最新文章