on 06-30-2009 12:05 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.