Solved: New db parameters to be update

Dear all,

I have upgrade DB patch from 10.2.0.2 to 10.2.0.4 , and then i have run Automatic DB parameter script (parameter_check_102) from ST04 .

Now my question is Shall i implement new db parameter as per output of automaic db parameter script.

or any precaution i have to do before new db parameter upgrade.

Kindly advise

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Dear All,

AIX , ECC6.0, Oracle 10.2.0.4.

I have upgraded only 0racle patch set (10.2.0.4),

Shall i implement new db parameter as per output of automaic db parameter script. or First i should install SAP_102045_201009_AIX after that i have implement new db parameter as per output of automaic db parameter .

Kindly advise

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Once you upgrade the patch set you must apply the opatches first.

Please read the following Note 1137346 - Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4

Every Opatch set comes with a README file, you need to go through it to determine the course of action.

Regards,

Siddhesh

Dear all,

I have checked Current Opatch version is

SAPDEVQA:oraird 3> cd /oracle/IRD/102_64/OPatch

SAPDEVQA:oraird 4> pwd

/oracle/IRD/102_64/OPatch

SAPDEVQA:oraird 5> opatch version

Invoking OPatch 10.2.0.4.3

OPatch Version: 10.2.0.4.3

OPatch succeeded.

SAPDEVQA:oraird 6>

1, first i should install Opatch (OPatch_10205_Generic_v0.zip on Oracle_home).

2, secondly i Sholud install MOpatch (mopatch-2_1_4.zip in Oracle_home).

3, Finally i should install SAP_102045_201009_AIX.zip .

The above procedure is correct ?

Kindly advise ,

Hello Sathees,

If you read the note I gave in the previous post, it clearly states the new patching strategy followed by SAP as of 10th May 2010. As of that date all Opatches are being delivered in a bunch as SBP or SAP Bundle Patches.

Here is some text from the SAP Note

Change to the patch release strategy

This affects only UNIX and Linux platforms. Windows platforms are not affected.

As of the patch day (May 10th, 2010), Oracle database patches for UNIX platforms are provided only as SAP Bundle Patches (SBP).

An SBP contains the following:

The current Patch Set Update (PSU).
SAP-specific single patches and merge patches that are required, but not contained in the PSU (in particular, the current SAP-specific optimizer merge patch).
README.html: SBP README and installation instructions
bugs_fixed.html: SBP patch history

SBPs are cumulative; that is, the next SBP contains all patches of its predecessor plus the newly-added patches.

For the required prerequisites (for example, required MOPatch and OPatch versions) and other information, see the current SBP README.

Advantages of SBPs:

Integration of PSUs with SAP-specific Oracle patches.
Simple installation using MOPatch support.
The most recent two SBP versions (that is the current version and the predecessor version) are provided on SAP Service Marketplace; this is the same as for Windows patch collections.

Consequences:

For Oracle Version 10.2.0.4.0, as of the patch day mentioned above, no new versions of the CBO merge patch will be provided.
Due to SBPs, the installation of CPUs is obsolete. As a result, CPUs are no longer provided.

A CPU is always contained in the relevant PSU and, as a result, also in the relevant SBP. You cannot install a CPU and an SBP at the same time.

The bottomline to me is: SBPs are cumulative patches.. so I do not think there is any need to implement indiviual patches for Opatch or MoPatch as SBP should have it within. However as always the guideline is, please read the note and implement as per the README file attached in SBP.

Regards,

Siddhesh

Dear all ,

Pls check the output of

SAPDEVQA:oraird 6> ./opatch lsinventory

Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3

Oracle Home : /oracle/IRD/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.4.3

OUI version : 10.2.0.4.0

OUI location : /oracle/IRD/102_64/oui

Log file location : /oracle/IRD/102_64/cfgtoollogs/opatch/opatch2010-09-20_18-5

-56PM.log

Lsinventory Output file location : /oracle/IRD/102_64/cfgtoollogs/opatch/lsinv/

sinventory2010-09-20_18-51-56PM.txt

Installed Top-level Products (3):

Oracle Database 10g 10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0

Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0

There are 3 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

OPatch succeeded.

SAPDEVQA:oraird 7>

