This discussion is archived
3 Replies Latest reply: Apr 25, 2013 10:33 PM by Nitesh. RSS

Confusion with isql*plus

972355 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Check if this link might of some help

    SQLPLUS login as SYSDBA
  • 3. Re: Confusion with isql*plus
    Nitesh. Explorer
    Currently Being Moderated
    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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points