Oracle Database extension - no ability to scale deployment beyond 10 targets

[Phil_Broughton]

So a complete novice question from a newbie.

We have 500 oracle databases we would like to hook up for monitoring by Dynatrace. Using Oracle Extensions, this appears to limit us to just 10 "configurations (databases)"

What am I missing or is this simply a limitation of the extension 2.0 architecture?

[Mizső · Accepted solution]

Hi @Phil_Broughton,

Maybe @dglugla could answer your question.

You can use this feedback channel:

Re: Feedback channel for the Database monitoring extensions - Dynatrace Community

I hope it helps. Have a nice day.

Best regards,

Mizső

[MateuszKacprzak]

Hi @Phil_Broughton,

You can have 10 configurations but in each configuration you can configure up to 100 Oracle endpoints.

The limitation there is that defining e.g. 100 endpoints in one configuration, they must all be accessible from the ActiveGate, on which this extension is enabled.

Best regards,

Mateusz

[Phil_Broughton]

@MateuszKacprzak Thanks, but where is that doc'd? All I am seeing is that a configuration = 1 database connection, I don't see anything about endpoints? I am using the DB Extension for Oracle here...

[Mizső]

Hi @Phil_Broughton,

This is my understading. Here is the documentation about it:

https://www.dynatrace.com/support/help/shortlink/extend-oracle#step-2

I hope it helps. Have a nice day.

Best regards,

Mizső

[Phil_Broughton]

That's great, but doesn't then permit with any ease whatsoever the ability to remove or add an endpoint to an existing configuration once created. It looks like you have to drop all and start over which isn't flexible enough. 

[MateuszKacprzak]

You can click on ✏️ button and modify existing configuration. Then you can add or remove existing endpoints.

[Phil_Broughton]

Need to be able to do this using Rest-API rather than UI. Not sure that is possible, but will dig around. Fear is we have to drop/recreate over and over and over which is highly disruptive and losses historic data. We create alot of db services (cookie cutting/cloud service etc).

[Mizső]

Hi @Phil_Broughton,

You can do it VIA the collection of Rest API and with it you can automate. You only need a proper Auth token.

With the highlighted POST you can create an extension configuration with up to 100 endponint. You need to extend an exapmle JSON with the endpoint. With the highlighted PUT you can modify an existing configuration. 

On the GUI during the endpoint configuration you can see the required JSON which can be used at the POST (curl is created which can be use later or for the automation).

I have already attached the screenshots about the mentioned POST.

I hope it helps. Have a nice day.

Best reagrads,

Mizső