oracle10G的相关问题

Oracle 10g相关问题及解决方法

[注：我的linux版本是RHEL 5,Oracle版本是10g]

1、在ORACLE 10g 安装准备的过程中：缺少libXp.so.6依赖
上网搜过不少文章，但是都不是很好的解决
我自己摸索出一个解决方法：
在RHEL5的安装盘中找到libXp-1.0.0-8.i386.rpm，进行安装后，便可解决。

2、在安装测试orabm时碰到
之前使用orabmload时找不到相应的库，查了下，应该是跟oracle版本有关，oracle10G应该使用orabmload.10g.linux
./orabmload.10g.linux: error while loading shared libraries: /u01/app/oracle/product/10.2.0/CBP1/lib/libnnz10.so: cannot restore segment prot after reloc: Permission denied

转相关的文章：
Topic:
Some Linux distributions with SELinux enabled may prevent IDL from running under the default security context. This TechTip is a workaround for CR#41937

Discussion:
Newer Linux distributions have enabled new kernel security extensions from the SELinux project at the NSA. These extensions allow finer-grained control over system security. However, SELinux also changes some default system behaviors, such as shared library loading, that can be problematic to third party programs.If you receive the error message "cannot restore segment prot after reloc: Permission denied" when launching IDL, then your SELinux configuration is preventing IDL from launching.

有两个解决办法：
1、修改缺省的上下文
chcon -t texrel_shlib_t /u01/app/oracle/product/10.2.0/CBP1/lib/libnnz10.so
chcon -t texrel_shlib_t /u01/app/oracle/product/10.2.0/CBP1/lib/libclntsh.so.10.1

2、禁用selinux
SELINUX=disabled
in your /etc/sysconfig/selinux file.