一、使用腳本初始化環(huán)境
網(wǎng)站建設(shè)哪家好,找創(chuàng)新互聯(lián)公司!專注于網(wǎng)頁設(shè)計(jì)、網(wǎng)站建設(shè)、微信開發(fā)、小程序開發(fā)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項(xiàng)目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了定西免費(fèi)建站歡迎大家使用!
腳本如下:(標(biāo)紅處修改對應(yīng)的配置需求)
#!/bin/bash
#1.配置主機(jī)名/etc/hosts 并關(guān)閉防火墻及selinux
echo ' 172.168.0.xx linux.tk ' /etc/hosts
#注意修改為服務(wù)器的ip和主機(jī)名
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
#sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
#2.安裝相關(guān)軟件包
yum -y install telnet vim lszrz gcc make binutils gcc-c++ compat-libstdc++-33 elfutils-libelf-devel
elfutils-libelf-devel-static ksh libaio libaio-devel numactl-devel sysstat
unixODBC unixODBC-devel pcre-devel wget unzip
#3.配置內(nèi)核參數(shù)
echo "fs.aio-max-nr = 1048576" /etc/sysctl.conf
echo "fs.file-max = 6815744" /etc/sysctl.conf
echo "kernel.shmmni = 4096" /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65500" /etc/sysctl.conf
echo "net.core.rmem_default = 262144" /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" /etc/sysctl.conf
echo "net.core.wmem_default = 262144" /etc/sysctl.conf
echo "net.core.wmem_max = 1048576" /etc/sysctl.conf
sysctl -p
#4.oracle用戶資源限制
echo "oracle soft nproc 2047" /etc/security/limits.conf
echo "oracle hard nproc 16384" /etc/security/limits.conf
echo "oracle soft nofile 4096" /etc/security/limits.conf
echo "oracle hard nofile 65536" /etc/security/limits.conf
#5.登錄配置
echo "session required /lib64/security/pam_limits.so" /etc/pam.d/login
echo "session required pam_limits.so" /etc/pam.d/login
#改授權(quán)
echo "if [ $USER = 'oracle' ];then" /etc/profile
echo "if [ $SHELL = '/bin/ksh' ];then" /etc/profile
echo "ulimit -p 16384" /etc/profile
echo "ulimit -n 65536" /etc/profile
echo "else" /etc/profile
echo "ulimit -u 16384 -n 65536" /etc/profile
echo "fi" /etc/profile
echo "fi" /etc/profile
source /etc/profile
#6.創(chuàng)建用戶組和用戶
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper oracle
echo 'oracle' | passwd --stdin oracle
#7.創(chuàng)建相關(guān)目錄
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app
#8.配置oracle用戶環(huán)境變量
echo "ORACLE_SID=ora; export ORACLE_SID" /home/oracle/.bash_profile
#sid指定為現(xiàn)場的sid
echo "ORACLE_BASE= /u01/app/oracle ; export ORACLE_BASE" /home/oracle/.bash_profile
echo "ORACLE_HOME=$ORACLE_BASE/ product/11.2.0/dbhome_1 ; export ORACLE_HOME" /home/oracle/.bash_profile
echo "ORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATH" /home/oracle/.bash_profile
echo "ORACLE_TERM=xterm; export ORACLE_TERM" /home/oracle/.bash_profile
echo "TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN" /home/oracle/.bash_profile
echo "ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11" /home/oracle/.bash_profile
echo "PATH=.:${JAVA_HOME}/bin:${PATH}:$ORACLE_HOME/bin " /home/oracle/.bash_profile
echo "PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin " /home/oracle/.bash_profile
echo "export PATH " /home/oracle/.bash_profile
echo "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" /home/oracle/.bash_profile
echo "LD_LIBRARY_PATH=$ORACLE_HOME/lib" /home/oracle/.bash_profile
echo "LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib " /home/oracle/.bash_profile
echo "LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib " /home/oracle/.bash_profile
echo "export LD_LIBRARY_PATH" /home/oracle/.bash_profile
echo "export LANG=en_US.UTF-8 " /home/oracle/.bash_profile
echo "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" /home/oracle/.bash_profile
echo "CLASSPATH=$ORACLE_HOME/JRE " /home/oracle/.bash_profile
echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib" /home/oracle/.bash_profile
echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib" /home/oracle/.bash_profile
echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib" /home/oracle/.bash_profile
echo "export CLASSPATH" /home/oracle/.bash_profile
echo "THREADS_FLAG=native; export THREADS_FLAG" /home/oracle/.bash_profile
echo "nls_date_format='yyyy-mm-dd hh24:mi:ss' " /home/oracle/.bash_profile
echo "export nls_date_format " /home/oracle/.bash_profile
echo "export TEMP=/tmp " /home/oracle/.bash_profile
echo "export TMPDIR=/tmp " /home/oracle/.bash_profile
echo "umask 022 " /home/oracle/.bash_profile
source ~/.bash_profile
二、上傳或者下載oracle安裝包并解壓,例如放置在/opt/目錄下
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
直接在目錄解壓,會在當(dāng)前目錄中生成database目錄
三、修改應(yīng)答文件安裝數(shù)據(jù)庫軟件
修改前建議先備份下
cp /opt/database/response/*.rsp /opt/database/rspbak
3.1、生成修改響應(yīng)文件(/opt/database/response/db_install.rsp)
備注:清空源文件,復(fù)制粘貼如下內(nèi)容(標(biāo)紅處需要修改對應(yīng)的設(shè)置需求):
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME= linux.tk
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION= /u01/app/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE= /u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:10.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
3.2、開始安裝
1)、用oracle用戶登錄操作
# su - oracle
$ cd /opt/database
$ ./runInstaller -silent -responseFile /opt/database/response/db_install.rsp
2)、在安裝過程中可以新開會話,使用tailf 命令查看進(jìn)度
# tailf /u01/app/oraInventory/logs/installActions2022-XX-XX_03-28-06PM.log
提示安裝結(jié)束,需要在root用戶執(zhí)行兩個(gè)腳本,如下:
# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
四、修改應(yīng)答文件安裝數(shù)據(jù)庫實(shí)例(/opt/database/response/dbca.rsp)
安裝實(shí)例前,需要新建一個(gè)實(shí)例存放的目錄(/home/OracleData/),如下:
# mkdir /home/OracleData
# chown -R oracle:oinstall /home/OracleData/
4.1、修改應(yīng)答文件
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "ora"
SID = "ora"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "***012"
SYSTEMPASSWORD = "***012"
DATAFILEDESTINATION = /home/OracleData/
RECOVERYAREADESTINATION = /u01/app/oracle/flash_recovery_area
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "2048"
4.2、建實(shí)例,登錄oracle用戶
# su - oracle
$ dbca -silent -responseFile /opt/database/response/dbca.rsp
此安裝過程是有進(jìn)度顯示,不用tailf查看,不過也可以查看對應(yīng)的log日志查看進(jìn)度
4.3、刪除實(shí)例
編輯應(yīng)答文件
#vim /opt/database/response/del_dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "deleteDatabase"
[DELETEDATABASE]
SOURCEDB = "ora "
$ dbca -silent -responseFile del_dbca.rsp
五、啟動(dòng)監(jiān)聽,配置自啟動(dòng)等
5.1、啟動(dòng)監(jiān)聽
# su – oracle
$ lsnrctl start
查看狀態(tài) lsnrctl status
# netstat -tnulp | grep 1521
# ps -ef | grep ora_ | grep -v grep
5.2、設(shè)置自啟動(dòng)
修改vim /etc/oratab 如下
ora:/u01/app/oracle/product/11.2.0/dbhome_1: Y
5.3、修改dbstart文件
vim /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart
將ORACLE_HOME_LISTNER=$1
修改為ORACLE_HOME_LISTNER=$ORACLE_HOME
5.4、將dbstart加入開機(jī)自啟動(dòng),/etc/rc.d/rc.local中增加
su - oracle -lc /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart
賦權(quán)限 chmod +x /etc/rc.d/rc.local
5.3、登錄數(shù)據(jù)庫設(shè)置權(quán)限等
sqlplus / as sysdba
startup;
alter system register;
create user ora identified by ***012;
grant dba to ora;
exit
六、遠(yuǎn)程連接數(shù)據(jù)庫
6.1、開放1521端口
firewall-cmd --zone=public --add-port=1521/tcp --permanent
firewall-cmd –reload
firewall-cmd --list-ports
首先,否定樓上說法。靜默安裝甚至于用腳本結(jié)合響應(yīng)文件實(shí)現(xiàn)靜默自動(dòng)安裝都是可以實(shí)現(xiàn)的,你可以參照下面這篇文章作為入門。
靜默安裝指的是不需要值守和輸入各項(xiàng)安裝參數(shù)的安裝方式,其實(shí)是將安全的參數(shù)都指定到一個(gè)文件里了,其實(shí)意義不大,因?yàn)镺racle的OUI安裝并不復(fù)雜,而且你也不會大規(guī)模的安裝很多個(gè)Oracle。
切入到oracle用戶下
進(jìn)入/u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca
目錄,vim編輯靜默安裝文件dbca.rsp
主要配置[GENERAL][CREATEDATABASE]這2個(gè)模塊下的配置即可
執(zhí)行如下命令安裝
dbca -silent -responseFile /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/dbca.rsp
安裝完成,lsnrctl status檢查監(jiān)聽吧。
此錯(cuò)誤是因?yàn)榘惭bOracle的用戶(一般是oracle用戶),沒有權(quán)限調(diào)用圖形界面,只需退出oracle用戶,在root下執(zhí)行xhost +命令,然后再進(jìn)入oracle用戶重新運(yùn)行./runInstaller即可 [root@wyzc ~]# xhost + [root@wyzc ~]# su - oracle。
oracle 11gR2
1、數(shù)據(jù)庫安裝環(huán)境準(zhǔn)備
1)編輯/etc/sysctl.con
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Enter the following command to change the current values of the kernel parameters:
# /sbin/sysctl -p
2)編輯/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
3)創(chuàng)建oracle用戶,組
groupadd install;
groupadd oper;
groupadd dba;
useradd -g oinstall -G dba,oper oracle
passwd oracle
4) oracle相關(guān) 環(huán)境變量設(shè)置
.bash_profile文件中加入如下內(nèi)容:
export ORACLE_SID=orcl
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
保存后使環(huán)境變量生效。
. .bash_profile
5)創(chuàng)建安裝目錄
# mkdir /opt/app
#chown -R oracle:oinstall /opt/app
2、準(zhǔn)備靜默安裝響應(yīng)文件
1)利用圖形化界面生成rsp文件
運(yùn)行到oracle 安裝目錄下
./runInstaller
到最后快filish的時(shí)候點(diǎn)擊 Save Response File 按鈕制定db.rsp文件存放路徑;最后cancel安裝界面。
2)如果不能執(zhí)行圖形化界面錄制,可以通過編輯現(xiàn)有的rsp文件
打開安裝文件路徑找到response文件夾里面的 db_install.rsp文件。
根據(jù)文件提示修改相關(guān)內(nèi)容,一般是安裝組,ORACLE_HOME,ORACLE_BASE 路徑等信息。
3、執(zhí)行靜默安裝操作
1)開始靜默安裝
$ ./runInstaller -silent -noconfig -ignorePrereq -responseFile /home/oracle/db.rsp
2)查看安裝過程
可以到/opt/app/oraInventory/logs 目錄下查看安裝進(jìn)度。
tail -100f installActions2012-03-13_10-36-42AM.log
3)安裝成功提示執(zhí)行腳本
到最后提示:
/opt/app/oracle/oraInventory/orainstRoot.sh
/opt/app/oracle/product/11.2.0/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
標(biāo)題名稱:oracle如何靜默安裝,oracle靜默安裝實(shí)例
文章來源:http://muchs.cn/article38/hcjgsp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供小程序開發(fā)、App設(shè)計(jì)、企業(yè)建站、ChatGPT、全網(wǎng)營銷推廣、品牌網(wǎng)站制作
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)