Question

  Asked: Apr 24 2008   4:00 PM GMT
  Asked by: Itsee


connect sys as sysdba


TOAD, iSQLPlus, connect sys as sysdba, SYSDBA

how to connect sys as sysdba in toad software and in isqlplus.
When i tried in isqlplus and in toad by connecting as
"sys as sysdba" i got the error. please give me a solution.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



In Toad, type sys in the User/Schema textbox, it's password in the Password textbox and change the Connect As dropdown to be SYSDBA.

You cannot log into isqlplus as sys as sysdba. You will get an error SP2-0927 - CONNECT AS SYSDBA OR AS SYSOPER not allowed through iSQL*Plus URL.

Hope this helps.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and Oracle.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register