Starting iSQL*Plus and connecting to a database is relatively easy. The most difficult part is to remember the URL to type into your web browser.
If you're the DBA, you may need to worry about starting the iSQL*Plus server. The concept is similar to starting an Oracle Net listener. The iSQL*Plus server is what clients running web browsers connect to when they enter the iSQL*Plus URL into their web browsers. Figure 3-1 illustrates.
Figure 3-1. iSQL*Plus architecture
To start the iSQL*Plus server in Oracle Database 10g on a Unix or Linux system, log in as the Oracle software owner and issue the isqlplusctl start command:
isqlplusctl startiSQL*Plus 10.1.0.2.0 Copyright (c) 2004 Oracle. All rights reserved. Starting iSQL*Plus ... iSQL*Plus started.
Once you've started iSQL*Plus on your server, clients will be able to freely connect and use iSQL*Plus via their web browsers. You can use the isqlplusctl stop command to shut down the iSQL*Plus server, although you'll normally want to leave iSQL*Plus running for as long as your database is open.
To start Oracle Database 10g's iSQL*Plus server under Windows, go to the Services control panel, look for the Oracle service with a name ending in "iSQL*Plus", and start that service.
You can also use isqlplusctl start to start the iSQL*Plus server under Windows. Issue the command from ...