Solved

LGWR failure and is causing instance shutdown.

Posted on 2001-07-25
5
1,553 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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

630 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