Forum Stats

  • 3,853,691 Users
  • 2,264,256 Discussions
  • 7,905,433 Comments

Discussions

We can't clear cache on Solaris

Hi,

We generated the script, after read this links

"http://obiee101.blogspot.com/2008/03/obiee-manage-cache-part-1.html" 2. Purging the cache by table.
and
"http://forums.oracle.com/forums/thread.jspa?threadID=918372" for verify our paramenters.

this is our sql input file(limpia_tabla.txt):
prompt$ cat limpia_tabla.txt
Call SAPurgeCacheByTable( 'SERANKUA', NULL, 'SERANKUA', 'CUB_MATRIZ_CONSUMO' );

prompt$ nqcmd -d "Connection Pool" -u Administrator -p PASSWORD -s limpia_tabla.txt -o log_limpia_tabla.txt

but we have this error:

ld.so.1: nqcmd: fatal: libodbc.so: open failed: No such file or directory
Killed


Thanks for you help.
Gustavo.

Best Answer

Answers

This discussion has been closed.