Oracle检查与安装操作内容

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






















posted @ 2015-05-03 17:31  Bodi  阅读(401)  评论(0编辑  收藏  举报