This discussion is archived
8 Replies Latest reply: Nov 19, 2012 6:58 AM by 933363 RSS

10G isqlplus for sysdba

422664 Newbie
Currently Being Moderated
O/S xp pro sp 2, downloaded java.
using SQL*Plus®User’s Guide and Reference:
Enabling iSQL*Plus DBA Access:
How do I do
To start the JAZN shell, enter:
$JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_
HOME/sqlplus/admin/iplus/provider -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar
-user "iSQL*Plus DBA/admin" -password admin_password -shell ?

Thanks Eric
  • 1. Re: 10G isqlplus for sysdba
    4783 Newbie
    Currently Being Moderated
    You need to open up a command window using:

    Start > Run

    then enter "command" and click OK.

    In the command window, enter the following, but use your own paths/variables:

    set ORACLE_HOME=c:\myOracleHome
    set ORACLE_SID=mydb
    set JAVA_HOME=%ORACLE_HOME%\jdk

    Then run the JAZN commands, again, substituting the username and password for your own:

    cd %ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus

    %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 -adduser "iSQL*Plus DBA" myiSQLPlusUserName myiSQL*PlusUserPassword

    %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 -grantrole webDba "iSQL*Plus DBA" myiSQLPlusUserName

    Alison
  • 2. Re: 10G isqlplus for sysdba
    422664 Newbie
    Currently Being Moderated
    Sorry for the dumb ?, but unable to get set to work,
    Using xp pro sp 2, from the command prompt, I get:
    C:\>set oracle_home=c:\hold

    C:\>cd oracle_home
    The system cannot find the path specified.
    or
    C:\>cd %oracle_home
    The system cannot find the path specified.

    ??
    Thank you very mush for your help.



  • 3. Re: 10G isqlplus for sysdba
    4783 Newbie
    Currently Being Moderated
    Try this:

    C:\>set ORACLE_HOME="c:\hold"

    C:\>cd %ORACLE_HOME%

    Alison
  • 4. Re: 10G isqlplus for sysdba
    238555 Newbie
    Currently Being Moderated
    Alison,

    Thanks for the instructions! I briefly tried to do this yesterday per the documentation and it wasn't working. Your steps worked perfectly.

    ...don
  • 5. Re: 10G isqlplus for sysdba
    4783 Newbie
    Currently Being Moderated
    Don,

    I'm glad you're up and running. I will ask that the documentation includes some Windows syntax for future editions of the reference guide.

    Alison
  • 6. Re: 10G isqlplus for sysdba
    640984 Newbie
    Currently Being Moderated
    After doing all the steps I got this error:

    " The specified role does not exist in the realm. "

    I am using Oracle 10g R2 version 10.2.0.3.0
    and OS is Windows

    can you help me?
  • 7. Re: 10G isqlplus for sysdba
    876000 Newbie
    Currently Being Moderated
    Hy Sir
    I have tried all of your provided steps on Windows XP. I got no error but still I am unable to Connect I*Sqlplus .please tell me what user name i should give in POP Up window asking user name and Password

    Regards
    Daisy
  • 8. Re: 10G isqlplus for sysdba
    933363 Newbie
    Currently Being Moderated
    C:\Users\User>set oracle_sid=si
    C:\Users\User>emctl
    EM Configuration issue. D:\oracle\product\10.2.0\db_1/192.168.0.50_si not found.+
    C:\Users\User>isqlplusctl stop
    iSQL*Plus 10.2.0.1.0
    Copyright (c) 2003, 2005, Oracle. All rights reserved.
    Stopping iSQL*Plus ...
    iSQL*Plus stopped.
    C:\Users\User>set ORACLE_HOME=D:\oracle\product\10.2.0\db_1
    C:\Users\User>set JAVA_HOME=%ORACLE_HOME%\jdk
    C:\Users\User>cd %oracle_home%\oc4j\j2ee\isqlplus\application-deployments\isqlpl
    us
    C:\Users\User>d:
    D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplu
    s>%JAVA_HOME%\bin\java -Djava.security.properties=%ORACLE_HOME%\oc4j\j2ee\home\c
    onfig\jazn.security.props -jar %ORACLE_HOME%\oc4j\j2ee\home\jazn.jar -user "iSQL
    *Plus DBA/admin" -password welcome -shell
    JAZN:> adduser "iSQL*Plus DBA" sirajul sirajul
    JAZN:> grantrole webDba "iSQL*Plus DBA" sirajul
    JAZN:> listusers "iSQL*Plus DBA"
    Admin
    sirajul
    JAZN:> exit
    JAZN:>
    java.io.FileNotFoundException: D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\
    application-deployments\isqlplus\config\jazn-data.xml (Access is denied)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:70)
    at oracle.security.jazn.spi.xml.FSXMLStore.getJAZNWriter(Unknown Source)

    at oracle.security.jazn.spi.xml.XMLJAZNProvider.persist(Unknown Source)
    at oracle.security.jazn.util.PersistenceService$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at oracle.security.jazn.util.PersistenceService$PersistenceThread.run(Un
    known Source)
    ---is it normal?

    D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplu
    s>isqlplusctl start
    iSQL*Plus 10.2.0.1.0
    Copyright (c) 2003, 2005, Oracle. All rights reserved.
    Starting iSQL*Plus ...
    iSQL*Plus started.

    D:\oracle\product\10.2.0\db_1\BIN>c:

    C:\Users\User>

    then in browser
    user-pc:5560/isqlplus/dba

    a dialog box for authentication
    username: sirajul
    password: sirajul

    ok> returns to the same dialog box for authentication
    Help please!

    OS Name: Microsoft Windows 7 Ultimate
    OS Version: 6.1.7600 N/A Build 7600
    OS Manufacturer: Microsoft Corporation
    VERSION
    ------------
    10.2.0.1.0