iSQL*Plus Architecture

iSQL*Plus uses a three-tier architectural model comprising:

• Client Tier (iSQL*Plus user interface, typically a web browser).

• Middle Tier (iSQL*Plus Server, Oracle Net, and Oracle HTTP Server).

• Database Tier (Oracle9i).

  
  
  Text description of the illustration arch.gif

The three tiers may or may not be on the same machine. The iSQL*Plus Server must be on the same machine as the Oracle HTTP Server. The middle tier coordinates interactions and resources between the client tier and the database tier. The database tier is Oracle9i. Oracle9i can be installed and accessed on the middle tier, or accessed via Oracle Net.

iSQL*Plus User Interface

The iSQL*Plus user interface runs in a web browser connected to the Internet or your intranet. You only need to know the URL of the Oracle HTTP Server to access Oracle9i.

Oracle HTTP Server

The middle tier contains the Oracle HTTP Server and the iSQL*Plus Server. The iSQL*Plus Server enables communication and authentication between the iSQL*Plus user interface and Oracle9i. Each iSQL*Plus session is uniquely identified, so you can have multiple concurrent sessions open to Oracle9i.

Oracle9i

Oracle Net components provide communication between the iSQL*Plus Server and Oracle9i in the same way as for a client server installation of Oracle9i.