Linux7。8下静默安装oracle11。2
一、使用脚本初始化环境
脚本如下:(标红处修改对应的配置需求)
#!/bin/bash
#1.配置主机名/etc/hosts 并关闭防火墙及selinux
echo "172.168.0.xx linux.tk " >> /etc/hosts
#注意修改为服务器的ip和主机名
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
#sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config
#2.安装相关软件包
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.配置内核参数
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
#改授权
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.创建用户组和用户
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper oracle
echo "oracle" | passwd --stdin oracle
#7.创建相关目录
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app
#8.配置oracle用户环境变量
echo "ORACLE_SID=ora; export ORACLE_SID" >> /home/oracle/.bash_profile
#sid指定为现场的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
直接在目录解压,会在当前目录中生成database目录
三、修改应答文件安装数据库软件
修改前建议先备份下
cp /opt/database/response/*.rsp /opt/database/rspbak
3.1、生成修改响应文件(/opt/database/response/db_install.rsp)
备注:清空源文件,复制粘贴如下内容(标红处需要修改对应的设置需求):
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 命令查看进度
# tailf /u01/app/oraInventory/logs/installActions2022-XX-XX_03-28-06PM.log
提示安装结束,需要在root用户执行两个脚本,如下:
# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
四、修改应答文件安装数据库实例(/opt/database/response/dbca.rsp)
安装实例前,需要新建一个实例存放的目录(/home/OracleData/),如下:
# mkdir /home/OracleData
# chown -R oracle:oinstall /home/OracleData/
4.1、修改应答文件
[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、建实例,登录oracle用户
# su - oracle
$ dbca -silent -responseFile /opt/database/response/dbca.rsp
此安装过程是有进度显示,不用tailf查看,不过也可以查看对应的log日志查看进度
4.3、删除实例
编辑应答文件
#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
五、启动监听,配置自启动等
5.1、启动监听
# su – oracle
$ lsnrctl start
查看状态 lsnrctl status
# netstat -tnulp | grep 1521
# ps -ef | grep ora_ | grep -v grep
5.2、设置自启动
修改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加入开机自启动,/etc/rc.d/rc.local中增加
su - oracle -lc /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart
赋权限 chmod +x /etc/rc.d/rc.local
5.3、登录数据库设置权限等
sqlplus / as sysdba
startup;
alter system register;
create user ora identified by ***012;
grant dba to ora;
exit
六、远程连接数据库
6.1、开放1521端口
firewall-cmd --zone=public --add-port=1521/tcp --permanent
firewall-cmd –reload
firewall-cmd --list-ports
刚刚,印度车企发布的这款车,居然在中控内饰上种花说起印度,不少人会对这国家的电影或者小吃印象更深刻,作为全球第二大人口国,经济发展也是日益增长,那印度的汽车工业如何?还是那家在海外通过收购并购的模式发展?今天看完这款概念车,或许
又一国产黑马出现!堪比小华为,70员工做研发,对手英伟达芯片,这两个字一直是我国产业之痛,很多人把芯片理解为CPU,认为芯片就是电脑用芯片手机用的芯片,实际上芯片不仅仅包含这些,还包含驱动芯片电池芯片AI芯片等等,即便是我们手里面的银行
五一长假来了,劳斯莱斯库里南推出旅行套装,绝对是奢侈旅行必备库里南绝对是劳斯莱斯车系中的另类,于2018年上市,当年也是劳斯莱斯年轻化的纪年,但是其骨子里还是一辆超豪华品牌的SUV。SUV就是一辆多用途汽车,库里南也不例外,穿州过省长途旅行
三星MicroLED困境巨量转移难题未解,成本下降之路艰巨三星在MicroLED领域的动作不断,年初三星发布了110吋MicroLED电视,预测三星将新增MicroLED电视生产线,并计划在2021年底前依序推出99寸88寸与76寸的三星
3款大空间67座MPV推荐,比SUV更实用近年,国内消费者对MPV需求日渐提高,多座位的设定对于人员较多的家庭,外出时能满足全家成员乘坐需求,都坐在一辆车愉快出行更合适,而且长期计算,出行费用也会比开多辆车要划算。7座车型
选择自动洗碗机的经验知识我们不仅要注重价格,还要注重设备的性能,配置和功能以及实际操作等。洗碗餐具消毒设备有效果吗?一套要多少钱?想开一个餐具消毒公司的人一开始都会提这样的问题。首先,需要根据各自的情况使
商用自动洗碗机的正确使用方法商用自动洗碗机通常是长龙洗碗机。在洗涤过程中,有必要人工将餐具正确摆放在履带上,通过传动系统带动餐具从一侧移动到另一侧,实现了餐具的自动洗涤过程。因此,省去了篮传式洗碗机的装筐步骤
开箱评测光威弈Pro笔记本内存国产颗粒,圆梦强国开箱评测光威弈Pro笔记本内存国产重器,圆梦强国充满不幸的2020终于过去,疫情爆发停工停产医疗设备需求暴增代工厂产能不足线上办公远程课堂引发计算机需求旺盛,但这其中,存储芯片却价
传MacBooks评估OLED技术,OLED笔记本电脑渗透率有望逐步提升据供应链消息称,苹果开始评估将OLED技术应用于MacBooks等IT产品,并正在与韩国两大面板制造商讨论,以尽量减少与现有LCD产品相比增加的成本。这是继苹果计划在2023年至2
自动洗碗机的维护保养知识1。定期测试清洗机的绝缘性能。定期检查老化的电气部件和接地线。清洗机应确保设备接地良好。项目必须由经验丰富的电工执行2。定期测试洗碗机的电源,确认其满足设备的电源电压要求,避免在过
自动商用洗碗机的维护知识关机后1。关闭洗碗机机电系统,打开检查门,拆下机内主洗涤缸上上喷淋管的堵头进行清洗。如果有任何废物堵塞,应予以清除。2。拆下前中后悬挂的雨帘,并清洗干净。3。打开机器内排水管的电源