《oracle安装及使用中出现的问题及解决》由会员分享，可在线阅读，更多相关《oracle安装及使用中出现的问题及解决（19页珍藏版）》请在金锄头文库上搜索。
1、系统默认选项值取自于： E:ProgramFilesora92precompadminpcscfg.cfgPCC-F-02101, 无法打开输入文件: E:precomp_main_nt_011204oracleprecompdemoprocsampLe.pc一种情况是你 COMILE 之前,没有保存解决办法是先保存另一种情况可能是你的 PC 文件可能不能用了,解决办法是删除重新生成除此之外有可能是你的 PC 文件放的位置不正确哈1、在 ORACLE 10g 安装准备的过程中：缺少 libXp.so.6依赖上网搜过不少文章，但是都不是很好的解决我自己摸索出一个解决方法：在 RHEL5的安装盘中
2、找到 libXp-1.0.0-8.i386.rpm，进行安装后，便可解决。2、在 ORACLE 10g 安装过程中 Xlib: connection to :0.0 refused by serverXlib: connection to :0.0 refused by serverXlib: No protocol specifiedError: Cant open display: :0.0以 root 用户登陆，在 shell 中运行rootbrady # xhost local:oraclenon-network local connections being added to acc
3、ess control list然后 oracle 身份就可以运行 X 程序了。man xhost 中有这样一段A complete name has the syntax family:name where the families are as follows:inet Internet host (IPv4)inet6 Internet host (IPv6)dnet DECnet hostnis Secure RPC network namekrb Kerberos V5 principallocal contains only one name, the empty stringsi
4、 Server Interpreted其中 local 那个是用来解决同一台机器的不同用户访问 X 的问题的。3.proc: error while loading shared libraries: libclntsh.so.10.1:cannot open shared object file: No such file or directory解决方法：在/etc/profile 中添加LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib;export LD_LIBRARY_PATH然后可以用 source /etc/profi
5、le 生效一下改后如果也不行,你可能没有权限执行 libclntsh.so.10.1,请 ls -l 看一下执行权限吧(有时 root 也不能执行它的哦)4、PCC-S-02201错误在用 proc 进行编译的时候（ proc iname=test.pc） 出错错误信息有很多：PCC-S-02201, Encountered the symbol ; when expecting one of the following.发生 PCC-S-02201 错误时有两种解决办法：1)升级编译器2)设置 parse=none更正后的命令：proc iname=test.pc parse=none结果生
6、成 test.c 文件5、error: sqlca.h: No such file or directory执行 gcc -o test test.c 时：test.c:152:19: error: sqlca.h: No such file or directorysqlca.h 在$ORACLE_HOME/precomp/public/下更正后的命令：gcc -o test test.c -I $ORACLE_HOME/precomp/public6、undefined reference to sqlcxt执行5中的命令时出现错误如下：test.c:(.text+0x5e5): unde
7、fined reference to sqlcxt需要用到$ORACLE_HOME/lib/libclntsh.so故需加上 -L $ORACLE_HOME/lib -l clntsh更正后的命令为：gcc -o test test.c -I /home/oracle/oracle/product/10.2.0/db_1/precomp/public -L $ORACLE_HOME/lib -l clntshOK!至此编译成功 !但是这样写太麻烦7、error while loading shared libraries: $ORACLE_HOME/lib/libnnz10.so:cannot
8、 restore segment prot after reloc: Permission denied执行程序（./test）时提示错误：error while loading shared libraries: $ORACLE_HOME/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
9、security context. This TechTip is a workaround for CR#41937Discussion: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 behavi
10、ors, 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.To rectify this issue, you can either:
11、（1）Change the default security context for IDL by issuing the command:chcon -t texrel_shlib_t /usr/local/rsi/idl_6.1/bin/bin.linux.x86/*.so（2）Disabling SELinux altogether by setting the lineSELINUX=disabledin your /etc/sysconfig/selinux file.我使用的解决办法：chcon -t texrel_shlib_t $ORACLE_HOME/lib/*.soPCC-
12、S-02015错误1、配置好 $ORACLE_HOME/precomp/admin/pcscfg.cfg 文件根据你的系统不同，大概像这样Error at line 33, column 10 in file /usr/include/string.h#include .1PCC-S-02015, unable to open include fileError at line 34, column 11 in file /usr/include/stdio.h# include .1PCC-S-02015, unable to open include file但是在 RHEL4上都是好的，
13、检查后发现 /u01/app/oracle/product/10.2.0/db_1/precomp/admin/pcscfg.cfg 文件中指定的搜索路径有问题，oraclerzgh $ less /u01/app/oracle/product/10.2.0/db_1/precomp/admin/pcscfg.cfgsys_include=(/ade/aime_rdbms_9819/oracle/precomp/public,/usr/include,/usr/lib/gcc-lib/i486-suse-linux/2.95.3/include,/usr/lib/gcc-lib/i386-re
14、dhat-linux/3.2.3/include,/usr/lib/gcc-lib/i386-redhat-linux7/2.96/include)ltype=short/u01/app/oracle/product/10.2.0/db_1/precomp/admin/pcscfg.cfg (END) 由于 CentOS 5.5 升级后， gcc 的版本已经到了 4.1.2，相关的头文件路径也发生了变化，所以这里配置的头文件是找不到的。 。 。按照上面的报错，逐个解决，添加头文件：handsomerzgh $ find /usr -name stddef.h -print/usr/src/ke
15、rnels/2.6.18-238.19.1.el5-i686/include/linux/stddef.h/usr/src/kernels/2.6.18-194.el5-i686/include/linux/stddef.h/usr/include/linux/stddef.h/usr/lib/syslinux/com32/include/stddef.h/usr/lib/syslinux/com32/include/bitsize/stddef.hfind: /usr/lib/audit: Permission denied/usr/lib/gcc/i386-redhat-linux/4.1
16、.1/include/stddef.h/usr/lib/gcc/i386-redhat-linux/3.4.6/include/stddef.h/usr/lib/bcc/include/stddef.h选择使用 4.1.1的头文件目录，添加到 /u01/app/oracle/product/10.2.0/db_1/precomp/admin/pcscfg.cfg 中，重新进行编译，不再报错了。同题sys_include=(/usr/lib/gcclib/i386redhatlinux/3.2.2/include,/u01/oracle/product/8.1.7/precomp/public,/usr/include,/usr/include/sys)include=(/u01/oracle/produ
