CentOS 6.4 上安装 Oracle 10.2.0.1 并升级到 10.2.0.4

vim /etc/sysctl.conf

kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144

sysctl -p

3. 创建组和用户

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
chown -R oracle:oinstall /data

4. 设置主机名

vim /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 vvml-yz-oracle.172.168.1.1
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
172.168.1.1 db01

5. 检查安装软件包

yum -y install binutils.x86_64 compat-db.x86_64 compat-libstdc++-33.i386 compat-libstdc++-33.x86_64 cpp.x86_64 elfutils-libelf.i386 elfutils-libelf.x86_64 gcc-c++.x86_64 gcc.x86_64 glibc-devel.i386 glibc-devel.x86_64 glibc-headers.x86_64 glibc.i686 glibc.x86_64 ksh.x86_64 libaio-devel.i386 libaio-devel.x86_64 libaio.i386 libaio.x86_64 libstdc++.i386 libstdc++.x86_64 make.x86_64 setarch.x86_64 sysstat.x86_64

yum -y install openssh-clients
yum -y install mlocate
yum -y install libXp
yum -y install libXp-1.0.0-15.1.el6.i686
yum -y install libXt-1.1.3-1.el6.i686 libXtst-1.2.1-2.el6.i686
yum -y install glibc-devel.i686
yum -y install libgcc.i686
yum -y install rsync
  
rpm -Uvh --force --nodeps openssl-1.0.1e-15.el6.x86_64.rpm

6. 设置 oracle 用户环境变量

su - oracle
vim .bash_profile

...
# User specific aliases and functions
export ORACLE_BASE=/home/oracle/app/oracle;
export ORACLE_HOME=/home/oracle/app/oracle/product/10.2.0/db_1;
export PATH=.:$PATH:$ORACLE_HOME/bin;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/lib32:/lib64:/usr/lib64;
export ORACLE_SID=mvbox;
export NLS_LANG=american_america.AL32UTF8;
alias rman='rlwrap rman';
alias sqlplus='rlwrap sqlplus';

source .bash_profile

二、安装 Oracle 软件包

1. 安装 10.2.0.1 安装包

# 用 oracle 用户的 vnc-client 图形化执行 ！！！
cd ~/database
./runInstaller -ignoreSysPrereqs

# /tmp/OraInstall2024-11-11_10-44-39AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
yum -y install libXp

# /tmp/OraInstall2024-11-11_10-49-01AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: wrong ELF class: ELFCLASS64 occurred..
yum -y install libXp-1.0.0-15.1.el6.i686
yum -y install libXt-1.1.3-1.el6.i686 libXtst-1.2.1-2.el6.i686

# Exception String: Error in invoking target 'install' of makefile '/home/oracle/app/oracle/product/10.2.0/db_1/ctx/lib/ins_ctx.mk'. See '/home/oracle/app/oracle/oraInventory/logs/installActions2024-11-11_11-28-10AM.log' for details.
# INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
yum -y install glibc-devel.i686

# INFO: /home/oracle/app/oracle/product/10.2.0/db_1/lib32//libclntsh.so: file not recognized: File truncated
$ORACLE_HOME/bin/relink all

# INFO: /home/oracle/app/oracle/product/10.2.0/db_1/sysman/lib/snmccolm.o: could not read symbols: File in wrong format
# 忽略，安装 10.2.0.4 补丁即可解决

2. 安装 10.2.0.4 补丁

# 用 oracle 用户的 vnc-client 图形化执行 ！！！
cd ~/p6810189_10204_Linux-x86-64/Disk1/
./runInstaller

# Error in setting permissions of file/directory /home/oracle/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/example.dmp
# 忽略（没找到 example.dmp 文件，不影响使用）

三、建库

su - oracle
cd /data
mkdir oracledata

# 用 oracle 用户的 vnc-client 图形化执行 ！！！
dbca

# You need at lease 949248 KB on /data/, You have only -282345472 KB available. Please allocate more free disk space.
# 忽略

# 点击“Finish”没反应
init 6 重启系统后再执行 dbca 建库

四、配置监听器

1. 编辑配置文件

vim /home/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

INBOUND_CONNECT_TIMEOUT_LISTENER = 0
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = mvbox)
      (ORACLE_HOME = /home/oracle/app/oracle/product/10.2.0/db_1)
      (SID_NAME = mvbox)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.1)(PORT = 1521))
    )
  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF

LISTNER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.1)(PORT = 1521))
      )
    )
  )

2. 启动监听器

lsnrctl start
lsnrctl status

五、后续

rpm -ivh rlwrap-0.37-1.el6.x86_64.rpm
su - oracle
sqlplus / as sysdba