Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

[solved] connecting to a oracle database

Hi there,

after finally reaching a oracle database (after getting a new driver), there is still a problem with connecting:

When I want to connect this error pops up:

"Listener refused the connection with the following error: ora-12504, TNS:listener was not given the SID in CONNECT_DATA"

Do you know, where I have to enter the "SID" or the "service name" for an Oracle Database in RapidMiner? Normally you need them for connecting f.e. in Oracle SQL Developer and I suppose thats the mistake here...

Thank you a lot,
Jan

edit: ok I just had to find out the right expression for "database scheme"

Find more posts tagged with

AI Studio

Databases

Oracle

Accepted answers

All comments

persons08

Here is Example how to configure Oracle services - listener and other configuration file tnsanmes.ora and sqlnet.ora
http://www.dbasupport.com/forums/showthread.php?61511-ORA-12504-TNS-listener-was-not-given-the-SERVICE_NAME-in-CONNECT_DATA
and here is tool to check listener. type in CMD
tnsnames OraName

OraName is name in tnsnames.ora file (borg example)
lpe