Sqlplus Login Box problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Sqlplus Login Box problem

  1. #1
    Join Date
    Jan 2002
    Posts
    146
    Hi,

    In Oracle 9i you can connect to sys as sysdba/sysoper only.
    How will I connect to sys as sysdba using the sqlplus
    login dialog box? where you have

    User Name : ____________

    Password : ____________

    Host String : ____________

    I tried putting "as sysdba" on either of the 3 fields but
    I can not connect.

    Please help.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You must put it in host string field of your loging dialog box, after your actual Net service name.

    Suppose your Net service name is "ORCL.acme.com", so you enter the following string into your host string field (without the double quotes);

    "ORCL.acme.com as sysdba"

    It works for me.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jul 2002
    Posts
    132
    try : "sys as sysdba" as username(enclose in quotes).
    What is the error u r getting?

  4. #4
    Join Date
    Jan 2002
    Posts
    146
    Thanks Jmodic,

  5. #5
    Join Date
    Jan 2002
    Posts
    146
    Hi,

    Is there a way to override this sysdba requirement
    for sys? Actually my problem is I have a 3rd-party
    Apps and it uses a login dialog box similar to
    sqlplus to connect to SYS during installation.
    It has the ff. fields:

    user: __________ maximo

    passord : _________ maximo

    database : _________ ora9 as sysdba


    *error database is too large

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by rommel
    Is there a way to override this sysdba requirement
    for sys?
    No, not in 9i.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width