| iSQL*Plus login for DBA [message #526761] |
Wed, 12 October 2011 20:23  |
|
|
iSQL*Plus login for SYSDBA
Step-1)
Export the java path.
[harsh@esparkinfo]$ export JAVA_HOME=$ORACLE_HOME/jdk
Step-2)
Change the directory.
[harsh@esparkinfo]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
Step-3)
Run the JAZN prompt.
[harsh@esparkinfo]$ $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.
harsh.esparkinfo:5560/isqlplus/dba
Harsh
-----------------------------------------
Jr.DBA
[EDITED by LF: removed an advertising link]
[Updated on: Thu, 13 October 2011 01:00] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
