Re: connecting to TOAD

On Thu, 26 Aug 2004 00:37:49 GMT, "c.o.jones" <nospam.ple_at_se> wrote:

>How do I connect to TOAD as SYS?
>
>If I try to connect with :
>
>Database [GDN]
>User / schema [sys]
>Password [*******]
>
>Then I get the error "connection should be as sysdba or sysoper"
>
>How do I specify connecting as sysdba?
>
>I've tried using : Database [GDN as sysdba]
>but that gives the error "could not resolve service name"
>
>I've tried using User / schema [sys as sysdba]
>but that gives the error " invalid username/password; logon denied"
>
>
>
>
>

If you are using TOAD to connect to a database, there is a combobox showing Normal, sysdba, or sysoper below the password field. Needless to say you have to use that one.

--
Sybrand Bakker, Senior Oracle DBA