Automatic parameter check in Oracle

[Former Member]

Hello All,

I have installed Solution Manager on Oracle 11g database. While performing the post installation steps for Oracle,i came across the automated parameter check. So i referred SAP note 1171650.

I downloaded the script attached in this note and when i uploaded it via DBACOCKPIT, it is throwing an error as,

"ORACLE-00971 INVALID CHARACTER"

Can anyone suggest?

Thank You,

Regards,

Hasan

[former_member213250]

Hi there

This might be because there might be some change in code which you are executing to that of original document.

The easy way to perform automated check will using a SAP transaction

use /NSE38

run program RSORADJV --> execute

in next screen copy paste the text as it is from the attachment of the note. (Make sure you use right DB version attachment.)

Execute

it will take a while to execute.

It should give the output.

These attachments are tested to perfection so shouldn't give errors while execution.

Hope it helps

Cheers

Regards

Venkat

[Former Member]

Hello Venkat,

I just opened that script directly in browser and pasted in the SQL Command editor, it works.

The error occurs only if i download to my PC and then upload it.

But as per note 1171650, " For OLAP systems, you need to replace the string '<OLAP System? [n]>' with 'y'."

Since it is a solution manager system i have considered it to be OLAP system...AM i correct?

Regards,

Hasan

[Former Member]

Hello,

Solution Manager is an OLTP system as far as I understand. Several customers activate BI client in solution manager itself to use diagnostics or other functionality but that doesn't make the Solution manager to be an OLAP system.

Thanks

[Former Member]

Hello,

But Note 1171650 says,

"OLTP system: Systems with mainly non-BW functions (this also includes, for example, Bank Analyzer systems and systems with a pure Java stack)"

But solution manager system is a dual stack system.

Please clarify,

Thanks,

Regards,

Hasan

[Former Member]

For Dual stack, Note says - 'depending on the degree to which you use BW functions'

I don't think that we are going to use 'Solution Manager' to include that much degree of BW functionality that at last we call it a 'BW' system. We activate a BI client just for some of the functionality.

It is the similar scenario as in we have a customer where we use BW in ECC6 system itself by dedicating a separate BI client there. But we keep Oracle parameters to OLTP as ECC 6 system is an OLTP system.

I would say, in my opinion we should set oracle parameter for Solution manager w.r.t OLTP settings, that's what we ourselves do in our many customer landscapes.

Thanks

[former_member182307]

Hello,

Did you download the file attached to the note ( right click and save as ) or did you open the file through your browser and copy/paste from your browser into a new file ?

You need to right click / save the file, then upload the file in the dba_cockpit.

HTH

Steve.