oracle雜記

記錄日常遇到小問題,以備忘.[@more@]

1、sqlplus /
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

解決辦法：以root執行：

chmod -R a+rX $ORACLE_HOME

2、proc
proc: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

解決辦法：export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib;

Enterprise Manager Database Control URL - (wgods) :
http://192.168.1.101:1158/em
iSQL*Plus URL 為:
http://192.168.1.101:5560/isqlplus
iSQL*Plus DBA URL 為:
http://192.168.1.101:5560/isqlplus/dba

3、cc -o unload -L $ORACLE_HOME/lib unload.c

unload.c:(.text+0x853): undefined reference to `sqlcxt'

cc -o unload -L $ORACLE_HOME/lib -l clntsh unload.c

4、expdp etl/etl dumpfile=test.dmp ;impdp etl/etl dumpfile=test.dmp

5、提取耗時較長sql
select sql_text,sql_fulltext,elapsed_time from v$sql where lower(sql_text) like '%select%dm.%' order by elapsed_time desc