search

kubo / ruby-oci8

Ruby-oci8 - Oracle interface for ruby
Other
169 stars 75 forks source link

oci8 ORA-12154 #190

Closed avinashsa closed 5 years ago

avinashsa commented 6 years ago

Hi when I invoke the new I get the following error.

Has anyone seen this issue ?

oci8.c:561:in oci8lib_240.so: ORA-12154: (OCIError)

kubo commented 6 years ago

Could you post more information when you post an issue?

The error ORA-12154 is very common. It is caused by incorrectly configured network settings. Could you connect to the server using sqlplus? If you can, it may be a ruby-oci8 issue. Otherwise, it isn't.

avinashsa commented 6 years ago

Hi, sorry for the very brief info.. What version of ruby-oci8 do you use? 2.2.5.1 the latest version

What version of Oracle client and server do you use? I have tried with various.. The oracle server version is Version 11.2.0.4.0 so I have the same client at the moment but I have tried with Version 11.2.0.4.0 and 12.2.0.1.0 No joy on any.. I even installed the full client but still no joy..

What OS and the version do you use? I am running ruby on windows 10

Does it work using sqlplus? Yes it used to work with sqlplus but after installing and uninstalling various versions I have broken the tns connection but the fully qulified version still works uname/passwd@server:port/SID

And it works using sql developer as well which uses the same combo above.

"It is caused by incorrectly configured network settings." Which network settings do you mean the login credentials/TNS/server settings or something else ?

avinashsa commented 6 years ago

Oh I hate it when things suddenly start working without me fixing anything..

Anyway it works now.

Basically I did the following. 1> uninstalled all my clients 2> installed 11.2.0.4 instant client basic 3> instant client sql 4> instant client sdk. 5> There was a problem with my NLS so I changed it (Maybe this was the key) 6> tested connecting through sqlplus --success 7> tested connecting through oci8--success.

Maybe when I have time I will try break my nls again and test this and post the result to be sure if that was what was wrong with it.

kubo commented 6 years ago

"It is caused by incorrectly configured network settings." Which network settings do you mean the login credentials/TNS/server settings or something else ?

I meant TNS settings. See here.

The issue is unrelated to NLS. I guess that you changed also TNS settings when you changed NLS.