iSQLPlus - Enable DBA Login
Use isqlplusctl to start iSQLPlus at least once to create jazn-data.xml.
With reference to the "SQL Plus User Guide and Reference", here are the steps to enable DBA login through iSQLPlus: (Take care of the slash and back slash)
cd %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus
%ORACLE_HOME/jdk\bin\java -Djava.security.properties=%ORACLE_HOME%\sqlplus\admin\iplus\provider -jar %ORACLE_HOME%\oc4j\j2ee\home\jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
JAZN> adduser "iSQL*Plus DBA" username password
E.g. JAZN> adduser "iSQL*Plus DBA" user1 password1
JAZN> listusers "iSQL*Plus DBA"
JAZN> grantrole webDba "iSQL*Plus DBA" username
JAZN> remuser "iSQL*Plus DBA" username
JAZN> revokerole webDba "iSQL*Plus DBA" username
JAZN> setpasswd "iSQL*Plus DBA" username old_password new_password
Access the iSQLPlus DBA login page http://machine:5560/isqlplus/dba
Reference:
SQL Plus User Guide and Reference -> Chapter 3 "Configuring SQL*Plus" -> "iSQL*Plus Application Server Configuration" -> "Enabling iSQL*Plus DBA Access" (b12170.pdf)
No comments:
Post a Comment