ERROR:-
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-32003: error occured processing parameter ‘utl_file_dir’
LRM-00101: unknown parameter name ‘utl_file_dir’
SOLUTION:-
Remove the line which contains “utl_file_dir” from the pfile and save the pfile.
Then you can create spfile from the pfile.
create spfile from pfile='<path>’; / create spfile from pfile;
CAUSE:-
Utl_file_dir parameter is obsolete on 18.3 and onwards.
Recent Posts