ORA-16019:Cannot use LOG_ARCHIVE_DEST_1

[Former Member]

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

[former_member188883 · Accepted solution]

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

[Former Member · Accepted solution]

Dear Deepak,

We have change value in initSID.ora for parameter log_archive_dest, and it works now.

Thanks for your support

Kind Regards,

N S Rathore

[Former Member · Accepted solution]

Hi Gurus How to Solve This .... Required Valid Solution ....plz mail me to this mail : phani3366@gmail.com