OEL7.1安装oracle 12c简单步骤
发表于:2025-02-05 作者:千家信息网编辑
千家信息网最后更新 2025年02月05日,设置主机名:[root@db12c ~]# hostnamectl set-hostname db12c --static[root@db12c ~]# cat /etc/hosts127.0.0.1
千家信息网最后更新 2025年02月05日OEL7.1安装oracle 12c简单步骤
设置主机名:
[root@db12c ~]# hostnamectl set-hostname db12c --static[root@db12c ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.34.189 db12c[root@db12c ~]# hostnamectl Static hostname: db12c Icon name: computer Chassis: n/a Machine ID: 5e84ad7084be4550be7929df16f31ea7 Boot ID: 4793b89804f849bd86464594eb107e22 Virtualization: vmware Operating System: Oracle Linux Server 7.1 CPE OS Name: cpe:/o:oracle:linux:7:1 Kernel: Linux 3.8.13-55.1.6.el7uek.x86_64 Architecture: x86_64
添加组和用户:
[root@db12c ~]# groupadd -g 54321 oinstall[root@db12c ~]# groupadd -g 54322 dba[root@db12c ~]# groupadd -g 54323 oper[root@db12c ~]# groupadd -g 54324 backupdba[root@db12c ~]# groupadd -g 54325 dgdba[root@db12c ~]# groupadd -g 54326 kmdba[root@db12c ~]# groupadd -g 54327 asmdba[root@db12c ~]# groupadd -g 54328 asmoper[root@db12c ~]# groupadd -g 54329 asmadmin[root@db12c ~]# useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
设置密码:
[root@db12c ~]# passwd oracleChanging password for user oracle.New password: BAD PASSWORD: The password is shorter than 8 charactersRetype new password: passwd: all authentication tokens updated successfully.
安装软件包:
[root@db12c Packages]# yum install oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64.rpm -yLoaded plugins: langpacksExamining oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64.rpm: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64Marking oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64.rpm to be installedResolving Dependencies--> Running transaction check---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-3.el7 will be installed--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64--> Running transaction check---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed---> Package gcc-c++.x86_64 0:4.8.3-9.el7 will be installed---> Package ksh.x86_64 0:20120801-22.el7 will be installed---> Package libaio-devel.x86_64 0:0.3.109-12.el7 will be installed---> Package libstdc++-devel.x86_64 0:4.8.3-9.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved===================================================================================================================================== Package Arch Version Repository Size=====================================================================================================================================Installing: oracle-rdbms-server-12cR1-preinstall x86_64 1.0-3.el7 /oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64 43 kInstalling for dependencies: compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k compat-libstdc++-33 x86_64 3.2.3-72.el7 ol7_latest 190 k gcc-c++ x86_64 4.8.3-9.el7 ol7_latest 7.2 M ksh x86_64 20120801-22.el7 ol7_latest 879 k libaio-devel x86_64 0.3.109-12.el7 ol7_latest 12 k libstdc++-devel x86_64 4.8.3-9.el7 ol7_latest 1.5 MTransaction Summary=====================================================================================================================================Install 1 Package (+6 Dependent packages)Total size: 9.8 MTotal download size: 9.7 MInstalled size: 29 MDownloading packages:-------------------------------------------------------------------------------------------------------------------------------------Total 42 MB/s | 9.7 MB 00:00:00 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : libstdc++-devel-4.8.3-9.el7.x86_64 1/7 Installing : gcc-c++-4.8.3-9.el7.x86_64 2/7 Installing : libaio-devel-0.3.109-12.el7.x86_64 3/7 Installing : compat-libcap1-1.10-7.el7.x86_64 4/7 Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 5/7 Installing : ksh-20120801-22.el7.x86_64 6/7 Installing : oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64 7/7 Verifying : ksh-20120801-22.el7.x86_64 1/7 Verifying : gcc-c++-4.8.3-9.el7.x86_64 2/7 Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 3/7 Verifying : compat-libcap1-1.10-7.el7.x86_64 4/7 Verifying : libaio-devel-0.3.109-12.el7.x86_64 5/7 Verifying : oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64 6/7 Verifying : libstdc++-devel-4.8.3-9.el7.x86_64 7/7Installed: oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-3.el7 Dependency Installed: compat-libcap1.x86_64 0:1.10-7.el7 compat-libstdc++-33.x86_64 0:3.2.3-72.el7 gcc-c++.x86_64 0:4.8.3-9.el7 ksh.x86_64 0:20120801-22.el7 libaio-devel.x86_64 0:0.3.109-12.el7 libstdc++-devel.x86_64 0:4.8.3-9.el7 Complete!
禁用selinux和防火墙:
[root@db12c Packages]# vim /etc/selinux/config [root@db12c Packages]# systemctl start firewalld.service[root@db12c Packages]# systemctl stop firewalld.service[root@db12c Packages]# systemctl disable firewalld.servicerm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'rm '/etc/systemd/system/basic.target.wants/firewalld.service'[root@db12c Packages]# setenforce
修改系统内核参数:
[root@db12c Packages]# sysctl -pfs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500
修改oracle用户资源限制:
[root@db12c Packages]# tail -10 /etc/security/limits.conf #@faculty hard nproc 50#ftp hard nproc 0#@student - maxlogins 4oracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768
配置环境变量:
export TMP=/tmpexport ORACLE_HOSTNAME=db12cexport ORACLE_UNQNAME=ORA12Cexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1export ORACLE_SID=ORA12CPATH=/usr/sbin:$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;alias cdob='cd $ORACLE_BASE'alias cdoh='cd $ORACLE_HOME'alias tns='cd $ORACLE_HOME/network/admin'alias envo='env | grep ORACLE'umask 022envo
建立安装目录:
[root@db12c ~]# mkdir -p /u01/app/oracle/product/12.1.0/db_1[root@db12c ~]# chown oracle:oinstall -R /u01/[root@db12c ~]# systemctl mask tmp.mountln -s '/dev/null' '/etc/systemd/system/tmp.mount'[root@db12c ~]# chmod 775 -R /u01/
用户
主机
内核
参数
变量
密码
环境
目录
系统
资源
软件
软件包
防火墙
配置
防火
限制
步骤
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
浪潮服务器代理商哪里有
2020十大网络安全
四川鳗鲡网络技术有限公司
停车场道闸系统用什么数据库
网络安全插图简笔画
制度建设数据库需求方案
网络安全管理中的核心
知网分销软件开发
制做视频的手机软件开发
串口通讯服务器批发
外文ei数据库
存储服务器技术培训方案
access数据库同步
郑州维爱互联网科技怎么样
ms如何连接服务器网关
秋季网络安全作业
美萍酒店管理系统服务器
申请流程数据库表设计
短视频软件开发技术
临朐im即时通讯软件开发
磁盘数据库锁定
停车场道闸系统用什么数据库
怎样知道数据库表数据改变了
sql2005恢复数据库
rpc数据库配置
表格内容如何保存到数据库中
企业网络安全漏洞管理之晋级路线
互联网科技创新驱动
串口服务器如何使用
快手上怎么认证服务器