Centos安装Oracle11g数据库并图形化界面创建库

我就是我 2022-11-10 03:43 321阅读 0赞

**Centos安装Oracle11g数据库并图形化界面创建库**

实用工具：  
MobaXterm——shell远程连接工具

/***以下内容使用root用户执行***\*\*\*/

#创建oracle用户
    groupadd oinstall
    groupadd dba
    useradd -g oinstall -G dba oracle
    passwd oracle
    
    #将安装包放至oracle家目录下并更改属组
    mv software /home/oracle
    chown -R oracle:oinstall software
    
    #解压安装包
    unzip xxxx_1of7
    unzip xxxx_2of7
    
    #关闭selinux（保证重启生效）
    vim /etc/selinux/config
    设置SELINUX=disabled
    #关闭selinux（立即生效重启失效）
    setenforce 0
    #查看sestatus状态
    sestatus -v
    
    #关闭防火墙
    service iptables stop
    #查看防火墙状态
    service iptables status
    #关闭开机自启
    chkconfig iptables off
    
    #安装oracle所需依赖包
    yum install gcc make binutils gcc-c++ compat-libstdc++-33elfutils-libelf-devel elfutils-libelf-devel-static ksh libaio libaio-develnumactl-devel sysstat unixODBC unixODBC-devel pcre-devel –y
    
    #修改内核参数
    vim /etc/sysctl.conf
    #具体内容先不做了解
    fs.aio-max-nr = 1048576
    fs.file-max = 6815744
    kernel.shmall = 2097152
    kernel.shmmax = 1073741824
    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 = 1048576
    #内核参数立即生效
    sysctl -p

\#修改用户限制信息

vim /etc/security/limits.conf

\#具体内容先不了解

oracle           soft    nproc           2047
    oracle           hard    nproc           16384
    oracle           soft    nofile          1024
    oracle           hard    nofile         65536
    oracle           soft    stack           10240

#  #

vim /etc/pam.d/login

在这里插入代码片

\#添加如下内容

session required /lib64/security/pam_limits.so session required pam_limits.so

\#创建oracle安装目录

cd /home/oracle
    mkdir -p app/oracle/product/11.2.0.4/dbhome_1
    chown -R oracle.oinstall /app

/***以下内容使用oracle用户执行***\*\*\*/

\#编辑用户概要文件

su oracle
    cd /home/oracle
    vi .bash_profile

\#添加如下内容

export ORACLE_BASE=/home/oracle/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
    export ORACLE_SID=yourdbname
    export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
    export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
    export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

\#配置图形化登陆  
\#打开xmanager-passive  
\#声明DISPLAY变量(IP换成自己IP)

export DISPLAY=10.8.4.98:0.0

\#测试图形化是否可以打开

xhost

\#开始安装

cd /home/oracle/xx..xxx/database

sh ./runInstaller

\#图形化安装具体步骤  
(1)I wish to receive security updates via My Oracle Support.不选择  
Do you wish to remain uninformed of critical security issues in your configuration?->Yes  
(2) Skip software updates  
(3) Install database software only  
(4) Single instance database installation  
(5) Selected Language: English  
(6) Select Database Edition: Enterprise Edition  
(7) Oracle Base: /u01/app  
Software Location: $ORACLE\_BASE/oracle/product/11.2.0.4  
(8) Inventory Directory: /u01/oraInventory  
oraInventory Group Name: oinstall  
(9) DataBase Administrator(OSDBA) Group: dba  
DataBase Operator(OSOPER) Group: oinstall  
(10) next  
(11) Finish

\#配置yum源  
\#解压redhat安装包到/root/redhat67  
cd /etc/yum.repos.d  
vi redhat67.repo  
\#添加如下内容  
\[redhat\]  
name=redhat  
baseurl=file:///root/redhat67  
enable=1  
gpgcheck=0  
\#检查yum安装  
yum makecache

\#适当调整.bash\_profile中的内容，确认是否准确  
\#立即生效

su oracle
    cd /home/oracle
    source .bash_profile

\#配置监听

cd /home/oracle/xx...xxxx/bin
    ./netca

\#创建数据库

cd /home/oracle/xx...xxxx/bin
    ./dbca

\#图形化安装具体步骤  
(1)create a Database

(2)Template：General Purpose or Transaction Processing

(3)Global Database Name和SID ：testdb

(4) Enterprise Manager：不选择  
Automatic Maintenance Tasks：不选择

(4)Use the Same Administrative Password for All Accounts

(6) Storage Type：File System  
Storage Locations：Use Database File Locations from Template