Updating...
Skip to main content
Filter your search by category. Current category:
All
All
Knowledge Base
Service Catalog
Search the client portal
Search
Sign In
Show Applications Menu
IT
Sign In
Search
Help
Services
Knowledge Base
More Applications
Skip to Knowledge Base content
Search
Articles
Blank
Knowledge Base
Banner
Banner: Accounts & Access
Oracle / Access database in SQL Developer
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
Open Oracle SQL Developer
Right-click on your connection for Banner PROD
Or create a new connection, if you currently do not have one
Select
Properties...
In the
Connection Type
menu, select
Advanced
In the
Custom JDBC URL
box, enter
jdbc:oracle:thin:@ldap://ldap.miamioh.edu:389/PROD,cn=OracleContext,ou=oracle,dc=muohio,dc=edu
Select
Test
to make sure the connection works
Select
Save
Note
You can replace the PROD in the above JDBC URL with TEST, DEVL, MARS, etc. to connect to other Oracle databases
Sign in to leave feedback
0 reviews
Blank
Blank
Blank
Blank
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)
SQL Developer / Error Record
Deleting...
×
Share
Recipient(s)
- separate email addresses with a comma
Message
Press Alt + 0 within the editor to access accessibility instructions, or press Alt + F10 to access the menu.
Check out this article I found in the IT knowledge base.<br /><br /><a href="https://miamioh.teamdynamix.com/TDClient/1813/Portal/KB/ArticleDet?ID=50840">https://miamioh.teamdynamix.com/TDClient/1813/Portal/KB/ArticleDet?ID=50840</a><br /><br />Oracle / Access database in SQL Developer