OraFAQ Forum: Server Administration » ORA-12514 log_archive_dest changed and now db instance won't start

Home » RDBMS Server » Server Administration » ORA-12514 log_archive_dest changed and now db instance won't start (Oracle 11.2 Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12514 log_archive_dest changed and now db instance won't start [message #639969]

Tue, 21 July 2015 00:57

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

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

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 3495 times)

Report message to a moderator

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

John Watson
Messages: 8964
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

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8964
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>

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to be locally connected to restart the database.

Report message to a moderator

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

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!

Report message to a moderator

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

John Watson
Messages: 8964
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?

Report message to a moderator

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

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>

Report message to a moderator

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

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.

Report message to a moderator

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

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).

Report message to a moderator

Previous Topic:	NOLOGGING TABLES in DATAGUARD
Next Topic:	Oracle client connectivity to Database in different Windows work Domain

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:55:14 CST 2025