DB

SAP

Ver 1.0

DB Oracle

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

DBACOCKPIT Solman=MSS, =OracleNote

Oracle:1261329, MSS:1027512, SDB:1028751DB2:1027452, DB4:1028173, DB6:1027336 and 200164,

Oracle dbsl(lib_dbsl_<patchlevel>-<nnnnnnnn>.sar) temporary

patches.mf, dboraslib.dll,dborasllib.pdb<drive>:\usr\sap\<SAPSID>\SYS\exe\run

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

SMP “Downloads” -> “Database Patches OCL<nnnn>.SAR OracleClient

Windows <drive>:\oracle\client\instantclientUnix /oracle/client/10x_<64|32>/instantclient_<version>

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

Windows Unix <sid>adm

Windows Path : <drive>:\oracle\client\instantclientTNS_ADMIN : <drive>:\usr\sap\<SAPSID>\SYS\profile\oracle

Unix LIBPATH(AIX), LD_LIBRARY_PATH(Linux, Solaris and HP-UX) :/oracle/client/10x_<64|32>/instantclient_<version>

TNS_ADMIN /usr/sap/<SAPSID>/SYS/profile/oracle

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

usr/sap/<SAPSID>/SYS/profile/oracle sqlnet.ora, protocol.ora, tnsnames.ora 3DB

sqlnet.ora:NAMES. DIRECTORY_PATH = (TNSNAMES)

protocol.ora:

tnsnames.ora:<SID> =

(DESCRIPTION =(SDU = 32768)(ADDRESS_LIST =

(ADDRESS =(COMMUNITY = TCP)(PROTOCOL = TCP)(HOST = <database_host>)(PORT = <port>)

))(CONNECT_DATA =

(SID = <DB_ID>))

)

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

Trcd:DBACOCKPIT

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

Trcd:DBACOCKPIT

DB TNS Name TNSSID

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

Trcd:SE37

Trcd:SE37 ADBC_TEST_CONNECTIONDBACOCKPIT PI DB

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (Oracle)

Trcd:DBACOCKPIT

Trcd:DBACOCKPIT DBDBACOCKPIT

DB SQL Server

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

DBACOCKPIT Solman=MSS, =MSS

Sysadmin

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

http://<solman_host>:<port>/webdynpro/dispatcher/sap.com/tc~smd~navigation/StandaloneApp?APP_ID=ADMIN_RB_DBCON_SETUP

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

DB Next

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

Connectivity test Green

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

Trcd:DBACOCKPITDBACOCKPITDB Connection SID Edit

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

Trcd:DBACOCKPITUser Name sysadmin

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

Trcd:DBACOCKPITDBACOCKPIT

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)Trcd:DBACOCKPIT

SQL Script Execution Configuration

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)Trcd:DBACOCKPIT

Functional level Create/repair schema Execute scipt(s)

Functional Schema- Minimum set : static SQL Server Object- Standard set : Minimu + SAP DB collector- ABAP set : ABAP Schema

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

http://<solman_host>:<port>/webdynpro/dispatcher/sap.com/tc~smd~navigation/StandaloneApp?APP_ID=ADMIN_RB_DBCON_SETUP

Green

SAP AG 2009, Solution Manager Diagnostics Setup

- DBA (SQL Server)

Trcd:DBACOCKPIT

Trcd:DBACOCKPIT DBDBACOCKPIT

EWA SMDFastest Growing Table, Database Size History, Table Size History

SAP AG 2009, Solution Manager Diagnostics Setup

Copyright 2009 SAP AGAll rights reserved

SAP AG

SAP R/3 xApps xApp SAP NetWeaver Duet PartnerEdge ByDesign SAP Business ByDesign SAPSAP AG

SAP

SAP SAPSAP

SAP SAP

SAP

SAP

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The informationcontained herein may be changed without prior notice.Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.SAP, R/3, xApps, xApp, SAP NetWeaver, Duet, SAP Business ByDesign, ByDesign, PartnerEdge and other SAP products and services mentioned herein aswell as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All otherproduct and service names mentioned and associated logos displayed are the trademarks of their respective companies. Data contained in this documentserves informational purposes only. National product specifications may vary.The information in this document is proprietary to SAP. This document is a preliminary version and not subject to your license agreement or any otheragreement with SAP. This document contains only intended strategies, developments, and functionalities of the SAP® product and is not intended to bebinding upon SAP to any particular course of business, product strategy, and/or development. SAP assumes no responsibility for errors or omissions in thisdocument. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, or other items contained within this material. Thisdocument is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability, fitnessfor a particular purpose, or non-infringement.SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the useof these materials. This limitation shall not apply in cases of intent or gross negligence.The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the useof hot links contained in these materials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-partyWeb pages