I issued the command:
Connect / as sysdba
and I keep getting this message: ORA-01031 insufficient privileges
I figured it's the facted that my Remote_login_passwordfile is set wrong so I go to my Oracle file through my OS and find my init.ora file. I find the parameter and erase "None" and type in "Exclusive" figuring that would solve the problem.
I issued the same command and still receive the ORA-01031 insufficient privileges error so I type in "Show parameters remote" to see if the passwordfile has changed and it still registers as "none" even though in the init.ora file it says "exclusive".
I'm I changing the Remote_login_passwordfile wrong in the init.ora and if I am how do I change this particular parameter correctly.
Or is there another problem all together that I don't even realize.
do you actually have the required priveleges to connect as sysdba using OS authentication?
I just had this problem.
I noticed in similar threads they say to add (NTS) into your sqlnet.ora file. Well, I actually REMOVED that line and now everything works fine!
I only wasted 4 hours attempting to solve this problem.
At least it is solved. Now all I need to know is why.
I was connecting remotely to the host.
Click Here to Expand Forum to Full Width