#3 ORA-28009, Oracle 9i, and SYSDBA


I'm getting an ORA-28009 when doing a SQLConnect to
an Oracle 9i database. Yes, I'm trying to logon into
the "SYS" ID and as SYSDBA. I'm able to do it from the
PLSQL command so permissions exist.

I just can't get my code to make Oracle 9i happy. Life
was easier with the Internal ID, but all good things (and
bad things) change.

Any suggestions/advice (and not doing it isn't one of

Thanks in advance for your time, consideration, and

Bert Moshier




  • Bertram Moshier

    Bertram Moshier - 2002-08-05
    • priority: 5 --> 7
  • Bertram Moshier

    Bertram Moshier - 2002-08-14

    Logged In: YES

    Here is what were doing and why we need support for the "IN
    SYSDBA / SYSOPER MODE" (e.g. from Pro*C).

    We are wanting to do a logical backup once a week of our
    database. In a logical backup, we take can export of the
    entire database. Oracle recommends the database be in
    restricted mode (e.g. as quiet as possible) when doing a full
    database export.

    We would like to have for our Oracle 9i database the following
    script. (NOTE: This works with releases before Oracle 9i but
    with Oracle 9i the SYSDBA mode requirement exists.)

    1. Shutdown immediate (requires sysdba mode)
    2) Startup restricted (requires sysdba mode)
    3) Do the export
    4) Alter system disable restricted session (thus allowing
    everyone back on).


  • Bertram Moshier

    Bertram Moshier - 2002-08-14
    • priority: 7 --> 8
  • Mark Hessling

    Mark Hessling - 2004-06-15
    • assigned_to: nobody --> rexx

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks