Oracle user name and password Modification

Oracle user name and password Modification

After the Oracle database is copied or cloned, you often need to modify the user name and password. The following describes the modification methods and steps:

1. query the table USER $

Select name, USER # FROM user $ where upper (TRIM (NAME) = 'user name ';

2. Modify the user name

UPDATE user $ set name = 'new name' where user # = (select user # FROM user $ where upper (TRIM (NAME) = 'user name ');

COMMIT;

3. Clear Cache

Alter system checkpoint;
Alter system flush SHARED_POOL;

COMMIT;

4. Change the user password and unlock the account

Alter user username identified by 'new password ';

Alter user username account unlock; -- UNLOCK the ACCOUNT

COMMIT;

Modification completed ~~~ Use new users and secret login ......

Migration from 32-bit to 64-bit for a single Oracle instance

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian