Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
[solved] connecting to a oracle database
Contributor II
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
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