Instant Client

Solving the ORA-12504 Error

by
Oracle DB ORA-12504 error

When attempting to use the ODBC Data Source Administrator to test a connection to an Oracle Database from an Oracle client – one that did not have TNSPING installed – I got the above error: Unable to connectSQLState=S1000[Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA When searching this error, I found quite a few … Read more

Adding Configuration Files to Oracle Database 12c Instant Client

by
Oracle Database 12c

Happy New Year! Though I generally prefer to use the full Oracle client, I have many customers that use the Instant Client to save space. However, this setup frequently is missing the configuration files that may be necessary for some applications to be able to find database servers. If you are missing any of the … Read more