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

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

Solution:
-------------------------------------------------------------------------------------------------------------------------
As of version 12.1.0.2 parameter sec_case_sensitive_logon is deprecated and its default value is TRUE, this means that if you set the parameter
to FALSE, this error will be reported:

$ sqlplus / as sysdba
SQL> show parameter sec_case_sensitive_logon

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

When the error occurs starting up Database: ORA-32004 error could be found, it can be safely ignored.

E-Business Suite Release 12.1 or 12.2, ensure that your sqlnet_ifile.ora has the line:

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE)

$ sqlplus / as sysdba
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=FALSE;

OR

sqlplus / as sysdba
SQL> select name, value from v$parameter where ISDEPRECATED='TRUE' and ISDEFAULT='FALSE';

NANE                               VALUE
sec_case_sensitive_logon FALSE

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=TRUE;