🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #1159

[Oracle/Linux]RHEL AS4��װOracle10g(��Զ��)����

#1159
From: ��ɮ�����
Date: Fri, 14 Mar 2008 02:59
197 lines
4031 bytes
ǰ������Ҫ������Ҳ�ܶ࣬������DZȽ����еİ汾�ˣ���һ��
���С� l ����oracleʹ���ߵĻ������ơ��ⲽ������ν
zz ��ʼ��


RHEL AS4��CentOS4.4���ں˰汾��

[xujg@centos:~]$uname -r

2.6.9-42.EL

 

Oracle�汾��������

10201_database_linux32.zip

 

1�����û�����

groupadd oinstall

groupadd dba

useradd �Cg oinstall �CG dba oracle

passwd oracle

 

2����Ŀ¼�ṹ

/oracle/u01 ��һ����������װoracle����ã�������Ű�װ����

/oracle/u02 ��һ����������oracleʵ����

 

/oracle/u01/app/oracle/

/oracle/u01/setup/

 

/oracle/u02/oradata/

 

chown �CR oracle:oinstall /oracle/u01

chown �CR oracle:oinstall /oracle/u02

chmod 755 /oracle/u01

chmod 755 /oracle/u02

 

3����������

    һ������Ҫ�İ��Ѿ���װ����ȱ�Ļ���ݰ�װ������ʾ��װ��Ӧ�İ�

 

4�����ϵͳ����

 

 l  �����ں˲������ֻ��Ҫ�޸�kernel.shemmax��

vi /etc/sysctl.conf

���ӣ�

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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

 

 l ����oracleʹ���ߵĻ�������

vi /etc/security/limits.conf

���ӣ�

*               soft    nproc           2047

*               hard    nproc           16384

*               soft    nofile          1024

*               hard    nofile          65536

 

vi /etc/pam.d/login

���ӣ�

session    required     /lib/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

 

 l ���/tmp�ռ䣬����400M

df /tmp

 

4�����û�������

�޸�oracle�û���.bash_profile:

 

# oracle 10g

umask 022

export ORACLE_BASE=/oracle/u01/app/oracle

export ORACLE_SID=ora10g

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

export LC_CTYPE=en_US.UTF-8

 

�޸ĺ���Ч����������

. .bash_profile

 

6����ѹ��װ����

[oracle@centos:/oracle/u01/setup]$unzip 10201_database_linux32.zip

 

7����oracle�û���¼��װ

[oracle@centos:/oracle/u01/setup/database]$./runInstaller

--
    
    �Ұ�˵��
    ����ҽ��Ļ�������ʲô���������

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.99.222.55]
Technical Details
Message-ID: <4Z44T0$aui@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,c3ea09e48d5d4390,start
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: wodetian.bbs@bbs.sjtu.edu.cn (��ɮ�����)
Newsgroups: cn.bbs.comp.database
Subject: [Oracle/Linux]RHEL AS4��װOracle10g(��Զ��)����
Date: 14 Mar 2008 02:59:26 GMT
Organization: ��ˮ˼Դ
Message-ID: <4Z44T0$aui@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1205463408.A
Lines: 196
X-Original-Bytes: 3177