2 Replies Latest reply on Jul 16, 2013 11:23 AM by 84e45717-06df-499e-a789-5312b7434a74

    Sqldeveloper /as sysdba connection

    84e45717-06df-499e-a789-5312b7434a74

      I'm a total newbie in Oracle.

      I installed Oracle 11g XE R2.

      Also I installed SqlDeveloper 3.2.20.09 version.

      I have Java Version 7 Update 25

      I generated auto connections, and I have 2 connections. One is: /as sysdba and another: system-XE

      I successfully connect to system-XE, but when I try to connect as sysdba in SQLdeveloper (in same time I can connect trough SQL command line) I get this error:

       

      java.lang.Error: Incompatible version of libocijdbc[Jdbc:112030, Jdbc-OCI:112020

        at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3557)

        at java.security.AccessController.doPrivileged(Native Method)

        at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3550)

        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:266)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:552)

        at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:162)

        at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:526)

        at oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:153)

        at oracle.dbtools.raptor.standalone.connection.RaptorConnectionCreator.getConnection(RaptorConnectionCreator.java:195)

        at oracle.dbtools.raptor.dialogs.conn.ConnectionPrompt.promptForPassword(ConnectionPrompt.java:67)

        at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:321)

        at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:254)

        at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:60)

        at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534)

        at oracle.javatools.db.DatabaseFactory.createDatabase(DatabaseFactory.java:208)

        at oracle.jdeveloper.db.DatabaseConnections.getDatabase(DatabaseConnections.java:607)

        at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getDatabase(Connections.java:172)

        at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1064)

        at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1045)

        at oracle.dbtools.raptor.navigator.DatabaseConnection.openConnectionImpl(DatabaseConnection.java:115)

        at oracle.dbtools.raptor.navigator.AbstractConnectionNode.getConnection(AbstractConnectionNode.java:30)

        at oracle.dbtools.raptor.navigator.ConnectionFilter.getFactory(ConnectionFilter.java:94)

        at oracle.dbtools.raptor.navigator.ConnectionFilter$1.doWork(ConnectionFilter.java:119)

        at oracle.dbtools.raptor.navigator.ConnectionFilter$1.doWork(ConnectionFilter.java:104)

        at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

        at java.util.concurrent.FutureTask.run(FutureTask.java:138)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:515)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

        at java.util.concurrent.FutureTask.run(FutureTask.java:138)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:662)

       

       

      any help would be really appreciated since now I was searching for the solution almost 3 hours.

        • 1. Re: Sqldeveloper /as sysdba connection
          Turloch O'Tierney-Oracle

          Hi,

           

          >I'm a total newbie in Oracle.

          Welcome

          >I installed Oracle 11g XE R2.

          >Also I installed SqlDeveloper 3.2.20.09 version.

          >I have Java Version 7 Update 25

          Use SQLDeveloper 4.0 with Java 7

          >I generated auto connections, and I have 2 connections. One is: /as sysdba and another: system-XE

          >I successfully connect to system-XE, but when I try to connect as sysdba in SQLdeveloper (in same time I can connect trough SQL command line) I get this error:

           

          >java.lang.Error: Incompatible version of libocijdbc[Jdbc:112030, Jdbc-OCI:112020

          That means you are trying to use thick(OCI) driver and the version of 11gXER2 does not quite match SQLDeveloper 3.2.2.09.(one is 11.2.0.2 one is 11.2.0.3)

           

          I suggest use thin (not OCI/Thick) i.e. do not have tools->preferences->database->advanced->use OCI/Thick driver should be off/not checked.

          (If you absolutely need OCI you could install the suitable instant client version) Thin is pure java on the client side, the SQLDeveloper install is all you need on the client side)

           

          Turloch

          -SQLDeveloper Team

          1 person found this helpful
          • 2. Re: Sqldeveloper /as sysdba connection
            84e45717-06df-499e-a789-5312b7434a74

            I solved it on my own. I replaced the jdbc jar files in the jdbc/lib folder and now it is working. just downgraded the jdbc drivers to version 11.2.0.2