11.2 CRSD Fails to Start After Adding ENCRYPTION_WALLET_LOCATION Parameter in SQLNET.ora (Doc ID 1153244.1)

Last updated on MAY 18, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
11.2 CRSD fails to start after adding the ENCRYPTION_WALLET_LOCATION SQLNET.ora paramter to the Grid Infrastructure SQLNET.ORA.

This parameter will cause Transparent Data Encryption (TDE) feature to be used. This feature is not applicable to Grid Infrastructure resulting in the inability to start the stack. At first look this appears to be an issue accessing the OCR but these errors are misleading, the root cause of the issue is the inability for Grid Infrastructure processes to create TCP sockets.


***Checked for relevance on 11-Mar-2013***

Symptoms

CRSD Fails to start, evidence of the root cause of this issue is in the CTSSD log where we see NSerr (12560, 0).

GI Alert Log Reads:

[ohasd(19982)]CRS-2757:Command 'Start' timed out waiting for response from the resource 'ora.ctssd'. Details at (:CRSPE00111:) in /u01/app/11.2.0/grid/log/<hostname>/ohasd/ohasd.log.
[crsd(21482)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in /u01/app/11.2.0/grid/log/<hostname>/crsd/crsd.log


CRSD log Reads:

2010-07-06 13:55:52.315: [ OCRASM][1848988144]proprasmo: Error in open/create file in dg [GRID]
[ OCRASM][1848988144]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
ORA-15077: could not locate ASM instance serving a required diskgroup
2010-07-06 13:55:52.316: [ OCRASM][1848988144]proprasmo: kgfoCheckMount returned [7]
2010-07-06 13:55:52.316: [ OCRASM][1848988144]proprasmo: The ASM instance is down
2010-07-06 13:55:52.316: [ OCRRAW][1848988144]proprioo: Failed to open [+GRID]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
2010-07-06 13:55:52.317: [ OCRRAW][1848988144]proprioo: No OCR/OLR devices are usable
2010-07-06 13:55:52.317: [ OCRASM][1848988144]proprasmcl: asmhandle is NULL
2010-07-06 13:55:52.317: [ OCRRAW][1848988144]proprinit: Could not open raw device
2010-07-06 13:55:52.317: [ OCRASM][1848988144]proprasmcl: asmhandle is NULL
2010-07-06 13:55:52.317: [ OCRAPI][1848988144]a_init:16!: Backend init unsuccessful : [26]


CTSSD log Reads:

2010-07-06 13:55:52.255: [ COMMCRS][1111607616]clsclisten: Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>))
2010-07-06 13:55:52.255: [ COMMCRS][1111607616]clsclisten: op 65 failed, NSerr (12560, 0), transport: (583, 0, 0)
2010-07-06 13:55:52.256: [ CTSS][1228146768](:ctsscomm_init3:) clsclisten [(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>))] failed [3]. Return [5].

Changes

The SQLNET.ora parameter: ENCRYPTION_WALLET_LOCATION was added to the the Grid Infrastructure SQLNET.ORA.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms