1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

connect iSQL*Plus with SYS

Discussion in 'General' started by pankaj25, Nov 26, 2009.

  1. pankaj25

    pankaj25 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hello,
    I have Oracle 9i on Windows XP. I m able to connect iSQL*Plus(web-based) through Scott user easily. But when I try to connect it using SYS user, it prompts me for user name and password again, Could anyone tell me that how to connect iSQL*Plus through SYS user to perform administrative task.
     
  2. debasisdas

    debasisdas Active Member

    Messages:
    46
    Likes Received:
    3
    Trophy Points:
    90
    Location:
    Bangalore, India
    tyr this

    sys/ as sysdba
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    He is and that is failing for good reason: there is a different URL to enable isqlplus for admiinstrative use

    Code (Text):
    [url]http://machine_name.domain:port/isqlplusdba[/url]
    The difference is the 'dba' appended to isqlplus; without that addition isqlplus is nothing more than a user interface available from the web.

    Using the proper tool helps to ensure the proper result.
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
  5. pankaj25

    pankaj25 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80