Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help me : init.ora
Hi,
Oracle looks for a file called "init<SID_NAME>.ora" in the ORACLE_HOME
defined in your environment. So considering the files you could find it
looks like you had/have a database instance called JASPERDB running. So,
yes, make a copy of the init.ora file and call it initNSTRADER.ora.
I know of no way of Oracle telling you which init.ora or spfile it actually used to start up.
Regards
Pete
[END]
-----Original Message-----
From: Kean Jacinta [mailto:jacintakean_at_yahoo.com]
Sent: 16 February 2004 01:20
To: oracle-l_at_freelists.org
Subject: Help me : init.ora
Can someone please help me . I am using Linux AS with database 9.2 . Somehow ....my database goes down . I need to restart the database but it gave this error.
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/database/u01/app/oracle/product/9.2.0/dbs/initNSTRADER.ora'
So i went to the directory
/database/u01/app/oracle/product/9.2.0/dbs/
and found that iniNSTRADER.ora is not there instead
i only have this file :
initdw.ora
init.ora
lkJASPERDB
orapwJASPERDB
spfileJASPERDB.ora
Can you pls tell me should i change the init.ora file to initNSTRADER.ora so that the database can find this file.
Apart from this , i would also like to know, is that possible to know which init file the database file is currently using ? If i have more than 2 initABC.ora and initDEF.ora file then how can i check which file the database is currently using ?
Appreciate
JKean
![]() |
![]() |