Home » RDBMS Server » Server Administration » ORA-12514 log_archive_dest changed and now db instance won't start (Oracle 11.2 Windows)
ORA-12514 log_archive_dest changed and now db instance won't start [message #639969] Tue, 21 July 2015 00:57 Go to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hi,

Yesterday I changed the log_archive_dest_1 to 'location=/u02/archive' where before there was nog archive mode.
I then did a shutdown immediate but the startup doesn't succeed.

I get the ORA-12514 error. Can somebody help me? I haven't been able to login at any level.


Kind regards
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639970 is a reply to message #639969] Tue, 21 July 2015 01:00 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

"startup doesn't succeed" is not a very precise error message. Can you show what you are doing and what happens? Please use copy/paste, and [code] tags.
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639972 is a reply to message #639970] Tue, 21 July 2015 01:42 Go to previous messageGo to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hello,

Here is a screenshot of what I've executed:

/forum/fa/12767/0/

That's it. Unfortunally. A tnsping to oracle11.world still works.
  • Attachment: Capture.JPG
    (Size: 58.38KB, Downloaded 2462 times)
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639974 is a reply to message #639972] Tue, 21 July 2015 01:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I did ask you to use copy/paste. It is only just possible to read that screen shot.

However, this is all you need to do:
C:\Users\john>
C:\Users\john>
C:\Users\john>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 07:47:15 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

orclz> startup
ORACLE instance started.

Total System Global Area  788529152 bytes
Fixed Size                  3050600 bytes
Variable Size             390071192 bytes
Database Buffers          390070272 bytes
Redo Buffers                5337088 bytes
Database mounted.
Database opened.
orclz> 
orclz>

Your mistake is attempting to connect with @oracle11.world
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639976 is a reply to message #639974] Tue, 21 July 2015 01:56 Go to previous messageGo to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hello John,

Here is a copy/paste of the result:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Di Jul 21 08:55:23 2015

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639977 is a reply to message #639976] Tue, 21 July 2015 02:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I have already asked you to enclose your copy/paste in [code] tags. I shall not assist further if you do not follow the forum guidelines. So, your last chance. You might want to say "thankyou for your time" as well.

If the operating system authentication is not configured correctly (which is what your error tells me) you need to use password file authentication instead:
C:\Users\john>
C:\Users\john>sqlplus sys/oracle as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 08:00:12 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

orclz> startup
ORACLE instance started.

Total System Global Area  788529152 bytes
Fixed Size                  3050600 bytes
Variable Size             373293976 bytes
Database Buffers          406847488 bytes
Redo Buffers                5337088 bytes
Database mounted.
Database opened.
orclz>

Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639981 is a reply to message #639969] Tue, 21 July 2015 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to be locally connected to restart the database.

Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639985 is a reply to message #639981] Tue, 21 July 2015 02:24 Go to previous messageGo to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hello John,

Of course a thank you for your time! As for the code-tags, I wasn't aware - first time on forum ...

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Di Jul 21 08:55:23 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Voer gebruikersnaam in:
C:\Users\administrator>sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Di Jul 21 09:14:38 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Verbonden aan een inactieve instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: Kon parameterbestand 'D:\APP\DBA\PRODUCT\11.2.0\DBHOME_1\DATABASE\INI
TORACLE11.ORA' niet openen.
SQL>


The problem why he can't open the file is because it doesn't exits Confused (don't know why - inherited this server from a colleague who is now retired).

So again, a big thanks for helping me!
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639991 is a reply to message #639985] Tue, 21 July 2015 03:13 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It is certain that the Windows service for the atabase instance is running, or you would receive a different error. Can you show how it is confiugured, with the Windows command
sc qc oracleserviceoracle11

If your dabase instance is named ORACLE11, the file to start the instance would be named by default either
D:\APP\DBA\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITORACLE11.ORA
or
D:\APP\DBA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORACLE11.ORA
Do you have any files named something like that?

Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639992 is a reply to message #639991] Tue, 21 July 2015 03:19 Go to previous messageGo to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hello John,

Yes I have a file spfileoracle11.ora in that directory. As for the result of the query:


C:\Users\administrator>sc qc oracleserviceoracle11
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: oracleserviceoracle11
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : d:\app\dba\product\11.2.0\dbhome_1\bin\ORACLE.EXE O
RACLE11
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : OracleServiceORACLE11
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

C:\Users\administrator>
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #639996 is a reply to message #639992] Tue, 21 July 2015 03:59 Go to previous messageGo to next message
Caroline_789
Messages: 11
Registered: July 2015
Junior Member
Hi,

I just found an init.ora in a different folder. Copied en renamed it to what was needed and I could start the instance.
Many thanks for the help!

Regards.
Re: ORA-12514 log_archive_dest changed and now db instance won't start [message #640014 is a reply to message #639996] Tue, 21 July 2015 06:27 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Caroline_789 wrote on Tue, 21 July 2015 03:59
Hi,

I just found an init.ora in a different folder. Copied en renamed it to what was needed and I could start the instance.
Many thanks for the help!

Regards.


Now, for your own understanding you need to follow up by researching the difference between a pfile (init<sid>.ora) and an spfile (spfile<sid>.ora).
Previous Topic: NOLOGGING TABLES in DATAGUARD
Next Topic: Oracle client connectivity to Database in different Windows work Domain
Goto Forum:
  


Current Time: Thu Mar 28 08:00:46 CDT 2024