ISQL*Plus login for SYSDBA

iSQL*Plus login for SYSDBA

Step-1)
Export the java path.
[harsh@esparkinfo.com]$ export JAVA_HOME=$ORACLE_HOME/jdk

Step-2)
Change the directory.
[harsh@esparkinfo.com]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus

Step-3)
Run the JAZN prompt.
[harsh@esparkinfo.com]$ $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

Step-4)
Create user and grant the webDba role to the user.
JAZN>adduser “iSQL*Plus DBA” username password
JAZN>grantrole webDba “iSQL*Plus DBA” username
JAZN>exit

Step-5)
List the user.
JAZN> listusers "iSQL*Plus DBA"
Remove user.
JAZN> remuser "iSQL*Plus DBA" username

Revoke the webDba role
JAZN> revokerole webDba "iSQL*Plus DBA" username
Change user password.
JAZN> setpasswd "iSQL*Plus DBA" username old_password new_password

Step-6)
Login through web browser.
url:5560/isqlplus/dba