Home » RDBMS Server » Server Administration » iSQL*Plus login for DBA
iSQL*Plus login for DBA [message #526761] Wed, 12 October 2011 20:23 Go to next message
harshpatel
Messages: 6
Registered: August 2011
Location: Ahmedabad
Junior Member

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

Re: iSQL*Plus login for DBA [message #526762 is a reply to message #526761] Wed, 12 October 2011 20:27 Go to previous message
BlackSwan
Messages: 21945
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

isqlplus is obsoleted & no longer distributed or supported
Previous Topic: subpartition template view
Next Topic: find out what have been assign to a role
Goto Forum:
  


Current Time: Sat Apr 19 01:04:29 CDT 2014

Total time taken to generate the page: 0.10825 seconds