"Driver for connecting to Oracle Database"

AnkiAnki Member Posts: 39 Contributor II
edited June 2019 in Help
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
Tagged:

Answers

  • fischerfischer Member Posts: 439 Maven
    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
  • AnkiAnki Member Posts: 39 Contributor II
    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
  • AnkiAnki Member Posts: 39 Contributor II
    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
  • colocolo Member Posts: 236 Maven
    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 :D;)

    Regards
    Matthias
  • AnkiAnki Member Posts: 39 Contributor II
    Hi Matthias,

    The Problem solved. Thank you.

    Yours
    Anki
  • marcopomarcopo Member Posts: 14 Contributor II
    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

Sign In or Register to comment.