Ok, so after a lot of work, I have Oracle XE installed on my machine (Windows XP SP3).
The post where I got help is:
1060743
After I got the database up and running, I discovered that I could not use my normal user account (a domain user account) to connect as sysdba.
From my previous thread:
>
I switched to my user account and the database homepage appears to load fine now. I went to cmd and typed sqlplus /nolog then tried connect /as sysdba but it gave me the ORA-01031: insufficient privileges error. I then tried to connect system with the password I'd set during installation and that worked fine. (It said, 'Connected.').
>
Please note, using: connect sys as sysdba then entering the system password when prompted works just fine. I just can't use my normal Windows account (connect /as sysdba).
I also posted:
>
Ok, so I checked my sqlnet.ora file and found SQLNET.AUTHENTICATION_SERVICES = (NONE).
I thought maybe that was why I wasn't able to connect /as sysdba with my local account. I stopped my database/listener, changed the file to say SQLNET.AUTHENTICATION_SERVICES = (NTS), then restarted the database/listener.
Now, instead of getting the insufficient privileges error, I get ORA-12638: Credential retrieval failed.
With that setting set to NONE, I was at least able to do connect sys as sysdba with no problems. Now, when I try it, I get that ORA-12638 error. I'm going to try to reboot and see if that fixes it, otherwise it seems like I may have to put the setting back to NONE, then just use sys when I want to connect as sysdba.
>
Rebooting did not fix the problem.
I changed back to SQLNET.AUTHENTICATION_SERVICES = (NONE), and everything is back to working, except for my normal user account not being able to connect as sysdba.
I have triple-checked that my username (MYDOMAIN\myusername) is in the local ORA_DBA group and the local Administrators group. It definitely is.
Does anyone have any suggestions on how to fix this?
Edited by: user11033437 on Apr 19, 2010 2:03 PM (fixed a typo)