How do I connect to the UITS Oracle database Oed1prd from the IUB and IUPUI STCs?

Username:
Password:

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:

Using SQL*Plus

When you launch SQL*Plus in the Oracle 11gR2 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 Enter. When prompted with "Enter password:", enter your Oracle database password and click Enter again.

Using SQL Developer

In the Oracle 11gR2 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 No.
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.
In the Connections tab, click the New Connection 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 Save Password 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 SID and enter the database SID. For Oed1prd, this will be simply oed1prd . Do not include the .world extension.
Click Test to test the connection. If the test succeeds, you will see "Status: Success" in the lower left-hand 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 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.
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.
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.

Using Microsoft Access

In Microsoft Access, create a new database.
From the File menu, click Get External Data, and then choose either Import or Link Tables.
From the "Files of Type" list, select ODBC Databases.
In the Select Data Source window, choose the Machine Data Source tab, and then select your data source. In the STCs, you will see the Data Source Name (DSN) oed1prd_ora. On other computers, the DSN may be different. Click OK.
In the Connect dialog box, enter your Oracle database username and password, and then click OK.
The list of tables you see will include all of the tables on Oed1prd. Select the tables you want, and click OK.

Access requires that a table has a primary key field, or else it will prompt you for it before establishing the link. You should see the link in your database window, and you can proceed with your work.

The next time you open the database, the links will still exist unless you explicitly delete them. If you change a data source, you'll need to delete and recreate links in order for them to work.

Using Aqua Data Studio

To connect to the Oracle database Oed1prd using Aqua Data Studio, register the database server before connecting.

Registering

To register the Oracle database Oed1prd:

In Aqua Data Studio, from the menu bar, click Server, and then Register Server.
Click the General tab.
Under "RDBMS:", select Oracle 8i.
Note: Oracle 9i/10g will not work with Oracle 11g databases.
Next to "Name:", enter a name of your choice for this server registration (e.g., OED1PRD).
From the drop-down list next to "Type:", select Production.
Next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
Next to "Connect As:", make sure Normal is selected.
Uncheck Save password.
Next to "Host:", enter dbserv.uits.indiana.edu.
Next to "Port:", enter 1521.
Next to "SID:", enter oed1prd, and then click OK.

Connecting

Once the Oracle Oed1prd database is registered, to connect:

In Aqua Data Studio, on the left, beneath "Local Database Servers", choose the appropriate server name.
From the menu bar, click Server, and then click Connect.
In the Authenticate window, next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
Next to "Connect As:", make sure Normal is selected, and then click OK.
On the left, under your server name, double-click Schema, and then double-click your personal schema (the same name as your Oracle database username).

Note: UITS does not support Aqua Data Studio beyond installation from IUware. For technical support, visit the AquaFold support page.

Using other client applications

To connect to Oed1prd using a client application other than SQL Plus, Microsoft Access, or Aqua Data Studio 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 domain all.
Last modified on August 04, 2011.