How to unlock user in oracle 9i

how to unlock user in oracle 9i

We are getting ORA the account is locked while unlocked the user and we tried to change the password as well but no luck. I'm new to Oracle DBA stuff, and have been attempting to install an Oracle 9i database on . select 'alter user ' || username || ' account unlock;' from dba_users. In future if we want we can UNLOCK it. create a user named JACK which is ACCOUNT UNLOCK/LOCK NOT WORKING IN ORACLE 9I. ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;. here password is your How to Install Oracle 9i on Windows XP/ →. This chapter describes Oracle9i database default accounts and passwords. ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;. how to unlock user in oracle 9i

Related videos

how to unlock user in oracle database

Experts Exchange Solution brought to you by. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform. Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more to help build customer satisfaction and retention.

Experts Exchange. Individual SMB Enterprise. Log In. Sign Up. Oracle Database Oracle Database. Oracle 9i Install: The installation was sucessful, however I think I may have mucked something up in the last stage of the install where it has a window for changing passwords and locking users.

I have tried to log into my new database it is called 'db2'but can't do so as any user with DBA type privileges. I have tried the following: Who is Participating? Solutions Learn More Through Courses. Experts Exchange Solution brought to you by Enjoy your complimentary how to unlock user in oracle 9i view.

Get this solution by purchasing an Individual license! Start your 7-day free trial. I wear a lot of hats LVL 2. Try to log in sqlplus: Greetings, Lucy. Alternatively try this: Once you are in you can issue: After that you should be able to login to the unlocked accounts. LVL 4. Oracle has the concept of locking accounts. When a DBA or the system locks the account, no one can use it even with the vaild password till the DBA or system unlocks the account. New in the Oracle 9i installation for security is a new screen.

This screen appears with a how to unlock user in oracle 9i of ALL the usernames accounts that come with Oracle. The installation gives you the chance to set new passwords for these accounts and hence to unlock them. The only account you will have access to is the sys account.

You'll need to login for example: For example: Some suggestions on changing the accounts: At this point you can do the command: You don't have to do this action as the extra lines won't prevent the sql code from doing what you desire. This has advantages and disadvantages. The upsides are you don't have: You could set a "global" password and then individually change accounts you feel require their own unique passwords.

Experts Exchange Solution brought to you by Your issues matter to us. Download the guide. Thanks everyone - your advice was great! LVL 1. Pungwick Commented: Hi there, I was just wondering how I could create a new account using oracle, I have manged to log into oracle using: LVL 3.

After you connect to Oracle with your connect command: The following command will show all available accounts: To connect how to unlock user in oracle 9i the new account: You can accept your prefered answer in order to allow paradoxical movement of lower ribs pain expert to get the points It's more than this solution.

Get answers and train to solve all your tech problems - anytime, anywhere. Try it how to unlock user in oracle 9i free Edge Out The Competition for your dream job with proven skills and certifications.

Get started today Stand Out as the employee with proven skills. Start learning today for free Move Your Career Forward with certification training in the latest technologies. Start your trial today. Oracle Database From novice to tech pro — start learning today.

Oracle Database. Ben Brumm. Members can enroll in this course at no extra cost. Microsoft Applications. Debbie Fierst. Ken Mayer. Frank Tillinghast. Document Management. Internet of Things. Patrick Loner. IT Administration. Patrick von Schlag. Sandra Batakis. All rights reserved. Covered by US Patent. Privacy Policy Terms of Use.

5 thoughts on “How to unlock user in oracle 9i

Leave a Reply

Your email address will not be published. Required fields are marked *