​Oracle安裝筆記

標籤：oracle

Oracle安裝筆記

只修改時間,輸入:date -s 14:15:00

同時修改日期時間,注意要加雙引號,日期與時間之間有一空格,輸入:date -s "2015-08-03 14:15:00"

修改完後,記得輸入:clock -w 

root使用者登入

1，交換區檢查：

grep MemTotal /proc/meminfo

grep SwapTotal /proc/meminfo

2，磁碟空間情況

[[email protected] app]# df -h  

注意，如果切換使用者su - oracle時出現-bash-3.2$的提示符是因為把oracle使用者的.bash_profile最前面的if語句注釋掉的問題，放開就好了。

系統參數修改

1，修改核心

增加到/etc/sysctl.conf中

# For Oracle Install

fs.file-max = 6553600

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

配置生效：

[[email protected] ~]# sysctl  -p

 

2，修改使用者資源限制

/etc/security/limits.conf

#Oracle Install Add

oracle    soft    nproc   2047

oracle    hard    nproc   16384

oracle    soft    nofile  1024

oracle    hard    nofile  65536

3，登入限制

/etc/pam.d/login

session    required     /lib/security/pam_limits.so

4，

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

安裝包

1，安裝包檢查

rpm -q gcc make binutils openmotif setarch compat-db compat-gcc \

> compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel

2，安裝

rpm -Uvh compat-db-4.2.52-5.1.i386.rpm

rpm -Uvh compat-db-4.2.52-5.1.x86_64.rpm

rpm -Uvh libaio-0.3.106-5.i386.rpm

rpm -Uvh libaio-0.3.106-5.x86_64.rpm

rpm -Uvh libaio-devel-0.3.106-5.i386.rpm

rpm -Uvh libaio-devel-0.3.106-5.x86_64.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.x86_64.rpm

rpm -Uvh glibc-kernheaders-2.4-9.1.98.EL.i386.rpm

rpm -Uvh glibc-headers-2.5-49.x86_64.rpm

rpm -Uvh glibc-devel-2.5-49.i386.rpm

rpm -Uvh glibc-devel-2.5-49.x86_64.rpm

rpm -Uvh compat-gcc-34-3.4.6-4.x86_64.rpm

rpm -Uvh compat-gcc-34-c++-3.4.6-4.x86_64.rpm

rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm

rpm -Uvh libXp-1.0.0-8.1.el5.x86_64.rpm

rpm -Uvh openmotif-2.3.1-2.el5_4.1.i386.rpm

rpm -Uvh openmotif-2.3.1-2.el5_4.1.x86_64.rpm

rpm -Uvh gcc-4.1.2-48.el5.x86_64.rpm

rpm -Uvh gcc-c++-4.1.2-48.el5.x86_64.rpm

rpm -Uvh glibc-2.5-49.i686.rpm

rpm -Uvh glibc-2.5-49.x86_64.rpm

rpm -Uvh libgomp-4.4.0-6.el5.i386.rpm

rpm -Uvh libgomp-4.4.0-6.el5.x86_64.rpm

rpm -Uvh binutils-2.17.50.0.6-14.el5.x86_64.rpm

rpm -Uvh fontconfig-devel-2.4.1-7.el5.i386.rpm

rpm -Uvh fontconfig-devel-2.4.1-7.el5.x86_64.rpm

rpm -Uvh freetype-devel-2.2.1-21.el5_3.i386.rpm

rpm -Uvh freetype-devel-2.2.1-21.el5_3.x86_64.rpm

rpm -Uvh kernel-headers-2.6.18-194.el5.x86_64.rpm

rpm -Uvh libstdc++44-devel-4.4.0-6.el5.x86_64.rpm

rpm -Uvh libXmu-1.0.2-5.i386.rpm

rpm -Uvh make-3.81-3.el5.x86_64.rpm

rpm -Uvh setarch-2.0-1.1.x86_64.rpm

rpm -Uvh sysstat-7.0.2-3.el5.x86_64.rpm

rpm -Uvh zlib-devel-1.2.3-3.x86_64.rpm

增加使用者名稱

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd dba

/usr/sbin/useradd -m -g oinstall -G dba oracle

id oracle

passwd oracle

修改變數

修改.bash_profile檔案：此檔案隱藏，在/home/oracle/.base_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

# For Oracle Install

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10g

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin

export ORACLE_OWNER=oracle

export ORACLE_SID=mmkt11

export NLS_LANG=" american_america.WE8ISO8859P1 "

修改完畢，執行如下操作，使設定生效：

[[email protected] ~]#  source /home/oracle/.bash_profile 

安裝資料庫

1,建立目錄

[[email protected] /]# mkdir -p /u01

2,賦給資料庫安裝目錄許可權

[[email protected] /]# chown -R oracle:oinstall /u01

3,切換Oracle進入圖形化介面進入安裝目錄運行

./instsllrun

建立資料庫及配置

1,用oracle使用者，進入Oracle軟體目錄下的bin目錄，運行dbca

2,用oracle使用者，進入Oracle軟體目錄下的bin目錄，運行netca

​Oracle安裝筆記