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
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 ?#