cancel
Showing results for 
Search instead for 
Did you mean: 

initSID.ora and spfile parameters

Former Member
0 Kudos

Hi friends,

I have recieved early watch report from SAP saying that database parameters are missing. They have sent me some parameters. But I am unable where to set these parameters. I have found some parameters in initSID.ora. But it says we could not directly edit in this file(initSID.ora). I came to know we should set in spfile. Can any one explain how to set parameters in spfile.

Waiting for your reply friends......

Regards,

Nageshwar

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

If in the initSID.ora is a warning not to edit it directly, then you are prpbably using the SP (Server Parameter) file.

You should edit the database parameters with BRTOOLS.

Check 'Note 601157 - Oracle9i: Server Parameter File' for more information.

kind regards

Boudewijn

Former Member
0 Kudos

I did not read your message completely right.

You can edit database parameters with Brtools.

But new parameters you have to insert with sqlplus. In the note - 'Setting Events in the SPFILE' is described how to do that.

y

BR

Boudewijn