Search This Blog

Saturday, June 23, 2007

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.











11 comments:

حسن أمين said...

Dear Mohammad Taj ..
i'm very grateful for your valuable and helpful post..
i really can't thank you much..
:)
thank you sir .. hope you are doing great..
i was in a problem and your post really helped me very well..
thank you again ..
best wishes

Anonymous said...

THANK YOU VERY MUCH!

Anonymous said...

He dude thanks a lot your article helped me to resolve my issue.
Thanks a ton!!!!
Varun

He said...

This is the thing i wanted for a long time keep it up yar

Voyage said...

Thanks alot sir

I am truly greatful to u .
I am searching for this topic from past 3 days & not found stuff like this...thanks sir..
God Bless u

Voyage said...

Thanks a ton Sir

I am searching for this topic for last 3 days & don't find stuff like this....it is written in such a simple manner..!!

God Bless U

Voyage said...

Thanks alot sir

I am truly greatful to u .
I am searching for this topic from past 3 days & not found stuff like this...thanks sir..
God Bless u

Anonymous said...

Thanks a lot, very helpful article.

Regards,
Ajmal Ahmed.

Anonymous said...

Sir I need help In this concept my self I installed oracle 10.2 I have same problem how to solve this

Unknown said...

the following error I found when I wanna access
ERROR - ORA-01031: insufficient privileges

Can u assist me to relove this

Unknown said...

I got the following error
ERROR - ORA-01031: insufficient privileges

can u please assist me to resolve it