ORA-01078 And ORA-27046 Or ORA-01078

Database Startup Fails With Errors ORA-01078 And ORA-27046 Or ORA-01078
Error Description:-----------------------Database startup fails with errorSQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '......'or,SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '.......'ORA-27046: file size is not a multiple of logical block sizeOSD-04012: file size mismatch (OS 2558) Cause of The problem:------------------------------The error can be happened in many scenarios.1)The ORACLE_SID environmental variable is set improperly. 2)The error occurred as database could not find the spfile and pfile on the default location or specified location.(if startup pfile= is specified)3)The spfile exists in default location but it is corrupted and hence reported ORA-01078.4)If spfile exists in non-default location and we started by STARTUP pfile= where inside pfile it holds the location of spfile=location then error reported ORA-1078 along with ORA-27046. This scenario is explained in How to start your database with non-default spfile.Solution of The problem;------------------------------At first check whether your environment variable ORACLE_SID is set properly or not. On unix it is case sensitive. So dbase and Dbase is not same.Is there is no way to repair or modify an spfile so try to solve the problem in following order.1)If you have good backup of spfile then restore it. From RMAN you can easily do it if you have autobackup of controlfile.2)If the spfile backup does not exist then look at the database alert log file which is located in $ORACLE_HOME/admin/$ORACLE_SID/bdump. In the alert log file the list of non-default parameters listed. So create a pfile from spfile and later create spfile.3)If you have corrupted spfile then from that, using binary utilities like strings available on unix open that and create pfile. And then create spfile from that. Like,i)Follow either a or b part.a)$strings /oracle/app/oracle/product/10.2.0/db_1/dbs/spfiledbase.ora >/export/home/pfile.oraNow edit the /export/home/pfile.ora if any wrong character and then create spfile from that.SQL>!vi /export/home/pfile.oraSQL>create spfile from pfile='/export/home/pfile.ora';SQL>startupb)$strings /oracle/app/oracle/product/10.2.0/db_1/dbs/spfiledbase.oracopy the usable contents inside it Open another file and paste contents into it.SQL>!vi /export/home/oracle/test.txtCreate spfile from pfile.SQL> create spfile from pfile='/export/home/oracle/test.txt';File created.Then start the database.Related Documents:------------------------http://arjudba.blogspot.com/2008/04/how-to-know-my-database-start-with.htmlhttp://arjudba.blogspot.com/2008/04/pfile-and-spfile-in-oracle.htmlhttp://arjudba.blogspot.com/2008/04/how-to-start-your-database-with-no.html