In this article I will demonstrate how to resolve the issue ORA-46362: Could not translate variable ORACLE_BASE.
Problem
After Database/ Instance manually added to cluster resource, DB /Instance or services is not getting started using srvctl shows below error
racnodepdb01.pii.star:/home/oradb>srvctl start service -db C1RACDB
PRCD-1133 : Failed to start services for database
CRS-5017: The resource action “ora.C1RACDB.iam_pracnode1.svc clean” encountered the following error:
ORA-46362: Could not translate variable ORACLE_BASE.
. For details refer to “(:CLSN00106:)” in “/racnode/orabase/diag/crs/racnodepdb02/crs/trace/crsd_oraagent_oradb.trc”.
CRS-5017: The resource action “ora.C1RACDB.iam_pracnode1.svc check” encountered the following error:
ORA-46362: Could not translate variable ORACLE_BASE.
. For details refer to “(:CLSN00109:)” in “/racnode/orabase/diag/crs/racnodepdb02/crs/trace/crsd_oraagent_oradb.trc”.
CRS-2680: Clean of ‘ora.C1RACDB.iam_pracnode1.svc’ on ‘racnodepdb02’ failed
CRS-5017: The resource action “ora.C1RACDB.adhoc_pracnode1.svc clean” encountered the following error:
ORA-46362: Could not translate variable ORACLE_BASE.
. For details refer to “(:CLSN00106:)” in “/racnode/orabase/diag/crs/racnodepdb02/crs/trace/crsd_oraagent_oradb.trc”.
……………………….
Resolution
Modify the database resource:
srvctl setenv database -db [DBNAME] -env ORACLE_BASE=$ORACLE_BASE
***