Feature request #8666

Use SID to connect to Oracle

Added by Jonathan Moules almost 7 years ago. Updated almost 3 years ago.

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 7 years ago

Did you set the TNS_ADMIN environment variable to the directory where your tnsnames.ora is?

#2 Updated by Jonathan Moules almost 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 over 6 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 6 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 about 3 years ago

  • Easy fix? set to No

#6 Updated by Jürgen Fischer almost 3 years ago

  • Assignee deleted (Jürgen Fischer)

Also available in: Atom PDF