硬件 cpu 3.0 内存 2G 硬盘 160G
一:系统环境 (redhat 4)kernel 2.6.22
1.系统安装完全安装
分区:
/boot 100m
/ 5000m
/usr 10000m
/var 10000m
/tmp 1000m
Swap 4096
/oracle 5000m (oracle主目录)
语言选择USA
Firewall disable
Selinux disable
Ip 自配
包的选择为方便安装选择erverything
2. 建立相应的oracle用户和组
Groupadd –g 501 oinstall
Groupadd –g 502 dba
Useradd –g 501 –G 502 –d /oracle/oracle/ oracle
chown -R oracle.oinstall /oracle/oracle
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.设置信号量(可根据实际情况设置)vi
Vi /etc/sysctl.conf
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
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
4.控制oracle登录占用进程和文件数量
/etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
添加限制登陆模块
vi /etc/pam.d/login
session required /lib/security/pam_limits.so
编辑 /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
之后,执行$ ulimit 验证一下.
4.设置环境变量
Su – oracle
Vi .bash_profile
export ORACLE_BASE=/oracle/oracle
export ORACLE_HOME=/oracle/oracle/product/ 10.2.0 /db_1
export ORACLE_SID=rac
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:ORACLE_HOME/network/lib:ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:ORACLE_HOME/network/lib:/lib:/usr/lib:/usr/local/lib
export PATH=$PATH:/sbin:/usr/lbin:/usr/sbin:$JAVA_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/lib:$HOME/bin:.
export CDPATH=.:$HOME:$HOME/comm:$HOME/svr:/usr
# Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
export LD_ASSUME_KERNEL= 2.4.19 # for RHEL AS 4
#export LD_ASSUME_KERNEL= 2.4.1 # for RH 9 and RHEL AS 3
#export DISPLAY=127.0.0.1:0.0
export TMPDIR=/tmp
export LANG=zh_CN
export LC_MESSAGES=en_US.8859-15
umask 022
unset USERNAME
5.安装asm(采用asm方式存放数据)
安装asm (root用户)
Rpm –Uvh oracleasm-support- 2.0.1 -1.i386.rpm oracleasm-2.6.9-22.EL-2.0.0-1.i686.rpm
oracleasmlib- 2.0.1 -1.i386.rpm
磁盘分区
Fdisk /dev/sda
Sdax 10000m
Sday 10000m
Sdax 5000m
Sdam 5000m
Reboot 机器
配置asm
service oracleasm configure
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
建立asm卷
Service oracleasm createdisk VOL1 /dev/sdax
Service oracleasm createdisk VOL2 /dev/sday
Service oracleasm createdisk VOL3 /dev/sdaz
Service oracleasm createdisk VOL4 /dev/sdam
二安装Oracle 10gR2 database
su – oracle (在oracle下)
1 安装数据库应用程序
Cd /oracle/install (放置数据库安装程序的位置)
1.1unset 一些环境变量
$ unset ORA_CRS_HOME
$ unset ORACLE_HOME
$ unset ORA_NLS10
$ unset TNS_ADMIN
检查你的变量
$ env | grep ORA
ORACLE_SID=orcl2
ORACLE_BASE=/oracle/oracle
ORACLE_TERM=xterm
1.2 用oracle用户,运行你unzip之后的那个database目录下的runInstaller
1.3 ORACLE安装目录指定到 /oracle/oracle/product/
10.2.0
/db_1
1.4 选择 Install database Software only
会要求你用完全的root权限运行 root.sh
安装完毕
2配置netca
以oracle用户运行netca
选择 Listener configuration
添加一个LISTEN, 1521 port
回到开始界面,选择Naming Methods configuration
把Local Naming和Easy Naming 添加进去.然后结束配置
3配置dbca创建数据库
3.1用oracle用户运行 dbca
3.2输入数据库的全局名,比如orcl
3.3给你的系统的不同角色建立密码,我都选择same as
3.4选择用ASM管理数据库
3.5输入你前面设定的管理员密码
3.6进入ASM配置界面, create NEW, 名字叫做DATA
然后下面你会看到你前面创建的4个ASM VOL1-4, 你选择 1 和2, "Redundancy" 选择 Normal.这样 DATA diskgroup就创建好了
3.7回到ASM界面后. 仍旧选择create new, 然后名字叫做FLASH_RECOVERY_AREA, 选择第3和4两个卷,然后"Redundancy" 选择External
然后OK结束ASM配置
3.8.Database File Locations 选择DATA
3.9 Recovery Configuration 选择刚才创建的 FLASH_RECOVERY_AREA diskgroup
接下来默认就可了
数据库安装完毕
4 数据配置文件调试
Cp /oracle/oracle/admin/$ORACLE_SID/pfile/init3456.ora
/oracle/oracle/product/ 10.2.0 /db_1/dbs/initSID.ora
Sqlplus / as sysdba
Sql> CREATE SPFILE FROM PFILE=’ /oracle/oracle/product/ 10.2.0 /db_1/dbs/initSID.ora’;
Sql> exit
启动数据库
Export ORACLE_SID=+ASM
Sqlplus / as sysdba
Sql>Startup
Sql> exit
Export ORACLE_SID=SID
Sqlplus / as sysdba
Sql>Startup
Sql> exit
停止数据库
Export ORACLE_SID=SID
Sqlplus / as sysdba
Sql〉shutdown immediate;
Sql〉exit
Export ORACLE_SID=+ASM
Sqlplus / as sysdba
Sql〉shutdown immediate
Sql〉exit
注在采用asm存储数据文件时
必须要先启动+ASM实例 在启动数据库实例 关闭则相反