Thanks for the question, Ahmed.
Asked: July 07, 2017 - 4:38 am UTC
Last updated: July 16, 2017 - 7:06 am UTC
Version: oracle database 10g
Viewed 1000+ times
You Asked
HEllo !!
## PROBLEM STATEMENT ##
This server has just been handed over to me after it created problem. DB is not starting through WIndows Services. Windows service for Oracle starts running successfully but db stays dead. I have tried fol:-
1. oradim -start -sid <sid>. It runs but returns to command prompt without any output or errors in sessions or alert log.
2. SQLPLUS / as sysdba. It connects to idle instance. On startup it gives
"ORA-01078: failure in processing system parameters"
"LRM-00109: Message 109 not found: No message file for product=ORACORE, facility=LRM"
If i start through a manually created pfile it gives
"ORA-02778 Name given for the log directory is invalid"
I have tried alot but cant by pass this error. I AM STUCK HERE !!
## SUPPORTING INFO ##
1. alertlog shows very limited entries i.e. from 22 jun 2017 to 3 jul 2017 (the day it died), although this db is as old as 2009. Only entries of LGWR switched and absolutely nothing else. No errors. It doesnot even show why it shut down. Last entry is of a log switch
2. I cant find any backup (of any kind except very old exp)on the server.
3. All datafiles, controlfiles, redo log files seem intact and i have located them
## QUESTION ##
1. Can ORA-02778 be resolved (i have tried alot, working with pfile etc)
2. Given the fact, that i have no backup and only the datafiles, redo, controlfiles, can i try my luck with database cloning. I mean manually cloning the database.
Pl guide !!!!
Thanking in advance
and Connor said...
ORA-02778 normally means a critical directory we want to write to either could not be found, or we could not write it.
So check your pfile - and for every directory you see mentioned in there, ensure that correctness of the directory it references.
The challenge here is that if your pfile is incomplete, then defaults will be used, and obviously these defaults need to have their directories correct as well.
Can you get to nomount stage ? ie,
startup nomount
If you can, you can run 'show parameter' to get a list of all the parameters and their values to assist with directory checking, and then do something like
create pfile = '/tmp/init.ora' from memory;
The most common errors I see when it comes to folders causing startup issues are:
audit_file_dest
db_recovery_file_dest
diagnostic_dest
log_archive_dest_1/log_archive_dest
If you're stil stuck after all of this, it *might* be an issue with *software* installation. In that case, you could try copying all of the database files to the same structures on a new server or under a new fresh ORACLE_HOME
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment