ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
I am getting this error when starting the database. When I search the v$parameter or v$spparmeter view, the utl_file_dir is not found. However when I search the v$obsolete_parameter, I find utl_file_dir. How do I remove the utl_file_dir from v$obsolete_parameter view.
SQL> select name from v$obsolete_parameter where isspecified='TRUE';
NAME
--------------------------------------------------------------------------------------------------
utl_file_dir
Note that the statement:
alter system reset utl_file_dir scope=spfile sid='*';
return an error
The alert log does not show any error
Oracle Database version: 19c
Operating system: RedHat Linux 7.6
Tagged:
0