CentOS系統(tǒng) as4.6 安裝oracle 10.2.0.1
在CentOS系統(tǒng) as4.6 安裝oracle 10.2.0.1之前，我們應(yīng)先對Centos系統(tǒng)進(jìn)行安裝。要對于Centos安裝不多做說明一般開發(fā)工具都要裝。安裝完還需要安裝補(bǔ)丁包sysstat-5.0.5-14.rhel4.i386.rpm 和 libaio-0.3.105-2.i386.rpm 即可。
CentOS系統(tǒng)創(chuàng)建oracle賬號
su - root
groupadd dba
groupadd oinstall
useradd -c oracle -g dba -G oinstall oracle
passwd oracle
CentOS系統(tǒng)創(chuàng)建oralce安裝目錄
su - root
mkdir -p /u01/app/oracle
chown -R oracle.dba /u01
mkdir /var/opt/oracle
chown oracle.oinstall /var/opt/oracle
chmod 755 /var/opt/oracle
1.修改/etc/sysctl.conf 文件，增加如下內(nèi)容：
- kernel.shmall = 2097152
- kernel.shmmax = 2147483648
- 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.rmem_max = 262144
- net.core.wmem_default = 262144
- net.core.wmem_max = 262144
sem 4 個參數(shù)依次為 SEMMSL(每個用戶擁有信號量***數(shù))；SEMMNS(系統(tǒng)信號量***數(shù))；
SEMOPM(每次 semopm 系統(tǒng)調(diào)用操作數(shù))；SEMMNI(系統(tǒng)辛苦量集數(shù)***數(shù)).
shmmax ***共享內(nèi)存 2GB 物理內(nèi)存如果小的話可以設(shè)置成 536870912.
shmmni 最小共享內(nèi)存 4096KB.
shmall 所有內(nèi)存大小.
運(yùn)行/sbin/sysctl -p設(shè)置核心參數(shù)
2.修改/etc/security/limits.conf加入
oraclesoft nproc2047
oraclehard nproc16384
oraclesoft nofile 1024
oraclehard nofile 65536
3.修改/etc/pam.d/login ，加入
session required pam_limits.so
4.修改/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
5.oracle登錄 修改.bash_profile
- # .bash_profile
- # Get the aliases and functions
- if [ -f ~/.bashrc ]; then
- . ~/.bashrc
- fi
- # User specific environment and startup programs
- PATH=$PATH:$HOME/bin
- export PATH
- unset USERNAME
- # Set the LD_ASSUME_KERNEL environment variable only for Red Hat 9,
- # RHEL AS 3, and RHEL AS 4 !!
- # Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
- export LD_ASSUME_KERNEL=2.6.9-55.EL # for RHEL AS 4
- # Oracle Environment
- export ORACLE_BASE=/u01/app/oracle
- export ORACLE_HOME=$ORACLE_BASE/product/10.0.2/db_1
- export ORACLE_SID=your'sSID
- # export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin
- export NLS_LANG=American_America.UTF8;
- export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
- LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
- LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
- export LD_LIBRARY_PATH
- # Set shell search paths
- export PATH=$PATH:$ORACLE_HOME/bin
6.修改 /etc/oratab 文件
修改$ORACLE_HOME dbstart
- $ cd $ORACLE_HOME/dbs
- $ sqlplus /nolog
- SQL>connect / as sysdba
- connected
- SQL>Create pfile from spfile
dbora內(nèi)容
- # Set ORA_HOME to be equivalent to the ORACLE_HOME
- # from which you wish to execute dbstart and
- # dbshut
- # set ORA_OWNER to the user id of the owner of the
- # Oracle database in ORA_HOME
- ORA_HOME=/u01/app/oracle/product/10.0.2/db_1
- ORA_OWNER=oracle
- case "$1" in
- 'start_msg')
- echo"startup oracle10g database and listener"
- ;;
- 'stop_msg')
- echo "shutdown oracle10g database and listener"
- ;;
- 'start')
- # Start the Oracle database:
- su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
- # start the Oracle dbconsole:
- ;;
- 'stop')
- # Stop the Oracle database:
- su - $ORA_OWNER -c "emctl stop dbconsole"
- su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
- # Stop the Oracle listener:
- su - $ORA_OWNER -c "lsnrctl stop listener"
- ;;
- esac
- 1#cp dbora /etc/init.d
- 2#cd /etc/init.d
- 3#chmod 777 dbora
- 4#cd rc2.d
- #ln –s ../init.d/dbora S80ora
- 5#cd ../rc3.d
- #ln –s ../init.d/dbora S80ora
- 6#cd ../rc0.d
- #ln –s ../init.d/dbora K80ora
- 7#cd ../rc4.d
- #ln –s ../init.d/dbora S80ora
- #ln –s ../init.d/dbora K80ora
- 8#cd ../rc5.d
- #ln –s ../init.d/dbora S80ora
- #ln –s ../init.d/dbora K80ora
根據(jù)以上步驟，我們就完成了在CentOS系統(tǒng) as4.6 安裝oracle 10.2.0.1 的工作。希望大家能夠順利的使用CentOS系統(tǒng)。
【編輯推薦】
