ASM Oracle permission issue

 

ORA-12547: TNS:lost contact

This error is very generic and below are the symptoms to it. If you find any of these errors in the log it is probably the permission issue on oracle binary on Oracle Home under grid user. 

RMAN Crosschecks error:

RMAN-03002: failure of backup command at 03/24/2025 13:01:37

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file <datafile>

ORA-17503: ksfdopn:2 Failed to open file <filename>

ORA-12547: TNS:lost contact

ORA-12547: TNS:lost contact

ASM alert log showing error:

*** 2025-03-24T13:28:11.414105-06:00

*** MODULE NAME:(emagent_SQL_osm_instance) 2025-03-24T13:28:11.414215-06:00

*** ACTION NAME:(FileGroup_Usage) 2025-03-24T13:28:11.414234-06:00

ERROR: submiting READ on /dev/rdsk/<diskname> failed due to kgfknm error

crsctl status:

crsctl status res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

Oracle Alert log:

Fatal NI connect error 12547, connecting to:

 <JDBC>

  VERSION INFORMATION:

        TNS for <OS>: Version 19.0.0.0.0 - Production

        Oracle Bequeath NT Protocol Adapter for Solaris: Version 19.0.0.0.0 - Production

  Version 19.25.0.0.0

  Time: 24-MAR-2025 14:46:06

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12547

TNS-12547: TNS:lost contact

    ns secondary err code: 12560

    nt main err code: 517

Solution:

For all these error, below permission change will fix the issue.

login as grid user, and go to GRID_HOME/bin location

chmod 6751 oracle

ls -lrt oracle

-rwsr-s--x   1 grid oinstall 563794648 Mar 26 20:13 oracle

Oracle Bug reference:

But this was is not applicable for our version. 

Bug details: Bug 36461761 - ASM numerous trace files generated with 'error: submiting read on /dev/rdsk/nnn 'failed due to kgfknm error' messages (Doc ID 36461761.8)

Best Wishes!!