Connecting to an Oracle Database
The Division of IT hosts multiple Oracle databases which serve as the primary data stores for the academic and business units of the university.
- Connecting to the databases may only be done from university IP addresses. If you wish to connect from off-campus, you will first need to connect to the VPN.
- Oracle's recommended client software is SQL Developer. Instructional videos can be found on their download page, currently titled “SQL Developer Overview”.
- Your Oracle database username is the same as your university PID. Your Oracle database password may or may not be the same as your university PID password. You can change or reset your Oracle database password here.
- You will also need to obtain a connection string from the university tnsnames.ora file or set up your client to use the file itself. Generally, most data consumers will want to connect to RODB (a.k.a. RO Banner, "read-only"), which is updated nightly as a copy of PROD, a.k.a. Production Banner.