TEC 5323 Advanced Database Technology
Supplemental Reading of Chapter 3
TEC 5323 Advanced Database Technology
Supplemental Reading of Chapter 3
Oracle Client is a site where a typical corporate user can access the data in the database server. As an example, the following section describes ways to set up a typical Oracle client connecting to the database server in the School of Technology at Eastern Illinois University.
Oracle Client Setup or Installation
If you have already installed Oracle8i/9i/10g enterprise edition, the client software has been already installed in your computer. You need only to use Net Manger to configure your computer as a client to the host database in the School of Technology.
1. It is a good idea to test the network connection before installing Oracle client:
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 31-JAN-20
05 08:56:19Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\OraHome2\network\admin\sqlnet.oraUsed HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=oracle1.ei
u.edu))(ADDRESS=(PROTOCOL=TCP)(HOST=oracle1.eiu.edu)(PORT=1521)))
OK (130 msec)
If above steps are successful, your network connection is established and your database is ready to connect. You will be able to connect to the database server at the School of Technology.
2. Client Installation: If you completed your Project I successfully, please proceed with step 3.
If you have at least Windows 95 or Windows 98 with a minimum of 64 MB RAM, you may install Oracle client for connecting to the Oracle database server in the School of Technology.
The procedure was developed with Oracle8i, which Net Manger was called Net8. Basic ideas and procedure remain similar. If you like to see detailed procedure of installing Oracle client on Windows 98, click here.
Parameters for Client Installation:
| Net Service Name: | oracle1 |
| Protocol: | TCP/IP |
| Host Name: | oracle1.eiu.edu |
| Port Number: | 1521 |
| (Oracle 8i) Service Name: | oracle1.techdata1.eiu.edu |
|
Oracle8i Connection Type: |
Database Default |
3. Client Setup:
After you complete your Project I, if you installed Oracle 8i/9i/10g enterprise edition, client software has already been installed in your computer. All you need to do is to set up your computer as a client to the host database in the School of Technology. To accomplish your task, you will need to use Net Manager from Oracle, which has already been installed in your computer. You may use the parameters in the following table to set up Net8 (Net Manager) client. Click here for detailed procedure to set up Net8. Procedure for Oracle9i and 10g is very similar.
Parameters for Client Setup:
| Net Service Name: | oracle1 |
| Protocol: | TCP/IP |
| Host Name: | oracle1.eiu.edu |
| Port Number: | 1521 |
| (Oracle 8i) Service Name: | oracle1.techdata1.eiu.edu |
|
Oracle8i Connection Type: |
Database Default |
4. Once you have installed or set up your client site, you may test the connection to the central database (oracle1.techdata1.eiu.edu) in the School of Technology . The server (oracle1.eiu.edu) is physically located in Klehm Hall on campus. Your own computer is a client.
The testing procedure is as follows:
|
User Name:
|
scott
|
|
Password:
|
tiger
|
|
Host String:
|
oracle1
|
After you successfully log in SQL Plus, type the following command lines:
SQL>
2SELECT username
FROM all_users;
SQL Plus will display query results as which users are on the database system. You may use your mouse to highlight the results, then use "Copy" in Edit menu and paste it in your Notepad or Microsoft Word. Or, you may use ctrl+C to copy it in the computer clipboard, and paste it your Notepad or Microsoft Word.
Off the Subject:
Doctor on Operation: