Skip to Content
avatar image
Former Member

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 (92.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 25, 2013 at 05:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded