How to fix the Oracle error PRCT-01207: Failed to set the ORACLE_SID for running asmcmd from CRS home location {0}?

In this post, you’ll learn more about the Oracle ErrorPRCT-01207: Failed to set the ORACLE_SID for running asmcmd from CRS home location {0} with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCT-01207: Failed to set the ORACLE_SID for running asmcmd from CRS home location {0}

Reason for the Error PRCT-01207: Failed to set the ORACLE_SID for running asmcmd from CRS home location {0}

Cause: Unable to retrieve the ASM instance name on the local node to generate the ORACLE_SID value.

How to fix the Error PRCT-01207: Failed to set the ORACLE_SID for running asmcmd from CRS home location {0} ?

You can fix this error in Oracle by following the below steps

Action: Use crsctl to make sure that the CRS stack is up; use ‘srvctl status asm’ to make sure that the ASM resource is running on the local node.

Tags :

Leave Your Comment