Home > IT Answers > Development > connect sys as sysdba
Help

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
Help

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

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 25 2008  2:28 PM GMT  by Dwaltr




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.


RSS - Discussions Help

Discuss This Answer


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