oracle安裝及使用中出現(xiàn)的問題及解決

1、百度文庫-讓每個人平等地提升自我系統(tǒng)默認(rèn)選項值取自于:E:ProgramFilesora92precompadminpcscfg.cfg pCC-F-02101,無法打開輸入文件：E:precomp main nt 011204oracleprecompdemoprocsampLe.pc1、在ORACLE 10g 安裝準(zhǔn)備的過程中：缺少libXp.so.6依賴 上網(wǎng)搜過不少文章，但是都不是很好的解決 我自己摸索出一個解決方法:RHEL5的安裝盤中找到libXp-1.0.0-8.i386.rpm ,進(jìn)行安裝后，便 可解決。、在 ORACLE 10g 安裝過程中 Xlib: connection

2、to :0.0 refused byerverlib: connection to :0.0 refused by serverlib: No protocol specifiedError: Cant open display: :0.0以root用戶登陸，在shell中運行rootbrady # xhost local:oraclenon-network local connections being added to access control listmanThostijA complete name has the syntax family:name Where the fami

3、lies are as follows:inetInternet host (IPv4)inet6Internet host (IPv6)dnetDECnet hostnisSecure RPC network name|krbKerberos V5 principaTIlocalcontains only one name, the empty stringsiServer Ic:errorwhileloadinqsharedlibraries：libclntsho.10.1B cannot open shared object file: No su

4、ch file or directoryetc/profilelLD_LBRARY_PATH=$ORACLE_HOME/jbsr/jbsr/oca/jbJexport LDLIBRARYPATH性后可以用 source /etc/profile 生效一下STSShSOTnST!SwootSol4、pcc-s-022O71SSMrocO#Oiprociname=testpc)dnltJPCC-S-02201, Encountered the symbol ; when expecting one of the following.|CCS022O IM 2)arse=non匡正后的命令：proc

5、 iname=test.pc parse=noneestcl5、error: sqlca.h: No such file or directoryBccolestest.ctest.c1521:19:error:sqlca.hNosuchfileordirectorH sqlca.h 在$ORACLE HOME/precomp/public/正后的命令：gcc -o test test.c -I $ORACLE_HOME/precomp/public、undefined reference to sqlcxt愧行5中的命令時出現(xiàn)錯誤如下:est.c:(.text+0x5e5): undefin

6、ed reference to sqlcxt需要用到 $ORACLE HOME/lib/libclntsh.so牧需加上-L $ORACLE HOME/lib -l clntsh正后的命令為:cc -o test test.c -I home/oracle/oracle/product/1020/db1/precomp/public -L $ORACLE HOME/lib -l clntshOK!至此編譯成功！且是這樣寫太麻煩7、error while loading shared libraries:ORACLEHOME/lib/libnnz10.so:cannot restore segm

7、ent prot after reloc: Permission denied 網(wǎng)行程序(./test)時提示錯誤： error while loading shared libraries: $ORACLE_HOMESSnZ10QM |cannot restore segment prot after reloc: Permission deniedTopic:Some Linux distributions with SELinux enabled may prevent IDL from running under the default security context. This T

8、echTip is a workaround for CR#41937Discussion:Newer Linux distributions have enabled new kernel secuHty 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 libra

9、ry loading, that can be problematic to third party programs.If you receive the error message cannot restore segment prot after reloc:PermissiondeniedwhenlaunchinglDL,thenyourSELinul configuration is preventing IDL from launching.To rectify this issue, you can either:| (1) Change the default security

10、 context for IDL by issuing the command:Ichcon -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.PiiThconexre_shlb_j$ORACLEHOME/7HPCC-S-02015 錯誤1、配置好 $ORACLE HOME/precomp/admin/pcs

11、cfg.cfg 文件 根據(jù)你的系統(tǒng)不同，大概像這樣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上都是好的，檢查后發(fā)現(xiàn) /u01/app/oracle/product/1020/db_1/precomp

