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: sskgpcreates

ISSUE:

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: sskgpcreates

CAUSE:

So it turns out, the max number of arrays have been reached:
#check limits of all IPC
root@doxer# ipcs -al

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 67108864
max total shared memory (kbytes) = 17179869184
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 1024000
max ops per semop call = 100
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 16
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536

#check summary of semaphores
root@doxer# ipcs -su

------ Semaphore Status --------
used arrays = 127
allocated semaphores = 16890

FIX:

To resolve this, we need increase value of max number of semaphore arrays:

root@doxer# cat /proc/sys/kernel/sem
250 1024000 100 128
                 ^---needs to be increased

Invalid specification for system parameter LOCAL_LISTENERORA-00119: invalid specification ORA-00132: syntax error

ISSUE: 

sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu 12 07:37:51 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'
SQL>




CAUSE




Your INIT file by default will look for an ALIAS name of Listener in

TNSNAMES.ora which doesnt exist in the file.




SOLUTION




#OPTION:1

Hence create a same entry for LISTENER in tnsnames.ora file.




LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

 #OPTION 2:

You can directly insert the entry of Local Listener in the INIT file like below.

*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))'

Rapid Clone Ouicli.pl Fails: "Finished OUI CLI cloning for s_db_oh with return code: 16777215"

ISSUE: 

While cloning a 12.0.6 environment using the Rapid Clone option "dbtechstack", the following error occurs when Rapid Clone runs "ouicli.pl":

CAUSE

The perl program "ouicli.pl" is unable to locate the JDK installation. This could be due to any of the following reasons:

1) There is no JDK/JRE installed under the "/appsutil/jre/bin" directory.

2) There is a problem, such as file corruption, with the JDK.

3) The value of "s_adjvaprg" in the Context File is set to an invalid location.

SOLUTION

1. Ensure there is a working "java" executable under "/appsutil/jre/bin": 

$ cd $ORACLE_HOME/appsutil/jre/bin

$ ./java -version

java version "1.6.0_07"

Java(TM) SE Runtime Environment (build 1.6.0_07-b06)

Java HotSpot(TM) Server VM (build 10.0-b23, mixed mode)

If the version information is returned, the JDK/JRE is working. This "java" executable file should be referenced directly

In My Case, JRE folder is missing. So Copied the folder from working env and kickked off again

then it is successfull.