Re: Connecting as Sys with Toad and 9i
From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 19 Apr 2002 20:08:50 GMT
Message-ID: <mP_v8.43064$VQ2.27147959_at_twister.socal.rr.com>
Date: Fri, 19 Apr 2002 20:08:50 GMT
Message-ID: <mP_v8.43064$VQ2.27147959_at_twister.socal.rr.com>
You'll have to use to 'password file authentication' ...
- orapwd file=$ORACLE_HOME/dbs/orapw password=<sys password> entries=<users>
Make sure to set entries higher than the number of users you will ever grant sysdba to.
as sys ...
2. alter system set remote_login_passwordfile = exclusive scope = spfile;
That's assuming you're using an spfile otherwise add it to your init.ora.
3. bounce the instance
After that you should be able to connect as sys remotely with the password.
Richard
Tom Hopkins wrote:
>
> With Oracle 9i;
> I can connect to toad as a regular user no problem.
> I can connect as sys using sql plus by doing:
> "connect sys/password_at_dbcid as sysdba"
>
> How do I connect to a 9i instance as sys using toad?
Received on Fri Apr 19 2002 - 22:08:50 CEST