Using Central DBACOCKPIT with multiple databases on 1 host.

[Former Member]

This message I have sent to SAP and from the reply it seems not being covered by SAP support but more likely consulting. Therefore I also place the message here to see if there is anyone who can give feedback on this.

Shorty said the question is specifically for using Central DBACOCKPIT with multiple ABAP systems with own databases on 1 host. Installation of a standalone gateway is a solution, but what if you have many systems, besides that ABAP systems already have an integrated gateway.... is there another way?

Dear SAP,

We are using the DBACOCKPIT centrally on the Solution Managers in order

to have one central point for database administration for the whole

customer landscape. We for instance also use the central database job

planning, for every satellite system (also java-only) DBA jobs are

scheduled in the Solution Manager.

For Oracle systems the SAPXPG RFC is used, which automatically is generated.

Problem occurs when there are multiple databases on 1 host, as this RFC

contains the server name, but not a SID. So there is only 1 RFC

available per host. In this RFC you can maintain 1 Gateway. A solution

is to make sure this gateway can distinguish the databases by using

multiple Oracle_Home and SAP_DATA environment variables. (See Note

1025707 - DBA Cockpit: Planning calendar and remote Oracle databases at

the end). We tested this and it works fine. However we want to see if

there are other solutions.

The situation is like this:

- Host with 1 remote ABAP system will use its own integrated

gateway

- Host with 1 remote Java-only system. A gateway needs to be

added. The easiest and quickest way is to add an integrated gateway by

adding this in the SAP profile.

- Host with multiple Java-Only systems. We install a standalone

gateway and use the multiple environment variables.

- Host with multiple ABAP systems. Here we also have this issue

that the sapxpg RFC only can connect to 1 gateway. Now we can install a

standalone gateway here too, but wonder if there is another way around.

The question arises when each systems already has its own gateway,

whether an additional gateway is really necessary. Is it possible to

use an integrated gateway of one of those ABAP systems, and makes this

gateway be able to distinguish systems, so that it also can connect to

other environments?

As I did not read something about such a solution I expect that if it

is possible, SAP does not recommend to use it in that way. However as

we maintain many systems of many customers it would be

useful if there is a way to avoid standalone gateway installations.

Or could SAP develop a new setting where it is possible for any DBA

connection to choose a sapxpg RFC. In this way it is easy to copy these

RFC's hence maintain mutiple sapxpg's for 1 host. This seems to be not

so difficult to develop but probably it is difficult to change the

whole process that is running under water. However I notice on

simply "Google" search that quite some people face the same issue, so

it would be nice if something can be made for this.

Met vriendelijke groet / With kind regards,

M.Sc. Jean-Paul van den Eijnden

Reply:

Dear M.Sc. Jean-Paul van den Eijnden

Thanks for your interest in Oracle remote monitoring alternitives

and development request raised. I'll try to pass your suggestion and

questions to related department. However these validation questions

and development request is not covered by SAP support services but

more likely consulting topics.

As an alternative to find an answer or a solution to your issue you

could refer to the SAP Expert Forums at following link:

http://service.sap.com/request-help

You might also have a look at "The SAP Eco-System in a Nutshell#,

note 1054121,

http://service.sap.com/~sapidb/011000358700006245642006E/

This document contains numerous venues that can help you to find

a suitable answer to your inquiry.

I'll also get back to you if I have any update from department

responsible.

So I wonder if anyone has an idea on this.The Solution Manager has many functionalities which are meant to be used for the whole SAP landscape, such as central DBACOCKPIT. It seems to me that more people are using this.

[ernaldo_cezar2]

Dear Jean-Paul,

I solved the problem using the following environment variables for each database you have:

DB1_SAPDATA_HOME = ?:\oracle\DB1\

The brtools can find by itself the rest of the important variables.

I hope it helps you to solve your problem.

Best Regards,

Ernaldo Cezar