oracle 安装:
关闭防火墙:
systemctl stop firewalld.service --关闭防火墙
关闭slinux:
vi /etc/selinux/config
SELINUX=encourceing改为SELINUX=disabled
vi /etc/sysconfig/network打开配置文件
修改或添加HOSTNAME
修改HOSTNAME=dbserver.localdomain
vi /etc/hosts
加上127.0.0.1 localhost
创建oracle用户:
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle
# id oracle
#mkdir -p app/oracle //安装目录
#mkdir -p app/oraInventory //配置文件目录
#mkdir -p app/database // 解压目录
#chown -R oracle:oinstall app/oracle
#chown -R oracle:oinstall app/oraInventory
#chown -R oracle:oinstall app/database
检查依赖包:
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 sysstat unixODBC unixODBC-devel
安装依赖包:
yum install 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 sysstat unixODBC unixODBC-devel
--------------------------------------
yum install -y binutils*
yum install -y compat-libstdc*
yum install -y elfutils-libelf*
yum install -y gcc*
yum install -y glibc*
yum install -y ksh*
yum install -y libaio*
yum install -y libgcc*
yum install -y libstdc*
yum install -y make*
yum install -y sysstat*
yum install -y libXp*
yum install -y glibc-kernheaders
修改OS系统标识:
#cat /proc/version //查看Linux系统版本
#cat /etc/redhat-realease //查看CentOS系统版本
CentOS Linux release 7.2.1511(Core)
#vi /etc/redhat-release
把之前的注销加上这个redhat-7(或Red Hat Enterprise Linux 6)
修改内核参数:vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912 ---4294967295
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
(注释掉重复的)
使参数生效; /sbin/sysctl -p
修改/etc/pam.d/login(在最后一条的前面)
vi /etc/pam.d/login:
session required /lib64/security/pam_limits.so(不用)
session required pam_limits.so
vi /etc/profile:
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
vi /etc/security/limits.conf(在末尾加上)
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle hard stack 10240
切换oracle用户
vi .bash_profile
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
source .bash_profile
Linux默认中文的话:
$ echo $LANG
#修改Linux系统语言
$ export LANG='en_US'
如果xmaneger没法调用安装
yum groupinstall "Desktop"
yum groupinstall "X Window System"
yum groupinstall "KDE Desktop"
报错:
Error in invoking target 'install' of makefile '/home/oracle/app/oracle/prod
解决方法:
[oracle@ysserver ~]$ cd $ORACLE_HOME/sysman/lib
[oracle@ysserver lib]$ cp ins_emagent.mk ins_emagent.mk.bak
[oracle@ysserver lib]$ vi ins_emagent.mk
命令模式输入/NMECTL 在后面追加参数 -lnnz11
启动监听:lsnrctl start
查看监听状态:lsnrctl status
关闭监听:lsnrctl stop
启动数据库:sqlplus /nolog; conn /as sysdba; startup;
关闭数据库:sqlplus /nolog; conn /as sysdba; shutdown;
如果监听和数据库都可以启动,plsql没法连,报监听错误,
需要把app/oracle/product/11.2.0/dbhome_1/network/admin/下的 listener.ora文件和tnsnames.ora文件里的localhost改成0.0.0.0
Oracle11G安装
最新推荐文章于 2024-06-12 07:22:08 发布