Oracle Database10g Client - Autorun
window to open.File Download - SecurityWarning
dialog box, click Save, and then select adestination folder. Then, click Save.Oracle 10g Client(10.1.0.2)
. Once the installation program has loaded, clickNext.C:IUware OnlineOracle 10g Client (10.1.0.2)
. If youwould like to change to a different folder, clickBrowse... To continue, click Install.Information needed | Example (for Oed1prd) |
---|---|
Version of the database to connect to (8 or 8i or later) | 8i or later |
Name or System Identifier (SID) of the database and the full service name of the database | SID = oed1prd Service name = oed1prd.world (recommended) |
Port number | The default port is 1521. |
Name of the host computer where the database is located | dbserv.uits.indiana.edu |
Installation Types
window. Unless you knowthat you want another type of installation, select Custom.Once you have selected your installation type, click Next.Available Product Components
window, in thefollowing order, select: Oracle Net Configuration Assistant:Welcome
window, you have two options: Naming Methods Configuration
windowdisplays Local Naming
in the box labeled 'Selected NamingMethods'. Click Next. oed1prd.uits.indiana.edu
), and then clickNext. If you do not know the Service Name, check withthe database administrator.Oed1prd
, the hostname isdbserv.uits.indiana.edu
. Unless specifiedotherwise, leave the port number as the default port, 1521. Tocontinue, click Next.oed1prd.world
. Click Next.oed1prd
rather than oed1prd.world
) can causeconnection problems. You can also use the same name as the SID andextension that you entered in step 3 above (e.g.,oed1prd.uits.indiana.edu
).oed1prd.uits.indiana.edu
), and then clickNext. If you do not know the Service Name, check withthe database administrator.Oed1prd
, the hostname isdbserv.uits.indiana.edu
. Unless you are instructedotherwise, select Use the standard port number of 1521. Tocontinue, click Next. oed1prd.world
. Click Next.oed1prd
rather than oed1prd.world
) can causeconnection problems. You can also use the same name as the SID andextension that you entered in step 4 above (e.g.,oed1prd.uits.indiana.edu
). oed1prd.world
or oed1prd.uits.indiana.edu
). Click OK.ODBC Data Source Administrator
window, select the System DSN tab, and then clickAdd... Oed1prd
database on dbserv.uits.indiana.edu
:Field | Explanation | Example |
---|---|---|
Data source name | User-specified name by which you will refer to this ODBC data source | oed1prd_ora |
Description | Not required; just a phrase reminding you why you created this ODBC data source | Oracle ODBC for Oed1prd database on dbserv.uits.indiana.edu |
TNS service name | The Oracle Net Service Name you created for the database to which you want to connect | |
User name | Usually left blank; you will be prompted for this later when you make an ODBC connection to the database |
dss1dev.uits.indiana.edu
iedssdev.uits.indiana.edu
1521
(default)dss1dev.uits.indiana.edu
dss1tst.uits.indiana.edu
esdbd99.uits.iupui.edu
1521
(default)dss1tst.uits.indiana.edu
dss1prd.uits.indiana.edu
esdbd100.uits.indiana.edu
1521
(default)dss1prd.uits.indiana.edu