update stats issue

[Former Member]

Hi All,

While running update stats , am facing below issue.I have followed SAP note 113747 for brtools permissions too,But still am facing issues ....

brconnect -c -u / -f stats -t all -f collect -p 4;
BR0801I BRCONNECT 7.20 (24)
BR0805I Start of BRCONNECT processing: cekvxoqu.sta 2013-03-28 16.18.28
BR0484I BRCONNECT log file: /oracle/XXX/sapcheck/cekvxoqu.sta
BR0280I BRCONNECT time stamp: 2013-03-28 16.18.28
BR0301E SQL error -942 at location db_connect-6, SQL statement:
'SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1'
ORA-00942: table or view does not exist
BR0310E Connect to database instance XXX failed
BR0280I BRCONNECT time stamp: 2013-03-28 16.18.28
BR0301W SQL error -942 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20130328161828', 'sta', 'XXX', 'ALL', '9999', ' ', 'cekvxoqu', '7.20 (24)')'
ORA-00942: table or view does not exist
BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cekvxoqu.sta 2013-03-28 16.18.28
BR0280I BRCONNECT time stamp: 2013-03-28 16.18.28
BR0804I BRCONNECT terminated with errors

Let me know if there are any solutions to avoid this errors

Regards

Ram

[Former Member · Accepted solution]

Hello Ram,

Can you please check and see if connec to Ora db is Woeking ok?

BR0310E Connect to database instance XXX failed

BR0280I BRCONNECT time stamp: 2013-03-28 16.18.28

The error says the connect to bd failed.

Kind Regards,

Jacob

[Former Member · Accepted solution]

Hi Jacob,

Database is Up and running fine.Return code of R3trans is 0000.

Regards

Ram

[Former Member · Accepted solution]

Can you please try http://scn.sap.com/thread/925172 

Kind Regards,

Jacob

[former_member188883 · Accepted solution]

Hi Bharatram,

Please run the following

SQL>@sapconn_role.sql

SQL>@sapdba_role.sql <SAPSchemaID>

Additionally refer SAP note 400241 (Problems with ops$ or sapr3 connect to Oracle) and performed the general checks such checking the SAPUSER owner,etc.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks a lot deepak for your pinpointed solution

Regards

Bharatram

[former_member185239]

Hi Bharatram,

follow the sap note

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

With Regards

Ashutosh Chaturvedi

[Former Member]

Thanks a lot Ashutosh for the SAP note you have provided  and now the issue is resolved

Regards

Bharatram