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