You can issue the following SQL statement to get a list of all deprecated initialization parameters:

SQL> SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE';

You can issue the SQL statement below to create a listing of all of the obsolete parameters:

SQL> select name, isspecified from v$obsolete_parameter;

Also you can look at alertlog file to find out for which initialization parameter you have this error.
You must reset the parameter or delete from init.ora file to get rid of this error.

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -