Enabling iSQL*Plus DBA Access

My Signature Article

Fellow below steps to enable iSQL*Plus DBA Access

Create users

List users

Grant the webDba role

Remove users

Revoke the webDba role

Change user passwords

Open Command Prompt

start ----> run ----> cmd [[hit enter]]

Change Directory

C:\>set ORACLE_HOME=c:\oracle\product\10.1.0\db_1

C:\>cd %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus

C:\Oracle\product\10.1.0\Db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>

Note: change ORACLE_HOME variable according your enviourment


open JAZN shell to configure OC4J setup

C:\Oracle\product\10.1.0\Db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>

c:\oracle\product\10.1.0\db_1\jdk\bin\java -Djava.security.properties=

c:\oracle\product\10.1.0\db_1\sqlplus\admin\iplus\provider -jar

c:\oracle\product\10.1.0\db_1\oc4j\j2ee\home\jazn.jar

-user "iSQL*Plus DBA/admin" -password welcome -shell

Note:
Above command description.

On command prompt
[[start]]
c:\> cd %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus [[continue]]
c:\oracle\product\10.1.0\db_1\jdk\bin\java
[[continue]]
-Djava.security.properties=c:\oracl
e\product\10.1.0\db_1\sqlplus\admin\iplus\provider -jar
[[continue]]
c:\oracle\product\10.1.0
\db_1\oc4j\j2ee\home\jazn.jar
[[continue]]
-user "iSQL*Plus DBA/admin" -password welcome -shell
[[end]]

Default username : "iSQL*Plus DBA/admin" admin
Default password : welcome (small case)



Create New User for "iSQL*Plus" DBA Access

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

Check Existing User and Verify new user created.

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

Grant "webDba" role to Above Created user.

JAZN:> grantrole webDba "iSQL*Plus DBA" taj

JAZN:> exit

Restart isqlplus services

C:\Oracle\product\10.1.0\Db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplu
s>isqlplusctl stop
iSQL*Plus 10.1.0.5.0
Copyright (c) 2005 Oracle. All rights reserved.
Stopping iSQL*Plus ...
iSQL*Plus stopped.

C:\Oracle\product\10.1.0\Db_1\BIN>isqlplusctl start
iSQL*Plus 10.1.0.5.0
Copyright (c) 2005 Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.