Friday, 15 June 2012

ORACLE JAZN



==========================
ORACLE JAZN ON WINDOWS
==========================
SET ORACLE_HOME=D:\oracle\product\10.2.0\db_1
CD D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus
D:\oracle\product\10.2.0\db_1\jdk\bin\java -Djava.security.properties=D:\oracle\product\10.2.0\db_1\sqlplus\admin\iplus\provider -jar D:\oracle\product\10.2.0\db_1\oc4j\j2ee\home\jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell

JAZN:> adduser "iSQL*Plus DBA" oracle oracle
listusers "iSQL*Plus DBA"
admin
taj

JAZN:> grantrole webDba "iSQL*Plus DBA" oracle
JAZN:> exit

C:\Oracle\product\10.1.0\Db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>isqlplusctl stop
C:\Oracle\product\10.1.0\Db_1\BIN>isqlplusctl start

http://server4:5560/isqlplus/dba
user :taj
pwd:- oracle    //these password enter you to sys account

and see normal login


=============================
JASS COMMANDS CONNECTION:-
=============================
set ORACLE_HOME=c:\oracle\product\10.2.0\db_1
CD D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus
D:\oracle\product\10.2.0\db_1\jdk\bin\java -Djava.security.properties=D:\oracle\product\10.2.0\db_1\sqlplus\admin\iplus\provider -jar D:\oracle\product\10.2.0\db_1\oc4j\j2ee\home\jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell

JAZN> HELP

*Create Users
  JAZN> adduser "iSQL*Plus DBA" username password

*List Users
  JAZN> listusers "iSQL*Plus DBA"

*Grant Users the webDba Role
  JAZN>grantrole webDba "iSQL*Plus DBA" username

*Remove Users
  JAZN>remuser "iSQL*Plus DBA" username

*Revoke the webDba Role
  JAZN> revokerole webDba "iSQL*Plus DBA" username

*Change User Passwords
  JAZN> setpasswd "iSQL*Plus DBA" username old_password new_password

*Test iSQL*Plus DBA Access
 Test iSQL*Plus DBA access by entering the iSQL*Plus DBA URL in your web browser:
 http://machine_name.domain:5560/isqlplus/dba
 http://machine_name:5560/isqlplus/dba
 http://192.168.21.238:5560/isqlplus/dba


Enjoy All of You..........................?

10:49 AM 4/15/2011



=====================
ERROR
##Delete OracleOraDb10g_home1iSQL*Plus
Service not started and when you will start show error msg follow these command &
when show error msg popup is (failed to start the service error 0,the operation completed successfully)
=====================
to delete it service :
Eg:- sc delete service name
sc delete OracleOraDb10g_home1iSQL*Plus

No comments: