Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Connecting to SQL Developer

    Hi all,
    i have installed Oracle 10 g Exp Edition in my stand alone system.
    I want to connect through SQL Developer tool.
    Can any one please tell me the steps involved in "how to connect to the Oracle 10 g Exp Edition from Oracle SQL Developer Tool ".

    Thanks in Advance.

  2. #2
    Join Date
    Jul 2011
    Posts
    5

    Thumbs up connect to sql developer tool

    Hi Arvind,
    Its nice to hear that you are using Oracle Developer tool.
    You have two option do create connectivity from D2k/6i or any oracle developer tool.
    1) Through Wizard , by using Oracle Net8 easy config. When you run this wizard it ask your computer name or IP

    2) Second , Manually you can change in tnsnames.ora file.
    You can get tnsnames.ora from home of Developer Tool -> network ->admin

    Happy to use developer tool

    Manoj Kumar

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Manoj, it is not Developer Suite (D2K or 6i or whichever version you thought), but SQL Developer.

    Arvind, it is all described in User's Guide. Did you read it?

  4. #4
    Join Date
    Jul 2011
    Posts
    5

    Thumbs up connect to sql developer tool

    Dear Arvind,
    You can connect sql developer tool by using the following step.

    1 . Open Oracle SQL Developer.
    2. In the Connections navigator, right-click Connections and select New Connection
    3. Enter the Connection Name like (HR_ORCL) or any other name that identifies your connection, Username(LIKE hr) and Password (like HR) , specify your localhost(database ip address or database computer name) for the Hostname and enter ORCL for the SID (or which ever is your SID nane) . Click Test

    FOR REFERENCE YOU CAN SEE
    Getting Started With Oracle SQL Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •