[receiver/oracledbreceiver] Initial implementation

[atoulme]

Component(s)

receiver/oracledb

Is your feature request related to a problem? Please describe.

Initial implementation of oracledbreceiver, after the work in #oracle

Describe the solution you'd like

This issue captures the work of the initial implementation. It uses a scraper to access the database and query periodically.

Describe alternatives you've considered

No response

Additional context

No response

[perk-sumo]

Hey @atoulme what is the end goal of this receiver:

• query db for telemetry data that is stored inside?
• query db for it's own telemetry data?
• both?

For sql records there is another issue for mysql specifically:

• New component: receiver/mysqlrecordsreceiver #12082

There is also a working PoC for MySQL records:

• https://github.com/JKashyap96/sumologic-otel-collector/tree/main/pkg/receiver/mysqlrecordsreceiver#mysql-records-receiver

I'm bringing this up for visibility, maybe it might help you.

[atoulme]

Here is a lot more background on this:
#13939

You can see in the PR #16044 we advertise a few metrics related to the Oracle DB itself. Feedback on the PR would be much appreciated.