How do I 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:
- Using SQL*Plus
- Using SQL Developer
- Using Microsoft Access
- Using Aqua Data Studio
- Using other client applications
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 clickEnteragain.
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
Closewhen you are ready to close this window.
- In the
Connectionstab, click theNew Connectionicon (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 Passwordis 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
SIDand enter the database SID. For Oed1prd, this will be simplyoed1prd. Do not include the.worldextension.
- Click
Testto 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
Connectto connect to the database. Your connection will appear in theConnectionstab 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
Resultstab at the bottom of the screen.
- After you have the connection name displaying in the
Connectionstab, if you need to connect to that database again, right-click the connection name and selectConnect. A dialog box will appear; enter your database username and password, and then clickOK.
Using Microsoft Access
- In Microsoft Access, create a new database.
- From the
Filemenu, clickGet External Data, and then choose eitherImportorLink Tables.
- From the "Files of Type" list, select
ODBC Databases.
- In the
Select Data Sourcewindow, choose theMachine Data Sourcetab, 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. ClickOK.
- In the
Connectdialog box, enter your Oracle database username and password, and then clickOK.
- 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 thenRegister Server.
- Click the
Generaltab.
- 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
Normalis selected.
- Uncheck
Save password.
- Next to "Host:", enter
dbserv.uits.indiana.edu.
- Next to "Port:", enter
1521.
- Next to "SID:", enter
oed1prd, and then clickOK.
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 clickConnect.
- In the
Authenticatewindow, next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
- Next to "Connect As:", make sure
Normalis selected, and then clickOK.
- 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. Useoed1prd_oraunless you encounter problems, in which case tryoed1prd_ms.
Last modified on August 04, 2011.







