Oracle Database Errors

ERROR :  ID: oracle.install.library.crs.CRSInfo:1692

PRCI-1151 : crsctl utility failed to get the cluster node configured roles

PRCT-1011 : Failed to run "crsctl". Detailed error: <hostname1>:hub,<hostname2>:hub,CRS-601: Internal error,RC: 5, File: clsGetParser.cpp, Line: 3410,CRS-4000: Command Get failed, or completed with errors.

SOLUTION : 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

12.1.0.2.191015 EE and SE2 DB home creation may fail 

If 12.1.0.2 EE or SE2 DB home creation fails due to the error:

[FATAL]java.lang.NullPointerException
PRCI-1151 : crsctl utility failed to get the cluster node configured roles
PRCT-1411 : Encountered unexpected output during the crsctl command execution to retrieve configured node roles

Run the following command to check which node is causing the problem:

# /u01/app/19.5.0.0/grid/bin/crsctl get node role config -all

To fix this problem, stop and start the CRS on the node where its unable to list the cluster role from the command above

# /u01/app/19.5.0.0/grid/bin/crsctl stop crs -f
# /u01/app/19.5.0.0/grid/bin/crsctl start crs

After restarting the CRS, the crsctl utility should be able get the cluster node configured roles as expected. Then retry the 12.1.0.2 EE/SE2 DB home creation.

 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Oracle MiniCluster S7-2 MCMU Version 1.3.0 Release Notes (Doc ID 2661467.1)

ERROR : ERRORMSG(cgecedp4db06): PRVF-4353 : Proper soft limit for resource "maximum user processes" not found on node "cgecedp4db06" [Expected = "2047" ; Found = "1024"] 

 ERROR: [Result.addErrorDescription:624]  PRVF-4354 : Proper hard limit for resource "maximum open file descriptors" not found on node "cgecedp4db06" [Expected = "65536" ; Found = "4096"]

Solution : Define user limits in /etc/security/limits.conf as below

oracle soft nproc 1056767

oracle hard nproc 1056767

oracle soft nofile 125536

oracle hard nofile 125536

oracle soft stack 10240

oracle hard stack 32768

oracle  hard  memlock  238137088

oracle  soft  memlock  238137088

 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

ERROR : ORA-17500: ODM err:KGNFS READ FAIL:Permission denied

Solution : This error is because of improper permissions set , please check and the permissions and retry again 

 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++