How to logon toad as sys user in Oracle 9.2.0.1.0
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to logon toad as sys user in Oracle 9.2.0.1.0

  1. #1
    Join Date
    May 2001
    Location
    Fairfax, virginia
    Posts
    23

    Unhappy

    Hello, Everyone,

    I have a question:

    I use Oracle 9i release2 in win 2k server. when I tried to logon in Toad as sys, toad prompt: you must logon user sys as sysdba or sysoper. I created a password file in SQL*PLus, and issued command: connect sys/... @... as sysdba, and then tried to logon in toad as sys, still the same propmt, so I can't login. Could anyone tell me how should I do if I want to logon in toad as user sys in Oracle 9.2.0.1.0. ?
    (In Oracle 8i, I never met this problem)

    Thanks a lot!

    Gary

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Which release of TOAD are you using? You must have an old release of TOAD. Newer releases have a separate logon option where you can choose if you want to connect as NORMA, SYSOPER or as SYSDBA.

    From 9i on you can't connect as SYS without using AS SYSOPER/SYSDBA option, so unless you have a release of TOAD that enables you to choose it you won't be able to connect as SYS. You'll have to upgrade your TOAD.
    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