oracle linux 7.4 (oel 7.4)上安装oracle 10g 10.2.0.1错误处理办法

郑全

oel 7.4上安装oracle 10g 10.2.0.1错误处理办法：
1./lib/ld-linux.so.2: bad ELF interpreter: No such file or directory 的错误
[oracle@dbserver database]$ ./runInstaller
./runInstaller: /u01/setup/database/install/.oui: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory
需要安装 glibc*.i686
yum install glibc*.i686
安装后问题解决
[oracle@dbserver database]$ uname -r
4.1.12-94.3.9.el7uek.x86_64

2.libawt.so: libXp.so.6: cannot open shared object file: No such file or directory 的错误
[oracle@dbserver database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Passed

All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-08-21_05-36-51PM. Please wait ...
[oracle@dbserver database]$ Exception in thread "main" java.lang.UnsatisfiedLinkError:
/tmp/OraInstall2017-08-21_05-36-51PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(Unknown Source)
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(Unknown Source)
        at sun.security.action.LoadLibraryAction.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
        at sun.awt.DebugHelper.<clinit>(Unknown Source)
        at java.awt.Component.<clinit>(Unknown Source)
        
这个错误，通过安装32位的  libXp解决
yum install libXp*.i686
3.libawt.so: libXt.so.6: cannot open shared object file: No such file or directory 的错误
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-08-21_05-40-12PM.
Please wait ...[oracle@dbserver database]$ Exception in thread "main" java.lang.UnsatisfiedLinkError:
/tmp/OraInstall2017-08-21_05-40-12PM/jre/1.4.2/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(Unknown Source)
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(Unknown Source)
        at sun.security.action.LoadLibraryAction.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
        at sun.awt.DebugHelper.<clinit>(Unknown Source)
        at java.awt.Component.<clinit>(Unknown Source)
这个错误，通过安装32位的  libXt解决
yum install libXt*.i686
4.libXtst.so: libXt.so.6: cannot open shared object file: No such file or directory 的错误        
[oracle@dbserver database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Passed
All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-08-21_05-40-53PM. Please wait ...
[oracle@dbserver database]$ Exception in thread "main" java.lang.UnsatisfiedLinkError:
/tmp/OraInstall2017-08-21_05-40-53PM/jre/1.4.2/lib/i386/libawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(Unknown Source)
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(Unknown Source)
        at sun.security.action.LoadLibraryAction.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
        at sun.awt.DebugHelper.<clinit>(Unknown Source)
        at java.awt.Component.<clinit>(Unknown Source)   
   
   
5.安装过程中，报：ins_ctx.mk 编译错误
   
   Error in invoking target 'install' of makefile '/u01/app/oracle/product/10.2.0/dbhome_1/ctx/lib/ins_ctx.mk'
   
   该错误，通过glibc-devel的32位包文件安装即可。
   yum install glibc-devel*.i386
   
6.安装过程中,报 Error in invoking target 'collector' of makefile  ins_emdb.mk
Exception String: Error in invoking target 'collector' of makefile
'/u01/app/oracle/product/10.2.0/db_1/sysman/lib/ins_emdb.mk'.
See '/u01/app/oracle/oraInventory/logs/installActions2014-09-20_02-43-00PM.log' for details.  
oracle10g安装过程报ins_emdb.mk错误处理方法
处理方法：
这里继续点击“continue”即可，待Oracle完成安装后，再手工执行相应脚本完成链接即可。
当oracle完成安装后，如下操作
[oracle@hyl bin]$ /u01/app/oracle/product/10.2.0/db_1/bin/relink all

7.创建数据库时,遇到ORA-27125
  通过把dba用户组加到 /proc/sys/vm/hugetlb_shm_group  解决
[root@dbserver ~]# id oracle
  uid=1001(oracle) gid=1001(dba) groups=1001(dba)
  [oracle ~]$ more /proc/sys/vm/hugetlb_shm_group
   0
下面用root执行下面的命令，将dba组添加到系统内核中：
# echo 501 > /proc/sys/vm/hugetlb_shm_group

8.ie访问不了em
  http://192.168.0.152:1158/em
  无法访问网址
  本地也不行。
  还以为是不支持oel7.
  
  本机测试sqlplus连接
  SQL> conn system/oracle@192.168.0.152:1521/sztech1
  ERROR:
  ORA-12170: TNS: 连接超时
  看来直接无法联通：
  
  想起了，oel7以上版本，默认是开启了防火墙
  察看防火墙：
  
  
  [root@dbserver ~]# systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2017-08-21 19:12:55 CST; 1s ago
     Docs: man:firewalld(1)
Main PID: 16079 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─16079 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --destination 192.168.12...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --source 192.168.122.0/2...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface virbr0 --...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --out-interface virbr0 -...that name.
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface virbr0 --...that name.
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface virbr0 --pr...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface virbr0 --pr...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete OUTPUT --out-interface virbr0 --...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface virbr0 --pr...t chain?).
Aug 21 19:12:56 dbserver firewalld[16079]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface virbr0 --pr...t chain?).
Hint: Some lines were ellipsized, use -l to show in full.
[root@dbserver ~]#
   简单的办法，就是关闭防火墙：
   systemctl stop firewalld.service
   
   我采取了加端口的方式处理：
   [root@dbserver ~]# firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources:
  services: ssh dhcpv6-client
  ports:
  protocols:
  masquerade: no
  forward-ports:
  source-ports:
  icmp-blocks:
  rich rules:
  以上没有1521端口，增加1521端口
  
  [root@dbserver ~]# firewall-cmd --permanent --add-port=1521/tcp
   success
  [root@dbserver ~]# firewall-cmd --permanent --add-port=1521/udp
  
  重载生效：
  [root@dbserver ~]# firewall-cmd --reload
  success
   [root@dbserver ~]# firewall-cmd --list-all
  public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources:
  services: ssh dhcpv6-client
  ports: 1521/tcp 1521/udp
  protocols:
  masquerade: no
  forward-ports:
  source-ports:
  icmp-blocks:
  rich rules:
  
  我们看到已经增加了1521端口
  
  再次测试sqlpus 的连接：
  SQL> conn system/oracle@192.168.0.152:1521/sztech1
已连接。
SQL>
  成功
  
  再测试em，还是不能访问：
  忘了 em的端口是1158
  
  [root@dbserver ~]# firewall-cmd --permanent --add-port=1158/udp
  success
  [root@dbserver ~]# firewall-cmd --permanent --add-port=1158/tcp
  success
  [root@dbserver ~]# firewall-cmd --reload
  success
  [root@dbserver ~]# firewall-cmd --list-all
  public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources:
  services: ssh dhcpv6-client
  ports: 1521/tcp 1521/udp 1158/udp 1158/tcp
  protocols:
  masquerade: no
  forward-ports:
  source-ports:
  icmp-blocks:
  rich rules:
  
  再去访问em，可以了
  
  但oel7.4上的firefox始终不能访问 em，提示，Gah. Your tab just crashed.可能是firefox的问题，没有去管它。
  
  
  
  
  

郑全

谁说oel7.4上不支持 oracle 10g了

不过，oracle官方确实是没有对 linux 7以上版本就oracle 10g进行认证。

zhouwei1990

yum install glibc-devel*.i386
这个应该是
yum install glibc-devel*.i686吧
oel7.4安装包上32位的包都是i686了吧。

郑全

对,是i686, i386那是以前版本的说法.使用yum install glibc_devel按tab键,就会出来.