ora-01031

[du365]

Hi guys,



Oracle 9i
Windows 2000
SQL*Plus


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.


Thank guys.

 

[sem]

By default 9i uses spfile instead of pfile.

Regards, Dima

 

[mike1953]

Ok...Oracle uses an spfile if-and-only-if you create it. Otherwise, it still uses the initSID.ora file. If you DO have an spfile, you can delete it so that Oracle will default back to the initSID.ora file.
Next, once you make a change to initSID.ora, you must restart the instance. Since you're on Windows, use the 'oradim' command to shutdown and restart the instance services.
Finally, you must grant access to the sysdba role from inside the database with a "grant" command.
HTH,
Mike