Solved

LGWR failure and is causing instance shutdown.

Posted on 2001-07-25
5
1,393 Views
Last Modified: 2007-11-27
Hi All,

I experienced a problem where oracle instance shuts down,
and the last entry on alert_sid.log file:

:
Thread 1 advanced to log sequence 22412
  Current log# 2 seq# 22412 mem# 0: /opt/dbfiles1/dev1/oradata/dev1/redo02.log
LGWR: terminating instance due to error 27152
Instance terminated by LGWR, pid = 13562
Wed Jul 25 14:16:28 2001
Errors in file /oracle/admin/dev1/bdump/dev1_lgwr_13562.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwrm1
ORA-27152: attempt to post process failed
Additional information: 1
Additional information: -2090048448
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwpost1
ORA-27303: additional information: semid = 12648451

Some additional information:
From init.ora: processes = 50
Oracle version is 8.1.6

I'm quite at lost at how to start investigating this problem.
The problem has occurred three times in the span of the last 10 days.

Any help, hints would be appreciated.

Thanks heaps.
Lucy
0
Comment
Question by:lusiana
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Kong
Comment Utility
This is an Oracle bug, fixed in 8.1.7 and 8.1.6.3 (Solaris).

It occurs when two of your ORACLE_SIDs are similarly named. Rename one of your ORACLE_SIDs - this is relatively easy since your instance ID (ORACLE_SID) can be different from db_name.
0
 
LVL 2

Expert Comment

by:Kong
Comment Utility
Here is some more info. Good luck!

Bug 1262942 is an issue where the hash function used to generate the key for semaphore set allocation can generate duplicates for similar ORACLE_SID/ORACLE_HOME combinations. This can cause problems when there are several databases on the same server using similar ORACLE_SIDs as if the keys are the same only one of the instances can be running at a time.

The bug is fixed in 8.1.7 and included in the 8.1.6.3 patchset release (for Solaris only). The workaround is to rename the ORACLE_SID of one of the clashing instances.

You can check for duplicate keys using 'ipcs -s':

o startup instance 1
o ipcs -s
o shutdown instance 1
o startup instance 2
o ipcs -s

0
 

Author Comment

by:lusiana
Comment Utility
Thanks for your response.
At the moment, our database has only one instance.
The ORACLE_SID is defined to be the same as db_name.
Thanks again.
0
 

Accepted Solution

by:
ianmcgrath earned 100 total points
Comment Utility
Some info that might help

The ORA-27152 indicates a problem at the Network layer

Bug 1228104:
The customer runs batch jobs from an MVS system against an 8.1.5 database on
Windows NT, when they have forty running concurrently the instance terminates
with :
  ORA-27152 attempt to post process failed
  OSD-19013670: Message 19013670 not found;  product=RDBMS; facility=SOSD
  (OS 170258008)
.
This problem seems to occur when Log Writer (LGWR) is busy and many session
are waiting for 'log buffer space'. If they reduce the number of concurrent
batch jobs the problem goes away, but reducing the number prevents them from
achieving the necessary data throughput.
.
The problem seems to be exacerbated by running hot backups, so they are trying
to reduce the number of waiters by not running these during the high load and
spreading the redo logs across more devices.
.
.
Workaround
----------
Reduce the number of waiters for a particular event.
.
Related Bugs
------------
Bug:1132689


Hope this helps

Ian
0
 

Author Comment

by:lusiana
Comment Utility
Thanks heaps for the responses, everyone.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SSN Format in Oracle 2 59
Oracle 12c patching 1 30
File generation using utl_file 4 28
PL/SQL Search for multiple strings 5 20
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now