Oracle parameter change.

[ganesh_borase2]

Hello everybody,

I had install the SAP on windows x64 and oracle

I want to change some parameter in oracle.

when I chech the directort c:\oracle\IDS\102\database,

I found the files :

initIDS.sap, initIDS.ora and SPFILEIDS.ORA

when I execute the SQL

SQL> show parameters spfile;

NAME TYPE VALUE

-

---

-

---

-

---

spfile string C:\ORACLE\IDS\102\DATABASE\SPFILEIDS.ORA

SQL> select count(1) from v$spparameter where isspecified = 'TRUE';

COUNT(1)

-

---

46

Means initial parameter's spfile is used here is it right?

So please suggest me steps , How to change the initialization parameter like LOG_BUFFER, MAX_DUMP_FILE_SIZE.

Thanks

Ganesh

[former_member524429]

Hi,

Use BR*Tools to change/reset any DB related parameters.

Refer this useful link [Altering Database Parameters with BR*Tools|http://help.sap.com/saphelp_nw04/helpdata/en/f1/0d01b42a4aa84fbe2be415d23bf023/content.htm] to get step by step details.

You will have to login as ora<dbsid> user and run brtools program.

Regards,

Bhavik G. Shroff

[Former Member]

you can also use command:

alter system set <parameter> <value> scope=both

[nikolay_kumanov]

Have a look at [Note 601157 - Oracle9i: Server Parameter File|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=601157] Basically, you have two options:

- use the alter system set .... command

- create a pfile from the spfile, move the spfile and continue in the old-fashioned way - not recommended, but those of us that prefer the good old vi editor use it.