@tiagobzr I didn't get this..Im getting the same error as cited above

Prithivi-Raj commented 2 years ago

@tiagobzr This won't be a ruby-oci8 issue. Could you connect to the server with the connect string with sqlplus?

sqlplus user/password@//host.intranet:1521/SID

Originally posted by @kubo in https://github.com/kubo/ruby-oci8/issues/219#issuecomment-524276832

kubo commented 2 years ago

@Prithivi-Raj Could you explain what you asked? What is "the same error as cited above"?

Prithivi-Raj commented 2 years ago

I resolved it xd. Thanks anyways

aravindaytha12 commented 1 year ago

Hi @Prithivi-Raj, @kubo

I have installed Oracle client based on the below steps https://medium.com/@arunkundgol/how-to-setup-oracle-instant-client-on-windows-subsystem-for-linux-cccee61d5b0b

(1) I have installed 'Oracle Instant Client' in WSL (Windows Subsystem for LINUX, ubuntu) (2) Facing 2 issues while trying from rails console (ruby on rails application)

output error: ORA-12162: TNS:net service name is incorrectly specified
output error: ORA-12162: Connect failed because target host or object does not exist

(3) Even I have mentioned the PATH and ORACLE_HOME Path in '.bashrc' file

export ORACLE_HOME="/opt/oracle/instantclient_19_9" 
export LD_LIBRARY_PATH="/opt/oracle/instantclient_19_9" 
export PATH=$ORACLE_HOME:$PATH
export ORACLE_SID="XD"

Kindly let me know if there anything is missing out here

Regards, Aravind Aytha

kubo / ruby-oci8

@tiagobzr I didn't get this..Im getting the same error as cited above #241