Feature request #8666
Use SID to connect to Oracle
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||17395|
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.
#2 Updated by Jonathan Moules over 7 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 about 7 years ago
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 about 7 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