1、Oracle11g修改数据库用户名 一：创建一个测试用户xxx,并写入测试数据，由spfile文件生成pfile文件，关闭rac数据库1.[oracle@node1 ~]$ sqlplus sys/Ab123456@rac5 as sysdba 2.SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 6 19:42:12 2012 3.Copyright (c) 1982, 2011, Oracle. All rights reserved. 4. 5.Connecte
2、d to: 6.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 7.With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 8.Data Mining and Real Application Testing options 9. 10.SQL> create user xxx identified b
3、y 123456 default tablespace users; 11.User created. 12. 13.SQL> grant resource,connect to xxx; 14.Grant succeeded. 15. 16.SQL> create table xxx.test as select * from dba_objects; 17.Table created. 18. 19.SQL> alter user xxx rename to yyy; 20.alter user xxx rename
4、 to yyy 21. * 22.ERROR at line 1: 23.ORA-00922: missing or invalid option 24. 25.SQL> alter user xxx rename to yyy identified by 123456; 26.alter user xxx rename to yyy identified by 123456 27. * 28.ERROR at line 1: 29.ORA-00922: missi
5、ng or invalid option 30. 31.SQL> create pfile from spfile; 32.File created. 33. 34.[oracle@node1 ~]$ srvctl stop database -d rac -o immediate 35.[oracle@node1 ~]$ srvctl status database -d rac 36.Instance node1 is not running on node node1 1.Instance node2 is not
6、 running on node node2 二：修改pfile文件，添加隐含参数*._enable_rename_user='TRUE'，将数据库以restrict方式启动1.[oracle@node1 ~]$ cd /u01/app/oracle/product/11.2.0/db1/dbs/ 2.[oracle@node1 dbs]$ ls 3.hc_node1.dat initnode1.ora init.ora orapwnode1 4. 5.[oracle@node1 dbs]$ tail -1 ini
7、tnode1.ora 6.*._enable_rename_user='TRUE' 7. 8.[oracle@node1 dbs]$ sqlplus /nolog 9.SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 6 19:51:41 2012 10.Copyright (c) 1982, 2011, Oracle. All rights reserved. 11. 12.SQL> conn /as sysdba 13.Connected to an idle
8、instance. 14.SQL> startup restrict pfile=$ORACLE_HOME/dbs/initnode1.ora 15.ORACLE instance started. 16. 17.Total System Global Area 1235959808 bytes 18.Fixed S
