8 Replies Latest reply: Nov 19, 2012 6:58 AM by 933363 RSS

    10G isqlplus for sysdba

    422664
      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
          Alison Holloway
          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
            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
              Alison Holloway
              Try this:

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

              C:\>cd %ORACLE_HOME%

              Alison
              • 4. Re: 10G isqlplus for sysdba
                238555
                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
                  Alison Holloway
                  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
                    user637981
                    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
                      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
                        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