Identify and resolve errors / SQL Developer

Problem

  • How do I identify and resolve errors in SQL Developer?

Error + Resolution

Error Message

  Network Adapter could not establish connection
Affected User / Client Office / Action When a user tries to connect to an Oracle database through SQL developer
Cause
  1. The connection string is incorrect 
  2. The user does not have appropriate permissions in banner
  3. User is off campus and needs to connect to VPN
Applied Resolution
  1. If you are off campus, connect to the MU VPN
  2. If error persists, follow all steps in Access database in SQL Developer / Oracle to ensure correct connection details
  3. If error persists, contact the appropriate office as listed in Banner Security Access to request access
    • If you are a member of IT services, have your manager submit a ticket to the DBAs to request access
Associated Procedure
   

User

  • Miami University Community

System

  • 10503: PROD-DB
  • 10528: TEST-DB
  • 10514: DEVL-DB
  • 752150: MUVPN - Banner