The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
[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