Skip to Content
0
Former Member
Jun 26, 2007 at 07:44 AM

ORA-01031: insufficient privileges

494 Views

Dear All,

I have upgrade SAP 4.7 to ECC 6.0 and database from Oarcle 9 to 10g and now while i go to execute job "Check Database & Update Optimizer Stats" via DB13 then i get below error:

Pls help me to resolve this issue:

********************

26.06.2007 12:30:01 Job started

26.06.2007 12:30:01 Step 001 started (program RSDBAJOB, variant &0000000001931, user ID JITENDRA)

26.06.2007 12:30:01 Execute logical command BRCONNECT On host bssltests

26.06.2007 12:30:01 Parameters: -u / -jid STATS20070626123001 -c -f stats -t ALL

26.06.2007 12:30:07 BR0801I BRCONNECT 7.00 (18)

26.06.2007 12:30:07 BR0805I Start of BRCONNECT processing: cdvokrcl.sta 2007-06-26 12.30.03

26.06.2007 12:30:07

26.06.2007 12:30:07 BR0280I BRCONNECT time stamp: 2007-06-26 12.30.07

26.06.2007 12:30:07 BR0813I Schema owners found in database PRD: SAPPRD*, SAPPRDSHD+

26.06.2007 12:30:07 BR0280I BRCONNECT time stamp: 2007-06-26 12.30.07

26.06.2007 12:30:07 BR0301E SQL error -1031 at location BrRsnspaceRead-1, SQL statement:

26.06.2007 12:30:07 'PREPARE stmt_11 STATEMENT FROM'

26.06.2007 12:30:07 'SELECT NAMESPACE, NSPACEGEN FROM "SAPPRD".RSNSPACE ORDER BY NAMESPACE'

26.06.2007 12:30:07 ORA-01031: insufficient privileges

26.06.2007 12:30:07

26.06.2007 12:30:07 BR0806I End of BRCONNECT processing: cdvokrcl.sta2007-06-26 12.30.07

26.06.2007 12:30:07 BR0280I BRCONNECT time stamp: 2007-06-26 12.30.07

26.06.2007 12:30:07 BR0804I BRCONNECT terminated with errors

26.06.2007 12:30:07 External program terminated with exit code 3

26.06.2007 12:30:07 BRCONNECT returned error status E

26.06.2007 12:30:07 Job finished

***************************

Regards & Thanks,

Ankita