iSQL*PLUS 10g

iSQL*Plus

If you do not want to install the Oracle 10g client software on your computer (because it does take up a lot of disk space), there is a way to send queries to the database as well as execute scripts and do most things that you can do with SQL*Plus. This is by starting and using iSQL*Plus running on the Oracle server computer and then connecting to it using a web browser. Each installation of the Oracle 10g database will have iSQL*Plus available, though it needs to be started on the server first.

To start iSQL*Plus on a Linux system, log in to the computer where Oracle is

installed as the oracle user, i.e., the owner of the Oracle installation, and while ensuring that the PATH includes $ORACLE_HOME/bin, issue the command

isqlplusctl start

If you want to stop iSQL*Plus on Linux, issue the command

isqlplusctl stop

On Windows systems iSQL*Plus runs as a service and can be started and stopped

using the Services Microsoft Management Console (MMC). You can still use the isqlplusctl command to stop and start the service and check its status.

The best way to determine if iSQL*Plus is running, as well as to make use of it, is

to connect to it using a web browser and then specify the URL in the form 

where server is the name or IP address of the computer on which Oracle is running and port is the TCP port number on which iSQL*Plus is listening—usually 5560. If the Oracle Universal Installer detects that port 5560 is already in use, it will go to the next higher available port until it finds one that is free (5561, 5562, etc.). To determine what port is being

used, you can always check the contents of the portlist.ini file in $ORACLE_HOME/install

*****************************

[oracle@centos5 ~]$ isqlplusctl start

iSQL*Plus 10.2.0.1.0

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

getnameinfo failed

getnameinfo failed

Starting iSQL*Plus ...

iSQL*Plus started.

[oracle@centos5 10.2.0.1]$ cd $ORACLE_HOME/install

[oracle@centos5 install]$ pwd

/u01/app/oracle/product/10.2.0.1/install

[oracle@centos5 install]$ ls

createseed1.sh      jlib      portlist.ini       rootlocaladd  unix

createseed.sh       make.log  readme.txt         seed.log      utl

envVars.properties  oratab    rootdeletenode.sh  templocal

[oracle@centos5 install]$ more portlist.ini

iSQL*Plus HTTP port number =5560

Enterprise Manager Console HTTP Port (gaudi) = 1158

Enterprise Manager Agent Port (gaudi) = 3938

[oracle@centos5 install]$