7 Replies Latest reply: Apr 5, 2013 3:00 PM by TSharma-Oracle RSS

    reuse old password

    user13667036
      Hello,
      OS: windows 7 (personal laptop), ORACLE version : 11gR2

      USER (sys, system, BI, SCOTT, HR) password expired and needed to reset it. However I would like to keep my old password... mostly for convenience, but also different applications (e.g. oracle data miner...) connecting to DB needed to be reset, which I am reluctant to do. I issued the command "SQL> ALTER profile DEFAULT limit password_life_time unlimited" after logging as sysdba. But still can't replace the new password by my old password. How to fix it?

      Thanks,
      Sourabh
        • 1. Re: reuse old password
          EdStevens
          user13667036 wrote:
          Hello,
          OS: windows 7 (personal laptop), ORACLE version : 11gR2

          USER (sys, system, BI, SCOTT, HR) password expired and needed to reset it. However I would like to keep my old password... mostly for convenience, but also different applications (e.g. oracle data miner...) connecting to DB needed to be reset, which I am reluctant to do. I issued the command "SQL> ALTER profile DEFAULT limit password_life_time unlimited" after logging as sysdba. But still can't replace the new password by my old password. How to fix it?

          Thanks,
          Sourabh
          Surely you get an error message. Surely that message would be helpful in pointing you to an acceptable solution.
          • 2. Re: reuse old password
            user13667036
            Sorry, here it is:

            Win7> sqlplus / as sysdba

            SQL> alter user hr identified by <oldpassword>;
            *
            ERROR at line 1:
            ORA-00922:missing or invalid option


            Thanks,
            Sourabh
            • 3. Re: reuse old password
              Brian Bontrager
              It appears you typed this verbatim?
              alter user hr identified by <oldpassword>;
              The password in alter user should not include the "<" and ">" you may find in a syntax example.
              SQL>  alter user hr identified by <oldpassword>;
               alter user hr identified by <oldpassword>
                                            *
              ERROR at line 1:
              ORA-00922: missing or invalid option
              
              SQL> alter user hr identified by oldpassword;
              
              User altered.
              Edited by: Brian Bontrager on Apr 5, 2013 3:13 PM
              • 4. Re: reuse old password
                user13667036
                No, that was the example, in sqlplus I typed the intended password not like <...>!!
                • 5. Re: reuse old password
                  Brian Bontrager
                  Then the password must begin with a character oracle does not expect. Several other classes of character return the same error
                  SQL> alter user hr identified by 123invalid;
                  alter user hr identified by 123invalid
                                                 *
                  ERROR at line 1:
                  ORA-00922: missing or invalid option
                  
                  SQL> alter user hr identified by @invalid;
                  alter user hr identified by @invalid
                                               *
                  ERROR at line 1:
                  ORA-00922: missing or invalid option
                  If your old password DID start with something other than a alphabetic character, you can enclose the password in quotes
                  SQL> alter user hr identified by "@invalid";
                  
                  User altered.
                  
                  SQL> alter user hr identified by "123valid";
                  
                  User altered.
                  
                  SQL> alter user hr identified by "<oldpassword>";
                  
                  User altered.
                  
                  SQL> 
                  Edited by: Brian Bontrager on Apr 5, 2013 3:33 PM
                  • 6. Re: reuse old password
                    user13667036
                    My password do start with a number but that's strange because I was using that before and never had any problem, though I created those during oracle installation. But more importantly is there any issue with oracle regarding reusing old password? Reading from different posts it's not very clear if that is the case, some mentions oracle saves the password in a table and will not allow to reuse it! Is that true?

                    ~Sourabh
                    • 7. Re: reuse old password
                      TSharma-Oracle
                      Check this link. It may be helpful.

                      Password Reuse Max question