Skip to Content

You have a requirement of setting up central administration of your MaxDB database to be monitored by SOLMAN 7.1 system, running on Oracle/Linux or any other DB/OS other than MaxDB.

MaxDB database instance might be standalone or an SAP application may be running on it. Content server, live cache or complete SAP system.

Also you would like to configure DBA planning calendar to schedule database backups and other DB related task centrally from solution Manager.

To achieve this, we should be able to connect to the MaxDB database instance from the solution manager 7.1 system to access database information. To realize this connection, we need to have a compatible version of MaxDB client libraries installed on all the application servers of the solution manager system.

Maxdb client is not installed by default if you are running the DBACOCKPIT on a  SAP system which is running on a database other than MaxDB.

How to check if the client is installed or not on your system.

  1. Check for the Maxdb client installation on all  application servers of system using Tcode SE38/SA38 and program RSADA_CHECK_SERVERS

    

 

2. Download and Install the MaxDB Client Libraries.

822271 – FAQ: SAP MaxDB client software

Download the maxdb client runtime package from service market place. File with name MAXDBART<XXXX_XX-XXXXXXXX.SAR

Once it has been downloaded , install it as shown in steps below and run the installation using command  ./SDBINST

Set group to “sapsys” and owner to “sidadm” and continue. You can also create standard group and user but make sure that sidadm user has access to read client libraries .


Set the environment variables PATH and LD_LIBRARY_PATH and include the path of the lib and programs/bin for MaxDB client on all application servers. Logoff and login again from the shell so that the changes can take effect.

3. Download the Maxdb database library ( this is different from Maxdb client libraries) , depending upon your kernel version and uncar it to the SAP kernel directory

In my case as I am running on linux, we downloaded the linux compatible library.

Uncar and copy the library dbsdbslib.so to the SAP kernel directory

Once the environment variables have been set, and the MaxDB library copied to the SAP kernel, for the changes to take effect, restart the application servers.

Now test the client installation using the program RSADA_CHECK_SERVERS again

4. Now we are all set to define a database connection in DB59 to a remote MaxDB database

Once this has been setup , we are all set to monitor the database in DBACOCKPIT.

In the next document related to  MaxDB, i will explain how to setup DBA planing calendar to schedule activities like DB backup , log backup , check database and other activities central from the DBACOCKPIT for a remote MaxDB database.

Also I will explain, how to create the database connection from SOLMAN 7.1 managed system setup instead of creating it manually and how to setup and configure diagnostics agent and outside discovery for a Maxdb database instance and how to configure monitoring for a MaxDB remote database in SOLMAN 7.1 MAI , which is running standalone or as part of content server or livecache database.

Thanks

Amit

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Christian Paminger

    Hello and thank you for the good guide.

    Where or how do I have to set the variables PATH and LD_LIBRARY_PATH?
    If I google, I find different files where to set this paths.

    Kind regards

    (0) 
  2. carlos cavero

    Hi

    I have some problems with this configuration. My solution manager uses maxdb and my satelites systems too. They are in outside network so im trying to configurate by saprouter , i read this in a post. But when im testing the connection the error is:

    Could not open connection D01 .
    sql error 0 occured:
    Connection failed (RTE:[1] NI: connect failed,ROUT: intern. error)

    i create a connection from dbco and in the connection information i set:

    /H/MY SAPROUTER PUBLIC IP/S/3299/H/SAPROUTER PUBLIC IP  CLIENT/S/3299/H/privateipdatabase-DBSID

    Is correct this configuration=

    I open all the ports  in my saprouter and from client too

    Can anybody help me

    Thanks a lot

    (0) 

Leave a Reply