is ISQL Plus running

ISQL *plus Page
Isql*plus is a product independent of Enterprise Manager. The Isql*plus user interface runs in a Web browser connected to the Internet or your intranet. Isql*plus enables a Web browser to connect to a Oracle database and perform the same actions as for you would thro Ugh the command line version of Sql*plus (known as sql*plus in this guide). can use Isql*plus to write Sql*plus, SQL and Pl/sql commands to:

Enter, edit, run and save SQL commands and Pl/sql blocks.

Calculate, and print query results.

You can use the Isql*plus Workspace to write, load, save and execute scripts. You can enter scripts as your would in command line Sql*plus. The script output can is displayed in the Workspace screens or saved to a file on your client machine.

The ISQL *plus application can is used by two types of users; A database user with the NORMAL role and a WEBDBA user. For security reasons, if you are want to connect as Sysoper or SYSDBA, you must create and configure a WEBDBA user this is HTT P authenticated.

Configuring ISQL *plus

If you receive a error message page to click the ISQL *plus link on the Database home page and you should check the F Ollowing:
is ISQL *plus configured properly?
For Grid control, Isql*plus'll not is shipped with the OMS (Oracle Management Server). So ISQL *plus needs to is manually configured to the to the any running 10G ISQL server. All of the target databases discovered in this Grid control application'll use this ISQL *plus server for their queries.

For Database control, the ISQL *plus installation'll automatically configure to use the ISQL *plus server shipping with This target.

To configure ISQL *plus, two entries in the $ORACLE _home/sysman/config/emoms.properties file on the OMS (ORACLE Management Server) machine needs to is populated by replacing the following placeholders:replace,%isqlplus_protocol% t% and%isqlplus_port% with the Protocol, the host and the PORT of the ISQL *plus server.

For a database user with the NORMAL role:
Oracle.sysman.db.isqlplusurl=%isqlplus_protocol%\://%isqlplus_host%\:%isqlplus_port%/isqlplus/dynamic

For a database user with Sysoper and SYSDBA role (requires additional setup for ISQL *plus DBA access):
oracle.sysman.db.isqlpluswebdbaurl=%isqlplus_protocol%\://%isqlplus_host%\:%isqlplus_port%/isqlplus/dba/ Dynamic

For example:

Oracle.sysman.db.isqlplusurl=http://chablis.au.oracle.com:5560/isqlplus/dynamic

Oracle.sysman.db.isqlpluswebdbaurl=http://chablis.au.oracle.com:5560/isqlplus/dba/dynamic

For RAC applications, the emoms.properties file to all nodes to the cluster must also have these two entries.

After configuring the "entries", the OMS needs to is restarted to pick up the change.
Is ISQL *plus running?
If ISQL *plus is not started, your may start ISQL *plus using the command:

$ORACLE _home/bin/isqlplusctl Start
are isql* Plus DBA Access Set up?
If isql* Plus is configured properly, the ISQL *plus Connection role page prompts your to select the role you want to use T O Connect to ISQL *plus-Normal, Sysoper (WEBDBA) or SYSDBA (WEBDBA).

To connect as Sysoper or SYSDBA, the WEBDBA user must being set up and authenticated using the Oracle JAAS Provider, known as JAZN (Java authorizationn). This is Oracle ' s implementation the Java authentication and Authorization Service (JAAS). When ISQL *plus Webdba URL was invoked, you are must enter a valid JAZN and username in a password to dialog access to the Isql*plus the DBA URL. This username and password may is different to the username and password for your Oracle database instance.

For instructions in how to set up access to isql*plus the DBA URL, the Sql*plus User ' s Guide and Reference.

For more information about the Jaznadmin setup, and the Isql*plus installation and Configuration guide or go:

Wiggum.ce.columbia.edu:7778/iplus/help/us/toc.htm