Feature request #8666
Use SID to connect to Oracle
Status: | Open | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | Data Provider/Oracle | ||
Pull Request or Patch supplied: | No | Resolution: | |
Easy fix?: | No | Copied to github as #: | 17395 |
Description
Currently (2.0.1) to connect to Oracle you need to know the Host details (IP and port). This is redundant because it is stored in TNS-names.
In theory all that is required is either SID or SERVICE_NAME/GLOBAL_NAME which can then lookup the details. FME does it this way and it works well, maybe QGIS can do it too.
History
#1
Updated by Jürgen Fischer almost 11 years ago
Did you set the TNS_ADMIN
environment variable to the directory where your tnsnames.ora
is?
#2
Updated by Jonathan Moules almost 11 years ago
My mistake - this is already in there and no TNS_ADMIN is needed. It's not "SID" that is used, it's SERVICE_NAME. Apologies for my confusion.
If I just fill in the "database" as SERVICE_NAME/GLOBAL_NAME, and leave host blank, then it works fine.
---
So my feature request changes:
- Can the help and/or dialog be updated to reflect this? The current dialog implies that Host is mandatory in all situations. Just entering the database name is much easier.
#3
Updated by Carlo Copat over 10 years ago
Good morning,
I have a problem with the connection to the spatial data with oracle. When I go to test the connection oracle gives me this error: ORA-12705 Can not access NLS data files or invalid environment specified. Unable to connect. If I run the same connection with SQL Navigator everything is working perfectly. You need to set some specific parameter in QGIS? thanks
#4
Updated by Jonathan Moules over 10 years ago
Hi Carlo, I don't think that's the same issue. You might want to ask on the QGIS mailing list - http://www.qgis.org/en/site/forusers/support.html#mailing-lists
#5
Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
#6
Updated by Jürgen Fischer almost 7 years ago
- Assignee deleted (
Jürgen Fischer)