IRT Support Center (2023)

In the Oracle RAC environment, databases may be moved between the server clusters. To prevent end users from having to update their settings after each move, it is advised that you use OID through a JDBC connection string to connect to an Oracle Database.

JDBC Step-by-Step Guide

To connect using a JDBC string, modify the following string template to fit your credentials and desired database.

  1. ReplaceINSTANCENAME in the string above with the desired database name.
    1. For a list of database instance names, please view theRAC Status Page.
  2. In SQL Developer,createa new connection. You can do so by clicking the green plus sign, typically in the upper left portion of the application window.
  3. Specify a namefor your connection. You may want to follow the convention of INSTANCE - USERNAME, as analysts may access the same instance/environment using service accounts.
  4. Under "Connection Type," chooseAdvanced. You will then be presented with a text field where you can paste in your custom JDBC URL.
  5. Testto confirm your string is properly formatted, thenSave.

IRT Support Center (1)

The above graphic shows settings for a connection titled "PROD" connecting to the "PROD" database instance, using the username "scott" and the password "tiger".

LDAP Step-by-Step Guide

  1. Createa file calledldap.orain a chosen directory, preferably the user's home directory (i.e. C:\users\[network ID]), but you could alsouse any other directory of your choice.

    In theldap.orafile, add these entries. The content ofldap.orawill be the same for every database instance:


    DEFAULT_ADMIN_CONTEXT ="dc=rowan,dc=edu"


  2. In Windows Search, search for "Advanced system settings", and choose "View advanced system settings"

    IRT Support Center (2)

  3. Cick "Environment Variables" button at the bottom, right of the dialog

    IRT Support Center (3)

  4. Add a new environment variable -TNS_ADMINthat points to the directory containing the fileldap.ora

    IRT Support Center (4)

  5. Once you've done that, start up SQL Developer, then use the LDAP Server drop-down to pick our LDAP server(it will be the only, the context drop-down below it will then auto-populate with the correct entry (dc=rowan,dc=edu).

    IRT Support Center (5)

  6. Click theLoadbutton just to the right of theDB Servicedrop-down, and all the databases show up in the DB Service drop-down. Find your database instance in the list, and double-click the entry to select it.

    IRT Support Center (6)

  7. Click the Save button to save your new connection settings


Top Articles
Latest Posts
Article information

Author: Chrissy Homenick

Last Updated: 17/10/2023

Views: 5518

Rating: 4.3 / 5 (74 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Chrissy Homenick

Birthday: 2001-10-22

Address: 611 Kuhn Oval, Feltonbury, NY 02783-3818

Phone: +96619177651654

Job: Mining Representative

Hobby: amateur radio, Sculling, Knife making, Gardening, Watching movies, Gunsmithing, Video gaming

Introduction: My name is Chrissy Homenick, I am a tender, funny, determined, tender, glorious, fancy, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.