cancel
Showing results for 
Search instead for 
Did you mean: 

how to Change Database parameters as suggested by EWA report

Former Member
0 Kudos

Dear Experts,

As per EWA report , i have been asked to change several DB parameters as per note 0124361 . Should i go aghead and change the parameters ? What is the procedure of chaging those parameters? what is the real process that should be followed ? Please revert.Points guaranteed.

Regards,

Somya

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

First compare your active DB parameters with the parameters mentioned SAP note 124361.

Change those parameter which are mentioned in your EWA report. You can write all parameters in a batchfile & run it from SQL.

Dont forget to take backup of your old parameters files ( Pfile & spfile).

Best practise is 1st change the DB parameter in DEV & QA, test it for few days & once find ok, chnange all in prod.

Hope this helps

Thanks

Sushil

Former Member
0 Kudos

Run "brspace -f dbparam"

Select option 1 "Change parameter value" and change the parameters. After changing select option 3 to create a new init.ora.

If you change parameters that have the scope "spfile" oracle requires a restart. If you only change parameters with scope "both" you don't need a restart of oracle. This changes are affected on the fly.

To restart oracle:

connect / as sysdba

SQL> shutdown

SQL> startup

You don't need to stop SAP if you only change oracle parameters. SAP reconnects automatically if the database is up.

former_member204746
Active Contributor
0 Kudos

simply read the note and apply changes. then, adapt DB17 accordingly.

if you are with Oracle 10g, you must use SAP note 830576 instead.

if initSID.ora file does not have parameters starting with a star * , then edit this file directly and restart your SAP and Oracle instance.

Former Member
0 Kudos
Former Member
0 Kudos

Hi,

I would request if somebody could send a word docuemnt for the same or good detailed steps for the procedure.

Regards,

Somya

Former Member
0 Kudos

hi

I am explaining here for AIX OS

Changing Oracle Parameter

Steps

1. Logon to database server in which you want to change parameter and shutdown the application and database if running.

􀂾su - <sid>adm

􀂾stopsap

􀂾lsnrctl stop

􀂾saposcol u2013k

􀂾exit

2. After shutting database first take the backup of existing init<SID>.ora and spfile<SID>.ora file as below:

􀂾su u2013 ora<sid>

􀂾cd /oracle/<SID>/102_xx/dbs

􀂾cp u2013rp init<SID>.ora init<SID>.ora.<date>

􀂾 cp u2013rp spfile<SID>.ora spfile<SID>.ora.<date>

􀂾exit

3. Create pfile from spfile as below:

􀂾su u2013 ora<sid>

􀂾 sqlplus /nolog

􀂾 SQL> connect / as sysdba

􀂾 SQL> create pfile from spfile;

This will create new pfile(init<SID>.ora) file in $ORACLE_HOME/dbs directory.

4. Now you can change the required oracle database parameters in init<SID>.ora file using file editor at OS level and save the file with modifications.Kindly follow syntax correctly to make changes.

5. Next is to create spfile from pfile:

􀂾su u2013 ora<sid>

􀂾 sqlplus /nolog

􀂾 SQL> connect / as sysdba

􀂾 SQL> create spfile from pfile;

This will create new spfile(spfile<SID>.ora) file in $ORACLE_HOME/dbs directory.

6. Now to check parameter changes are correct we have start database in nomount mode.

􀂾su u2013 ora<sid>

􀂾 sqlplus /nolog

􀂾 SQL> connect / as sysdba

􀂾 SQL> startup nomount

If the database startup in nomount mode is OK then parameter changes are successfully completed.

7. After this shutdown the database

􀂾su u2013 ora<sid>

􀂾 sqlplus /nolog

􀂾 SQL> connect / as sysdba

􀂾 SQL> shutdown

Now you are ready to start database and application as per requirement.

Regards,

Nitin Salunkhe

markus_doehr2
Active Contributor
0 Kudos

Ask your DBA - or attend a database course (no offense).

Parameters listed in notes are based on "best knowledge" values. They may be right for your system but they also can make things worse.

To judge whether the changes are good or not it's crucial to understand the parameters and what they affect. If in doubt, create an OSS call.

Markus