Wednesday, October 4, 2017

"unable to create shared memory segment" occurred in Solaris 11

Issue: While Starting the database "unable to create shared memory segment" occurred in Solaris 11

RMAN> startup mount pfile=initINTP.ora.plug;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 10/04/2017 13:04:47
RMAN-04014: startup failed: ORA-27125: unable to create shared memory segment
SVR4 Error: 22: Invalid argument
Additional information: 2640
Additional information: 33554432
Additional information: 8192
RMAN-04017: startup error description: ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated

RMAN> exit

Cause: Memory is not allocated in the OS level for the USER.

Solution:
Verify as root user if the user name is available in the projects file, if the user is not found, add the user with attributes as below.

Run as root user.

#projects -l
#projadd -p 104 -U intpora -G dba,oinstall -K 'project.max-shm-memory=(priv,161061273600,deny)' user.intpora

RMAN> startup mount pfile=initINTP.ora.plug;

Oracle instance started
database mounted

Total System Global Area   10737418240 bytes

Fixed Size                     2925344 bytes
Variable Size               6375349472 bytes
Database Buffers            4328521728 bytes
Redo Buffers                  30621696 bytes

RMAN>

Retest the issue.

PRCR-1079 : Failed to start resource ora.asm

Issue:

PRCR-1079 : Failed to start resource ora.asm
ORA-01017: invalid username/password; logon denied
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/ebspgrid/app/12.1.0.2/diag/crs/euxhoerpdbtn/crs/trace/ohasd_oraagent_grid.trc".

CRS-2674: Start of 'ora.asm' on 'euxhoerpdbtn' failed


Cause: The ASM OS Authentication was failing due to the config.o was corrupted under $GRID_HOME/rdbms/lib

Solution:

$ORACLE_HOME/rdbms/lib
$rm config.o
$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/config.o
$ relink all

NOte: The solutions is applicable while connecting to the oracle database to an idle instance.

Tuesday, October 3, 2017

Oracle error 922: has been detected in alterpassword2.

Issue while changing the APPS password in R12.1.3

cat L6460833.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 04-OCT-2017 10:43:17

+---------------------------------------------------------------------------+

Working...
APP-FND-02704: Unable to alter user APPS to change password.
Oracle error 922:  has been detected in alterpassword2.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 04-OCT-2017 10:43:45

+------------------------

Cause: Password contains invalid character "$", password can contain only characters _, $, and #. 


Solution:

Remove Special Characters and retry.