Consequence of Deleting Initialization file

[janki_mehta]

what happens if init.ora gets deleted when database is running(ORacle 9i)???

[davey23uk]

nothing, it is only read at startup

[jhmartin]

If you are using a SPFILE then it won't even impact startup, although it would be a good idea to keep the plaintext version around for backup / reference.

[reydp]

set pages 0
set feed off
set lines 200
spool initSID.ora
select name, value
from v$parameter
where isdefault = 'FALSE'
/
spool off
--this might be missing