3 Replies Latest reply: Apr 26, 2013 12:33 AM by Nitesh. RSS

    Confusion with isql*plus

    972355
      good Morning to all;

      What's the procedure to start isql*plus in oracle 10g ?

      DB created using OUI. When i trying to connect following url getting


      SQL*Plus URL:
      http://rhel5.myserver:5560/isqlplus

      iSQL*Plus DBA URL:
      http://rhel5.myserver:5560/isqlplus/dba


      Should i start isql*plus manually ?
        • 1. Re: Confusion with isql*plus
          972355
          Hello to all ;

          I enabled isql*Plus but i can't connect as sysdba ..

          In iSQL*Plus login screen how can i issue command to connect as sysdba
          I entered like this method
          username : sys as sysdba
          password : xxxxxxxxxx
          CONNECT IDENTIFIER : ORCL
          When i am using above method i am getting error
          *SP2-0306 - Invalid option. Usage: CONN[ECT] username/password[@connect_identifier] [AS {SYSOPER|SYSDBA}] or: CONN[ECT] /[@connect_identifier] AS SYSOPER*
                    
          Please provide a  way to connect  as  sysdba  via iSQLPlus ..*
          • 2. Re: Confusion with isql*plus
            TSharma-Oracle
            Check if this link might of some help

            SQLPLUS login as SYSDBA
            • 3. Re: Confusion with isql*plus
              Nitesh.
              Very simple dude give command as connect sys@orcl as sysdba
              enter your password :

              Connect identifier is your orcl which is database in which you want to connect .. Because sys is user/schema which can get connect to any database which is having all privileges so client wont understand if you dont mention DB name which is called as connect identifier ..


              Regards..