DBCOCKPIT Installation Script

[Former Member]

Hi All,

I downloaded the scripts and copied them to the server.

Now i started the process. here the is screen output

orasmp> sqlplus "/ as sysdba" @create.sql;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 6 15:01:30 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

Production

With the Partitioning and Data Mining options

Connected.

Warning

~~~~~~~

Running CreateCompressTables.sql drop all GVD_* and ORA_* Tables

and recreate the tables with compression mode "enabled".

You may wish to export the data before continuing.

About to drop and recreate GVD_* and ORA_* Tables

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you would like to continue press <enter> else type no:

Please selecet the sap schema

USERNAME

-

---

OPS$SR3ADM

OPS$SMPADM

OPS$ORASMP

OPS$SAPSERVICESMP

SYS

SYSTEM

SAPSR3

SAPSR3DB

OUTLN

TSMSYS

DIP

DBSNMP

Enter value for sap_schema:

Now i am bit confused, Which sap_schema i am suppose to specify?

Sap Note : 706927 does not mention about this part.

Thanks

[markus_doehr2 · Accepted solution]

>

> Hi All,

> I downloaded the scripts and copied them to the server.

> Now i started the process. here the is screen output

>

> orasmp> sqlplus "/ as sysdba" @create.sql;

>

> SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 6 15:01:30 2008

Your database version is NOT supported!!

Upgrade to 10.2.0.2 and the latest interim patches (40+ of them).

Markus

[Former Member · Accepted solution]

Thanks Markus,

Is this mentioned anywhere in SAP Notes?

[markus_doehr2 · Accepted solution]

See note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0

<quote>

You must install at least Oracle patch set 10.2.0.2 if you want to use Oracle Release 10.2 in the SAP environment. In addition, apply the patches specified in this note. All patches currently required are available for 10.2.0.2. New patches will also be made available for this release.

<quote>

Markus

[Former Member · Accepted solution]

You may want to refer note 871096

Hope this helps

Cheers

Senthil

Edited by: Senthil Murugan Muthuvelu on Mar 6, 2008 9:29 PM