This discussion is archived
6 Replies Latest reply: Apr 30, 2013 9:05 PM by rp0428 RSS

sql developer newbie queries

user2429896 Explorer
Currently Being Moderated
Hi,

After installing SQL developer to my PC, do I have to install Oracle client in my PC as well to connect to Oracle DB in the servers?

Thanks in advance.
  • 1. Re: sql developer newbie queries
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    No - connectivity is handled via JDBC in the tool itself, so you can connect right away. Assuming, of course, that you have a database running somewhere to connect to.

    If you have an Oracle Client, there are a few benefits to using it with SQL Developer, namely better query cancellation support, some XML feature support, and the ability to change your expired passwords.
  • 2. Re: sql developer newbie queries
    user2429896 Explorer
    Currently Being Moderated
    What could be the problem with message "no ocijdbc in java.library.path" when I tried to connect to the Oracle DB from SQL Developer?
  • 3. Re: sql developer newbie queries
    Gary Graham Expert
    Currently Being Moderated
    That condition arises if ...

    1. Your Tools -> Preferences -> Database -> Advanced -> Use OCI/Thick driver setting is checked but you either have no Oracle client software installed or SQL Developer is having trouble finding it (perhaps the ORACLE_HOME environment variable is not set properly or something similar).
    2. You use Connection Type: TNS with the Connect Identifier option, which requires OCI.

    So decide if you need OCI/Thick or not and adjust your environment as needed. If you want to read a longer discussion of this issue, here is a thread from over a year ago on this forum, which in turn references another good discussion thread:
    Test failed - no ocijdbc11 in java.library.path
    no ocijdbc11 in java.library.path (Win 7)

    Regards,
    Gary
    SQL Developer Team
  • 4. Re: sql developer newbie queries
    1006454 Newbie
    Currently Being Moderated
    I've been using PL/SQL for a while, but have a new issue.

    A DBA has set up my account with an expired password. The thought is that I will log in the first time and change the password. The reality is that I cannot create the connection with the expired password. I currently have the thin client installed.

    In order to create the new connection, what else do I need to install?

    The database is Oracle 11g (at least I assume it is, I can't tell until I can log in). I'm running Mac OS X 10.7.5
  • 5. Re: sql developer newbie queries
    Gary Graham Expert
    Currently Being Moderated
    You will have to install the Oracle Instant Client. Pick the appropriate one for your OS and Oracle DB version:
    http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

    -Gary
  • 6. Re: sql developer newbie queries
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!
    >
    I've been using PL/SQL for a while, but have a new issue.
    >
    In the future when you have a question or issue you should create your own thread.

    Asking your question in another user's thread is considered HIJACKING and is inappropriate.

    This thread is ONLY for comments, questions and suggestions for the OP (original poster). That is who we are trying to help in this thread.

    Responders need to be able to focus on the original question asked and direct their reponses to them. It can be very confusing when someone else starts asking questions about their own problem. Your version of sql developer is likely to be different as is you OS and/or configuration and even how you are using the product.

    The same courtesy will be extended to you in YOUR thread.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points