The above result is shows There are no Interim patches installed in this Oracle Home.

let me know which patch exactly i should install ...

satheesh, you already got your answer:

Read Note 1137346 - Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4

it contains all the info you need. Please read and test this. it's the only way to learn.

Dear all,

I have applied only latest patch set 10.2.0.4 . now i need to apply Interim patches after i need to implement new db papameter .

now i need clarity on Oracle Interim patches .

As per SAP note : 1137346 , I have downloaded SAP_102045_201009_AIX.zip,OPatch_10205_Generic_v0.zip ,mopatch-2_1_4.zip.

As per README_201009_AIX.htm : I have Updated latest OPatch and MOPatch on Oracle_home (oracle/IRD/102_64)on DEV.

Pls check the below OPatch version .

SAPDEVQA:oraird 6> ./opatch lsinventory

========================================================

GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY

========================================================

Invoking OPatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0

Oracle Home : /oracle/IRD/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.5.0

OUI version : 10.2.0.4.0

OUI location : /oracle/IRD/102_64/oui

Log file location : /oracle/IRD/102_64/cfgtoollogs/opatch/opatch2010-09-22_11-08

-27AM.log

Patch history

file: /oracle/IRD/102_64/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file

location : /oracle/IRD/102_64/cfgtoollogs/opatch/lsinv/l

sinventory2010-09-22_11-08-27AM.txt

Installed Top-level Products (3):

Oracle Database 10g

10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 1

10.2.0.2.0

Oracle Database 10g Release 2 Patch Set 3

10.2.0.4.0

There are 3 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

OPatch succeeded.

SAPDEVQA:oraird 7>

Now my question is I have use OPatch or MOpatch for Installing SAP Bundle Patch .

I have checked SAP Note : 1027012 .

the above note is mentioned

1. Important Terms and Notations

Patch Base Directory.

Patch Source Path.

Patch Basename.

Need some clarity on the above points.

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh \

-v -s patch-source-path

let me know the above steps are correct?

Regards

Sathies

Hi,

From the old posts of this thread, you have already got most of the answers from friends.

