LinuxRHEL5.4系统安装Oracle11gR2位_动视

LinuxRHEL5.4系统安装Oracle11gR2位

2020-11-09 12:11:31 责编:小采

binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-deve

首页 → 数据库技术

背景：

阅读新闻

Linux RHEL5.4 系统安装Oracle 11gR2 位

[日期：2011-01-27] 来源：Linux社区作者：jssnode1 [字体：]

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5

glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)

[root@linuxidc ~]# rpm -q gcc
gcc-4.1.2-44.el5
[root@linuxidc ~]# rpm -q sysstat
package sysstat is not installed

[root@linuxidc Server]# rpm-ivh sysstat-7.0.2-3.el5.x86_.rpm
warning: sysstat-7.0.2-3.el5.x86_.rpm: Header V3 DSA signature: NOKEY, key ID
1e5e0159
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]

[root@linuxidc Server]# 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
[root@linuxidc ~]# sysctl -p

[root@linuxidc ~]# groupadd -g 502 dba

[root@linuxidc ~]# groupadd oinstall

3.2
[root@linuxidc ~]# useradd -u 502 -g oinstall -G dba Oracle

[root@linuxidc ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
3.3 Shell Limits

vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
vi /etc/pam.d/login
session required pam_limits.so

[root@linuxidc ~]# mkdir /data/ora11g
[root@linuxidc ~]# mkdir /data/ora11g/product
[root@linuxidc ~]# mkdir /data/ora11g/oradata
[root@linuxidc ~]# mkdir /data/software
unzip
linux.x_11gR2_database_1of2.zip
linux.x_11gR2_database_2of2.zip
/data/software
[root@linuxidc ~]# chown -R oracle:oinstall /data/ora11g
[root@linuxidc ~]# chown -R oracle:oinstall /data/software

vi /home/oracle/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/data/ora11g
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=jssdb
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:/usr/X11R6/lib/
export
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LD_ASSUME_KERNEL=2.6.18
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
umask 022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
[root@linuxidc ~]# xhost +
Access control disabled, clients can connect from any host
[root@linuxidc ~]# su - oracle
[oracle@linuxidc ~]$

[oracle@linuxidc ~]$ cd /data/software/database/
[oracle@linuxidc database]$ ./runInstaller
Starting Oracle Universal Installer...

查看和设置Oracle数据库的最大连接数

MySQL分区表未建导致Rsyslog写入数据失败

全部频道