CentOS5.5安装ORACLE10GR2

1:关闭yum
rm /var/run/yum.pid
-------------------------------------------------------------------------------------------------------------
2:检查必须的rpm包
rpm -q binutils-2.17.50.0.6-6.el5 /
compat-db-4.2.52-5.1 /
compat-libstdc++-33-3.2.3-61 /
rpm-build-4.4.2.3-18.el5 /
control-center-2.16.0-16.el5 /
gcc-4.1.2-42.el5 /
gcc-c++-4.1.2-42.el5 /
glibc-2.5-24 /
glibc-common-2.5-24 /
libgnome-2.16.0-6.el5 /
libstdc++-4.1.2-42.el5 /
libstdc++-devel-4.1.2-42.el5 /
make-3.81-3.el5 /
ksh-20060214-1.7 /
sysstat-7.0.2-1.el5 /
gnome-screensaver-2.16.1-8.el5 /
setarch-2.0-1.1 /
libXp-1.0.0-8.1.el5

检查结果如下，如果没有安装则安装相关rpm包
package binutils-2.17.50.0.6-6.el5 is not installed
package compat-db-4.2.52-5.1 is not installed
package compat-libstdc++-33-3.2.3-61 is not installed
package rpm-build-4.4.2.3-18.el5 is not installed
control-center-2.16.0-16.el5
------------------------------------------------------------
package gcc-4.1.2-42.el5 is not installed
package gcc-c++-4.1.2-42.el5 is not installed
package glibc-2.5-24 is not installed
package glibc-common-2.5-24 is not installed

yum install gcc-c++
则:
gcc-4.1.2-42.el5 /
gcc-c++-4.1.2-42.el5 /
glibc-2.5-24 /
glibc-common-2.5-24 /都已安装好
------------------------------------------------------------
libgnome-2.16.0-6.el5
package libstdc++-4.1.2-42.el5 is not installed
package libstdc++-devel-4.1.2-42.el5 is not installed
make-3.81-3.el5
package ksh-20060214-1.7 is not installed
package sysstat-7.0.2-1.el5 is not installed
gnome-screensaver-2.16.1-8.el5
setarch-2.0-1.1
package libXp-1.0.0-8.1.el5 is not installed
-------------------------------------------------------------------------------------------------------------
3:修改主机名
主机名修改文件有/etc/hosts 、/etc/sysconfig/network 、hostname 要改的名字(改完要重启不然无发生效)
vim /etc/hosts

92.168.10.10 localhost.oracle oracle
127.0.0.1 localhost.localdomain localhost
-------------------------------------------------------------------------------------------------------------
4:修改系统内核参数，增加以下内容
vim /etc/sysctl.conf

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 = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

再运行sysctl -p应用以上参数
/sbin/sysctl -p
-------------------------------------------------------------------------------------------------------------
5:修改/etc/security/limits.conf，增加如下内容
vim /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
-------------------------------------------------------------------------------------------------------------
6:修改/etc/pam.d/login文件，增加如下内容
vim /etc/pam.d/login

session required /lib/security/pam_limits.so
session required pam_limits.so
-------------------------------------------------------------------------------------------------------------
7:修改vi /etc/profile文件，增加如下内容
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
-------------------------------------------------------------------------------------------------------------
8:用户设置与配置
添加oinstall和dba用户组
groupadd -g 501 oinstall
groupadd -g 502 dba

添加oracle用户
useradd -g oinstall -G dba -u 501 -d /oracle oracle

修改/oracle权限
chown -R oracle:oinstall /oracle

使用oracle用户登录，修改.profile文件。
# su – oracle
$ pwd
/oracle
$ vim .bash_profile
加入以下内容
# !/usr/bin/bash
umask 022
ORACLE_BASE=/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export ORACLE_HOME
ORACLE_SID=manager
export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
export PATH
   
创建相应的目录
$ pwd
/oracle
$ mkdir app
$ mkdir data
-------------------------------------------------------------------------------------------------------------
9:修改Centos5.2发行标识
由于oracle10g具有系统安装监测，当检测到的系统不符合安装配置规定的要求时，安装不能正常进行，故要更改操作系统的版本标识，
这一操作不会影响任何系统问题，可以在安装结束后恢复为正常状态；操作如下：
备份/etc/redhat-release文件为/etc/redhat-release.bak
cp /etc/redhat-release /etc/redhat-release.bak
以root权限修改/etc/redhat-release文件
将文件的内容
修改为redhat-4，用于满足/home/database/install/oraparam.ini的检查要求
也可以修改/home/database/install/oraparam.in的检查条件与系统的/etc/redhat-release文件内容保持一致
或者安装的时候，带上参数，即【runInstaller –ignoreSysPrereqs】则可跳过系统版本检查。
 
