Linux下Oracle 10g 安装环境配置-Mysql Tutorial-php.cn

Linux下Oracle 10g 安装环境配置

WBOY

Release： 2016-06-07 17:11:05

Original

824 people have browsed it

linux下oracle10g 安装里用的是redhat linux as 5 和oracle10g1、先打系统补丁[root@oracle rpm]# rpm -ivh libXp-*warning: lib

首页 → 数据库技术

背景：

阅读新闻

Linux下Oracle 10g 安装环境配置

[日期：2012-02-08] 来源：Linux社区作者：yujin2010good [字体：]

linux下Oracle10g 安装里用的是RedHat linux as 5 和oracle10g

1、先打系统补丁
[root@oracle rpm]# rpm -ivh libXp-*

warning: libXp-1.0.0-8.i386.rpm: Header V3DSA signature: NOKEY, key ID 82fd17b2

Preparing... ########################################### [100%]

1:libXp ########################################### [ 50%]

2:libXp-devel ########################################### [100%]

[root@oracle rpm]#

2、修改操作系统核心参数
vi /etc/sysctl.conf

kernel.msgmax = 65536

# Controls the maximum shared segment size,in bytes

kernel.shmmax = 536870912

# Controls the maximum number of sharedmemory segments, in pages

kernel.shmall = 2097152

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range =1024 65000

net.core.rmem_default = 1048576

net.core.rmem_max = 1048576

net.core.wmem_default = 262144

net.core.wmem_max = 262144

用下面这个命令就不需要重启了
/sbin/sysctl -p

设置shell调用限制
vi/etc/security/limits.conf

* soft nproc 2047

* hard nproc 16384

* soft nofile 1024

* hard nofile 65536

vi /etc/pam.d/login
session required pam_limits.so

下面来建组建用户
[root@oracle rpm]# groupadd oinstall

[root@oracle rpm]# groupadd dba

[root@oracle rpm]# useradd -g oinstall -gdba -m oracle

[root@oracle rpm]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it does not contain enoughDIFFERENT characters

Retype new UNIX password:

passwd: all authentication tokens updatedsuccessfully.

[root@oracle rpm]# mkdir /opt/ora10g

[root@oracle rpm]# mkdir/opt/ora10g/product

[root@oracle rpm]# mkdir/opt/ora10g/oradata

[root@oracle rpm]# chown -R oracle:oinstall/opt/ora10g

[root@oracle rpm]# su - oracle

[oracle@oracle ~]$ vi .bash_profile

PATH=$PATH:$HOME/bin

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/opt/ora10g

exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID=orcl
export ORACLE_TERM=xterm

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11R6/lib64

exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export LD_ASSUME_KERNEL=2.6.18

export NLS_LANG="SIMPLIFIEDCHINESE_CHINA.UTF8"

umask 022

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536
else

ulimit –u 16384 –n 65536

# modify /etc/redhat-release

echo '#Red Hat Enterprise Linux Server release 5.3 (Tikanga)

redhat-4' > /etc/redhat-release

[oracle@oracle ~]$ source .bash_profile

然后把软件拷贝到我门建的目录/opt/app

xhost +

su - oracle

[oracle@oracle database]$ LANG=C

[oracle@oracle database]$ ./runInstaller

Oracle手工建库

Oracle 行级锁与表级锁