Bug report #8665
QGIS doesn't use SID for Oracle connection
|Affected QGIS version:||2.0.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||17394|
The oracle connection help says:
"Database" - SID or SERVICE_NAME of the Oracle instance.
However, if I enter a valid SID of a database here, it will fail with a ORA-12514 error. I spent many hours of frustration wondering why my Oracle connection wasn't working due to this. :-(
It does work if a SERVICE_NAME or GLOBAL_NAME is entered.
#6 Updated by Jonathan Moules about 7 years ago
Using Oracle 10g here (though with the 11 client).
The TNSnames entry looks like this:
(COMMUNITY = wcctcp.world)
(PROTOCOL = TCP)
(Host = co-gistest-li2)
(Port = 1521)
(SID = gistest)
(GLOBAL_NAME = co_gistest.world)
Specifying "gistest" as my database instantly gets me back the ORA-12154 error.