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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22630256/viewspace-1034465/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22630256/viewspace-1034465/