O'Reilly logo

Oracle SQL*Plus: The Definitive Guide, 2nd Edition by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Starting iSQL*Plus

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.

Starting the iSQL*Plus Server

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.

iSQL*Plus architecture

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:

oracle@gennick02:~> isqlplusctl start
iSQL*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.

Tip

You can also use isqlplusctl start to start the iSQL*Plus server under Windows. Issue the command from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required