一)安装
1.命令 rpm -q gcc make binutils setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel unixODBC unixODBC-devel libaio-devel
显示木有安装的,则安装上,可以把redhat的安装盘挂载redhat的系统上,到server目录下找到名字差不多的rpm;
安装的过程中可能会报错,缺少.so的链接文件,则在server目录下找到相应的安装文件安装
rpm -i openmotif-2.3.1-2.el5.i386.rpm
libXp.so.6 is needed by openmotif-2.3.1-2.el5.i386
参考http://www.linuxidc.com/Linux/2011-01/31646.htm
rpm -i libaio-0.3.106-3.2.i386.rpm
rpm -i openmotif-2.3.1-2.el5.i386.rpm
rpm -i compat-gcc-34-g77-3.4.6-4.i386.rpm
compat-libf2c-34 = 3.4.6-4 is needed by compat-gcc-34-g77-3.4.6-4.i386
libg2c.so.0 is needed by compat-gcc-34-g77-3.4.6-4.i386
参考http://www.2cto.com/database/201305/207856.html
rpm -ivh compat-libf2c-34-3.4.6-4.i386.rpm
rpm -ivh compat-gcc-34-g77-3.4.6-4.i386.rpm、
都安装好之后,再次运行刚开始的命令,我这里,还是有以下包显示未安装
package compat-gcc is not installed
package compat-gcc-c++ is not installed
package compat-libstdc++ is not installed
package compat-libstdc++-devel is not installed
这时,可以不必理会,参考http://hi.baidu.com/winlei/item/cfa1109bad9ab68d58146105
安装rpm,可以到系统盘的安装包里,运行yum list | grep *** 找到想应的rpm安装包;再运行yum install ***(比如compat*,一次安装多个)
2.OS系统参数配置
vi /etc/sysctl.conf 添加:
#below for oracle10g
kernel.core_uses_pid = 1
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
fs.aio-max-nr = 1048576
3. vi /etc/security/limits.conf 添加:
#use for oracle
soft nproc 2047
hard nproc 16384
soft nofile 1024
hard nofile 65536
4. vi /etc/selinux/config 确保:
SELINUX=disabled
5. vi /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
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl
6.添加用户组和用户
groupadd dba
groupadd oinstall
useradd oracle -g oinstall -G dba
passwd oracle
7.新建目录权限
mkdir -p /u01
chown -R oracle:dba /u01
chmod -R 755 /u0
8. su –oracle (最好是注销,再用oracle账号登录)
9. cd ~
vi .bash_profile 添加;
#oracle environment add from 2013-08-07
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0.6
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
10. unset LANG (以防安装界面显示不全,oracle的安装界面是Java做的,可能是redhat系统中文的支持问题)
进到oracle安装包的安装目录.../oracle_database_10g/database
运行 ./runInstaller
二)配置
1. cd $ORACLE_HOME/network/admin
即cd /u01/app/oracle/product/11.1.0.6/network/admin
2. netca
这个命令会弹出配置界面,也可以vi编辑,如下
vi tnsnames.ora 添加:(依据实际情况,以下举一个例子)
ORCL_39 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.39)(PORT = 1529))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3.测试能不能连接成功
tnsping orcl_39
tnsping 192.168.6.39:1529/orcl
4.进入sqlplus (命令的格式如下)
sqlplus 用户名/密码@orcl_39
灰常感谢龙哥,全程指导
ps:64位的redhat6上安装oracle11g时,遇到一个问题:
问题描述:
运行sqlplus时,
ERROR:
ORA-01034: ORACLE not
available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No
such file or directory
解决:参考http://www.itpub.net/forum.php?mod=viewthread&tid=359574&highlight=
/etc/oratab
oradb:/home/oracle/product/8.1.7:Y
oracle11g的安装过程:http://www.cnblogs.com/zhangyongli2011/archive/2012/04/04/2431953.html