12、 /admin/pcscfg.cfg文件中指定的搜索路徑有問題，oraclerzgh$less/u01/app/oracle/product/1020/db_1/precomp /admin/pcscfg.cfg sys_include=(/ade/aime_rdbms_9819/oracle/pr ecomp/public,/usr/include,/usr/lib/gcc-lib/ i486-suse-linux/2.95.3/include,/usr/lib/gcc -lib/i386-redhat-linux/3.2.3/include,/usr/l ib/gcc-lib/i386-r

13、edhat-linux7/2.96/include) ltype=short /u01/app/oracle/product/1020/db_1/precomp /admin/pcscfg.cfg (END) 由于CentOS 5.5 升級后，gcc的版本已經(jīng)到了 4.1.2,相關(guān)的頭文件路徑也發(fā)生了變化，所以這里配置的頭文件是 找不到的。 按照上面的報錯，逐個解決，添加頭文件： handsomerzgh $ find /usr -name stddef.h -print/usr/src/kernels/2.6.18-238.19.1.el5-i686/include/linux/stddef

14、.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.1/include/stddef.h/usr/lib/gcc/i386-redhat-linux/3

15、.4.6/include/stddef.h/usr/lib/bcc/include/stddef.h選擇使用 4.1.1 的頭文件目錄，添加到/u01/app/oracle/product/1020/db_1/precomp/admin/pcscfg.cfg中，重新進(jìn)行編譯，不再報錯了。同題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/pro

16、duct/8.1.7/precomp/public)include=/u01/oracle/product/8.1.7/precomp/hdrsinclude=/u01/oracle/product/8.1.7/tpcc2x_2/srcinclude=/u01/oracle/product/8.1.7/precomp/precomp/includeinclude=/u01/oracle/product/8.1.7/precomp/oracore/includeinclude=/u01/oracle/product/8.1.7/precomp/oracore/publicinclude=/u01

17、/oracle/product/8.1.7/precomp/rdbms/includeinclude=/u01/oracle/product/8.1.7/precomp/rdbms/publicinclude=/u01/oracle/product/8.1.7/precomp/rdbms/demoinclude=/u01/oracle/product/8.1.7/precomp/nlsrtl/includeinclude=/u01/oracle/product/8.1.7/precomp/nlsrtl/public include=/u01/oracle/product/8.1.7/preco

18、mp/network_src/include include=/u01/oracle/product/8.1.7/precomp/network_src/public include=/u01/oracle/product/8.1.7/precomp/network/include include=/u01/oracle/product/8.1.7/precomp/network/public include=/u01/oracle/product/8.1.7/precomp/plsql/public ltype=short2、預(yù)編譯的時候加上parse=none選項proc iname=*

19、parse=none3、編譯的時候要鏈接 oracle的庫文件，加選項-Iclntsh 下面是我參照別的網(wǎng)友的一個makefile文件，INCLDIR= -I. -I/u01/oracle/product/8.1.7/precomp/public-I/u01/oracle/product/8.1.7/rdbms/public-I/u01/oracle/product/8.1.7/rdbms/demo-I/u01/oracle/product/8.1.7/plsql/public-I/u01/oracle/product/8.1.7/network/publicDFLAGS= -DPRECOMP

20、 -DLINUX -D_GNU_SOURCE-DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT-DNS_THREADSCFLAGS= -O3LIBPATH= -L/u01/oracle/product/8.1.7/lib/LIBS=-lclntsh cat /u01/oracle/product/8.1.7/lib/sysliblist -Idl-Immyproc:myproc.pcprocparse=noiname=myproc.pcinclude=$(ORACLE_HOME)/precomp/publicgcc -o $ $.c -I$(ORACLE_HO

21、ME)/precomp/public -L$(ORACLE_HOME)/lib -Iclntsh -lclient8 $(LIBPATH) $(LIBS)clean:rm *.lis myproc.c myproc摘 0000090: error while loading shared libraries:要 libmysqlclient.so.15: cannot restore segment protafter reloc: Permission denied說 error while loading shared libraries:2009-03-020210明 libmysqlc

22、lient.so.15: cannot restore segment protafter reloc: Permission denied錯誤原因在于selinux 禁用了訪問此共享庫解決辦法：關(guān)閉selinux1、編輯/etc/selinux/config文件，找至1J SELINUX=enforcing ,改為 SELINUX=enforcing2、編輯/etc/sysconfig/selinux文件，找至1J SELINUX=enforcing ,改為 SELINUX=enforcing3、重啟電腦rootlocalhost # more /etc/sysconfig/selinux#

23、 This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - SELinux is fully disabled.SELINUX=enforcing# SELINUXTYPE= type of policy in

