ORA-01031: insufficient privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-01031: insufficient privileges

  1. #1
    Join Date
    Jul 2006
    Posts
    10

    ORA-01031: insufficient privileges

    can someone help please? i have just run sqlplus /nolog and i am trying to connect to an existing database with the command
    SQl> connect sys as sysdba
    Enter Password: here i gave change_on_install
    and it gives me
    ORA-01031: insufficient privileges

    another problem...

    i executed the following..

    SQL> connect
    Enter user_name: system
    password: manager
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: no such file or Directory

    whats the cause of this problem and how do i fix it?
    please help.

  2. #2
    Join Date
    May 2005
    Location
    France
    Posts
    34
    Quote Originally Posted by bjayaram
    SQl> connect sys as sysdba
    Enter Password: here i gave change_on_install
    and it gives me
    ORA-01031: insufficient privileges
    AFAIK, this can only be due to the fact that you are not connected as the correct OS user ("oracle" in general), because the "as sysdba" connection uses OS authentification (under UNIX-like OS, the user has to belong to the "dba" group).
    Quote Originally Posted by bjayaram
    SQL> connect
    Enter user_name: system
    password: manager
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: no such file or Directory

    whats the cause of this problem and how do i fix it?
    please help.
    You cannot connect as another user than sys because Oracle is not started yet . This is because users other than sys do connect via the listener and Oracle authentification, not via local OS authentification.

    HTH & Regards,

    rbaraer

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    The second part is wrong, he isnt connecting via the listener is the second connection attempt

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Hey Davey what do you want to bet he's on a Windoz box?

    Hence his connection problems.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Jul 2006
    Posts
    10
    im on a linux 9.5 os system...

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and what is a linux 9.5 system?

  7. #7
    Join Date
    Jul 2006
    Posts
    10
    ok.. i had doubts myself if the problem was with the user.. now i had a user called oracles user previously with which i used to login. but i took a break for a month on vacations and my sys admin i guess made some changes...
    so now i want to create a user who can have access to the database and can connect using the sys as sysdba command..

    how do i do this?

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need a user in the dba group

  9. #9
    Join Date
    Jul 2006
    Posts
    10
    ok
    ill check if the user exists. i doubt the sys admin has mapped my user login to the server. i will also try to unmap it and check out if my username is correct. possibilities exist tht i have forgotten my username.

    tnks for the suggestion. if nothing works, ill create a new user. is it possible to create one now????

    thnks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width