4-10. Setting up iSQL*PLUS for SYSDBA and SYSOPER access

For a user to login to iSQL*PLUS as SYSDBA or SYSOPER you must set up the user in the OC4J user manager by performing the following steps:

  1. Create a user
  2. Grant the webDba role to the user
$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus$ $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 -shell

JAZN> add user "iSQL*Plus DBA" username passwordJAZN> grantrole webDba "iSQL*Plus DBA" username

March 10, 2008. isqlplus. Leave a comment.

4-9. Using iSQL*Plus

ISQL*Plus has a server-side listener process that must be started before you can connect with a browser. To start this server process, use:

isqlplusctl start

After thes server process is started, connect to it by entering the following URL in a browser:

http://host:port/isqlplus

The port number that is used by iSQL*Plus is usually 5560 unless Oracle Universal Installer detects that something is already using that port. Check $ORACLE_HOME/install/portlist.ini to find the port used by iSQL*PLUS

March 10, 2008. isqlplus. Leave a comment.