Skip to Content
0
Mar 03, 2009 at 02:29 PM

Change parameters in Oracle 9.2 - spfile initialization file missing

57 Views

Hi community,

I have to change some parameters in an Oracle database 9.2

On the server there is a single init<sid>.ora which was created from an spfile, but the spife is no more present on the directory. I don't know why this was done, and I can't find any related informations.

Can I change the database parameters directly in this file or I must create the corresponding spfile and start to use it? I know that the second way is the best and the use of spfile is recommended by SAP, but I would like to keep things as they were until now, as I have not enough informations on this system

Thanks for ant suggestion,

Valerio