ARTICLES

iSQL*Plus DBA URL Configuration – Windows                     Download PDF

You can connect to iSQPL*Plus to perform database administration tasks as starting and stopping a database by using the iSQL*Plus DBA URL. To use this URL you must connect as either the SYSDBA or SYSOPER roles. You will need to authenticate yourself twice as a DBA. The first authentication is the DBA username and password; process described below. The second authentication involves you choosing either the SYSDBA or SYSOPER roles and then using your Oracle database username and password. Before you can connect as a DBA you must create a special username and password.

    1.      To configure the iSQL*Plus DBA URL you must perform these steps from the following directory:

    %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus
    2.      In this directory run the following commands:

    set ORACLE_HOME=[your-oracle-home]

    set JAVA_HOME=%ORACLE_HOME%\jdk

    cd %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus

    Note: Replace to the location of your Oracle Home on your machine. This location is where Oracle was installed.
    3.      You will use JAZN to add a user and assign a role to access the iSQL*Plus DBA URL. Run the following commands:

    %JAVA_HOME%\bin\java –Djava.security.properties=
    %ORACLE_HOME%\oc4j\j2ee\home\config\jazn.security.props –jar
    %ORACLE_HOME%\oc4j\j2ee\home\jazn.jar –user “iSQL*Plus DBA/admin” –password welcome –adduser “iSQL*Plus DBA” iplusdba iplusdba

    %JAVA_HOME%\bin\java –Djava.security.properties=
    %ORACLE_HOME%\oc4j\j2ee\home\config\jazn.security.props –jar
    %ORACLE_HOME%\oc4j\j2ee\home\jazn.jar –user “iSQL*Plus DBA/admin” –password
    welcome –grantrole webDba “iSQL*Plus DBA” iplusdba
    4.      Test iSQL*Plus DBA URL Access

    To test URL access, enter the iSQL*Plus DBA URL in your web browser:

    http://[machine_name.domain:5560]/isqlplus/dba
    5.      A dialog box will appear requiring authentication for the the iSQL*Plus DBA URL. Enter the username and password you created above.

    6.      If authentication is valid you will be brought to the iSQL*Plus login screen. Enter the username and password you created above and set the privilege to SYSDBA.

    7.      Click Login. You should be at the Workspace.