Adminer / Discussion / Other databases: Connect to Oracle through oracleinstantclient?

Connect to Oracle through oracleinstantclient?

Forum: Other databases

Creator: livefree75

Created: 2013-10-25

Updated: 2021-02-06

livefree75 - 2013-10-25

I have my PHP configured with OracleInstantClient. But when I enter the database information (server, username/password and database) on the Login screen, I get the following error:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Help?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

John Zornig - 2013-12-09

Same problem here.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

grammm - 2014-02-26

You must type in "Server" the database name and it works

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Basil Crayon - 2014-03-03

It works with "Host/SID" in "Server" field, and nothing in "Database" field.
You can check your tnsnames.ora for hosts and SID values.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.