Facing below issue on Oracle 12c database.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
solution:-
Down Database.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
solution:-
Down Database.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Edit PFILE:-
Go to PFILE location.
[sujeet@oracle ~]$ cd $ORACLE_HOME/dbs
[sujeet@oracle dbs]$ vi initORCL.ora
commit below parameter.
#sec_case_sensitive_logon = FALSE
save pfile.
start database with pfile.
SQL> startup pfile=/apps/dba/db/tech_st/12.1.0.2/dbs/initORCL.ora
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 872417400 bytes
Database Buffers 1258291200 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 872417400 bytes
Database Buffers 1258291200 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
Issue resolved.
No comments:
Post a Comment