ARCHIVED: Connect to the UITS Oracle database Oed1prd from the IUB and IUPUI STCs
You can connect to the Oracle database Oed1prd from the Indiana University Bloomington and IUPUI Student Technology Centers (STCs) using the method appropriate to your client.
On this page:
Use SQL*Plus
When you launch SQL*Plus in the Oracle 12c client, you will get the command shell version.
- When prompted with "Enter user-name:", enter your Oracle database username and then the character
@
followed by the net service name.In the STCs, the full Oracle net service name is
oed1prd.world
. Oracle net service names that you configure on your own computer may differ from the STC names, since these can be arbitrarily assigned.An example of a complete connection string for SQL*Plus is
username@oed1prd.world
. - Click . When prompted with "Enter password:", enter your Oracle database password and click again.
Use SQL Developer
- In the Oracle 12c client, launch SQL Developer; it may take a moment to load.
- While SQL Developer is loading, you may be prompted with the following:
Would you like to migrate settings from a previous release?
Click
. - After SQL Developer has loaded, you may be presented with a "Tip of the Day". Click when you are ready to close this window.
- In the tab, click the icon (paper with a green cross on the lower right).
- Enter a connection name; this is a name of your choosing to identify this connection configuration.
- Enter your Oracle database username and password. Make sure is unchecked.
- Keep the defaults for "Role", "Connection Type", "OS Authentication", "Kerberos Authentication", and "Proxy Connection".
- Enter the database hostname (for Oed1prd,
dbserv.uits.indiana.edu
). - Enter the database port (for Oed1prd,
1521
). - Select
oed1prd
. Do not include the.world
extension.
and enter the database SID. For Oed1prd, this will be simply - Click to test the connection. If the test succeeds, you will see "Status: Success" in the lower-left corner of the window. If it fails, a red error message will display and you will need to fix your connection details.
- If the test of the connection succeeded, click to connect to the database. Your connection will appear in the tab to the left and you will have an SQL worksheet displayed in front of you for that particular connection. Each worksheet has a tab displaying the connection name; there will be a different worksheet for each database connection.
- After running some SQL in the SQL worksheet, you may need to adjust the sections of the SQL Developer screen in order to see the results in the tab at the bottom of the screen.
- After you have the connection name displaying in the tab, if you need to connect to that database again, right-click the connection name and select . A dialog box will appear; enter your database username and password, and then click .
Use other client applications
To connect to Oed1prd using a client application other than SQL Plus in the STCs, you'll need an ODBC connection. An ODBC data source is a name set up on the client computer that is associated with specific connection information to a remote database. Refer to the application's help pages for information on making an ODBC connection. The following general information may help you:
- To use an ODBC connection with a client application such as Microsoft Excel, you will need to know the ODBC Data Source Name (DSN) set up on the client computer.
- The STC computers are set up with an ODBC System (or Machine) DSN for the Oed1prd database. The DSN is configured to use the Oracle driver for Oracle and is named
oed1prd_ora
. - A second DSN is set up to use the Microsoft driver for Oracle and is named
oed1prd_ms
. Useoed1prd_ora
unless you encounter problems, in which case tryoed1prd_ms
.
This is document anhm in the Knowledge Base.
Last modified on 2021-09-21 17:52:01.