系統安裝手記-Oracle9i

 [Oracle]
劃分磁碟空間
$fdisk /dev/hda
$mkfs.ext3 /dev/hda5
$mount /dev/hda5 /app
$vi /etc/fstab
/dev/hda5 /app ext3  defaults 0 0

安裝補丁包
$rpm -qa
$rpm -ivh compat-glibc-6.2-2.1.3.2.i386.rpm
$rpm -ivh compat-libstdc++-6.2-2.9.0.16.i386.rpm
$rpm -ivh compat-libstdc++-6.2-2.9.0.16.i386.rpm

設定Linux系統核心參數
vi /etc/rc.local
echo 100 256 100 100 > /proc/sys/kernel/sem
echo 2147483648 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall

安裝JRE/JDK
tar xvfz ibm-jdk-l118-linux-x86.tar.gz -C /usr/local
cd /usr/local
ln -s jdk118 java

配置java環境
Add this line to "/etc/profile":
PATH=$PATH:/usr/local/java/bin

建立oracle使用者帳戶
groupadd oinstall
groupadd dba
useradd oracle -g oinstall -G dba
passwd oracle

建立oracle安裝目錄
mkdir  /app
chmod -R 775 /app
chown -R oracle.dba /app

更改使用者啟動設定檔
$vi /home/oracle/.bash_profile
# User specific environment and startup programs
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=/app/oracle/product/9.2.0
export ORACLE_SID=localdb
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/jre:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

開始安裝Oracle
./runInstaller
取預設值一路斷行符號
GlobalDatabaseName: webdb.fanyamin.yeah.net
SID:webdb

Link error:

$vi $ORACLE_HOME/ctx/lib/env_ctx.mk

INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

modify to

INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

修改sys 和system的密碼:******,******

啟動和關閉資料庫
sqlplus /nolog
SQL>connect / as sysdba
SQL>startup(啟動)
SQL>shutdown(關閉)

安裝完成,測試安裝結果
$ps -ef|grep ora_

$sqlplus scott/tiger@$ORACLE_SID
SQL>select  * from emp;