cancel
Showing results for 
Search instead for 
Did you mean: 

BRConnect SQL Error

Former Member
0 Kudos

I have a query:

Statistics Update Data isperiodically colloected for many SAP systems in our landscape.

I found error in Ora_Dict

The Ora_Dict log as the following log:

BR0801I BRCONNECT 7.00 (33)

BR0805I Start of BRCONNECT processing: cecgrbaw.sta 2010-01-03 02.50.02

BR0484I BRCONNECT log file: F:\oracle\NWT\sapcheck\cecgrbaw.sta

BR0280I BRCONNECT time stamp: 2010-01-03 02.50.12

BR0807I Name of database instance: NWT

BR0808I BRCONNECT action ID: cecgrbaw

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: ORADICT_STATS

BR1314I Oracle dictionary statistics will be collected with default options

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2010-01-03 02.50.12

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRCONNECT time stamp: 2010-01-03 02.58.54

BR0301E SQL error -3113 at location stats_oradict_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NO_INVALIDATE => FALSE); END;'

ORA-03113: end-of-file on communication channel

BR1313E Collection of Oracle dictionary statistics failed

BR0806I End of BRCONNECT processing: cecgrbaw.sta 2010-01-03 02.58.54

BR0280I BRCONNECT time stamp: 2010-01-03 02.58.55

BR0804I BRCONNECT terminated with errors

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member524429
Active Contributor
0 Kudos

Hi,

As suggested please analyse alert_<SID>.log file to get more specific information about the same.

Also refer this [SAP Note 335199 - ora-3113 collective note|https://service.sap.com/sap/support/notes/335199] and other relative notes, to get more information about the possible reasons about ORA-3113 error.

Regards,

Bhavik G. Shroff

markus_doehr2
Active Contributor
0 Kudos

> BR0301E SQL error -3113 at location stats_oradict_collect-2, SQL statement:

> 'BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NO_INVALIDATE => FALSE); END;'

> ORA-03113: end-of-file on communication channel

The Oracle shadow process crashed. Please check your alert_<SID>.log

Markus