Skip to main content

Posts

Showing posts from June, 2014

Alert not working in Oracle R12 - Program was terminated by signal 11

Issue: Alert are not getting fired from concurrent programs in R12 (12.1.3) Symptom: Error Message /orpogpp1/erpapp/appl/alr/12.0.0/bin/ ALECTC Program was terminated by signal 11 Cause: A code mismatch was introduced by patch 13855823 where all the alert related concurrent programs errored with a signal 11 reflected from the error above.  A code fix for this was delivered in patc h 13728376. Solution: 1. Please download  Patch 13728376  from metalink support and apply it.

ORA-27301: OS failure message: No space left on device

After installing Oracle on Linux and creating a database,I tried to connect to sqlplus and startup the database instance I got this error: $ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 5 15:53:47 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper Solution: As root user, edit the /etc/sysctl.conf file and edit the kernel parameters  # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128