When trying to start the instance , getting this ..
Enter user-name: sys as sysdba;
Connected to an idle instance.
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u01/app/oracle/product/11.2.0/db_1/dbs/initDemo.ora’
solutuon one :
Check the Oracle SID name. Wrong settings in bash profile.
Solution two :
I used to face this issue.
I realized that the error can be caused by the pfile not being found. You have to start the Oracle instance using a fully referenced pfile by issuing the following command:
SQL> startup pfile=<your pfile full path here>
path location: cd $ORACLE_HOME/db/dbs/init<SID>.ora
demo : /oracle/product/220.127.116.11/db/dbs/initDEMO.ora
SQL> startup pfile=’/oracle/product/18.104.22.168/db/dbs/initDEMO.ora’;
then sql>create spfile from pfile;
have a good day.