centeros6.4 64位下远程安装64位 oracle11gr2_安装centeros64-优快云博客

本文详细介绍了如何在Linux环境下安装、配置Oracle数据库，包括修改系统参数、安装所需软件、创建用户组、设置环境变量、启动监听器和数据库等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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用户访问

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 &

#<<<<<<

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