美文网首页
安装Oracle11g数据库

安装Oracle11g数据库

作者: 苏水的北 | 来源:发表于2021-07-03 10:56 被阅读0次

linux环境准备:

1、关闭软件:

1.1、关闭防火墙及永久关闭:

[root@localhost ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@localhost ~]# service ip6tables stop
ip6tables: Setting chains to policy ACCEPT: filter         [  OK  ]
ip6tables: Flushing firewall rules:                        [  OK  ]
ip6tables: Unloading modules:                              [  OK  ]
[root@localhost ~]# chkconfig iptables off
[root@localhost ~]# chkconfig ip6tables off

1.2、关闭图形化网络工具:

[root@localhost ~]# service NetworkManager stop
Stopping NetworkManager daemon:                            [  OK  ]
[root@localhost ~]# chkconfig NetworkManager off

1.3、关闭Linux中selinux安全增强机制:

[root@localhost ~]# setenforce 0

[root@localhost ~]# vim /etc/selinux/config
[root@localhost ~]# vim /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted
2、配置yum软件仓库:
[root@localhost dev]# mount /dev/sr0  /mnt/
mount: block device /dev/sr0 is write-protected, mounting read-only
[root@localhost dev]# vim /etc/yum.repos.d/rhel-source.repo
[yum]
name=123
enabled=1
gpgcheck=0
baseurl=file:///mnt
[root@localhost dev]# yum repolist
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscripti                                                                  on-manager to register.
yum                                                              | 3.9 kB     00:00 ...
yum/primary_db                                                   | 3.1 MB     00:00 ...
repo id                                    repo name                              status
yum                                        123                                    3,690
repolist: 3,690
3、配置主机名及映射关系:
[root@localhost dev]# hostname oracle1
[root@localhost dev]# vim /etc/sysconfig/network
[root@localhost dev]# cat  /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=oracle1
[root@localhost dev]# vim /etc/hosts
[root@localhost dev]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.6    oracle1

4、安装oracle安装所需依赖包:

yum -y install binutils-* compat-libstdc++-* compat-libstdc++-*.i686 elfutils-libelf* elfutils-libelf-devel* gcc-* gcc-c++-* glibc-* glibc-*.i686 glibc-common* glibc-devel* glibc-devel*.i686 glibc-headers* ksh* libaio* libaio*.i686 libaio* libaio*.i686 libgcc* libgcc*.i686 libstdc++* libstdc++*.i686 libstdc++-devel* make* sysstat* unixODBC* unixODBC*.i686 unixODBC-devel* unixODBC-devel*

5、准备用户组和用户:

[root@oracle1 ~]# groupadd oinstall
[root@oracle1 ~]# groupadd dba
[root@oracle1 ~]# useradd -g oinstall -g dba -m oracle
[root@oracle1 ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is too simplistic/systematic
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.

6、创建目录:

[root@oracle1 u01]# mkdir -p /u01/app/oracle/product/11.2/db_1
[root@oracle1 u01]# chown -R oracle:oinstall  /u01/app/oracle/product/11.2/db_1
[root@oracle1 ~]# mkdir -p /ora_data/
[root@oracle1 ~]# chown -R oracle:oinstall  /ora_data
[root@oracle1 ~]# mkdir -p /ora_idx/
[root@oracle1 ~]# chown -R oracle:oinstall  /ora_idx
[root@oracle1 ~]# mkdir -p /ora_flash/
[root@oracle1 ~]#  chown -R oracle:oinstall  /ora_flash

7、配置环境变量:

[oracle@oracle ~]$ vim .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
export PATH=$PATH:$ORACLE_HOME/bin
[oracle@oracle1 ~]$ source .bash_profile

8、修改内核参数:

[root@oracle1 ~]# vim /etc/sysctl.conf
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
[root@oracle1 ~]# sysctl  -p

9、对oracle用户设置限制,提高软件运行性能:

[root@oracle1 ~]# vim  /etc/security/limits.conf
oracle hard nproc 16384
oracle soft nproc 2047
oracle hard nofile 65536
grid hard nproc 16384
grid soft nproc 2047
grid hard nofile 65536

10、上传oracle软件安装包并解压:

[root@oracle1 tmp]# unzip p10404530_112030_Linux-x86-64_1of7.zip
[root@oracle1 tmp]# unzip p10404530_112030_Linux-x86-64_2of7.zip
[oracle@oracle1 tmp]$ ll
drwxr-xr-x. 8 root root       4096 Sep 22  2011 database
-rw-r--r--. 1 root root 1358454646 Jul  3 09:22 p10404530_112030_Linux-x86-64_1of7.zip
-rw-r--r--. 1 root root 1142195302 Jul  3 09:23 p10404530_112030_Linux-x86-64_2of7.zip

11、在oracle用户下安装database软件:

[oracle@oracle1 database]$ ./runInstaller -ignoresysprereqs
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png

root用户下执行这两个脚本:

[root@oracle1 ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
[root@oracle1 ~]# /u01/app/oracle/product/11.2/db_1/root.sh
image.png

连接空闲实例验证是否软件安装成功:

[oracle@oracle1 database]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 3 10:00:56 2021

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> 

11、dbca建库:


image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png

相关文章

  • 虚拟机配置和eclipse部署

    安装数据库 oracle11g 使用数据库 1.替换Tns(app/用户名/product/11.2.0/dbho...

  • Openfire安装准备-Oracle数据库准备

    本篇所述为运行 Oracle 的Docker镜像。请自行安装Docker。 Oracle11g数据库 Docker...

  • Oracle安装

    Oracle11g安装界面 是否通过Email接收邮件,可跳过配置安全更新 是否在安装时创建数据库,也可以先安装再...

  • Linux安装Oracle数据库

    Linux安装Oracle数据库 一、Oracle11G下载 oracle数据库10G/11G官方迅雷下载地址[h...

  • centos7.4安装oracle11g

    centos7.4安装离线oracle11g服务端 centos7.4安装docker版oracle11g镜像

  • oracle安装报错

    标签(空格分隔): 数据库 Oracle11g安装报错::“无法访问临时位置”的问题,详细信息如下: INS-30...

  • oracle11g数据库卸载

    oracle11g数据库可以通过批处理文件自动卸载。找到oracle安装目录下的deinstall.bat批处理文...

  • PROC编程初步

    rhel7静态安装oracle11g真的很麻烦!!! oracle启动 “/nolog”是不登陆到数据库服务器的意...

  • Oracle11g数据库单机DG搭建

    1、文档介绍 本文档基于在Centos7下安装Oracle11g数据库,组建完成DG高可用架构的规划部署工作。 2...

  • 带你了解Oracle数据库的使用

    Oracle安装 安装版本:oracle11g for windows参考资料:https://blog.csdn...

网友评论

      本文标题:安装Oracle11g数据库

      本文链接:https://www.haomeiwen.com/subject/kfwyultx.html