ORACLE 11G R2 Modify "user name"

Sql> create Pfile from SPFile;

Modify the Pfile file, add the implied parameter *._enable_rename_user= ' TRUE ' to start the database in restrict mode

1, [[email protected] ~]$ cd/u01/app/oracle/product/11.2.0/db1/dbs/

2, [[email protected] dbs]$ ls
Hc_yoon.dat Init.ora inityoon.ora lkyoon orapwyoon snapcf_yoon.f Spfileyoon.ora

3, [[email protected] dbs]$ TAIL-1 Initnode1.ora namely: VI Inityoon.ora

Add to
*._enable_rename_user= ' TRUE '

4, sql> startup restrict pfile= $ORACLE _home/dbs/inityoon.ora

5, Sql>alter user Scott Rename to Yoonscott identified by Tiger;

6. Connect with Plsql Developer Oracle prompts: Ora-12526:tns: Listener: All applicable routines are in restricted mode

7. Use Administrator privileges:

ALTER SYSTEM DISABLE RESTRICTED SESSION;

ORACLE 11G R2 Modify "user name"