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