Pages

Tuesday, November 15, 2011

Login into ISQL*PLUS as SYSDBA


STEP # 1:

On DOS Prompt Set Java_Home , Oracle_home, Oracle_Sid

SET JAVA_HOME=d:\oracle\product\10.2.0\db_1\jdk
SET ORACLE_HOME=d:\oracle\product\10.2.0\db_1
SET ORACLE_SID=orcl


Navigate to following directory

cd d:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus

I type D: because my oracle installs D Drive à enter drive name where oracle install

d:\oracle\product\10.2.0\db_3\jdk\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

Now you are entered into  JAZN:>   Prompt
write the following steps on JAZN.  ( case sensitive).

JAZN:> adduser "iSQL*Plus DBA" xyz xyz
JAZN:> grantrole webDba "iSQL*Plus DBA" xyz
JAZN:> exit

STEP # 2:

Open Internal Explorer

On Address bar  type à http://host_name:5560/isqlplus
Security window open and ask for id / pass type username and password xyz/xyz ( as created in JAZN shell)


created by Syed Raheel



2 comments:

  1. JAZN:> grantrole WebDba "iSQL*Plus DBA" xyz
    The specified role does not exist in the realm.
    JAZN:>

    Why i am getting above error?

    ReplyDelete
    Replies
    1. use
      grantrole webDba...

      W is small<<<< typo mistake

      Delete