Re: ORA-01031: insufficient privileges

mehaboob_at_gmail.com wrote:
> Hi,
>
> I am trying the command on unix system as below,
>
> 1)logged into the unix system as root
> 2)su - oracle
> 3)sqlplus /nolog
> CONN logon AS SYSDBA
> Enter password: # pressed Enter
> ERROR:
> ORA-01031: insufficient privileges
>
> Previously I remember connecting using the above procedure but now it
> asks
> for password.I am not sure about the passowrd, I tried sysdba and
> manager (uppercase as
> well as lowercase)
>
> Thanks in advance,
> Mehaboob

I ran into a problem like this before. I asked around my office if anyone was playing with my instance. No one was. But....

try sqlplus "sys/password as sysdba" (single or double quotes, depending on system)
If that works, and in the past, you were able to get by with "/ as sysdba", then I think someone was messing around with the listener's security settings, which may not be tied to a particular instance, but to the installation directory which all instances on a machine may rely on. (Hence the response from my coworkers, "I didn't mess around with your instance." And technically they didn't.)

Somebody, on here might know the details. Received on Tue Jun 06 2006 - 16:41:18 CDT