Skip to Content
Author's profile photo Former Member

DBA COCKPIT CONFIGURATION IN MANAGED SYSTEM SETUP SOLUTION MANAGER 7.1

How to configure and Trouble Shooting DBA COCKPIT Configuration in Manage System Setup Solution Manager 7.1

In Managed System Setup – Step 4 (Enter System Parameters) highlighted below

Page1.png

Please provide all the required Details for DB Parameters

DB Host

Service Name

Port Number

TNS Name

And User Name will be your ABAP Schema User/ For Java (SAPSR3DB)

Page0.png

Once provided all the required information then save. you will see that log message saying

The DBA cockpit
connection %_******** is OK. DB Extractors can be activated

/wp-content/uploads/2014/12/image12_605043.jpg

Once this step is completed we can activate the DB Extractors in Step 8 ( Configure Automatically) . We can check the successful connection entry in

DBACOCKPIT T-Code. Below is the screen shot for your reference.

Page77.png

Trouble Shooting Connection Error

If DB cockpit connection cannot be established then you will get below message.

Page33.png

We can see that Error cannot establish DBcockpit connection

Page44.png

/wp-content/uploads/2014/12/page55_604405.png

as we can see the same connection entry in DBCO T-code. Delete these existing entries

Page66.png

And delete all the entries in DBACOCKPIT and MSS and check the in Operating System Level

tnsnames.ora at both location it should be the same as per the managed system

entries. If not then change the entries and check the tns ping.

Then configure the DBACOCKPIT in MSS in the same way shown above. Once the DBA
extractors are activated check the connection in T-Code DBACOCKPIT in SOLMAN

DBACOCKPIT Connection in SOLMAN à connection should be
successfully established.

Thank You,

Nahid

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sadik Iqbal Siddiqui
      Sadik Iqbal Siddiqui

      Hi Nahid

      Very good doc and very helpful

      Thanks

      Sadiq

      Author's profile photo Kathy Moreillon
      Kathy Moreillon

      Can you please tell me what the service name is?  Where do I find this information.

      Thanks,

      Kathy Moreillon

      Author's profile photo Yogesh Patel
      Yogesh Patel

      Hello Kathy,

      You better look at this video

      SAP Database Performance Warehouse for SQL Serv... | SCN

      This video has way much more information

      Regards,

      Yogesh