SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


Sidebar

Sponsor:

Would you like to sponsor this site?
Or buy me a beer?:


Recently Changed Pages:

View All Pages
View All Q Pages


View All Tags


Sign up for Q to post comments.





WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Terms And Conditions for Q users


Pages with comments

PageDateDiscussionTags
2019/06/22 10:36 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 3 Comments
2017/04/20 15:28 1 Comment
2017/04/20 15:23 1 Comment
2017/04/19 14:44 1 Comment
2017/04/17 20:10 1 Comment
2017/04/17 20:07 1 Comment
2017/04/17 19:58 1 Comment
2017/04/17 19:52 1 Comment

View All Comments

oracleusers

Oracle User Management

The listed commands assume you're logged into the system as the oracle owner user, this way you don't have to provide the password when connecting to the database.

Resetting Oracle Account

The command below unlocks the account and sets a new password:

  • alter user username identified by new_password;
  • alter user username account unlock;

These commands can be combined as you can see below:

UNIX>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 29 12:59:37 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production


SQL> alter user dbuser account unlock identified by <password>;

Validate Oracle Account

Step 2 Validate User connection

Now that the user has been reset, we can validate if a connection is possible

UNIX>sqlplus dbuser

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 29 12:59:37 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password: *********

Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
You could leave a comment if you were logged in.
oracleusers.txt · Last modified: 2013/05/14 20:00 by sjoerd