New Feature of oracle9i: ISQLPLUS (Web Apache access)

ArticleDirectory

• New Feature of oracle9i: ISQLPLUS

/Files/jifeng/oracle9inew special isqlplus.doc

 

The file content is as follows:

 

 

New Feature of oracle9i: ISQLPLUS

ISQLPLUS is a new function provided by Oracle9i and is released in the web form of sqlplus. It is designed based on a three-tier structure.
Its client, middle, and server can be located on the same machine or on different machines. ISQLPLUS does not need to be installed separately. Access ISQLPLUS
You only need to know the address and port of the intermediate layer server. You can log in as a standard user or sysdba or sysoper.
ISQL * Plus provides a fast browser-based interface. It uses the SQL * Plus processing engine through a three-tier model. This model includes:

Client layer (iSQL * Plus user interface, usually a web browser ).

Middle Layer (iSQL * Plus server, Oracle Net, and Oracle HTTP Server ).

Database layer (Oracle9i ).

 

These three layers can be located on the same computer or on different computers. The iSQL * Plus server must be on the same computer as the Oracle HTTP Server.

The middle layer coordinates the interaction and resources between the client layer and the database layer. The database layer is Oracle9i and can be accessed through Oracle Net.

The following is a detailed introduction.

1. Start the HTTP server on the server

Start HTTP server powered by Apache

2. Access the HTTP server through a browser

Generally, our port and protocol are set by default:

HTTP 7778 port/HTTPS 4443 PortMy lack of recognition is set to port 80

Note: different versions may use different ports. You can view the default port settings in the ports. ini file under $ ORACLE_HOME/Apache.

If you need to change the port, you can modify the port settings by adjusting the $ ORACLE_HOME/Apache/CONF/httpd. conf file.

 

In this example, set:

Http: // ggqiang: 7778

Https: // ggqiang: 4443

After the browser is entered, the following information is displayed:

 

Or:

 

3. Start ISQLPLUS

Enter

Http: // machine_name.domain: Port/isqlplus

You can start ISQLPLUS:

 

Enter the username, password, and other information to log on to the database and execute SQL statements and script files.

It can also be loaded and called for execution:

4. log in as sysdba

 

To Log On As sysdba, run:

Http: // machine_name.domain: 7778/isqlplusdba

This requires you to enter the HTTP server password, which is different from database authentication.

 

Create an authentication password file:

D: \ oracle \ ora92 \ apache \ bin> htpasswd:/Oracle/ora92/sqlplus/admin/iplusdba. Pw Admin Automatically using MD5 format on Windows. New Password :***** Re-type new password :***** Adding password for user admin

Then you can use this user to log on to the database as sysdba:

 

Log On As sysdba:

Start and Stop a database as sysdba:

 

4. startup service reference

Microsoft Windows 2000 [version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.   C: \> PS-Ef | grep Oracle System 816 240 0 19:23:12 conin $ D: \ oracle \ ora92 \ bin \ omtsreco.exe "oraclemtsrecoveryservice" System 1132 240 0 19:23:32 conin $ D: \ oracle \ ora81 \ bin \ dbsnmp.exe System 296 240 0 19:23:48 conin $ "D: \ oracle \ ora92 \ apache \ apache.exe" -- ntservice System 1192 240 0 19:23:50 conin $ D: \ oracle \ ora92 \ bin \ tnslsnr System 1212 240 0 19:23:52 conin $ D: \ oracle \ ora92 \ bin \ oracle. EXE vilen System 1432 296 0 19:24:14 conin $ "D: \ oracle \ ora92 \ apache \ apache.exe"-Z ap296_c1-F "D:/Oracle/ora92/Apache/CONF/httpd. conf" "-d" "D:/Oracle/ora92/Apache" "-F" "D:/Oracle/ora92/Apache/CONF/httpd. conf" System 1696 1432 0 19:24:16 conin $ D: \ oracle \ ora92 \ JDK \ bin \ java.exe-doracle_home = D: \ oracle \ ora92 org. Apache. jserv. jserv-opmpropfile D: \ oracle \ ora92 \ apache \ jserv \ conf \ jserv. properties-opmhost eygle-opmport 3339-opmgrp group1-opmindex 0-opmprocid 1 System 1704 1432 0 19:24:16 conin $ D: \ oracle \ ora92 \ JDK \ bin \ java.exe org. Apache. jserv. jserv -Opmpropfile D: \ oracle \ ora92 \ apache \ jserv \ conf \ jservsoap. properties-opmhost Eygle-opmport 3339-opmgrp group2-opmindex 0-opmprocid 2 System 1712 1432 0 19:24:16 conin $ "D:/Oracle/ora92/bin/isqlplus"   C: \>

 

 

For more information, see:

SQL * Plus Quick Reference release 9.2 part No. A90843-01

ISQLPLUS online help manual