Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: "Alter user sys identified by" not working

    Hello everyone!

    First of all, and following the forum guidelines (this is my first post ), I use:

    Windows 7 x64
    Oracle Enterprise 11g R2 x32

    I have some basic experience with SQL Server and MySQL (more with MySQL). Today I started working with Oracle, and I've been bumping a lot on the way.

    The problem I'm having now is that, for some reason, I can't connect to any sys user (sysdba or sysoper). Probably I made a mistake writing the password when creating the database, but I'm not sure, so I'm trying to change it.

    I've been trying, as some searches had led me to try, to use

    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. It's a little weird, since I can connect to "sysman" with my original password, but it doesn't have the privileges I need.

    I'd appreciate any help I could get, and I thank you beforehand.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >However, I still can't log in sqlplus with the new password.
    While I will accept above is true, it is totally & 100% devoid of any actionable detail.
    is COPY & PASTE broken for you?
    There are a gazillion different reasons why you can't login.
    Without knowing the complete error code & message from Oracle, I won't guess any possible solution.

    my car won't go
    tell me how to make my car go.

    [oracle@localhost ~]$ sqlplus / as sysdba

    SQL*Plus: Release Production on Wed Sep 11 17:45:13 2013

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

    Connected to:
    Oracle Database 11g Enterprise Edition Release - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> connect sys/foobar as sysdba
    SQL> connect sys/ID10T as sysdba
    SQL> connect sys/does_not_matter as sysdba
    Last edited by anacedent; 09-11-13 at 21:46.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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