DB02 ! Alert Monitor ! Profile Parameters ! Compatible value : 11.2.0

[Former Member]

Hi,

My system is :

SAP ECC 6.0 EHP 5 last SP available.

Database Oracle 11G 11.2.0.2.0

In transaction DB02 , Alert Monitor , Profile Parameters, there is a red alert in "compatible "

value : 11.2.0 <> 10.2.0

How can i corret this red alert ?

Also in DB02 , Space Management, Segments , Mosta Allocate extents in any segments, has red alert.

How can i fix it ?

Thanks.

[Former Member]

Ed,

Check in your init.ora file.

[Former Member]

1.2.5. Most allocated extents in any segment

-

---

This is the largest number of allocated extents in a segment.

Important: This alert has only an informative role for locally managed tablespaces (LMTS), where the max extents attribute is set to UNLIMITED and the next extents size is determined automatically by Oracle. As a result, the number of extents is no longer a critical factor for LMTS

But how to set this parameter to UNLIMITED ??

Where and How to do this ??

Thanks.

[ashish_vikas]

Hello,

these checks are performed with settings as per DB17.

http://help.sap.com/saphelp_nw70/helpdata/EN/25/5215e970077e4fb366e5ce25629aac/frameset.htm

In transaction DB02 , Alert Monitor , Profile Parameters, there is a red alert in "compatible "

value : 11.2.0 10.2.0

How can i corret this red alert ?

If your DB is 11.2.0 10.2.0, please update check condition in DB17

Also in DB02 , Space Management, Segments , Mosta Allocate extents in any segments, has red alert.

Note 666061 - FAQ: Database objects, segments and extents

http://help.sap.com/saphelp_nw04s/helpdata/en/25/5215e970077e4fb366e5ce25629aac/content.htm

thanks

ashish

[Former Member]

Check DB26 and DB16 as well, you may get some more hints.

Thanks

[Former Member]

Hi,

In DB17 the is no parameter about compatible.

In DB26 i can`t change the values. Cannot modify parameter COMPATIBLE online

I think i have to set maxextents to unlimited, but how can i do that ?

[JPReyes]

in DB17 the is no parameter about compatible.

In DB17 you should have an entry for it

type: PROF

condition: COMPATIBLE

Level: E

Check condition should be: not equal <> "your version of Oracle "

If you don't have that entry in DB17 simply create one

Regards

Juan

[Former Member]

Hi,

In check condiction is not equal to 11.2.0.2.0 Rate..

When the red alert are going to leave ??

After checkdatabase job ??

Thanks

[ashish_vikas]

yes, correct

[Former Member]

Ok,

First error is OK now.

How about the second :

in DB02 , Space Management, Segments , Mosta Allocate extents in any segments, has red alert.

How can i fix it ?

[Former Member]

Hello,

This might help -

Note 483856 - Description of the alerts for Oracle database monitoring

Thanks