ORA-01031: insufficient privileges

4 Jan

ORA-01031: insufficient privileges

oracle@ubs-desktop:~$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Mon Jan 4 09:25:38 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges


ACTION
oracle@ubs-desktop:~$ sqlplus sys as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Mon Jan 4 09:28:06 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 364081152 bytes
Fixed Size 1299960 bytes
Variable Size 314575368 bytes
Database Buffers 41943040 bytes
Redo Buffers 6262784 bytes
Database mounted.
Database opened.
SQL> exit

6 Responses to “ORA-01031: insufficient privileges”

  1. Bipin Bahuguna July 23, 2010 at 10:39 pm #

    its working now thanks man.
    will disscuss more issue if will face thanks buddy

  2. upendra July 24, 2010 at 12:49 pm #

    SQL*Plus: Release 11.1.0.6.0 – Production on Sat Jul 24 18:10:08 2010

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    Enter password:
    ERROR:
    ORA-01017: invalid username/password; logon denied

    Enter user-name: sys/oracle@orcl
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0

  3. upendra July 24, 2010 at 12:57 pm #

    root@sso-server:~# dgmgrl
    DGMGRL for Linux: Version 11.1.0.6.0 – Production

    Copyright (c) 2000, 2005, Oracle. All rights reserved.

    Welcome to DGMGRL, type “help” for information.
    DGMGRL> connect sys@orcl
    Password:
    ORA-01017: invalid username/password; logon denied

    DGMGRL> connect system/oracle@orcl
    ORA-01031: insufficient privileges

    DGMGRL>

    I got this error when I try to start oracle, I am sure I am providing the right password when connecting through system user, but it says wrong password.
    Please help me its third time when I installed, and getting the same error again and again.

    Thanks a ton in advance.

  4. daksaadiprana January 7, 2011 at 3:52 am #

    aku sudah pake sarannya pak agus n saya coba
    kenapa ya pak kok masih tetep error..

    [root@localhost ~]# sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 7 17:50:20 2011

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges

    [root@localhost ~]#sqlplus sys as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 7 17:50:37 2011

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    Enter password:
    ERROR:
    ORA-01031: insufficient privileges

    • setijoagus January 7, 2011 at 4:33 am #

      waktu login
      oracle@ubs-desktop:~$ sqlplus sys as sysdba
      Enter password:

      apakah sudah benar passwordnya ?

      terus memang meng-admin-nya pakai root ?
      “[root@localhost ~]#sqlplus sys as sysdba”
      kok nggak lazim biasanya user oracle

  5. daksaadiprana January 7, 2011 at 6:25 am #

    oya pak iya ya… trims pak hehehe

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: