Linux AS 5.4安装oracle10g 方法

Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)

一安装需求
1.swap 分区不低于2G
2.selinux 状态disable
3.物理内存不低于512M

系统组件

GNOME Desktop Environment
Editors
Graphical Internet
Text-based Internet
Development Libraries
Development Tools
Legacy Software Development
Server Configuration Tools
Administration Tools
Base
Legacy Software Support
System Tools
X Window System
二安装过程
1.软件下载
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
2.解包
unzip 10201_database_linux32.zip
3. host配置
vi /etc/hosts
中的127.0.0.1改成192.168.0.6

vi /etc/sysctl.conf file:

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
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

vi /etc/selinux/config

SELINUX=disabled

安装下面的rpm包
# From RedHat AS5 Disk 1
cd /media/cdrom/Server
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
cd /
eject
# From RedHat AS5 Disk 2
cd /media/cdrom/Server
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
cd /
eject

# From RedHat AS5 Disk 3
cd /media/cdrom/Server
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
cd /
eject

建立oracle用户和组

groupadd oinstall
groupadd dba
groupadd oper
add -g oinstall -G dba oracle
passwd oracle
建立相应的目录
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

编辑/etc/redhat-release
vi /etc/redhat-release
Red Hat Enterprise Linux Server release 5 (Tikanga) 被 Red Hat Enterprise Linux Server release 4 (Tikanga) 替换

登陆oracle 建立相应的环境变量

su - oracle
vi ~/.bash_profile

# Oracle Settings
TMP=/tmp;export TMP
TMPDIR=$TMP; export TMP
DIRORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_HOME
ORACLE_SID=test10g;
export ORACLE_SID
ORACLE_TERM=xterm;
export ORACLE_TERM
PATH=/usr/sbin$PATH;
PATH=$ORACLE_HOME/bin$PATH;
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlibORACLE_HOME/rdbms/jlib;
export DISPLAY=100.100.10.27:0.0
export LANG=AMRICAN
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
开始安装
设置显示位置
DISPLAY=:0.0; export DISPLAY
启动安装程序
./runInstaller
安装过程

Select Installation Method
Specify Inventory Directory and Credentials
Select Installation Type
Specify Home Details
Product-Specific Prerequisite Checks
Select Configuration Option
Select Database Configuration
Specify Database Configuration Options
Select Database Management Option
Specify Database Storage Option
Specify Backup and Recovery Options
Specify Database Schema Passwords
Summary
Install
Configuration Assistants
Database Configuration Assistant
Database Configuration Assistant Password Management
Execute Configuration Scripts
End Of Installation
安装结束后修改vi /etc/redhat-release 内容为
Red Hat Enterprise Linux Server release 5 (Tikanga)
设置开机启动vi /etc/oratab
TSH1:/u01/app/oracle/product/10.2.0/db_1:Y
启动监听
可在/etc/rc.d/rc.local中加入如下
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl start"

su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/dbstart start"
先设置ORACLE_SID环境变量后，启动EM console服务
emctl start dbconsole
emctl stop dbconsole
emctl status dbconsole
配置dbconsole的步骤
emca -repos create
emca -config dbcontrol db
emctl start dbconsole
重新配置dbconsole的步骤
emca -repos drop
emca -repos create
emca -config dbcontrol db
emctl start dbconsole
当emctl stop dbconsole
失败时候，修改 vi /etc/hosts 中的IP为127.0.0.1

当EM图片为乱码的时候
参看oracle10gEM乱码解决方案

CREATE USER username IDENTIFIED BY passwd

grant dba to username;
grant unlimited tablespace to username;
grant select any table to username;
grant select any dictionary to username;
grant create session to username;