|
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #639977 is a reply to message #639976] |
Tue, 21 July 2015 02:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #639991 is a reply to message #639985] |
Tue, 21 July 2015 03:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #640014 is a reply to message #639996] |
Tue, 21 July 2015 06:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
Caroline_789 wrote on Tue, 21 July 2015 03:59Hi,
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).
|
|
|