Oracle检查与安装操作内容

时间：2021-12-15 12:49:50
Oracle 安装：

检查安装包

rpm -q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat

vi /etc/sysctl.conf

添加参数

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 

改变当前系统内核参数值（让/etc/sysctl.conf立即生效）

# sysctl -p  

创建用户与组

groupadd -g 505 dba

groupadd -g 506 oinstall

useradd -g oinstall -G dba -s /bin/bash -u 555 oracle

passwd oracle

vi /etc/selinux/config

SELINUX=disabled

修改/etc/security/limits.conf文件

vim /etc/security/limits.conf

在打开的文件底部添加下面内容

oracle soft nproc 20470

oracle hard nproc 16384

oracle soft nofile 10240

oracle hard nofile 65536

oracle soft stack 10240  

mkdir -p /oracle/app/oracle/product/11.2/db_1

chown -R oracle:oinstall /oracle

vi .bash_profile

export PATH

export EDITOR=vi

export ORACLE_SID=redhat

export ORACLE_BASH=/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASH/product/11.2/db_1

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/x11r6/bin

umask 022

--------------》

解压Oracle 安装包

Xshell登录Linux 

测试   xclock

--------------------------------------

[roacle$redhat #]netca 配置Oracle

sqlplus / as sysdba;

select * from cat;

select status from v$instance;

解锁示库数据库

alter user hr identified by hr account unlock;

启动监听  lsnrctl start

startup 启动数据库实例

shutdown

相关文章