cancel
Showing results for 
Search instead for 
Did you mean: 

Modifying initSID.ora/spfile

former_member759680
Contributor
0 Kudos

Hello,

SAP system details - ECC 6.0. AIX+Oracle.

While applying OSS note - 1227227, I came across the statement -

Set the following event in the init<SID>.ora / spfile:

event='10091 trace name context forever, level 1'

I have a couple of queries -

1. Do I need to set the event in initSID.ora or spfile or both

2. Can I change spfile while the DB and SAP system are up and running?

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Gautam,

Just to add you should not change spfile manually.

Below links may help you.

SAP Note 601157 - Oracle9i: Server Parameter File

http://help.sap.com/erp2005_ehp_04/helpdata/DE/f1/0d01b42a4aa84fbe2be415d23bf023/frameset.htm

Hope this helps

Thanks

Sushil

JPReyes
Active Contributor
0 Kudos

Do I need to set the event in initSID.ora or spfile or both

Do it on both, but basically Oracle will pick up the spfile first, in the case spfile do no exist it will pick up the initSID.ora (pfile), but for consistency you should update both. Also you can update the pfile and create a new spfile vis sql commands.

Can I change spfile while the DB and SAP system are up and running?

You can indeed, it just won't make any effect until the DB is restarted.

Regards

Juan

former_member759680
Contributor
0 Kudos

Thanks Juan,

I got just 1 follow-up question -

I found these 2 methods of updating pfile and spfile -

1. sql command:

ALTER SYSTEM SET event='10091 trace name context forever, level 1'

SCOPE=BOTH;

2. edit initSID.ora using vi editor and then SQL command: create spfile from pfile

Which one should I use?

Thanks in advance.

Former Member
0 Kudos

Gautam,

Simplest method is use BR*Tools. It update it in both pfile & spfile. Check below link for details.

http://help.sap.com/erp2005_ehp_04/helpdata/DE/f1/0d01b42a4aa84fbe2be415d23bf023/frameset.htm

Thanks

Sushil

JPReyes
Active Contributor
0 Kudos

I usually modify the pfile and the use SQL command: create spfile from pfile.

But as said before you can use brtools.

Regards

Juan

former_member759680
Contributor
0 Kudos

Ok, one more question before I add this parameter

How do I delete this parameter from spfile and initSID.ora ?

.... you know, just in case it doesnt work.

Edited by: Gautam Poddar on Jul 1, 2009 4:06 PM

JPReyes
Active Contributor
0 Kudos

Exactly the same way... remove from initSID.ora and recreate the spfile, then restart the DB.

Regards

Juan

Former Member
0 Kudos

This feature is available in Oracle 9 and Oracle 10. To remove a parameter from spfile and

reset it to default value run the following command:

alter system reset "_db_block_lru_latches" scope=spfile sid='*';

Thanks

Rishi Abrol

former_member759680
Contributor
0 Kudos

I am getting this error -

SQL> alter system set event='10091 trace name context forever, level 1' scope=both;

alter system set event='10091 trace name context forever, level 1' scope=both

*

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

Kindly advise.

Former Member
0 Kudos

Hi,

Please use Brtools to change the parameter.

To viewall Oracle parameters, start BRTOOLS or BRGUI and choose Instance managemen -->Show database parameters. The column Modif. shows whether the parameter can be changed dynamically or not.

To modify an Oracle parameter, start BRTOOLS or BRGUI and choose Instance management --> Alter database parameters. If you already know the parameter to change, enter it in Database parameter (parameter) and continue. If you want to

select the parameter from a list, do not make any changes. Choose c to continue, select Alter database parameter, and enter the position number of the parameter (not the name) you want to change from the list of parameters.

Thnaks

Rishi Abrol