Oracle / Access database in SQL Developer

Objective

  • To provide instruction on accessing PROD in Oracle SQL Developer

Environment

  • 10503: PROD-DB
    • Oracle Database
    • Oracle SQL Developer

Cause

  • An update was made to the way databases are accessed that will require you to use a different JDBC string

Resolution

  • Accessing the database requires a user to either be on campus or connected to the VPN to access. Log into VPN if not on campus before connecting
  1. Open Oracle SQL Developer
  2. Right-click on your connection for Banner PROD
    • Or create a new connection, if you currently do not have one
  3. Select Properties...
  4. In the Connection Type menu, select Advanced
  5. In the Custom JDBC URL box, enter jdbc:oracle:thin:@ldap://ldap.miamioh.edu:389/PROD,cn=OracleContext,ou=oracle,dc=muohio,dc=edu
  6. Select Test to make sure the connection works
  7. Select Save

 

Note

  • You can replace the PROD in the above JDBC URL with TEST, DEVL, MARS, etc. to connect to other Oracle databases

 

Print Article

Details

Article ID: 50840
Created
Fri 3/23/18 9:44 AM
Modified
Mon 4/29/24 3:45 PM
Can you resolve this issue yourself?
Yes! This is self-service with a smile.

Related Articles (1)