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

发布于：2025-08-06 ⋅ 阅读:(14) ⋅ 点赞:(0)

目录

一、系统检查与设置

1. 检查系统版本与磁盘空间

2. 修改系统参数

3. 创建组和用户

4. 设置主机名

5. 检查安装软件包

6. 设置 oracle 用户环境变量

二、安装 Oracle 软件包

1. 安装 10.2.0.1 安装包

2. 安装 10.2.0.4 补丁

三、建库

四、配置监听器

1. 编辑配置文件

2. 启动监听器

五、后续

参考：

一、系统检查与设置

1. 检查系统版本与磁盘空间

df -hT
cat /etc/redhat-release

2. 修改系统参数

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

参考：

网站公告

今日签到

点亮在社区的每一天
去签到

热门文章

最新发布