Update statistics failed

[Former Member]

Hi All,

I am geting the following error in the DB13 update statistics jobs.

BR0986W Index SAPRP1.DD31S~0 is unbalanced - please rebuild the index

BR0280I BRCONNECT time stamp: 2007-10-21 06.17.05

BR0301E SQL error -604 at location stats_ind_collect-2

ORA-00604: error occurred at recursive SQL level 1

ORA-01089: immediate shutdown in progress - no operations are permitted

BR0886E Checking/collecting statistics failed for index SAPRP1.DSYAX~0

BR0280I BRCONNECT time stamp: 2007-10-21 06.17.05

BR0301E SQL error -1089 at location stats_ind_collect-2

ORA-01089: immediate shutdown in progress - no operations are permitted

BR0886E Checking/collecting statistics failed for index SAPRP1.DSYAX~VIE

BR0280I BRCONNECT time stamp: 2007-10-21 06.17.05

BR0301E SQL error -3114 at location stats_ind_collect-2

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPRP1.DSYBA~0

BR0280I BRCONNECT time stamp: 2007-10-21 06.17.05

BR0301E SQL error -3114 at location stats_ind_collect-2

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPRP1.DSYBB~0

BR0280I BRCONNECT time stamp: 2007-10-21 06.17.05

BR0301E SQL error -3114 at location stats_ind_collect-2

ORA-03114: not connected to ORACLE

Please help me with it

Thanks and regards,

Tajinder

[Former Member · Accepted solution]

Hello Tajinder,

ORA-01089: immediate shutdown in progress - no operations are permitted

ORA-03114: not connected to ORACLE

From the log it's indicated that the database shutdown is in progress.

Please check the status of your database.

Regards,

Ammey Kesarkar

[Former Member · Accepted solution]

check please the environment settings of the <sid>adm.

Which status does the database have?

<b><i>select status from v$instance</i></b>;

Could you please post the result of R3trans -d?

Best regards

[Former Member]

Database was up. But when i re-run the job. it suceeded. Thanks to all of you for your inputs.

points awarded

Tajinder

[Former Member]

'UPDATE SAP_SDBAD SET LINE = 'A 00000000 0000000000000000 00000000 00079877 00000174 00000172 00000000 00000000 00000

Hi ALL

i'm getting below error in db13, please help me

ORA-03114: not connected to ORACLE

BR0325W Writing to database log failed

BR0280I BRCONNECT time stamp: 2013-05-06 21.44.15

BR0301W SQL error -3114 at location thr_db_disconnect-1, SQL statement:

'COMMIT RELEASE'

ORA-03114: not connected to ORACLE

BR0327W Disconnect from database instance RGP failed

BR0806I End of BRCONNECT processing: celdhczg.sta2013-05-06 21.44.15

BR0280I BRCONNECT time stamp: 2013-05-06 21.44.15

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 5

BRCONNECT returned error status E

Job finished

[Nibu]

Hi Karthik,

Can you check if there any network related issues causing this?

Check your listener,tnsnames.ora and make sure no missing entries etc .

[former_member206552]

hi karthik

have a lok at the following

http://scn.sap.com/thread/0002117197

best regards

marius

[Former Member]

problem solved when re execute

[Former Member]

thanks everyone

[former_member204746]

simple:

while statistics were being calculated, the DB was shutdown.

perhaps an offline backup was started or a script shutdown Oracle.

[Former Member]

Error message seems, oracle shutdown in progress... while running brconnect.