How to change oracle parameter for ECC6 on Oracle10G

[Former Member]

Hi,

We have SAP ECC6 on Oracle10G. I need to change some Oracle parameters recommended by SAP Early Watch Alert. I need to know where I should set these parameters (SPFILE or PFILE). I also need to know the difference between these two files (since I am new to Oracle 10G). What are their advantages? How can I set parameters in SPFIE and PFILE?

Regards,

Joe

[Former Member]

Hi,

spfile and pfile are not the parameter but they are files at OS level.You can change the parameters in these files by using brtools or alter commands. If you use SCOPE = BOTH in alter commands then spfile will also be updated. Remember spfile or spfile<sid> will be read first if they are available. if not pfile<sid> or pfile will be read.

You can create spfile from pfile using oracle commands.

Hope this helps.

Manoj

[Former Member]

Hi Manoj,

I fully agree with you statement. I can also see a pfile (init<sid>.ora) in my system under /Oralce/<SID>/10*/dbs/.

will I be able to modify the parameters in pfile using Vi editer and then create a spfile from pfile and then do a stop/start.

Is this method accepted?

Regards,

Joe

[Former Member]

Hi ,

You can edit pfile using Vi text editor and the SPFILE can be created from pfile.

Regards

Dona

[former_member204746]

fist of all, it is not because that your have initSID.ora file that you are using a PFILE. when using an SPFILE, BRCONNECT create a "dummy" initSID.ora file for its own usage.

So, here's how to find out if PFILE is used or not:

sqlplus "/ as sysdba"

show parameter pfile;

you will get an output similar to:

NAME TYPE VALUE

-

---

-

---

-

---

spfile string

in this case, if SPFILE is empty, that means you are using PFILE and YES, you need to modify initSID.ora file

if SPFILE returns a value, you must alter values with:

ALTER SYSTEM SET OPEN_CURSORS=500 SID='SID' SCOPE='SPFILE';

to convert pfile to spfile (or the other way around): http://www.oracle-base.com/articles/9i/PersistentInitializationParameters.php

[Former Member]

Hi,

When the system was installed you would have an init<sid>.ora file and a spfile.ora

As default when Oracle starts up it will be reading the spfile for startup parameters.

The availability of the spfille has been there since 9i but you had to generate it.

Have a look at SAP note :601157 about spfile

Advantages over the the spfile over the pfile is you can dynamically change some parameters in Oracle.

There is an option in brtools for this.

Mark

[Former Member]

Hi

Following link will provide you with required information you are looking for

1)

http://www.orafaq.com/node/5

2)

http://www.dbasupport.com/oracle/ora10g/spfile01.shtml

Regards

Shan