"Driver for connecting to Oracle Database"

Anki

Hi Community,

I am using RapidMiner-5  64 bit,  Windows server 2003 (64 bit) as OS,  JDK 1.6 java version,  Oracle 11g for Database.
My problem is I am unable to connect to Database with RM. I tried with ojdbc14.jar and ojdbc6.jar,  but no use.

Please give me solution, which drivers I have to use.

Thank you

Yours
Anki

fischer

Hi,

Oracle changed the name of the driver class. You can go to Tools -> Manage Database Drivers and create a new Oracle Driver with class name "oracle.jdbc.OracleDriver" (as opposed to "oracle.jdbc.driver.OracleDriver"). That will probably solve the problem.

Best,
Simon

Anki

Hi Simon,

Thank you for your help. I did changes, but still not solved

Tools-Manage Drivers - Add oracle - and parameters as

Name: Oracle_New

  port  : 1521
Browsed for ojdbc14.jar and ojdbc6.jar
Class: oracle.jdbc.OracleDriver

But still not connected.

Please correct me if I did wrong in the procedure.

Thank you

Yours
Anki

Anki

Hi Simon and all

YES, above method is working fine. Thank you.
But while I am establishing, an error is coming as

listener refused the connection with the following error ora-12505

What could be the reason? any solution

Thank you

Yours
Anki

colo

Hi Anki,

since this issue is named, there should be some material about it.

Maybe some of these will be helpful: http://lmgtfy.com/?q=oracle+ora-12505

Regards
Matthias

Anki

Hi Matthias,

The Problem solved. Thank you.

Yours
Anki

marcopo

Hello Community,

I am a newbie in Rapidminer (5.2.008) and I am trying to establish a connection to an oracle database 11g. I was faced with the same error and I handled it in the way it was shown in the post. In the end I got the same ORA-12505 error. I tried to solve it in the way it was suggested but without suggest. What should I do?

Please help me.....


My listner.ora
# listener.ora Netw

ork Configuration File: C:\app\pospiech\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app

Best Regards

Marco