Solved

LGWR failure and is causing instance shutdown.

Posted on 2001-07-25
5
1,489 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Kong
ID: 6320316
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
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 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
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.
0
 

Accepted Solution

by:
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.
.
.
Workaround
----------
Reduce the number of waiters for a particular event.
.
Related Bugs
------------
Bug:1132689


Hope this helps

Ian
0
 

Author Comment

by:lusiana
ID: 6343190
Thanks heaps for the responses, everyone.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
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.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

733 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