tag:blogger.com,1999:blog-3170165991598330378.post5494914566066325930..comments2024-02-21T18:32:14.004-08:00Comments on Step Into Oracle DBA ( SID ): ORA-16033: parameter LOG_ARCHIVE_DEST_1 destination cannot be the same asUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3170165991598330378.post-81188935874180842032014-10-09T11:23:17.965-07:002014-10-09T11:23:17.965-07:00Aldar,
Looks like when you give "startup mou...<br />Aldar,<br /><br />Looks like when you give "startup mount" it tries to start the instance from spfile.<br /><br />Please try the below steps,<br /><br />1) Create a new pfile <br /><br />sqlplus / as sysdba<br /><br />Create pfile='/tmp/initdb.ora' from spfile;<br /><br />2) Now open the initdb.ora file and check the below parameters,<br /><br />log_archive_dest_1 <br />log_archive_dest_3<br /><br />3) Make sure both the values are different, if its same then modify it for different values.<br /><br />4) Take a backup of spfile before proceeding with below step<br /><br />5) Create spfile from pfile='/tmp/initdb.ora';<br /><br />6) now startup the instance<br /><br />startup <br /><br />Note : Please take a backup of init and spfile before making any changes and also try this in test environment first.<br /><br /><br />SIDhttps://www.blogger.com/profile/00813693173046599593noreply@blogger.comtag:blogger.com,1999:blog-3170165991598330378.post-33851488714243591122014-10-09T09:46:03.188-07:002014-10-09T09:46:03.188-07:00i can connect with init.ora file to use this com...i can connect with init.ora file to use this command SQL> startup pfile=/u01/app/oracle/admin/uccsdb2/pfile/init.ora.912013185639;<br />but alter system set log_archive_dest_1='LOCATION=/bkp/aldar' ; after shutdown , it was same , pls help meAnonymoushttps://www.blogger.com/profile/06718302778361900523noreply@blogger.comtag:blogger.com,1999:blog-3170165991598330378.post-19847520194768467182014-10-09T09:42:17.318-07:002014-10-09T09:42:17.318-07:00Copyright (c) 1982, 2013, Oracle. All rights rese...Copyright (c) 1982, 2013, Oracle. All rights reserved.<br /><br />Connected to an idle instance.<br /><br />SQL> startup mount ;<br />ORA-16033: parameter LOG_ARCHIVE_DEST_3 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination<br />SQL> Anonymoushttps://www.blogger.com/profile/06718302778361900523noreply@blogger.comtag:blogger.com,1999:blog-3170165991598330378.post-34960356210471761822014-10-09T09:05:51.017-07:002014-10-09T09:05:51.017-07:00
Hi Aldar,
Please post the full output which you ...<br />Hi Aldar,<br /><br />Please post the full output which you got from sqlplus. <br /><br />If possible attach <br /><br />1) screenshot of your error <br />2) database alert log file <br /><br />and send it across to my email ( stepintooracledba@gmail.com )<br /><br />Once you sent an email, kindly comment in this post. I will take a look and try to resolve your issue.<br />SIDhttps://www.blogger.com/profile/00813693173046599593noreply@blogger.comtag:blogger.com,1999:blog-3170165991598330378.post-11493177543614270232014-10-09T08:40:09.470-07:002014-10-09T08:40:09.470-07:00pls help me , icant log in sqlplus with startup; o...pls help me , icant log in sqlplus with startup; oracle not available , error msg = ora-16033 , pls Anonymoushttps://www.blogger.com/profile/06718302778361900523noreply@blogger.com