Add new Oracle database UI is misleading #11217
Labels
Administration/Databases
Database/Oracle
First Experience/Setup
Priority:P2
Average run of the mill bug
Type:UX
Describe the bug
The "Oracle system ID (SID)" and "Oracle service name" part formular to set up a new Oracle database are misleading:
To Reproduce
I have a Metabase (
0.33.4
) install, withojdbc7.jar
driver installed as detailed in the documentation.I want to add a connection to an Oracle database.
Say I can access the Oracle database from the server I have installed Metabase on via
where
CONTAINER
has been set up on the database as:Plus say that the Oracle instance's SID has been defined as
ORCLCDB
.Expected behavior
The way stupid-me understands the UI is that the SID is required, whereas the TNS is optional.
However, after a lot of trial and error, documentation and logs parsing, I've found that the (magic) working configuration is setting
CONTAINER
as "Oracle Service Name", and leaving "SID" empty:I guess it makes sense, because these are the same details used for connecting via
sqlplus
… but I tried quite some time by usingCONTAINER
as the "SID" (because I understood this entry as required) — what obviously didn't worked.However, using the wrong configuration below returns a misleading — and frankly mad driving —
ORA-01017: invalid username/password; logon denied
error.Information about your Metabase Installation:
Severity
Lost quite some time, and a few inches-worth of nails… but I guess it's not that severe.
The text was updated successfully, but these errors were encountered: