Forum Stats

  • 3,814,896 Users
  • 2,258,927 Discussions
  • 7,892,883 Comments

Discussions

Status : Failure -Test failed: no ocijdbc11 in java.library.path

2684456
2684456 Member Posts: 2
edited Jun 14, 2014 5:02PM in SQL Developer

I downloaded SQL Developer 4.0.2 (64bit) and I am new to the Oracle environment. I am looking create a database using SQL Developer but every time I try to create a connection I receive the the following error "Status : Failure -Test failed: no ocijdbc11 in java.library.path". I did some searching online but all suggestions I tried did not work.  For Connection type I am using Local/Bequeath and I am using OS Authentication. Note I get the same error independent whether I use Linux or Windows additionally I tried older versions of SQL Developer which yielded the same error. Please inform me if additional details is needed.

Tagged:

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,509 Employee

    are you trying to create a database, or create a database connection?

    does a non-bequeath or non-OS authent connection work?

  • 2684456
    2684456 Member Posts: 2

    My goal is to create a database on my local machine. So I am creating a new connection. I have attempted to use Basic in the connection type field but this just returns another error. That error reads " Status : Failure - Test failed IO Error: The Network Adapter could not establish the connection'.  For Hostname I used the default localhost and for port number I used 1521(this is also the default).

  • My goal is to create a database on my local machine. So I am creating a new connection. I have attempted to use Basic in the connection type field but this just returns another error. That error reads " Status : Failure - Test failed IO Error: The Network Adapter could not establish the connection'.  For Hostname I used the default localhost and for port number I used 1521(this is also the default).

    Well - that is confusing.

    You can't 'connect' to a database until AFTER you create the database.

    So if you haven't created it yet create the database. Then connect to it.

     I am looking create a database using SQL Developer

    To do that you have to have already installed Oracle. Then if you don't have a database you have to connect as SYSDBA using the SYS account and create the database.

    It is easier to just create a database as part of the installation of Oracle. Why don't  you do that?

  • mojave
    mojave Member Posts: 31

    This sounds like my problem here:

    https://community.oracle.com/thread/3569569

    What do you have for Tools > Preferences > Database > Advanced?  Specifically under "Use Oracle Client"?

This discussion has been closed.