记录日常遇到小问题,以备忘.[@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;

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

ITPub博客

oracle杂记