Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2015
    Posts
    4

    Unanswered: "Alter user sys identified by" not working Oracle 11g R2

    Hello everyone!

    I install Oracle 11g R2 on Win 7 x64
    11g Release 2 (11.2) for Microsoft Windows x64 (64-Bit)
    I choose to have one password for all users during installation
    I tried to connect to Oracle with SQL Developer as SYSDBA and I get:
    ORA-01017: Invalid username/password; logon denied.
    Then I open cmd as administrator and tried:
    echo %ORACLE_SID%

    and it gives me my SID
    than I connect with sqlplus:
    sqlplus /nolog
    connect / as sysdba
    alter user sys identified by "new_pass"

    And it seems to work. I mean, it says "User altered". However, I still can't log in sqlplus with the new password.
    Error is just the same:
    ORA-01017: Invalid username/password; logon denied.

    What do I do wrong?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Can you connect to that database from command prompt (i.e. NOT SQL Developer)?
    Code:
    sqlplus sys/new_password@your_database as sysdba
    What happens? Please, post the whole command prompt session so that we could see what you did and how Oracle responded.

  3. #3
    Join Date
    Nov 2015
    Posts
    4
    Yes I can.
    But I can't connect as:
    >sqlplus
    user:sysdba
    password:new_pass
    ORA-01017: Invalid username/password; logon denied.

    Either I can't connect with SQL Developer and that is more important

    Echo %ORACLE_SID% is ok, my_database

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    SYSDBA is not a user, it's a privilege assigned to a user
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Nov 2015
    Posts
    4
    Quote Originally Posted by cis_groupie View Post
    SYSDBA is not a user, it's a privilege assigned to a user
    Ok, but I need to connect to db as SYSDBA

    With sysdba I get mentioned error, with sys I get message I should be sysdba or sysoper.
    And what is your solution, how to connect with SQL Developer as sysdba?
    Thank You very much.

  6. #6
    Join Date
    Nov 2015
    Posts
    4
    Ok, I figure it out.
    There is ROLE, and SYSDBA and SYSOPER are roles.
    Ok.
    But...What when I don't have a privilege?
    I want to connect:
    username:system
    password:my_password
    ROLE: SYSDBA

    ORA-01031. Insufficient privileges.

  7. #7
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    What does the manual say about SYSDBA? Have you read anything yet? Have you googled anything yet? (I suspect that the answer is no, otherwise you would know that the SYSTEM user does not have SYSDBA privileges...)
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Man, what you do is not USING Oracle. You are ABUSING it.

    And it strikes back.

    Basically, you got what you deserved.

Posting Permissions

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