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.
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>
No comments:
Post a Comment