Service Mapping to an Oracle Database with only the SID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2022 06:07 AM - edited 11-29-2022 07:10 AM
Hi all,
In my TomCat Service Mapping map, I find a reference to an Oracle database in the following format:
url="jdbc:oracle:thin:@x0ipatrick01"
From what I understand from here java - Accessing oracle database via SID through JDBC without host:port - Stack Overflow is this an Oracle connection purely based on a SID.
However, what Connection should I use in my pattern now to continue my mapping from here? The standard Oracle DB Endpoint connection is asking for Host, Port, Instance and Schema. I cannot find a connection that is based on just an Oracle SID.
Anyone who knows what Connection to use here?
Kind regards, Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2022 06:38 AM
It is confusing, why do you want to use entrypoint directly for the oracle?
Ideally service mapping done based on patterns and patterns will have ways to parse the config and show you resp nodes in the map.
You only need to worry about the entrypoint [typically a http(s) url] of the main service that constitutes oracle db down the lane.
Can you elaborate what you are trying to achieve?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2022 07:12 AM
Sorry for being a bit unclear.
I updated my issue, my problem is with what Connection to create in my Service Map, since the connection Oracle DB Endpoint seems not the right fit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 02:36 AM
Sorry but I really don't get your use case, are you asking this as you trying to develop some new connection in the map by writing some new connection section to OOB pattern?
OR, you are asking about a OOB SNOW discovery not resulting in the oracle db in the map and you are trying to fix?
However I see only 3 endpoints for Oracle where mostly those were the attributes, only Oracle RAC DB Endpoint among them has a Service Name attribute which is equivalent to SID but no endpoint exactly with SID is available.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2022 12:14 AM
Yes, exactly, I am extending my TomCat WAR pattern and find an Oracle connection defined in a config file that only has the SID.
But when I want to use this SID to create an Oracle DB Connection, I see this is not enough and I cannot create this connection with only the SID given.
