Find in this Blog

Tuesday, October 7, 2014

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

ERROR 2014-10-07 10:37:22.120
CJS-00084  SQL statement or script failed. DIAGNOSIS: Error message: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Disconnected
. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.



SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DU
PLEX_DEST
SQL> shut immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DU
PLEX_DEST
SQL>

Solution:

Change the spfile value and init<SID> value on following parameter

LOG_ARCHIVE_DEST_1( set value for this parameter in both file)
 LOG_ARCHIVE_DEST (Remove this parameter from both file)

And start the serverice and startup the database;

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

Total System Global Area 1987641344 bytes
Fixed Size                  2256504 bytes
Variable Size            1006633352 bytes
Database Buffers          973078528 bytes
Redo Buffers                5672960 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL>

Thanks
Yoonus


 

No comments:

Post a Comment

Ask Your Questions ?#