Hello gurus,
I´m faccing with an error in DB13, I scheduled Update statistics every day but it did not run due an error.
I think this may resulted because an authorization problem.
In /usr/sap is with this permissions:
drwxr-xr-x 15 orad01 dba 4096 Oct 18 16:34 sap
The /oracle/D01/sapcheck is with the following permissions:
drwxr-xr-x 2 orad01 dba 4096 Nov 14 20:28 sapcheck
Inside of sapcheck directory I can see the following files with permissions:
-rw-r--r-- 1 orad01 dba 32262 Oct 14 13:16 ceeimamu.sta -rw-r--r-- 1 orad01 dba 2705 Oct 15 17:42 ceeisafo.sta -rw-r--r-- 1 orad01 dba 2705 Oct 15 17:50 ceeisazq.sta -rw-r--r-- 1 orad01 dba 1932 Oct 15 17:58 ceeisbie.sta -rw-r--r-- 1 orad01 dba 1791 Oct 15 22:16 ceeisyhm.sta -rw-r--r-- 1 orad01 dba 1931 Oct 15 22:24 ceeisyta.sta -rw-r--r-- 1 orad01 dba 19394261 Oct 15 23:45 ceeiszph.sta -rw-r--r-- 1 orad01 dba 1930 Nov 9 11:27 ceenjunx.sta -rw-r--r-- 1 orad01 dba 1790 Nov 9 11:38 ceenjvuv.sta -rw-r--r-- 1 orad01 dba 143103 Nov 9 11:40 ceenjwnr.sta -rw-r--r-- 1 d01adm sapsys 521 Nov 16 14:46 ceeosxxw.sta -rw-r--r-- 1 d01adm sapsys 521 Nov 16 14:49 ceeosydo.sta -rw-r--r-- 1 d01adm sapsys 521 Nov 16 14:54 ceeosyqi.sta -rw-r--r-- 1 d01adm sapsys 521 Nov 16 15:57 ceeotefd.sta -rw-r--r-- 1 orad01 dba 18530 Nov 16 16:27 ceeotgun.sta -rw-r--r-- 1 orad01 dba 996 Nov 16 16:27 connD01.log
In DB13 at details error, it show the following statements:
Job executado Etapa 001 executada (program.RSDBAJOB, variante &0000000000016, nome usuário XNSJAD) Execução do comando lógico BRCONNECT No host segoviad04 Parâmetros: -u / -jid STATS20101123153214 -c -f stats -t ALL BR0801I BRCONNECT 7.20 (7) BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement: 'ENABLE THREADS' BR0806I End of BRCONNECT processing: ceeqbmqh.sta2010-11-23 15.32.15 BR0280I BRCONNECT time stamp: 2010-11-23 15.32.15 BR0804I BRCONNECT terminated with errors External program terminated with exit code 3 BRCONNECT returned error status E Job encerrado
Can you help me please!? I do not know how to solve this situation...
Best regards,
João Dimas - Portugal