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/