24、use. Possible values are:# targeted - Only targeted network daemons are protected.# strict - Full SELinux protection.SELINUXTYPE=targeted看來是selinux的緣故，關(guān)掉selinux試試！修改SELINUX=disabled ,然后重啟系統(tǒng)才能生效，或者執(zhí)行：setenforce 0,立即生效。果然，關(guān)閉selinux后，sqlplus可以正常登陸了。其實在上面出現(xiàn) Permission denied時，也可以執(zhí)行供chcon -t texrel_shlib

25、_t $ORACLE_HOME/lib/*.soerror while loading shared libraries:/opt/IBM/db2/V8.1/lib/libdb2trcapi.so.1: cannot restore segment protafter reloc: Permission denied1 .環(huán)境Linux localhost.localdomain 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 200686 i686 i386 GNU/Linux2 .解決方案sudo chcon -t texrel_shlib_t /o

26、pt/IBM/db2/V8.1/lib/libdb2trcapi.so.1若有其他庫文件則直接：sudo chcon -t texrel_shlib_t /opt/IBM/db2/V8.1/lib/*so3 .若是還不行直接關(guān)閉SELinuxsetenforce Enforcing | Permissive | 1 | 0 setenforce 0關(guān)閉不用重啟.一下修改需要重啟：編輯 /etc/selinux/config,找到這段：# This file controls the state of SELinux on the system.# SELINUX= can take one o

27、f these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - SELinux is fully disabled.SELINUX=enforcing把 SELINUX=enforcing 注釋掉：#SELINUX=enforcing ,然后新加一行為：SELINUX=disabled保存，關(guān)閉。oracle-00955 錯誤，我用 select object_name,o

28、bject_type from user_objects whereobject_name = upper( customers)查找用到這個名稱的對象，結(jié)果也是沒有找到，建表的時候，00955提示名稱或?qū)ο笠呀?jīng)使用，可是明明沒有用這個對象名的東西嘛，怎么辦呢？我不想換表名，求高手解答18RA-00955:名稱已由現(xiàn)有對象使用ORA-06512: 在SZEMR.OUT_EMR, line 42ORA-06512:在 line 3View program sources of error stack?00:0 回復(fù)于：2011-06-21 08:51:21回復(fù)次數(shù)：3B創(chuàng)建臨時表ca_emr,

29、oracle不會自動刪除臨（老兵新手）時表，所以報名稱已被使用的錯誤！oracle的臨時表的表不是臨時的，跟 SQLServer有重 大的區(qū)別！ ！ 數(shù)據(jù)是臨時的會自動隨事務(wù)或會話結(jié)束而清除， 并且不 同的會話之間是不能看見對方的數(shù)據(jù)。 因此： 不要在存儲過程中建立臨時表，先在外面建立好臨時 表，然后在存儲過程中處理數(shù)據(jù)就行了。CREATE GLOBAL TEMPORARY TABLE ca_emr( MRID varchar(20), dia_date varchar(30), flag varchar, doctor varchar(5), iccardno varchar(20), MD

30、ESCRIPT varchar(4000), MHISDESCRIPT varchar(4000), CHECKUP varchar(4000), CHECKASS varchar(4000), COURSEREC varchar(4000), admiss_times smallint , DIAGNOSECONTENT varchar(60), DIAGNOSERANGE nchar(2) ) on commit PRESERVE rows;00精華推薦:得分：10 回復(fù)于：2011-06-21 09:09:40ORa-00955:名稱已由現(xiàn)有對象使用 r也,是告訴你，此臨時表的名字已被已

31、經(jīng)存在 的數(shù)據(jù)庫對象所使用，un)(_yeeX原因是你多次執(zhí)行此語句，或者數(shù)據(jù)庫里面已 經(jīng)有其他對象使用了此名；數(shù)據(jù)庫對象的命名應(yīng)該是一個有意義的名字，比如：student,class,emp,dept在創(chuàng)建一個簡單的 JAVA 存儲過程時，出現(xiàn)如下錯誤碼 ORA-00955，請大家?guī)兔ξ沂菂⒄杖缦挛恼聛碜龅模?實現(xiàn)方法：1、創(chuàng)建一個文件為TEST.javapublic class TEST public static void main (String args口) System.out.println(HELLOTHIS iS A JAVAPROCEDURE); 2、javac TEST .java3、 java TEST4、 SQL conn syste