LGWR failure and is causing instance shutdown.

Posted on 2001-07-25
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.
Question by:lusiana
  • 2
  • 2

Expert Comment

ID: 6320316
This is an Oracle bug, fixed in 8.1.7 and (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.

Expert Comment

ID: 6320338
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 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


Author Comment

ID: 6320580
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.

Accepted Solution

ianmcgrath earned 100 total points
ID: 6326493
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.
Reduce the number of waiters for a particular event.
Related Bugs

Hope this helps


Author Comment

ID: 6343190
Thanks heaps for the responses, everyone.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

773 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