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