[solved] connecting to a oracle database
jan87
New Altair Community Member
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"
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"
0
Answers
-
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
0