Online Tutorials & Training Materials | STechies.com
Register Login

Update optimizer statistics failed

|| || 1

Update optimizer statistics failed
Stechies

Hi

Check and update statistics failed with following log:
------------------------------------------------------------------------------------------------------------------------------
Job started
Step 001 started (program RSDBAJOB, variant &0000000000017, user ID BASIS)
Execute logical command BRCONNECT On host sapprod
Parameters: -u / -jid STATS20090213124236 -c -f stats -t ALL
BR0801I BRCONNECT 7.00 (24)
BR0805I Start of BRCONNECT processing: cdzxmizk.sta 2009-02-13 12.42.36
BR0484I BRCONNECT log file: /oracle/ARP/sapcheck/cdzxmizk.sta
BR0280I BRCONNECT time stamp: 2009-02-13 12.42.37
BR0301E SQL error -27140 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310E Connect to database instance ARP failed
BR0280I BRCONNECT time stamp: 2009-02-13 12.42.37
BR0301E SQL error -27140 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310E Connect to database instance ARP failed

BR0806I End of BRCONNECT processing: cdzxmizk.sta2009-02-13 12.42.37
BR0280I BRCONNECT time stamp: 2009-02-13 12.42.37
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
--------------------------------------------------------------------------------------------------------------------------------

Please help me solve this problem

With regards
 


Comments

  • 17 Jan 2011 11:17 am
    set permission for file $ORACLE_HOME/bin/oracle as "-rwsr-s--x".

    Now BRCONNECT command runs and I can run optimizer statistics.