as5安装oracle步骤

一:建立用户,用户组:
groupadd dba
groupadd oinstall
useradd oracle -g oinstall -G dba
passwd oracle

二:修改说明,改为as4
vi /etc/redhat-release
修改后的内容:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
#Red Hat Enterprise Linux Server release 5.4 (Tikanga)

三:改host(不必,网上说网络检查通不过,其实可以不进行网络监察,在安装oracle时有一步是检查,把网络监察的勾去掉即可)
vi /etc/hosts
修改后的内容:
192.168.10.172               localhost.localdomain localhost

四:export LC_ALL=en_US(如果as5安装时是english时,不必)

五:在/etc/sysctl.conf添加
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
使之生效:
/sbin/sysctl -p

六:在/etc/security/limits.conf中添加
*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

七:在/etc/pam.d/login中添加
session    required     /lib/security/pam_limits.so

八:禁止secure linux
vi /etc/selinux/config
修改以下行:
SELINUX=disabled

九:vi ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

ORACLE_BASE=~/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID

PATH=$PATH:/usr/sbin; export PATH
PATH=$PATH:$ORACLE_HOME/bin; export PATH

十:远程安装设置DISPLAY环境变量(配合xmanager)
export DISPLAY=192.168.10.29:0.0

十一:安装libXp(单独下载rpm包)
rpm -i libXp-1.0.0-8.i386.rpm

十二:安装
(一定要制定字符集,所以要选用自定义安装)
oracle_home_location:
/home/oracle/oracle/product/10.2.0/db_1

installation type:
enterprise edition

unix dba group :
dba

全局用户名密码:
orcl/orcl

operation group:
oinstall

十三:执行以下sh
/home/oracle/oraInventory/orainstRoot.sh
/home/oracle/oracle/product/10.2.0/db_1/root.sh

十四:启动数据库
lsnrctl start
sqlplus '/ as sysdba'

十六:toad连接数据库
用户名/密码:sys/orcl
sid:orcl

十七:创建表空间:
DATABASE->CREATE->TABLESPACE
basic info:
permanent,logging,online,flashback
data files:
uniform extent sizes 1g
sql:
CREATE TABLESPACE DATA2 DATAFILE
  'DATA2' SIZE 2048M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
文件名:data2,大小2g,自动增长,每次长1g

十八:删除用户和创建用户:
删除用户:
drop user udb_v2 cascade
创建用户:
CREATE USER udb_v2 IDENTIFIED BY "udb"
 DEFAULT TABLESPACE "DATA1"
 QUOTA UNLIMITED ON "DATA1";