Srvctl Fails to Start Instance while sqlplus Works on Solaris
(Doc ID 603051.1)
Last updated on MARCH 07, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.1 [Release 10.1 to 11.2]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Solaris on x86 (32-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
Solaris Operating System (Intel)Solaris Operating System (SPARC) (64-bit)Solaris Operating System (x86-64)
Solaris Operating System (x86)Solaris Operating System (SPARC 64-bit)
Symptoms
Attempting to start an instance/database via 'srvctl' would fail as follows:
However, starting the instance via sqlplus as oracle user works fine!
Changes
% cat /etc/procject shows ->
system:0::::
user.root:1::::
noproject:2::::
default:3::::process.max-file-descriptor=(priv,4096,deny)
group.staff:10::::
group.dba:100::::process.max-file-descriptor=(priv,4096,deny);process.max-sem-nsems=(priv,12000,deny
);process.max-sem-ops=(priv,4096,deny);project.max-sem-ids=(priv,4096,deny);project.max-shm-ids=(priv,4096,deny);project.max-shm-memory=(priv,30064771072,deny)
Project for the oracle user is correct..
You can verify an instance is using it if you start with sqlplus & then run ->
% ps -u oracle -o pid,user,project,args
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |