##########################
## Error
##########################
SP2-0332: Cannot create spool file.
### Full Error
SQL> spool /u01/pass/$ORACLE_SID_Pass.log
SP2-0332: Cannot create spool file.
##########################
# Error Occurred
##########################
Error occured while trying to spool a file with $ORACLE_SID in 11.2.0.4.0 version in HP-UX Platform
##########################
## Command Executed
##########################
spool /u01/pass/$ORACLE_SID_Pass.log
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Reason for Failure
#########################################
The output we are looking from spool command is "dbname_Pass.log". Here we are using $ symbol which seems to be a OS Limitation.
So to eliminate this error, we need to use ${VARIABLE_NAME}
=====================================================================================================================
##########################
## Solution
##########################
spool /u01/pass/${ORACLE_SID}_Pass.log
ls -ltr /u01/pass
SQL> !ls -ltr /u01/pass
total 204
-rw-r----- 1 oracle nogroup 12113 Jun 17 10:33 DBL_Pass.log
-rw-r----- 1 oracle nogroup 3922 Jun 20 16:48 DBW_Pass.log
SQL>
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
