ARCHIVED: Connect to the UITS Oracle database Oed1prd from the IUB and IUPUI STCs

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

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.

  1. 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.

  2. Click Enter. When prompted with "Enter password:", enter your Oracle database password and click Enter again.

Use SQL Developer

  1. In the Oracle 12c client, launch SQL Developer; it may take a moment to load.
  2. While SQL Developer is loading, you may be prompted with the following:
    Would you like to migrate settings from a previous release?

    Click No.

  3. After SQL Developer has loaded, you may be presented with a "Tip of the Day". Click Close when you are ready to close this window.
  4. In the Connections tab, click the New Connection icon (paper with a green cross on the lower right).
  5. Enter a connection name; this is a name of your choosing to identify this connection configuration.
  6. Enter your Oracle database username and password. Make sure Save Password is unchecked.
  7. Keep the defaults for "Role", "Connection Type", "OS Authentication", "Kerberos Authentication", and "Proxy Connection".
  8. Enter the database hostname (for Oed1prd, dbserv.uits.indiana.edu).
  9. Enter the database port (for Oed1prd, 1521).
  10. Select SID and enter the database SID. For Oed1prd, this will be simply oed1prd. Do not include the .world extension.
  11. Click Test 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.
  12. If the test of the connection succeeded, click Connect to connect to the database. Your connection will appear in the Connections 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.
  13. 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 Results tab at the bottom of the screen.
  14. After you have the connection name displaying in the Connections tab, if you need to connect to that database again, right-click the connection name and select Connect. A dialog box will appear; enter your database username and password, and then click OK.

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. Use oed1prd_ora unless you encounter problems, in which case try oed1prd_ms.

This is document anhm in the Knowledge Base.
Last modified on 2021-09-21 17:52:01.