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

[Bertram Moshier]

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

[Bertram Moshier]

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.