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.
Action
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/mount-vdb-instance.sh "restrict pfile='/de <IPT_DIR/mount-vdb-instance.sh "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 11.2.0.4.0 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
DIAGNOSTIC_DEST=/delphix/diag
and assigned the required Oracle permissions to read write to this folder solved the problem.