ISQL*Plus

· Article	*How to configure/install iSQLPlus**
· Database Version	Oracle Version 9.0.1.x / 9.2.0.2
· Article Revision Date	15-FEB-2003
· Web	www.SamOraTech.com
· Author	Sameer Wadhwa

How to configure/install iSQL*Plus

Find out port # and server name

Open in NotePad <Oracle Home>\Apache\Apache\conf\httpd.conf and find out PORT # and SERVERNAME

In my case I found PORT value 7778 and SERVERNAME sameer.xyz.com in D:\oracle\ora92\Apache\Apache\conf\httpd.conf file

Type the URL in the browser as http://<host.domain>:port#/isqlplus

In my case this is. http://sameer.xyz.com:7778/isqlplus.

You will see the isqlplus login screen at this point.

Make a entry in the tnsnames.ora to connect to the desired database

Enter the valid username/password and connect string to connect to the database whose entry you made in step 3.

How to connect to iSQL*PLUS through sysdba or sysoper

Go to DOS prompt

2. Assign a user and password for authorization to login as sysdba or sysoper as

D:\oracle\ora92\Apache\Apache\bin>htpasswd –b D:\oracle\ora92\sqlplus\admin\iplusdba.pw orsysuser samdba

orasysuser is a user and samdba is a password

Note :- Stop and Start the HTTP server after running the above command

Invoke the sqlplus login for sysdba/sysoper privilege by typing the following URL in the browser as (http://<host.domain>:port/isqlplusdba)

http://sameer.xyz.com:7778/isqlplusdba

Isqlplus will prompt you username and password . Enter the username and password which you created in step 2. A new login screen will appear with a privilege combo box with a option sysdba and sysoper.

Some Examples

Example 1:-

How to create HTML heading for a script file

1.Add alias to httpd.conf file as follows

Alias /myscript/ "C:\TEMP/"

1a. Make a sql file test.sql and put it in c:\temp folder

2 .Restart the HTTP server

3. Make a html file as follows

TEST.html

<HTML>

<HEAD>

<TITLE>iSQL*Plus Dynamic Report</TITLE>

</HEAD>

<BODY>

<H1><i>Test Report though iSQL*PLUS</i></H1>

<p><A HREF="http://sameer.xyz.com:7778/isqlplus?script=http://sameer.xyz.com:7778/myscript/test.sql">

Run Test Report</A> </p>

</BODY>

</HTML>

Open the html file in a browser

Example 2 (configure Login):

<HTML>

<HEAD>

<TITLE>iSQL*Plus Dynamic Report</TITLE>

</HEAD>

<BODY>

<H1><i>Test Report though iSQL*PLUS</i></H1>

<FORM METHOD=get ACTION="http://sameer.xyz.com:7778/isqlplus"><p>

<INPUT TYPE="text" NAME="userid" value="scott/tiger@sameer">

<INPUT TYPE="hidden" NAME="script" VALUE="http://sameer.xyz.com:7778/myscript/test.sql">

<INPUT TYPE="submit" VALUE="Search">

</BODY>

</HTML>

Example 3

<HTML>

<HEAD>

<TITLE>Database Info</TITLE>

</HEAD>

<BODY>

<H1><i>Database info</i></H1>

<FORM METHOD=get ACTION="http://sameer.xyz.com:7778/isqlplusdba"><p>

<INPUT TYPE="text" NAME="userid" value="sys/pass@sameer as sysdba">

<INPUT TYPE="hidden" NAME="script" VALUE="http://sameer.xyz.com:7778/myscript/test.sql">

<INPUT TYPE="submit" VALUE="Search">

</BODY>

</HTML>

Here is the test.sql

set markup html ON

Prompt Database Info

select * from v$database;

Prompt Version Info

select * from v$version;

Prompt Instance Info

select * from v$instance;

Prompt Control files

select * from V$controlfile;

Prompt Data files

select * from DBa_Data_files;

End of Article/Tip

Hope this helps

Sameer Wadhwa

Feedback/Comments or suggestions are most welcome.