《Oracle11g修改数据库用户名》由会员分享,可在线阅读,更多相关《Oracle11g修改数据库用户名(3页珍藏版)》请在金锄头文库上搜索。
1、文档供参考,可复制、编制,期待您的好评与关注! Oracle 11g修改数据库用户名一:创建一个测试用户xxx,并写入测试数据,由spfile文件生成pfile文件,关闭rac数据库1. oraclenode1$sqlplussys/Ab123456rac5assysdba 2. SQL*Plus:Release11.2.0.3.0ProductiononTueMar619:42:122012 3. Copyright(c)1982,2011,Oracle.Allrightsreserved. 4. 5. Connectedto: 6. OracleDatabase11gEnterpriseE
2、ditionRelease11.2.0.3.0-64bitProduction 7. WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP, 8. DataMiningandRealApplicationTestingoptions 9. 10. SQLcreateuserxxxidentifiedby123456defaulttablespaceusers; 11. Usercreated. 12. 13. SQLgrantresource,connecttoxxx; 14. Grantsucc
3、eeded. 15. 16. SQLcreatetablexxx.testasselect*fromdba_objects; 17. Tablecreated. 18. 19. SQLalteruserxxxrenametoyyy; 20. alteruserxxxrenametoyyy 21. * 22. ERRORatline1: 23. ORA-00922:missingorinvalidoption24. 25. SQLalteruserxxxrenametoyyyidentifiedby123456; 26. alteruserxxxrenametoyyyidentifiedby12
4、3456 27. * 28. ERRORatline1: 29. ORA-00922:missingorinvalidoption30. 31. SQLcreatepfilefromspfile; 32. Filecreated. 33. 34. oraclenode1$srvctlstopdatabase-drac-oimmediate 35. oraclenode1$srvctlstatusdatabase-drac 36. Instancenode1isnotrunningonnodenode1 37. Instancenode2isnotrunningonnodenode2二:修改pf
5、ile文件,添加隐含参数 *._enable_rename_user=TRUE,将数据库以restrict方式启动1. oraclenode1$cd/u01/app/oracle/product/11.2.0/db1/dbs/ 2. oraclenode1dbs$ls 3. hc_node1.datinitnode1.orainit.oraorapwnode1 4. 5. oraclenode1dbs$tail-1initnode1.ora 6. *._enable_rename_user=TRUE7. 8. oraclenode1dbs$sqlplus/nolog 9. SQL*Plus:R
6、elease11.2.0.3.0ProductiononTueMar619:51:412012 10. Copyright(c)1982,2011,Oracle.Allrightsreserved. 11. 12. SQLconn/assysdba 13. Connectedtoanidleinstance. 14. SQLstartuprestrictpfile=$ORACLE_HOME/dbs/initnode1.ora 15. ORACLEinstancestarted. 16. 17. TotalSystemGlobalArea1235959808bytes 18. FixedSize
7、2227904bytes 19. VariableSize805306688bytes 20. DatabaseBuffers419430400bytes 21. RedoBuffers8994816bytes 22. Databasemounted. 23. Databaseopened. 24. SQLselectopen_mode,namefromv$database; 25. 26. OPEN_MODENAME27. - 28. READWRITERAC 29. 30. SQLshowparameterspfile; 31. 32. NAMETYPEVALUE 33. - 34. sp
8、filestring三:修改xxx用户名为yyy1. SQLalteruserxxxrenametoyyy; 2. alteruserxxxrenametoyyy 3. * 4. ERRORatline1: 5. ORA-02000:missingIDENTIFIEDkeyword 6. 7. SQLalteruserxxxrenametoyyyidentifiedby123456; 8. Useraltered. 9. 10. SQLselectcount(*)fromyyy.test; 11. 12. COUNT(*) 13. - 14. 74556四:使用spfile启动rac1. SQ
9、Lshutdownimmediate; 2. Databaseclosed. 3. Databasedismounted. 4. ORACLEinstanceshutdown. 5. 6. oraclenode1dbs$srvctlstartdatabase-drac 7. oraclenode1dbs$srvctlstatusdatabase-drac 8. Instancenode1isrunningonnodenode1 9. Instancenode2isrunningonnodenode2五:连接测试,由此可见,对用户的rename操作,可以继承原有的权限1. SQL*Plus:Re
10、lease11.2.0.3.0ProductiononTueMar620:00:522012 2. Copyright(c)1982,2011,Oracle.Allrightsreserved. 3. 4. Connectedto: 5. OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction 6. WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP, 7. DataMiningandRealApplicationT
11、estingoptions 8. 9. SQLselect*fromtab; 10. 11. TNAMETABTYPECLUSTERID 12. - 13. TESTTABLE14. 15. oraclenode1$sqlplusxxx/123456rac5 16. SQL*Plus:Release11.2.0.3.0ProductiononTueMar620:01:222012 17. Copyright(c)1982,2011,Oracle.Allrightsreserved. 18. 19. ERROR: 20. ORA-01017:invalidusername/password;logondenied /