topic Re: Database Crashes with error ORA-1575 in Operating System - HP-UX

Database Crashes with error ORA-1575

Naginder Dassi — Mon, 10 Dec 2001 05:53:50 GMT

we upgraded the OS from HPUX10.20 to HPUX11.0 for our database version 7.3.4. This exercise was done as the first phase of migration from oracle 7.3.4 to oracle 8.1.7.
After the OS upgrade the database started crashing with the error ORA-1575.(timeout waiting for space management resource ).
Could anybody help me out on this.
The database is running on K460 machine

Re: Database Crashes with error ORA-1575

Alexander M. Ermes — Mon, 10 Dec 2001 06:58:27 GMT

Hi there.
Have you relinked the executables of Oracle ?
You work under a different OS version now, so you should do it.
Rgds
Alexander M. Ermes

Re: Database Crashes with error ORA-1575

Naginder Dassi — Mon, 10 Dec 2001 08:13:53 GMT

yes we have relinked with the new libraries

Re: Database Crashes with error ORA-1575

Volker Borowski — Mon, 10 Dec 2001 08:40:41 GMT

Hello,

I am not so sure if re-linking is enough.
I.e. SAP delivers diffrent Oracle CDs for 10.20 and 11.00 and a third set for 11.00 64-bit.

May be you need diffrent executables as well ?

Volker

Re: Database Crashes with error ORA-1575

Naginder Dassi — Mon, 10 Dec 2001 08:59:20 GMT

we have done that also ..we have used different CD's for HPUX11.0 and HPUX10.20

Re: Database Crashes with error ORA-1575

Steven Sim Kok Leong — Mon, 10 Dec 2001 09:07:27 GMT

Hi,

Relinking Oracle requires root.sh. Relinking SAP requires saproot.sh.

// *Cause: failed to acquire necessary resource to do space management.

In addition, check the following link out:

http://weh-intranet.ethz.ch/oracle/oramag/tip04296.html

====================================
POSSIBLE CAUSES

There can be multiple reasons why ORA-1575 occurs:

1) High contention for the space management (ST) enqueue is a legitimate reason for ORA-1575.

2) In an Parallel Server environment there may be deadlocks or locks lost by the DLM.

3) Could be caused by a heavy load, especially during very large deletes, parallel create index or parallel loads involving large amounts of data.

4) Trying to get space while some other process is holding the ST enqueue, will result in this error before it is possible to see whether any space is available. For example, SMON may be coalescing space.

5) A lot of on-disk sorting could cause contention for ST enqueue.
====================================
Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com

Re: Database Crashes with error ORA-1575

Naginder Dassi — Mon, 10 Dec 2001 09:52:02 GMT

The same database was not giving this error when running in HPUX10.20 ,But this problem surfaced only after upgrading the OS to HPUX11.0.
In fact we have rolled back to HPUX10.20 OS and it is working fine.
The load is same in both the OS versions.

Re: Database Crashes with error ORA-1575

Naginder Dassi — Tue, 11 Dec 2001 09:58:58 GMT

Someone Please come to my rescue...

Re: Database Crashes with error ORA-1575

Steven Gillard_2 — Tue, 11 Dec 2001 10:09:19 GMT

What were your 11.x kernel parameter settings? Can you post kmtune output? If you are back on 10.20 what kernel parameter changes did you make from the defaults when you tried 11.x?

Regards,
Steve

Re: Database Crashes with error ORA-1575

Steven Sim Kok Leong — Wed, 12 Dec 2001 01:02:32 GMT

Hi,

With regards to kernel parameters, note that there are additional kernel parameters to set for Oracle on HP-UX 11.00 than on HP-UX 10.20.

Some of the more important ones include:
- maxdsiz_64bit
- maxssiz_64bit
- maxtsiz_64bit

For more information, refer to the Oracle Installation Guide for the section on HP-UX 11.00.

Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com

Re: Database Crashes with error ORA-1575

T G Manikandan — Wed, 12 Dec 2001 03:29:13 GMT

Hello,
Can you please compare the kernel parameter list on the different versions?
Can you post your kernel parameters of the HP11.0 server?

Thanks

Re: Database Crashes with error ORA-1575

Dave Chamberlin — Tue, 18 Dec 2001 21:18:28 GMT

You should check the disk firmware on the system, both for version and consistency. According to the HPUX 11 install matls I read, there are some seagate disks that have potential problems. I had numerous problems (corruption, severe contention etc) after moving my database from 10.20 to 11.0, and mixing older disks with newer ones. My problems were nover actually resolved for cause - but with new disks they are gone.
Also, when you look in the oracle alert log - what is happening when the errors occur?