Oracle10G_install_RH4

RedHat4設定

Network Configuration
It is usually best to configure database servers with a static IP address. To do so, click on Edit .
A pop-up window appears. Uncheck the Configure using DHCP box, and enter the IP Address and Netmask for the server. Be sure that Activate on boot is checked, and click on OK .
In the Hostname box, select manually and enter the hostname.
In the Miscellaneous Settings box, enter the remaining network settings.

Firewall Configuration
For the purposes of this walk-through, no firewall is configured. Select No firewall
.

Time Zone Selection
Choose the time settings that are appropriate for your area. Setting the system clock to UTC is usually a good practice for servers. To do so, click on System clock uses UTC.


開設安裝群組
groupadd oinstall
groupadd dba

開設安裝user
useradd -g oinstall -G dba oracle
passwd oracle

開設安裝目錄
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

修改LINUX參數
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
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=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144


#vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

#vi /etc/pam.d/login
session required /lib/security/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
umask 022
fi

#vi /etc/csh.login
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif

登出改用oracle 登入
#vi .bash_profile
umask 022
PATH=$PATH:$HOME/bin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export PATH
unset USERNAME

開始安裝

oracle 登入
執行安裝程式
/mnt/cdrom/database/runInstaller

安裝重點
先裝ORACLE SEVER, 不要create database

裝完ORACLE SEVER後,
第二步再窩使用 dbca 去 create database

裝完後.
執行 . oraenv
指定oracle sid及oracle home 每一次重新開機後都要執行一次
$ . oraenv
ORACLE_SID = [oracle] ? demo1
Run SQL*Plus:

$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 27 15:40:29 2005Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>

$ emctl start dbconsole
http://192.168.42.4:1158/em <--從WEB連進管理端

http://192.168.42.4:5660/isqlplus <--從WEB連進管理端

http://192.168.42.4:5660/isqlplus/dba <--從WEB連進管理端

$ isqlplusctl start
$ isqlplusctl stop

$ lsnrctl start
$ lsnrctl stop

oracle 10G安裝參考網址
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html