正文

DBNEWNAME工具介绍

IP云
IP云V管理员/7 阅读
10/03
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

下面修改数据库的SID和db_name

  1. [root@oracle ~]# su - ora11g
  2. db11@oracle /home/ora11g$
  3. db11@oracle  /home/ora11g$ sqlplus /as sysdba
  5. SQL*Plus:Release11.2.0.4.0Production on MonMar3007:39:362015
  7. Copyright(c)1982,2013,Oracle.All rights reserved.
  10. Connected to:
  11. OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
  12. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options
  14. SQL>select name, dbid,log_mode,open_mode from v$database;
  16. NAME DBID LOG_MODE OPEN_MODE
  17. ---------------------------------------------------
  18. DB11 1400765095 ARCHIVELOG READ WRITE

启动到mount状态

  1. SQL> shutdown immediate;
  2. Database closed.
  3. Database dismounted.
  4. ORACLE instance shut down.
  5. SQL> startup mount
  6. ORACLE instance started.
  8. TotalSystemGlobalArea835104768 bytes
  9. FixedSize2257840 bytes
  10. VariableSize507513936 bytes
  11. DatabaseBuffers322961408 bytes
  12. RedoBuffers2371584 bytes
  13. Database mounted.
  14. SQL>exit
  15. DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
  16. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options

执行命令

  1. db11@oracle /home/ora11g$ nid target=sys/oracle dbname=newdb11 setname=yes
  3. DBNEWID:Release11.2.0.4.0-Production on MonMar3007:44:262015
  5. Copyright(c)1982,2011,Oracleand/or its affiliates.All rights reserved.
  7. Connected to database DB11 (DBID=1400765095)
  9. Connected to server version 11.2.0
  11. ControlFilesin database:
  12. /u01/app/oracle11g/oradata/DB11/controlfile/o1_mf_bcc2h7dx_.ctl
  14. Change database name of database DB11 to NEWDB11?(Y/[N])=> Y
  16. Proceedingwith operation
  17. Changing database name from DB11 to NEWDB11
  18. ControlFile/u01/app/oracle11g/oradata/DB11/controlfile/o1_mf_bcc2h7dx_.ctl - modified
  19. Datafile/u01/app/oracle11g/oradata/DB11/datafile/o1_mf_system_bcc2dp1d_.db - wrote new name
  20. Datafile/u01/app/oracle11g/oradata/DB11/datafile/o1_mf_sysaux_bcc2dp2c_.db - wrote new name
  21. Datafile/u01/app/oracle11g/oradata/DB11/datafile/fdstore.db - wrote new name
  22. Datafile/u01/app/oracle11g/oradata/DB11/datafile/o1_mf_users_bcc2dp33_.db - wrote new name
  23. Datafile/u01/app/oracle11g/oradata/DB11/datafile/o1_mf_new_user_bcp23qgn_.db - wrote new name
  24. Datafile/u01/app/oracle11g/oradata/DB11/datafile/undotbs2.db - wrote new name
  25. Datafile/u01/app/oracle11g/oradata/DB11/datafile/o1_mf_temp_bcc2hld2_.tm - wrote new name
  26. ControlFile/u01/app/oracle11g/oradata/DB11/controlfile/o1_mf_bcc2h7dx_.ctl - wrote new name
  27. Instance shut down
  29. Database name changed to NEWDB11.
  30. Modify parameter file and generate a new password file before restarting.
  31. Succesfully changed database name.
  32. DBNEWID -Completed succesfully.

数据库中修改db_name

  1. db11@oracle /u01/app/oracle11g/product/11.2.0/dbhome_1/dbs$ sqlplus /as sysdba
  3. SQL*Plus:Release11.2.0.4.0Production on MonMar3007:58:332015
  5. Copyright(c)1982,2013,Oracle.All rights reserved.
  7. Connected to an idle instance.
  9. SQL> startup nomount
  10. ORACLE instance started.
  12. TotalSystemGlobalArea835104768 bytes
  13. FixedSize2257840 bytes
  14. VariableSize507513936 bytes
  15. DatabaseBuffers322961408 bytes
  16. RedoBuffers2371584 bytes
  17. SQL>set line 200
  18. SQL> show parameter db_name
  19. SQL> show parameter db_name
  21. NAME TYPE VALUE
  22. ----------------------------------------------------------------------------------------
  23. db_name string db11
  24. SQL> alter system set db_name=newdb11 scope=spfile;
  26. System altered.
  28. SQL> startup mount force
  29. ORACLE instance started.
  31. TotalSystemGlobalArea835104768 bytes
  32. FixedSize2257840 bytes
  33. VariableSize507513936 bytes
  34. DatabaseBuffers322961408 bytes
  35. RedoBuffers2371584 bytes
  36. Database mounted.
  37. SQL>exit
  38. DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
  39. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options

创建新的密码文件

  1. db11@oracle /home/ora11g$ 
  2. db11@oracle  /home/ora11g$ orapwd file=$ORACLE_HOME/dbs/orapwnewdb11 password=oracle entries=10
  3.  
  4. 创建参数文件
  5.  
  6. db11@oracle  /home/ora11g$ export ORACLE_SID=newdb11
  8. SQL> create spfile from pfile;
  10. File created.
  12. SQL>exit
  13. DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
  14. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options
  16. 根据原参数文件，修改成新的参数文件，具体操作略

启动新的数据库名的数据库

  1. newdb11@oracle /home/ora11g$ export ORACLE_SID=newdb11
  2. newdb11@oracle  /home/ora11g$ sqlplus /as sysdba
  4. SQL*Plus:Release11.2.0.4.0Production on MonMar3008:16:162015
  6. Copyright(c)1982,2013,Oracle.All rights reserved.
  9. Connected to:
  10. OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
  11. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options
  13. SQL> startup
  14. ORACLE instance started.
  16. TotalSystemGlobalArea835104768 bytes
  17. FixedSize2257840 bytes
  18. VariableSize507513936 bytes
  19. DatabaseBuffers322961408 bytes
  20. RedoBuffers2371584 bytes
  21. Database mounted.
  22. Database opened.
  23. SQL>
  24. SQL>select instance_name,status from v$instance;
  26. INSTANCE_NAME STATUS
  27. ----------------------------
  28. newdb11 OPEN

OK。。。启动成功