oracle upgrade 10.2.0.4 to 11.2.0.3

[Former Member]

Dear All,

After upgrade when I execute the below command it show the error.

brconnect -c -u / -f stats -t all -f collect -p 4

BR0801I BRCONNECT 7.20 (33)

BR0805I Start of BRCONNECT processing: celqsbwu.sta 2013-07-16 20.41.32

BR0484I BRCONNECT log file: /oracle/IPD/sapcheck/celqsbwu.sta

BR0280I BRCONNECT time stamp: 2013-07-16 20.41.34

BR0813I Schema owner found in database IPD: SAPSR3*

BR0280I BRCONNECT time stamp: 2013-07-16 20.41.34

BR0301E SQL error -1466 at location BrRsnspaceRead-2, SQL statement:

'OPEN curs_101 CURSOR FOR stmt_13'

'SELECT NAMESPACE, NSPACEGEN FROM "SAPSR3".RSNSPACE WHERE ACTIVE = 'X' ORDER BY NAMESPACE'

ORA-01466: unable to read data - table definition has changed

BR0806I End of BRCONNECT processing: celqsbwu.sta 2013-07-16 20.41.34

BR0280I BRCONNECT time stamp: 2013-07-16 20.41.34

BR0804I BRCONNECT terminated with errors

Please help me.

Regards,

Manas

[former_member184473 · Accepted solution]

Hello Manas,

Check the following note:

1498109

ORA-01466 in BRCONNECT after upgrade to Oracle 11g

Regards,

Eduardo Rezende

[former_member206552]

Hi Manas,

I agree with Eduardo, seeing that you are on 720 (33) i would first start by doing the recomendations from note 1498109 as there is a workaround.

Best Regards

Marius