Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-16019:Cannot use LOG_ARCHIVE_DEST_1

Dear Expert,

Now I am installing SAP ECC 6.0 EHP5 on IDES Server with following details

OSĀ  - Windows Server 2003 R2 64bit

DB - Oracle 11g (11.2.0.2.0)

---------------------------------------------------------------------------------------

I got an error on create a database on time of installation attach the same for your kind reference. SAP has asked 10g oracle client on the phase of Oracle Client installation , Gui not accepted Oracle 11g client. I had already check all the oracle service those are running and uninstall antivirus software too.

Also got ORA-12560 TNS : Protocol adapter error at the time of Sqlplus.

Please see and resolve.

Kind Regards,

N S Rathore


oracle11g.png (92370 B)
Tags:
Former Member
replied

Hi Narendra,

Refer steps below to resolve the issue

1)You can check your current archival location by issuing, show parameter DB_RECOVERY_FILE_DEST

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oradata2
db_recovery_file_dest_size big integer 30G

2)Now you want to set log_archive_dest.

SQL> alter system set log_archive_dest='/oradata1';
alter system set log_archive_dest='/oradata1'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST

3)If you want to set log_archive_dest first reset DB_RECOVERY_FILE_DEST and then set .

SQL> alter system set DB_RECOVERY_FILE_DEST='';

System altered.

SQL> alter system set log_archive_dest='/oradata1';

System altered.

Note: Path used in the commands are for example only.

If above commands does not work, you can directly modify the initSID.ora file and set the value for parameter log_archive_dest.

Hope this helps.

Regards,

Deepak Kori

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question