做完上述配置后，建议重新启动系统，目的是让所有配置生效
-------------------------------------------------------------------------------------------------------------
final:准备安装oracle
(1)从oracle官网上下载Oracle10g for linux版本。将其上传到服务器，并解压。修改其所有者和执行权限。
(2)在解压后的目录database中，执行runInstaller命令即可进行安装。
以oracle用户登录，如果是远程登录则需修改DISPLAY参数为你本机的IP。
运行./runInstaller -ignoreSysPrereqs 进行安装。
$ ./runInstaller -ignoreSysPrereqs
这里需要ignoreSysPrereqs选项，因为如果执行系统版本检查，CentOS是不被支持的，安装会自动停止。
由于使用了ignoreSysPrereqs选项安装过程中的一些检查将不通过或不执行。可以不用理睬（因为该安装的软件包均已安装，内核参数均已修改）。
安装过程采用默认安装即可，最后会提示用户以root身份执行两个脚本


passwd 用户名
问题原因：oracle字符集的問題，它就沒這種字符,所以显示乱码
解决方法：解决方法有两种，一种是安装字符集，第二种简单的就是使用英文安装，怎么才能使用英文安装呢？执行如下命令之后在安装软件即可解决：
oracle$export LANG=en_US
oracle$export LC_ALL=en_US
oracle$export LANGUAGE=en_US


在CenotOS 5.3中文环境下安装Oracle 10g R2时，进入图形化界面后，发现中文乱码。
在网上搜索后，发现是由于Linux上没有安装Oracle安装时使用的字体库造成的。
从以下网站下载字体库
http://download.csdn.net/source/1073202
然后在Linux下执行以下命令，把字体库安装到相应位置即可
mkdir -p /usr/share/fonts/zh_CN/TrueType
cp zysong.ttf /usr/share/fonts/zh_CN/TrueType/
这样在安装的时候。Oracle就会提示中文了，而不再是中文乱码了。 ......


以下配置脚本需要以root身份执行
/oracle/oralnventory/orainstRoot.sh
/oracle/oracleproduct/10.2.0/db_1/root.sh


iSQL*Plus URL:
http://localhost.oracle:5560/isqlplus

iSQL*Plus DBA URL:
http://localhost.oracle:5560/isqlplus/dba

Database Control URL:
http://localhost.oracle:1158/em



netca and /etc/hosts

with 3 comments

When I first re-installed my laptop with Fedora 8, I naturally set about installing Oracle 10g. However at the end of the dbca process, the launching of netca failed. Trying to run netca manually yielded this fun error:

[oracle ~]$ netca

Oracle Net Services Configuration:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x004f0ab3, pid=19917, tid=3086797008
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C  [libc.so.6+0x6fab3]  index+0x63
#
# An error report file with more information is saved as hs_err_pid19917.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#
/u01/app/oracle/product/10.2.0/db_1/bin/netca: line 190: 19917 Aborted
$JRE -mx64m $SRVM_PROPERTY_DEFS -Dsun.java2d.font.DisableAlgorithmicStyles=true -classpath $CLASSPATH oracle.net.ca.NetCA $*
Well that was no good. I saw some threads with similar subject matter on the OTN forums and followed up. However time passed and then for seemingly no reason at all the next week, netca was working fine. Then a kind gentleman replied asking what my hostname was set to. BAM!

That’s when it dawned on me that the hostname that I had set for this laptop was not in any DNS service available at the time. It was set up in my office in Green Bay, but I wasn’t connected to that in Schaumburg. From home last night I disconnected from the VPN and removed my localhost entry for my hostname. Bingo, netca fails. Re-add the localhost entry, netca works.

I had originally added my hostname to the localhost line in /etc/hosts because gnome-terminal would take forever and day launching without DNS resolution of the hostname, waiting for the lookup to timeout. Apparently this same kind of thing is going on just to launch netca, although it just crashes.

Here is the entry in my /etc/hosts, for example:

127.0.0.1               localhost.localdomain   localhost       foo.example.com foo


bin/lsnrctl start
sqlplus /nolog
>sql conn system/asdfjkl as sysdba
>sql start