rhel6.4 自动安装oracle 11g客户端
1、安装过程
点击(此处)折叠或打开
[root@localhost ~]# cd /tmp/client/[root@localhost client]# lltotal 640676-rw-r--r--. 1 root root 5554 Dec 13 16:24 auto_install_oracle_client.sh #主脚本-rw-r--r--. 1 root root 12062 Dec 13 16:24 client_install.rsp #静默安装配置文件-rw-r--r--. 1 root root 656026876 Dec 13 16:22 p13390677_112040_Linux-x86-64_4of7.zip #安装包[root@localhost client]# chmod u+x auto_install_oracle_client.sh #赋权[root@localhost client]# ./auto_install_oracle_client.sh #在文件所在路径使用root用户执行tmp is.................................................... [ok] #检查/tmp目录，需要大于120 MBswap is.................................................... [ok] #检查swap空间，需要大于150 MBfinding sqlplus #通过find查找sqlplus，此处需要等待env is.................................................... [ok] #环境okpkg is.................................................... [ok] #安装包okrsp is.................................................... [ok] #静默安装配置文件okplease input which user to install oracle client:oracle #可以是已经存在的用户，也可以是新用户please input ip addr:192.168.1.222 #输入该系统ip地址unziping p13390677_112040_Linux-x86-64_4of7.zip #正在解压安装包，此处需要等待starting install,may be take a minutes,you can see log:/tmp/install_client.log #需要等待starting orainstRoot.sh,you can see /tmp/orainstRoot.sh.logThe execution of the script is complete.################################################################################please use root to run /tmp/del_client.sh to deinstall####### #卸载脚本#########dba oinstall oracle need your check################### #若需要，用户和组需手动删除#######################################################################2、验证过程点击(此处)折叠或打开
[root@localhost client]# su - oracle[oracle@localhost ~]$ cd $ORACLE_HOME/network/admin/[oracle@localhost admin]$ vi tnsnames.ora[oracle@localhost admin]$ cat tnsnames.oraORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.42)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )[oracle@localhost admin]$ sqlplus scott/tiger@orclSQL>3、卸载过程（需根据实际需求手动删除用户组和用户）点击(此处)折叠或打开
[root@localhost client]# /tmp/del_client.sh[root@localhost client]# su - oracle[oracle@localhost ~]$ sqlplus-bash: sqlplus: command not foundauto_install_oracle_client.sh的内容：
点击(此处)折叠或打开
#!/bin/bash#检查/tmp空间if [ `df -m /tmp|wc -l` -eq 2 ];then tmp=`df -m /tmp|tail -1|awk '{print $4}'`else tmp=`df -m /tmp|tail -1|awk '{print $3}'`fiif [ $tmp -gt 120 ];then echo "tmp is.................................................... [ok]"else echo "[fail]====>/tmp must more than 120MB"exit 5fi#检查swap空间if [ `free -m|grep Swap|awk '{print $2}'` -gt 150 ];then echo "swap is.................................................... [ok]"else echo "[fail]====>swap must more than 150MB"exit 5fi#检查该主机是否已经安装了sqlplusecho "finding sqlplus"if [ `find / -name "sqlplus"|grep sqlplus|wc -l` -gt 0 ]then echo "this system has installed oracle client.install process exit!" echo "install process stop!" exit 0else echo "env is.................................................... [ok]"fi#检查客户端安装包是否已经上传LOCALDIR=`pwd`if [ `ls -l $LOCALDIR|grep "p13390677_112040_Linux-x86-64_4of7.zip" |wc -l` -gt 0 ]then echo "pkg is.................................................... [ok]"else echo "please upload p13390677_112040_Linux-x86-64_4of7.zip in $LOCALDIR" echo "install process stop!" exit 0fi#检查配置文件是否已经上传LOCALDIR=`pwd`if [ `ls -l $LOCALDIR|grep client_install.rsp|wc -l` -gt 0 ]then echo "rsp is.................................................... [ok]"else echo "please upload client_install.rsp in $LOCALDIR" echo "install process stop!" exit 0fi#获取用户名、ORACLE_BASE、ip地址信息echo -e "please input which user to install oracle client:\c"read USERNAMEORACLE_BASE=/home/$USERNAME/oracle_clientecho -e "please input ip addr:\c"read ip_addr#备份和修改/etc/hosts文件cp /etc/hosts /etc/hosts_lihbbakecho "$ip_addr `hostname`">>/etc/hosts#备份oraInst.loc文件mv -f /etc/oraInst.loc /etc/oraInst.loc_lihbbak >/dev/null 2>&1#创建dba、oinstall用户组，创建用户/usr/sbin/groupadd dba >/dev/null 2>&1/usr/sbin/groupadd oinstall >/dev/null 2>&1/usr/sbin/useradd -m -g oinstall -G dba $USERNAME >/dev/null 2>&1#创建目录并附权mkdir -p $ORACLE_BASE >/dev/null 2>&1cd $ORACLE_BASEmkdir oraInventorychown -R $USERNAME:oinstall $ORACLE_BASE#解压安装包并附权echo "unziping p13390677_112040_Linux-x86-64_4of7.zip"cd $LOCALDIR/usr/bin/unzip p13390677_112040_Linux-x86-64_4of7.zip >/dev/null 2>&1chown -R $USERNAME:oinstall clientchown $USERNAME:oinstall client_install.rsp#备份并修改配置文件cp client_install.rsp client_install.rsp_lihbbaksed -i "s|/u01/app|$ORACLE_BASE|g" client_install.rsp#配置用户环境并安装软件echo "starting install,may be take a minutes,you can see log:/tmp/install_client.log"su - $USERNAME </tmp/install_client.log echo "export ORACLE_BASE=$ORACLE_BASE" >>/home/$USERNAME/.bash_profile echo "export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0.4/client_1" >>/home/$USERNAME/.bash_profile echo 'export PATH=\$ORACLE_HOME/bin:\$PATH' >>/home/$USERNAME/.bash_profile echo 'export LD_LIBRARY_PATH=$ORACLE_BASE/oracle/product/11.2.0.4/client_1/lib' >>/home/$USERNAME/.bash_profile source ~/.bash_profile >/dev/null 2>&1 cd $LOCALDIR/client ./runInstaller -silent -showProgress -ignorePrereq -waitforcompletion -responseFile $LOCALDIR/client_install.rspEOF#执行root.sh脚本sleep 2secho "starting orainstRoot.sh,you can see /tmp/orainstRoot.sh.log"$ORACLE_BASE/oraInventory/orainstRoot.sh >/tmp/orainstRoot.sh.log 2>&1tail -1 /tmp/orainstRoot.sh.log#修改ORACLE_HOME/bin的权限chmod 755 $ORACLE_BASE/oracle/product/11.2.0.4/client_1/bin/*#配置tnsnames.ora文件用于测试su - $USERNAME </dev/null source ~/.bash_profile cd $ORACLE_BASE/oracle/product/11.2.0.4/client_1/network/admin touch tnsnames.ora echo 'ORATEST1 ='>>tnsnames.ora echo ' (DESCRIPTION = ' >>tnsnames.ora echo ' (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.249)(PORT = 1521)) ' >>tnsnames.ora echo ' (CONNECT_DATA = ' >>tnsnames.ora echo ' (SERVER = DEDICATED) ' >>tnsnames.ora echo ' (SERVICE_NAME = oratest1) ' >>tnsnames.ora echo ' ) ' >>tnsnames.ora echo ' ) ' >>tnsnames.oraEOF#生成卸载脚本touch /tmp/del_client.sh >/dev/null 2>&1echo "#!/bin/bash" >/tmp/del_client.shecho "cd $LOCALDIR" >>/tmp/del_client.shecho 'rm -rf client' >>/tmp/del_client.shecho 'mv -f /etc/hosts_lihbbak /etc/hosts >/dev/null 2>&1' >>/tmp/del_client.shecho 'mv -f client_install.rsp_lihbbak client_install.rsp >/dev/null 2>&1' >>/tmp/del_client.shecho "rm -rf $ORACLE_BASE" >>/tmp/del_client.shecho "mv -f /etc/oraInst.loc_lihbbak /etc/oraInst.loc >/dev/null 2>&1 " >>/tmp/del_client.shchmod u+x /tmp/del_client.shecho '#########################################################################'echo '###########please use root to run /tmp/del_client.sh to deinstall#######'echo "###########dba oinstall $USERNAME need your check################"echo '#########################################################################'client_install.rsp 的内容：点击(此处)折叠或打开
[root@localhost client]# cat client_install.rsp |grep -v ^# |grep -v ^$oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v11_2_0ORACLE_HOSTNAME=UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=enORACLE_HOME=/u01/app/oracle/product/11.2.0.4/client_1ORACLE_BASE=/u01/app/oracleoracle.install.client.installType=Administratororacle.install.client.upgrading=falseoracle.install.client.customComponents="oracle.sqlj:11.2.0.4.0","oracle.rdbms.util:11.2.0.4.0","oracle.javavm.client:11.2.0.4.0","oracle.sqlplus:11.2.0.4.0","oracle.dbjava.jdbc:11.2.0.4.0","oracle.ldap.client:11.2.0.4.0","oracle.rdbms.oci:11.2.0.4.0","oracle.precomp:11.2.0.4.0","oracle.xdk:11.2.0.4.0","oracle.network.aso:11.2.0.4.0","oracle.assistants.oemlt:11.2.0.4.0","oracle.oraolap.mgmt:11.2.0.4.0","oracle.network.client:11.2.0.4.0","oracle.network.cman:11.2.0.4.0","oracle.network.listener:11.2.0.4.0","oracle.ordim.client:11.2.0.4.0","oracle.odbc:11.2.0.4.0","oracle.has.client:11.2.0.4.0","oracle.dbdev:11.2.0.4.0","oracle.rdbms.scheduler:11.2.0.4.0"oracle.install.client.schedulerAgentHostName=oracle.install.client.schedulerAgentPortNumber=oracle.installer.autoupdates.option=SKIP_UPDATESoracle.installer.autoupdates.downloadUpdatesLoc=AUTOUPDATES_MYORACLESUPPORT_USERNAME=AUTOUPDATES_MYORACLESUPPORT_PASSWORD=PROXY_HOST=PROXY_PORT=PROXY_USER=PROXY_PWD=PROXY_REALM=声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
![[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：REPLICA ON子句](/upload/rand_pic/2-05.jpg)
