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.
Leave Your Comment