DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, December 22, 2016

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

During startup,ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2926472 bytes
Variable Size            1392511096 bytes
Database Buffers          738197504 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.

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

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
buffer_pool_keep
buffer_pool_recycle
log_archive_start
standby_archive_dest
parallel_server
parallel_server_instances
fast_start_io_target

NAME
--------------------------------------------------------------------------------
serial_reuse
rdbms_server_dn
max_enabled_roles
remote_os_authent
sec_case_sensitive_logon
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest

NAME
--------------------------------------------------------------------------------
commit_write
sql_trace
parallel_automatic_tuning
parallel_io_cap_enabled

26 rows selected.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Cause:  Obsolete or deprecated parameters for this instance type were specified in the SPFILE or the PFILE on the server side.

Action: See alert log for a list of parameters that are obsolete or deprecated. Remove them from the SPFILE or the server side PFILE.

No comments: