Use SID to connect to Oracle

[qgib]

Author Name: Jonathan Moules (Jonathan Moules)
Original Redmine Issue: 8666

Redmine category:data_provider/oracle

---

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.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

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

[qgib]

Author Name: Jonathan Moules (Jonathan Moules)

---

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.

[qgib]

Author Name: Carlo Copat (Carlo Copat)

---

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

[qgib]

Author Name: Jonathan Moules (Jonathan Moules)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id removed Jürgen Fischer