Having "administrator" privileges (actually being a member of
"Administrators" group) is not enough.
If you want to "connect / as sysdba", you should be a member of ORA_DBA
group.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EM
hi.
after re-creating the password file, you have to cycle the instance for it
to take effect.
stop and restart the oracle service. (this will kill any connections)
You are better off to login to the instance and perform the shutdown
manually as opposed to just killing the service.
Have you set th
e have ORACLE 8.1.7 on NT server and I login as user wirh
"administrator" privilege. I tried to "connect / as sysdba" and got
"insufficient prvilege". The procedure are:
1. on DOS window
2. sqlplus /nolog
3. connect / as sysdba
ORA-001031 insufficient privileges
I have been recreate the passw