DB crashed while running optimizer stat job

[Former Member]

Hi Gurus,

We are on R/3 4.6C, Oracle 8.1.7.2, HP UX 11i

Everyweek end we used to run the DB optimizer job In our production system using the command

/usr/sap/SID/SYS/exe/run/sapdba -checkopt PSAP%

This week, during the execution our DB crashed with core dump

ORA-07445: exception encountered: core dump [11] [4286571752] [179433472] [0] [] []

Could any one please guide me to analyze the root cause and help me to find the reason for the DB crash?

The log of optimizer job,

*******************************************************************************

• SAPDBA - SAP Database Administration for ORACLE *****

*******************************************************************************

SAPDBA V4.6D Check CBO statistics

SAPDBA release: 4.6D

Patch level : 43

Patch date : 2002-10-22

ORACLE_SID : SID

ORACLE_HOME : /oracle/SAT/817_64

ORACLE VERSION: 8.1.7.2.0

Database state: 'open'

SAPR3 : 46C

SAPDBA DB USER: system (standard)

OS login user : orasat

OS eff. user : orasat

SYSDBA priv.: not checked

SYSOPER priv.: not checked

Command line : /usr/sap/SAT/SYS/exe/run/sapdba -checkopt PSAP%

HOST NAME : satcen1

OS SYSTEM : HP-UX

OS RELEASE : B.11.11

OS VERSION : U

MACHINE : 9000/800

Log file : '/oracle/SID/sapcheck/0705200900.opt'

Log start date: '2007-05-20'

Log start time: '09.00.34'

*******************************************************************************

Start of deferred log

SAPDBA: Another SAPDBA is already running on this computer

with the same operating system user ID 'orasat'

(this usually implies with the same database).

This is not recommended because the two processes might use

resources concurrently. SAPDBA does not check this.

You will be responsible for all consequences!

End of deferred log

Optimizer check parameters:

Object : Tablespace PSAP%

Criteria : Deviation of row-number by 10%

Time frame: 100 hours

*******************************************************************************

SAPDBA: Using control table DBSTATC

for taking optimizer settings into account

PSAPSTABD - Last: PA0085 Total: 2403 Time: 00:00

SAPDBA: SELECT OWNER,INDEX_NAME FROM SYS.DBA_INDEXES WHERE TABLE_OWNER='SAPR3'

AND TABLE_NAME='PA0086' AND UNIQUENESS='UNIQUE' ORDER BY 2

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

(2007-05-20 09.11.29)

SAPDBA: Error - finding primary index for table 'SAPR3.PA0086'!

ORA-03114: not connected to ORACLE

(2007-05-20 09.11.29)

SAPDBA: Could noLast: PA0086 Total: 2404 Time: 00:00

SAPDBA: SELECT OWNER,INDEX_NAME FROM SYS.DBA_INDEXES WHERE TABLE_OWNER='SAPR3'

AND TABLE_NAME='PA0087' AND UNIQUENESS='UNIQUE' ORDER BY 2

ORA-03114: not connected to ORACLE

(2007-05-20 09.11.29)

SAPDBA: Error - finding primary index for table 'SAPR3.PA0087'!

ORA-03114: not connected to ORACLE

(2007-05-20 09.11.29)

SAPDBA: Could noLast: PA0087 Total: 2405 Time: 00:00

SAPDBA: SELECT OWNER,INDEX_NAME FROM SYS.DBA_INDEXES WHERE TABLE_OWNER='SAPR3'

AND TABLE_NAME='PA0088' AND UNIQUENESS='UNIQUE' ORDER BY 2

ORA-03114: not connected to ORACLE

(2007-05-20 09.11.29)

regards,

Vinodh.

[Former Member · Accepted solution]

Hi Vinodh,

Check if there was any change done to SHMMAX value of the HP-UX server as well.

Cheers,

Nisch

[Former Member · Accepted solution]

Hi Nisch,

Thanks for the reply.

No, there is no change in the shared memory settings. I do know that there is a known bug in Ora 8.1.7.2 when there is a heavy load in the shared pool memory area.

My point is , how to prove that the DB crash was happened due to load on shared pool memory? How to analyze the load on shared pool?

please clarify.

regards,

Vinodh.

[former_member204746]

SAPDBA 4.6D is not supported anymore, update to at least BRTOOLS 6.40 and switch to brconnect

Oracle 8.1.7 is not supported, go with 9.2.0.8 or 10.2.0.2

at the very least, try a minor upgrade to 8.1.7.4

[former_member618758]

Hi,

First check if you have imported the HP Support Packages below or equivalent:

PHSS_16849 : s700_800 11.0 LIBCL Support Package

After import, do:

1. Shut down the database instance.

2. CD $ORACLE_HOME/rdbms/lib

3. make -f ins_rdbms.mk ioracle

This should solve the problem.

Thanks,

George

[Former Member]

Hi

Please try this note

Note 335562

Thanks