Archive for the ‘ Oracle SQL ’ Category
Could not start up oracle instance
Could not start up oracle instance
This issue occurred because no pfile or spfile
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
‘/mnt02/oracle/10.2.0.3/dbs/initfile.ora’
Oracle init file (parameter file – pfile or spfile)
init file are located under :
Unix : $ORACLE_HOME/dbs
Windows : %ORACLE_HOME%\database
SQL Statement – How to check ORACLE_SID
Just type the below SQL Statement :
select NAME , Value from v$parameter where NAME=’db_name’
Result :
NAME VALUE
db_name BLOGXXX