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

Start typing and press Enter to search