1 2 Previous Next 16 Replies Latest reply: Dec 15, 2011 2:43 AM by Nicolas.Gasparotto RSS

    How to Unlock SCOTT Account !!

    705051
      Dear all,

      We are in a tough situation , and really need help.

      We are using Oracle 11g , and the SCOTT account is locked. All the other accounts including SYS , SYSTEM , etc are locked too.

      We are unable to enter the database.

      Kindly , suggest us , how to unlock the accounts.


      Thanks & Regards
      Saswata Mandal.
        • 1. Re: How to Unlock SCOTT Account !!
          Azar
          sql>alter user <username> account unlock;
          • 2. Re: How to Unlock SCOTT Account !!
            Gurjas
            Have you tried with
                 sys as sysdba
                 instead of password just press enter .... 
            It will use OS authentication .. do this on server not on client.

            Then after login use
            SQL > alter user scott account unlock; 
            to unlock the scott account

            Edited by: Gj on Jan 20, 2010 1:44 PM

            Edited by: Gj on Jan 20, 2010 1:44 PM
            • 3. Re: How to Unlock SCOTT Account !!
              asifkabirdba
              Log in as SYSTEM or SYS.

              SQL > alter user scott account unlock;


              Regards
              Asif Kabir
              • 4. Re: How to Unlock SCOTT Account !!
                Uwehesse-Oracle
                >
                We are using Oracle 11g , and the SCOTT account is locked. All the other accounts including SYS , SYSTEM , etc are locked too.

                We are unable to enter the database.

                Kindly , suggest us , how to unlock the accounts.
                >

                Suppose there is no DBA arround at your site?

                You should be able to enter as sys with OS-authentication or by creating a password file, containing the sys password.

                Tell us your OS and the exact Oracle Version to explain how to do that.

                Kind regards
                Uwe

                http://uhesse.wordpress.com

                Edited by: Uwe Hesse on 20.01.2010 09:17
                • 5. Re: How to Unlock SCOTT Account !!
                  705051
                  Hi , Thanks for the quick reply.

                  I am able to login SQL using the SYS as SYSDBA and unlocked the scott account.

                  But , need to change the passwords for SYS, SYSTEM Accounts , as I dont know the existing passwords.

                  Kindly , suggest how to achive this.

                  Thanks & Regards
                  Saswata Mandal.
                  • 6. Re: How to Unlock SCOTT Account !!
                    Azar
                    SQL> ALTER USER SYSTEM IDENTIFIED BY AZAR; ---> CHANGE PASSWORD (azar).

                    User altered.

                    SQL> CONN SYSTEM/AZAR@RIYADH;
                    ERROR:
                    ORA-28000: the account is locked


                    Warning: You are no longer connected to ORACLE.
                    SQL> ALTER USER SYSTEM ACCOUNT UNLOCK;
                    SP2-0640: Not connected
                    SQL> CONN SYS/SYS@RIYADH AS SYSDBA
                    Connected.
                    SQL> ALTER USER SYSTEM ACCOUNT UNLOCK;

                    User altered.

                    SQL> CONN SYSTEM/AZAR@RIYADH;
                    Connected.
                    SQL> SHOW USER;
                    USER is "SYSTEM"
                    SQL>
                    • 7. Re: How to Unlock SCOTT Account !!
                      Uwehesse-Oracle
                      >
                      I am able to login SQL using the SYS as SYSDBA and unlocked the scott account.

                      But , need to change the passwords for SYS, SYSTEM Accounts , as I dont know the existing passwords.
                      >

                      That's easy:
                      SQL> alter user sys identified by <password of your choice>;
                      SQL> alter user system identified by <password of your choice>;
                      Kind regards
                      Uwe

                      http://uhesse.wordpress.com
                      • 8. Re: How to Unlock SCOTT Account !!
                        705051
                        Hi Guys ,

                        Thanks a lot.

                        At present , everything seems ok.

                        Shall get back to you soon, incase of any issue .

                        Really appreciate, your suggestions.

                        Thanks and REgards
                        Ssawata Mandal.
                        • 9. Re: How to Unlock SCOTT Account !!
                          Maran Viswarayar
                          Just bear in mind if there are any scheduled jobs with hard coded passwords then you are in for a trouble....


                          Is it a production system? any backup jobs...?
                          • 10. Re: How to Unlock SCOTT Account !!
                            EdStevens
                            Saswata wrote:
                            Hi Guys ,

                            Thanks a lot.

                            At present , everything seems ok.

                            Shall get back to you soon, incase of any issue .

                            Really appreciate, your suggestions.

                            Thanks and REgards
                            Ssawata Mandal.
                            While we don't mind helping, these questions are about as elementary as it gets, suggesting that you have not yet become familiar with even the most basic documentation.

                            Learning where to look things up in the documentation is time well spent investing in your career. To that end, you should drop everything else you are doing and do the following:

                            Go to tahiti.oracle.com. Drill down to your product and version.

                            Spend a few minutes just getting familiar with what is available here. Take special note of the "books" and "search" tabs. Under the "books" tab you will find the complete documentation library.

                            Spend a few minutes just getting familiar with what kind of documentation is available there by simply browsing the titles under the "Books" tab.

                            Open the Reference Manual and spend a few minutes looking through the table of contents to get familiar with what kind of information is available there.

                            Do the same with the SQL Reference Manual.

                            Do the same with the Utilities manual.

                            You don't have to read the above in depth. They are reference manuals. Just get familiar with what is there to be referenced. Ninety percent of the questions asked on this forum can be answered in less than 5 minutes by simply searching one of the above manuals.

                            Then set yourself a plan to dig deeper.
                            - Read a chapter a day from the Concepts Manual.
                            - Take a look in your alert log. One of the first things listed at startup is the initialization parms with non-default values. Read up on each one of them in the Reference Manual.
                            - Take a look at your listener.ora, tnsnames.ora, and sqlnet.ora files. Go to the Network Administrators manual and read up on everything you see in those files.
                            - When you have finished reading the Concepts Manual, do it again.

                            Give a man a fish and he eats for a day. Teach a man to fish and he eats for a lifetime.
                            • 11. Re: How to Unlock SCOTT Account !!
                              905463
                              How to unlock user scott.
                              I am unable to enter in database.
                              All other user are also locked.
                              From which schema should I start.
                              please give me suggestion
                              • 12. Re: How to Unlock SCOTT Account !!
                                Shivananda Rao
                                Please post your queries in a new thread rather than using someone elses' thread
                                • 13. Re: How to Unlock SCOTT Account !!
                                  Belt
                                  "sqlplus / as sysdba" can't enter in database?
                                  • 14. Re: How to Unlock SCOTT Account !!
                                    Shivananda Rao
                                    Create a new thread and then start asking your questions.

                                    This would help you out to get in the solutions easier
                                    1 2 Previous Next