Error in Brconnect

[Former Member]

KINDLY SUGGEST --- CHECK DB ERROR

-

---

LOG----

---

/oracle/DEV/saparch 5570624 8261365 5682787 31.21 0

/oracle/DEV/sapbackup 5570624 8261365 5682787 31.21 0

/oracle/DEV/sapcheck 5570624 8261365 5682787 31.21 0

/oracle/DEV/sapreorg 5570616 4129822 4084363 1.10 0

/oracle/DEV/saptrace 5570624 8261365 5682787 31.21 0

BR0280I BRCONNECT time stamp: 2007-09-05 12.22.21

BR0301E SQL error -1031 at location BrRsnspaceRead-1, SQL statement:

'PREPARE stmt_11 STATEMENT FROM'

<b>'SELECT NAMESPACE, NSPACEGEN FROM "SAPPRD".RSNSPACE ORDER BY NAMESPACE'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cdwbvqzc.chk 2007-09-05 12.22.21

BR0280I BRCONNECT time stamp: 2007-09-05 12.22.21

BR0804I BRCONNECT terminated with errors </b>

Regards,

Jitendra Tiwari

[Former Member]

Hi Jitendra

It looks like there is no permission to access the table "SAPPRD".RSNSPACE.

Try to apply the sapdba role (note 134592).

oraprd> sqlplus /nolog @sapdba_role SAPPRD

If this does not help. Please provide:

- how did you start brconnect (DB13, command line...)?

- please post the first lines from the log:

BR0801I BRCONNECT 7.00 (20)
BR0805I Start of BRCONNECT processing: cdwbejsy.sta 2007-09-01 20.30.56
BR0484I BRCONNECT log file: /oracle/SID/sapcheck/cdwbejsy.sta

BR0101I Parameters

Name                           Value

oracle_sid                     SID
oracle_home                    /oracle/SID/102_64
oracle_profile                 /oracle/SID/102_64/dbs/initSID.ora
sapdata_home                   /oracle/SID
sap_profile                    /oracle/SID/102_64/dbs/initSID.sap
system_info                    sidadm/orasid localhost HP-UX B.11.23 U ia64
oracle_info                    SID 10.2.0.2.0 8192 2866 1664395463529 localhost WE8DEC AL16UTF16
sap_info                       700 SAPR3 SID U1833406283 R3_ORA 0020091783
make_info                      hpia64 OCI_102 Dec  7 2006
command_line                   brconnect -u / -jid STATS20070217203000 -c -f stats -t ALL
stats_table                    ALL
stats_change_threshold         50
stats_parallel_degree          4

Regards

Michael

Message was edited by:

mho