Failed to mount database instance during provisioning

By Sathees Kodi posted 08-03-2015 02:49:00 PM

During provision we received the following error message. As of Oracle Database 11g Release 1 onwards, the diagnostics for each database instance are located in a dedicated directory, which can be specified through the "DIAGNOSTIC_DEST" initialization parameter.  In that case one should define the parameter in the init.ora with Path. 

Initially customer defined the path as DIAGNOSTIC_DEST=/delphix and receiving the following error message.

DB_PROVISION job for "GOLD/P01_GOLD" failed due to an error during execution: Failed to mount database instance. See command output for more information.
Make sure that the parameters in init<sid>.ora file are valid. Review the Oracle alert log for more details if applicable.
Command Output
rm -f $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora DELPHIX>$DLPX_SHELL $DB_SCRIPT_DIR/ "restrict pfile='/de <IPT_DIR/ "restrict pfile='/del phix/P01_GOLD/datafile/in <.sh "restrict pfile='/delphix/P01_GOLD/datafile/ini t.ora.rename'" #####DELPHIX_START_ERROR##### ERROR : ERROR : SQL*Plus: Release Production on Fri Jul 31 14:47:22 2015 ERROR : ERROR : Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR : ERROR : Connected to an idle instance. ERROR : ERROR : SQL> ORA-48189: OS command to create directory failed ERROR : Linux-x86_64 Error: 13: Permission denied ERROR : Additional information: 2 ERROR : SQL> Disconnected #####DELPHIX_END_ERROR##### MOUNT_DATABASE_ERROR

Once the path is corrected as 


and assigned the required Oracle permissions to read write to this folder solved the problem.