Mischiefblog
I make apps for other people

HOWTO change your password in Oracle

Posted by Chris Jones
On July 25th, 2012 at 16:35

Permalink | Trackback | Links In |

Comments Off on HOWTO change your password in Oracle
Posted in General

With SQLPlus

Log into Oracle with SQLPlus.$ sqlplus user@dbname
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Apr 12 11:46:48 2010

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

Enter password: <enter it here>

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> password
Changing password for USER
Old password: <old pass>
New password: <new pass>
Retype new password: <new pass>
Password changed
SQL> CTRL-D
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

With SQL Developer
To change your password in SQL Developer, log into the database in SQL Developer and execute the following statement:

alter user username identified by "newpassword" replace "oldpassword"

The quotes make the password safe for punctuation characters.

Comments are closed.