How to login into Oracle9 as SYSDBA?

[griobhtha]

Hi!

In PL/SQL Developer 5.0, how do we log in as SYSDBA to an Oracle9 database?

We have tried:
CONNECT SYS/***@PSDMO AS SYSDBA

but the result is:
ORA-28009 - Connection to SYS should be as SYSDBA or as SYSOPER.

Thanks!

 

[Marco Kalter]

The logon form has a "Connect as" selection list, where you can select "Normal", "SYSDBA" or "SYSOPER". In the Command Window you can connect like you described.

This requires Oracle Net 8 or later though. It also requires that you have not enabled the preference "Force OCI7 mode on OCI8" (Tools > Preferences > Options tab page).

 

[griobhtha]

Thanks, that worked!