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

open
Mark Hessling
None
8
2004-06-15
2002-08-05
Bertram Moshier
No

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
them).

Thanks in advance for your time, consideration, and
help!

Bert Moshier

bert@bmoshier.net

http://www.bmoshier.net/bertram

Discussion

    • priority: 5 --> 7
     
  • Logged In: YES
    user_id=588812

    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).

    Thanks.

     
    • priority: 7 --> 8
     
  • Mark Hessling
    Mark Hessling
    2004-06-15

    • assigned_to: nobody --> rexx