Patch Base Directory. (its working directory for MOpatch.. the readme files with documentation mode (optional activity in applying SBP on oracle using mopatch) are generated in this directory from where u have run $ORACLE_HOME/MOPatch/mopatch.sh -v -d -s patch-source-path

Patch Source Path.

Its a path pointing to SBP zip file location which MOpatch will consider for patching.

Patch Basename.

The patch basename consists of the patch file name and, if the patch file contains more than one patch, of an additional molecule ID. (refer SAP Note 1027012)

The detailed information about above terms are well described in that SAP Note 1027012. Read them slowly & carefully. Also you can get all these information from last mopatch run log file. Verify last mopatch run log file located at $ORACLE_HOME/cfgtoollogs/mopatch

e,g. $ORACLE_HOME/cfgtoollogs/mopatch/mopatch-2010_09_10-15-34-23.log

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -s patch-source-path

let me know the above steps are correct?

Yes its correct command syntax.

The simple flow of applying SAP Bundle Patch using Mopatch would be:

1. Get latest SBP, SBP's Readme File, OPatch, Mopatch from SMP.

2. Take backup of existing $ORACLE_HOME & Oracle Database (Offline Backup recommended)

3. Update OPatch , MOpatch

4. Stop SAP system, Stop Oracle Listner processes, any other processes which still uses $ORACLE_HOME

5. Refer Readme file of SBP which u are going to apply to perform all required pre-activities.

6. Sufficient Space around 7 GB should be there in $ORACLE_HOME

7. Go to MOpatch directory & Apply SBP using mopatch utility with the above mentioned command.

8. Refer Readme file of SBP to perfrom Post-Apply actions for each patch.(must be performed)

Regards,

Bhavik G. Shroff

Answers (1)

Hi,

As you have updated the patch of the same DB version (oracle 10g), u can go ahead and implement the DB parameters as per the * SAP Note 830576 - Parameter recommendations for Oracle 10g*.

Regards,

Varadharajan M

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Varathu ,

How can i update thebelow parameter ,

fixcontrol (5705630) add with value "5705630:ON"

fixcontrol (5765456) add with value "5765456:3"

Kindly suggest

Hello,

alter system set "_fix_control"='5705630:ON', '5765456:3' scope=spfile;

To use the above command you should be using SPFILE.

You should restart DB for the parameter to take effect.

Regards,

Yoganand.V

Edited by: Yoganand Vedagiri on Sep 16, 2010 11:16 AM

Dear Yoga,

Thanks for your mail .

How can i update the below db parameters.

event (10027) add with value "10027 trace name context forever, level 1"

event (10028) add with value "10028 trace name context forever, level 1"

event (10411) add with value "10411 trace name context forever, level 1"

event (10629) add with value "10629 trace name context forever, level 32"

event (14532) add with value "14532 trace name context forever, level 1"

The below systax is correct .

ALTER SYSTEM SET EVENT='10027 trace name context forever, level 1','10028 trace name context forever, level 1',.......SCOPE=SPFILE;

Kindly advise

Hello,

Yes, please check the below format also:

alter system set event='10027 trace name context forever, level 1',

'10028 trace name context forever, level 1',

'10142 trace name context forever, level 1', scope=spfile;

You can just save all the required parameters with recommended values in a text file with extension as .sql, then place the file under any of the directory like /oracle/<SID>/.sql and then login into sqlplus as sysdba and the run it as @.sql.

For example if you have a file under /oracle/<SID>/parameter10g.sql then go to this path and login into DB as said above and run @parameter10g.sql

Regards,

Yoganand.V

Dear Yoga,

Any precaution i have to do before updating the new Oracle db parameter ex : like backup ...etc.

or i can directly update the new DB parameter

Kindly suggest ,

the script you ran believes that you are using the latest patch set. It is not enough to just install 10.2.0.4, you must also install patch with OPATCH. Have you completed that step?

If so, you can rely on the results of the scripts, BUT, you should read SAP note 830576

Dear

I have upgraded only patch set 10.2.0.4 .

Kindly suggest

Dear all,

SQL> show parameter parallel_execution_message_size

NAME TYPE VALUE

parallel_execution_message_size integer 2148

now i will plan to update parallel_execution_message_size=add with value "16384"

Let me know the above value will be take from Free RAM SPACE ?

Kindly advise

Dear Yoga ,

I got error when i execute the below command .

SQL> show parameter event

NAME TYPE VALUE

event string 10191 trace name context fore

er, level 1

SQL> ALTER SYSTEM SET

2 EVENT='10753 trace name context forever, level 2',

3 '38087 trace name context forever, level 1',

4 '10183 trace name context forever, level 1',

5 '10027 trace name context forever, level 1',

6 '10028 trace name context forever, level 1',

7 '10411 trace name context forever, level 1',

8 '10629 trace name context forever, level 32',

9 '14532 trace name context forever, level 1',

10 '10091 trace name context forever, level 1',

11 '10142 trace name context forever, level 1',

12 '38068 trace name context forever, level 100',

13 '38085 trace name context forever, level 1',

14 '44951 trace name context forever, level 1024',

15 SCOPE=SPFILE;

EVENT='10753 trace name context forever, level 2',

ERROR at line 2:

ORA-02095: specified initialization parameter cannot be modified

and i have tried below steps also , i got error .

SQL> alter system set event='10753 trace name context forever, level 2','38087 t

race name context forever, level 1','10183 trace name context forever, level 1',

'10027 trace name context forever, level 1','10028 trace name context forever, l

evel 1','10411 trace name context forever, level 1','10629 trace name context fo

rever, level 32','14532 trace name context forever, level 1','10091 trace name c

ontext forever, level 1','10142 trace name context forever, level 1','38068 trac

e name context forever, level 100','38085 trace name context forever, level 1','

44951 trace name context forever, level 1024',scope=spfile;

alter system set event='10753 trace name context forever, level 2','38087 trace

name context forever, level 1','10183 trace name context forever, level 1','1002

7 trace name context forever, level 1','10028 trace name context forever, level

1','10411 trace name context forever, level 1','10629 trace name context forever

, level 32','14532 trace name context forever, level 1','10091 trace name contex

t forever, level 1','10142 trace name context forever, level 1','38068 trace nam

e context forever, level 100','38085 trace name context forever, level 1','44951

trace name context forever, level 1024',scope=spfile

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

SQL>

Kindly suggest

satheesh, you must also install post-fixes on top of ORacle 10.2.0.4. These are important. what is your OS?

try this command, you had one comma too many before the word scope:

alter system set event='10753 trace name context forever, level 2','38087 t

race name context forever, level 1','10183 trace name context forever, level 1',

'10027 trace name context forever, level 1','10028 trace name context forever, l

evel 1','10411 trace name context forever, level 1','10629 trace name context fo

rever, level 32','14532 trace name context forever, level 1','10091 trace name c

ontext forever, level 1','10142 trace name context forever, level 1','38068 trac

e name context forever, level 100','38085 trace name context forever, level 1','

44951 trace name context forever, level 1024' scope=spfile;

Hello,

Below format will work,

alter system set event='10753 trace name context forever, level 2',

'38087 trace name context forever, level 1',

'10183 trace name context forever, level 1',

'10027 trace name context forever, level 1',

'10028 trace name context forever, level 1',

'10411 trace name context forever, level 1',

'10629 trace name context forever, level 32',

'14532 trace name context forever, level 1',

'10091 trace name context forever, level 1',

'10142 trace name context forever, level 1',

'38068 trace name context forever, level 100',

'38085 trace name context forever, level 1',

'44951 trace name context forever, level 1024' scope=spfile;

You had extra comma before scope=spfile.

Regards,

Yoganand.V

Hello,

After applying 10.2.0.4, we applied the following:

Interim patches (12) :

Patch 7375644 Bugs fixed: 7375644, 7150470

Patch 7375617 Bugs fixed: 7375617

Patch 7375613 Bugs fixed: 7375613

Patch 7375611 Bugs fixed: 7375611

Patch 7197583 Bugs fixed: 7197583

Patch 7155254 Bugs fixed: 7155254

Patch 7155253 Bugs fixed: 7155253

Patch 7155252 Bugs fixed: 7155252

Patch 7155251 Bugs fixed: 7155251

Patch 7155250 Bugs fixed: 7155250

Patch 7155249 Bugs fixed: 7155249

Patch 7155248 Bugs fixed: 7155248

These are part of the CPU or Critical Patch Upgrade. You need to evaluate and apply the relevant OPatches patches that are applicable to your environment.

Regards,

Siddhesh

Dear Eric ,

OS is AIX . how can i install post-fixes.

Kindly advise.

Dear Siddhesh,

where should i get below Interim patch(12).

We are using AIX

Kindly advise

Hello Sathees,

The interim patches I listed before were part of the CPU pack which was SAP's strategy before, as of now this strategy has changed, and you get SBPs, so you need to follow the SBP strategy now.

You are already half way through with patched Opatch and MOPATCH.

PS: I think you have spent enough time discussing over the same information again and again I suggest that you take a full Oracle offline backup of your database, also take a full filesystem backkup and get on with your patching and see how it goes, cause its anyways your QA system, if you see any issues you can raise an OSS call to have it fixed.

Regards,

Siddhesh

Dear Eric/Team,

Successfully installed SAP_102045_201009_AIX.zip and As per README_201009_AIX.htm, i have adjust our fixcontrol and event .

I need to change the below parameter value ..

btree_bitmap_plans

optimizer_index_cost_adj

star_transformation_enabled

optimizerbetter_inlist_costing

optimizermjc_enabled

sortelimination_cost_ratio

parallel_execution_message_size

query_rewrite_enabled

parallel_threads_per_cpu

max_dump_file_size

Shall i change the above parameter values or need to install any patch for the same ?

Kindly suggest ,

again, I urge you to read SPA note 830576 and set parameters as per that note.

Ask a Question

Top Q&A Solution Author

User

Count

New db parameters to be update

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Re: BusinessObjects 4.2 SP9 to 4.3 latest version

Re: How to add SAP Datasphere as a datastore in Cl...

How to add SAP Datasphere as a datastore in Cloud ...

Re: CAP odata-v2-adapter: batch request is not sup...

Re: CAP odata-v2-adapter: batch request is not sup...