How do i get "startup exclusive" privilege? 1

[desert19]

I changed the password for sys and now I cant logon with as "sys as sysdba" or "sys as sysoper". I tried the old change_on_install and manager as well as the new password that I created, but none work.

Another related issue is: what privileges do I need (how can I find out if I have them?) to "startup exclusive"
(internal and sys failed)? Here's the message I got:

SQL> startup exclusive
ORA-24323: value not allowed
ORA-24323: value not allowed
ORA-01031: insufficient privileges

Thanks.

 

[karluk]

I don't know why you can't login as SYS. It may be as simple as mistyping the new password when you were making the change. You can try logging on as system and modifying the sys password again. Then try logging on as sys, and see if the change worked.

You need sysdba privileges to start a database. Sysoper is also probably sufficient. To see which ids have this privilege you can run the following query

select * from v$pwfile_users;

My guess is that the ORA-1031 results from not being logged in as sysdba. I'm not sure about the ORA-24323, but I'm suspicious that you aren't referencing the right init.ora file. Try running the startup command again and explicitly specify your initialization file:

startup exclusive pfile={full path of initsid.ora}