Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Crashes with error ORA-1575

Naginder Dassi
Occasional Contributor

Database Crashes with error ORA-1575

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
11 REPLIES
Alexander M. Ermes
Honored Contributor

Re: Database Crashes with error ORA-1575

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Naginder Dassi
Occasional Contributor

Re: Database Crashes with error ORA-1575

yes we have relinked with the new libraries
Volker Borowski
Honored Contributor

Re: Database Crashes with error ORA-1575

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
Naginder Dassi
Occasional Contributor

Re: Database Crashes with error ORA-1575

we have done that also ..we have used different CD's for HPUX11.0 and HPUX10.20
Steven Sim Kok Leong
Honored Contributor

Re: Database Crashes with error ORA-1575

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Naginder Dassi
Occasional Contributor

Re: Database Crashes with error ORA-1575

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.
Naginder Dassi
Occasional Contributor

Re: Database Crashes with error ORA-1575

Someone Please come to my rescue...
Steven Gillard_2
Honored Contributor

Re: Database Crashes with error ORA-1575

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
Steven Sim Kok Leong
Honored Contributor

Re: Database Crashes with error ORA-1575

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
T G Manikandan
Honored Contributor

Re: Database Crashes with error ORA-1575

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
Dave Chamberlin
Trusted Contributor

Re: Database Crashes with error ORA-1575

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?