Scribd Logo
Upload

Welcome to Scribd!

  • 299 views

    DBACOCKPIT Setup

    Uploaded by

    Deepak Sharma
    This document provides instructions for setting up the DBACockpit tool in SAP Solution Manager. It includes downloading required database libraries, configuring the Oracle client, setting environment variables, testing the database connection, and importing the monitored systems from the SLD into DBACockpit. The author is an SAP Basis administrator and Solution Manager consultant with many years of experience implementing SAP landscapes.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    DBACOCKPIT Setup

    Uploaded by

    Deepak Sharma
    299 views10 pages
    This document provides instructions for setting up the DBACockpit tool in SAP Solution Manager. It includes downloading required database libraries, configuring the Oracle client, setting environment variables, testing the database connection, and importing the monitored systems from the SLD into DBACockpit. The author is an SAP Basis administrator and Solution Manager consultant with many years of experience implementing SAP landscapes.

    Original Description:

    For Solman DBACOCKPIT SETUP

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for setting up the DBACockpit tool in SAP Solution Manager. It includes downloading required database libraries, configuring the Oracle client, setting environment variables, testing the database connection, and importing the monitored systems from the SLD into DBACockpit. The author is an SAP Basis administrator and Solution Manager consultant with many years of experience implementing SAP landscapes.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    299 views10 pages

    DBACOCKPIT Setup

    Uploaded by

    Deepak Sharma
    This document provides instructions for setting up the DBACockpit tool in SAP Solution Manager. It includes downloading required database libraries, configuring the Oracle client, setting environment variables, testing the database connection, and importing the monitored systems from the SLD into DBACockpit. The author is an SAP Basis administrator and Solution Manager consultant with many years of experience implementing SAP landscapes.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 10

    SAP Solution Manager

    Installation Guide
    Setup DBACockpit

    http://www.linkedin.com/in/solutionmanager
    Wenceslao Lacaze

    Sap Solution Manager Dbacockpit Setup

    Table of Contents
    Versioning ..............................................................................................................................................................................3
    Author Bio ..............................................................................................................................................................................3
    Landscape :.............................................................................................................................................................................4
    Database Library ........................................................................................................................................................4
    Download the oracle client.....................................................................................................................................5
    Configure the parameter for the database .......................................................................................................5
    Install the Oracle Client in X:\oracle\client10................................................................................................6
    Environment Variable ..............................................................................................................................................6
    Test the Connection at OS Level...........................................................................................................................7
    Import the system in DBACOCKPIT from SLD................................................................................................8

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 2 of 10

    Sap Solution Manager Dbacockpit Setup

    Versioning
    Version
    1.0
    2.0

    Change
    Original
    Webpage Link.

    Date
    10/06/2008
    23/06/2008

    Author Bio
    My name is Wenceslao Lacaze and Ive been working as a SAP basis
    Administrator and Solution Manager Consultant for the last 8 years.
    Im a Techno-Functional SAP Solution Manager Subject Matter Expert (SME), I
    Design, Build and Implement the product using Run Sap Methodology.
    I have developed a very extended experience with medium and large scaled
    SAP installations in several (multi)national environments.
    I am based in Argentina, but work all around the World.
    I work directly for clients or via an agency.
    I do speak Spanish, Italian and English fluently.
    You can contact me at:
    Email: [email protected]
    http://www.linkedin.com/in/solutionmanager
    You can found more papers at :
    http://wlacaze.googlepages.com/home

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 3 of 10

    Sap Solution Manager Dbacockpit Setup

    Landscape :
    Sap solution Manager 7.0 over W2003/MAXDB
    Satellite ERP2005 over AIX/ORACLE
    Satellite2 ERP2005 over W2003/MSSQL

    Database Library
    Install the Database Librarys for acess the remote Database

    Remember to download the Package for the version/Platform of your solution Manager.
    SAP KERNEL 7.00 64-BIT UNICODE:
    MS SQL SERVER ->
    Windows Server on x64 64bit:
    lib_dbsl_158-20001361.sar Database Library
    ORACLE -> Windows Server on x64 64bit:|
    lib_dbsl_158-20001356.sar
    Open the files with sapcar xvf (db<db>slib.dll and db<db>slib.pdb in
    H:\usr\sap\???\DVEBMGS00\exe

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 4 of 10

    Sap Solution Manager Dbacockpit Setup

    Download the oracle client

    Configure the parameter for the database


    In x:\usr\sap\SID\SYS\profile\oracle
    Sqlnet.ora
    ################################################
    # Filename......: sqlnet.ora
    # Created.......: created by SAP AG, R/3 Rel. >= 6.10
    # Name..........:
    # Date..........:
    # @(#) $Id: //bc/7001_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $
    ################
    AUTOMATIC_IPC = ON
    TRACE_LEVEL_CLIENT = OFF
    NAMES.DEFAULT_DOMAIN = WORLD
    # 05.01.06 unsorported parameter now
    #NAME.DEFAULT_ZONE = WORLD
    # 05.01.06 set the default to 10
    SQLNET.EXPIRE_TIME = 10
    # 05.01.06 set to default
    #TCP.NODELAY=YES
    # 05.01.06 set to 32768
    DEFAULT_SDU_SIZE=32768
    ###############################################

    tnsnames.ora
    ################################################
    # Filename......: tnsnames.ora
    # Created.......: created by SAP AG, R/3 Rel. >= 6.10
    # Name..........:
    # Date..........:
    # @(#) $Id: //bc/7001_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
    ################
    XXX.WORLD=
    (DESCRIPTION =
    (ADDRESS_LIST =

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 5 of 10

    Sap Solution Manager Dbacockpit Setup


    (ADDRESS =
    (COMMUNITY = SAP.WORLD)
    (PROTOCOL = TCP)
    (HOST = hostname)
    (PORT = 152?) (Usually
    )

    1527 or 1521)

    )
    (CONNECT_DATA =
    (SID = XXX)
    (GLOBAL_NAME = XXX.WORLD)
    )
    ################################################

    Install the Oracle Client in X:\oracle\client10

    Environment Variable
    TNS_ADMIN=H:\usr\sap\ ???\SYS\profile\oracle

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 6 of 10

    Sap Solution Manager Dbacockpit Setup


    CLIENT_ORACLE_HOME=H:\oracle\client10

    Test the Connection at OS Level.


    For the oracle database use this method.
    Use the owner of the database.Usually SAPSR3DB and the master password.
    Sqlplus SAPSR3DB/<password>@<SID>

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 7 of 10

    Sap Solution Manager Dbacockpit Setup

    Import the system in DBACOCKPIT from SLD


    Run txcode DBACOCKPIT
    Click in
    Select the systems and click Import

    In the Main screen select the system and click in Edit button

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 8 of 10

    Sap Solution Manager Dbacockpit Setup


    Select the database connection detail button.

    Select the user for the database(OWNER) and the TNS Name of the database(Usually the <SID>)

    You

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 9 of 10

    Sap Solution Manager Dbacockpit Setup

    can test the connection using

    and the system show the follow message if is everything ok.

    Now you can see the Green Light in the main Screen

    SAP-SOLMAN-INSTGUIDE-DBACockpit Setup-v2.0.doc

    Page 10 of 10

    You might also like