centeros6.4 64位 下远程安装64位 oracle11gr2

1.修改语言

export LANG=en_US.UTF-8

2.检查包

rpm -q binutils compat-libstdc++-33 elfutils elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel ksh

显示package XXX is not installed 的包使用

yum install XXX XXX ... 安装

3.安装twm

yum install *twm*

yum install xterm

4. 安装vnc server

yum install tigervnc-server.x86_64

5.修改系统参数 

vi /etc/sysctl.conf
#>>>>>
#fs.file-max = 6815744
#fs.aio-max-nr = 1048576
#net.ipv4.ip_local_port_range = 9000 65500
#net.core.rmem_default = 262144
#net.core.rmem_max = 4194304
#net.core.wmem_default = 262144
#net.core.wmem_max = 1048576
#kernel.sem = 250 32000 100 128
#<<<<<


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




vi /home/oracle/.bash_profile
#>>>>
ulimit -u 16384 -n 65536
umask 022
ORACLE_BASE=/u01/oracle/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin


export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib


export ORACLE_BASE ORACLE_HOME ORACLE_SID


export LANG=en_US.UTF-8
export ORACLE_UNQNAME=orcl
export PATH


#<<<<

6.创建oracle组，用户等

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle 

passwd oracle 

mkdir -p /u01/oracle/app

mkdir -p /u01/oracle/oraInventory

mkdir -p /u01/oracle/app/oracle

mkdir -p /u01/oracle/app/oradata

mkdir -p /u01/oracle/app/oracle/product

chown -R oracle:dba /u01

chown -R oracle:oinstall /u01/oracle/app

7. 解压oracle压缩文件到一个目录中，使目录可以用oracle用户访问

8.

su - oracle
vncserver :2

vncserver -kill :2

vi .vnc/xstartup
#>>>>>>
#!/bin/sh

#unset SESSION_MANAGER
#unset DBUS_SESSION_BUS_ADDRESS
OS=`uname -s`
if [ $OS = 'Linux' ]; then
  case "$WINDOWMANAGER" in
    *gnome*)
      if [ -e /etc/SuSE-release ]; then
        PATH=$PATH:/opt/gnome/bin
        export PATH
      fi
      ;;
  esac
fi
#if [ -x /etc/X11/xinit/xinitrc ]; then
#  exec /etc/X11/xinit/xinitrc
#fi
#if [ -f /etc/X11/xinit/xinitrc ]; then
#  exec sh /etc/X11/xinit/xinitrc
#fi
[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &


#<<<<<<

9.

vncserver :2

10.

windows上使用vnc连接端口5902

11.

xterm中 ./runInstaller

12. /etc/init.d/oracle

#>>>>>>>>>>>>>>>>

#!/bin/sh
# chkconfig: 35 80 10
# description: Oracle auto start-stop script.


#
# 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/oracle/app/oracle/product/11.2.0/dbhome_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi
case "$1" in
'start')
# Start the Oracle databases:
echo "Starting Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" >>/var/log/oracle
echo "Done"


# Start the Listener:
echo "Starting Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Listeners as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >>/var/log/oracle
echo "Done."
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;


'stop')
# Stop the Oracle Listener:
echo "Stoping Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Stoping Oracle Listener as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" >>/var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle


# Stop the Oracle Database:
echo "Stoping Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" >>/var/log/oracle
echo "Done."
echo ""
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
;;


'restart')
$0 stop
$0 start
;;
esac

#<<<<<<<<<<<<<<<<<

chmod 755 /etc/init.d/oracle

13.

vi /u01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

vi /u01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbshut

#ORACLE_HOME_LISTNER=$1
ORACLE_HOME_LISTNER=$ORACLE_HOME

14

dbca 管理工具