I've ran into the ORA-01031: insufficient privileges error running Oracle
7.3.4 on NT 4.0. The error was very misleading because the real problem was
that the password had been changed for the account. In my case it was also
the internal (sys) account. It was changed via the Oracle NT Instance
Manager application (Not Enterprise Manager). As long as your database is
set to autostartup there should be a strtSID.CMD file within your
ORANT\DATABASE which is a script for starting the NT service. Look for the
-usrpwd switch and use that trailing password.
dean_at_gfsmortgage.com wrote in article <6lmlbj$7uq$1_at_nnrp1.dejanews.com>...
> I'm running two Oracle servers. This morning I tried to shut one down
but
> couldn't. I tried logging on as SYS--still can't.
>
> I tried logging on as INTERNAL with NORMAL
> SYSOPER
> and SYSDBA
>
> each attempt gave me Insufficient Privledges to even log on! I've never
seen
> this. My other Oracle server is running fine. Does anybody have any
ideas?
>
> Oracle 7.3.3 on NT 4.0
>
> Any suggestions would be greatly appreciated
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Wed Jun 10 1998 - 15:11:06 CDT
