Use Nid to Change dbname

C:/>nid -help DBNEWID: Release 10.1.0.2.0 - Production Copyright (c) 2001, 2004, Oracle. All rights reserved. 关键字 说明 (默认值) ---------------------------------------------------- TARGET 用户名/口令 (无) DBNAME 新的数据库名 (无) LOGFILE 输出日志 (无) REVERT 还原失败的更改 否 SETNAME 仅设置新的数据库名 否 APPEND 附加至输出日志 否 HELP 显示这些消息 否

SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production SQL> show parameter name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string eyglev global_names boolean FALSE instance_name string eyglev lock_name_space string log_file_name_convert string oracle_trace_collection_name string oracle_trace_facility_name string oracled plsql_native_make_file_name string service_names string eyglev

SQL> connect sys/orasys as sysdba Connected. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.

SQL> startup mountORACLE instance started. Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytesDatabase mounted.

SQL> host Microsoft Windows 2000 [Version 5.00.2195] (C) 版权所有 1985-2000 Microsoft Corp. C:/>nid target=sys/orasys dbname=eyglen DBNEWID: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. Connected to database EYGLEV (DBID=677189177) Control Files in database: E:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTL E:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTL E:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTL Change database ID and database name EYGLEV to EYGLEN? (Y/[N]) => Y Proceeding with operation Changing database ID from 677189177 to 3955758099 Changing database name from EYGLEV to EYGLEN Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTL - modified Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTL - modified Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTL - modified Datafile E:/ORACLE/ORADATA/EYGLEN/SYSTEM01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/UNDOTBS01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/CWMLITE01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/DRSYS01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/INDX01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/ODM01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/TOOLS01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/USERS01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/XDB01.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/EYGLE.DBF - dbid changed, wrote new name Datafile E:/ORACLE/ORADATA/EYGLEN/TEMP01.DBF - dbid changed, wrote new name Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTL - dbid changed, wrote new name Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTL - dbid changed, wrote new name Control File E:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTL - dbid changed, wrote new name Database name changed to EYGLEN. Modify parameter file and generate a new password file before restarting. Database ID for database EYGLEN changed to 3955758099. All previous backups and archived redo logs for this database are unusable. Shut down database and open with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully.

SQL> shutdown immediateORA-01109: database not open Database dismounted.ORACLE instance shut down.

###########################################instance_name=eyglen#instance_name=eyglev###########################################db_domain=""db_name=eyglen# db_name=eyglev###########################################

SQL> startup pfile=E:/Oracle/admin/eyglen/pfile/init.ora ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes ORA-01991: invalid password file 'e:/oracle/Ora9iR2/DATABASE/PWDeyglen.ORA' SQL> CREATE SPFILE='E:/Oracle/Ora9iR2/database/SPFILEEYGLEN.ORA' FROM 2 PFILE='E:/Oracle/admin/eyglen/pfile/init.ora'; File created.

SQL> hostMicrosoft Windows 2000 [Version 5.00.2195](C) 版权所有 1985-2000 Microsoft Corp. C:/>orapwd file=E:/Oracle/Ora9iR2/database/PWDeyglen.ORA password=oracle entries=5

SQL> shutdown immediateORA-01109: database not open Database dismounted.ORACLE instance shut down.

SQL> startup mount ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter database open resetlogs 2 / Database altered. SQL>

SQL> show parameter name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string eyglen global_names boolean FALSE instance_name string eyglen lock_name_space string log_file_name_convert string oracle_trace_collection_name string oracle_trace_facility_name string oracled plsql_native_make_file_name string service_names string eyglen

SVRMGR> startup mount 已启动 ORACLE 实例。 系统全局区域合计有 61970460个字节 Fixed Size 75804个字节 Variable Size 17645568个字节 Database Buffers 44171264个字节 Redo Buffers 77824个字节 已装入数据库。 SVRMGR> show parameter name NAME TYPE VALUE ----------------------------------- ------- ------------------------------ db_file_name_convert 字符串 db_name 字符串 vilen global_names 布尔值 TRUE instance_name 字符串 vilen lock_name_space 字符串 log_file_name_convert 字符串 oracle_trace_collection_name 字符串 oracle_trace_facility_name 字符串 oracled service_names 字符串 vilen SVRMGR>

C:/>nid target=sys/orasys@vilen dbname=vilene DBNEWID: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. Connected to database VILEN (DBID=1535443189) Control Files in database: C:/ORACLE/ORADATA/VILEN/CONTROL01.CTL C:/ORACLE/ORADATA/VILEN/CONTROL02.CTL C:/ORACLE/ORADATA/VILEN/CONTROL03.CTL Change database ID and database name VILEN to VILENE? (Y/[N]) => Y Proceeding with operation Changing database ID from 1535443189 to 681857412 Changing database name from VILEN to VILENE Control File C:/ORACLE/ORADATA/VILEN/CONTROL01.CTL - modified Control File C:/ORACLE/ORADATA/VILEN/CONTROL02.CTL - modified Control File C:/ORACLE/ORADATA/VILEN/CONTROL03.CTL - modified Datafile C:/ORACLE/ORADATA/VILEN/SYSTEM01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/RBS01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/USERS01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/TEMP01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/TOOLS01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/INDX01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/EQSP01.DBF - dbid changed, wrote new name Datafile C:/ORACLE/ORADATA/VILEN/PERFSTAT.DBF - dbid changed, wrote new name Control File C:/ORACLE/ORADATA/VILEN/CONTROL01.CTL - dbid changed, wrote new name Control File C:/ORACLE/ORADATA/VILEN/CONTROL02.CTL - dbid changed, wrote new name Control File C:/ORACLE/ORADATA/VILEN/CONTROL03.CTL - dbid changed, wrote new name Database name changed to VILENE. Modify parameter file and generate a new password file before restarting. Database ID for database VILENE changed to 681857412. All previous backups and archived redo logs for this database are unusable. Shut down database and open with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully.

SVRMGR> shutdown immediateORA-01109: 数据库未打开已卸下数据库。已关闭 ORACLE 实例。

db_name = "vilene"#db_name = "vilen" instance_name = vilene#instance_name = vilen

C:/oracle/database>orapwd file=PWDvilen.ORA password=oracle entries=5 C:/oracle/database>

SVRMGR> startup mount ORACLE instance started. Total System Global Area 61970460 bytes Fixed Size 75804 bytes Variable Size 17645568 bytes Database Buffers 44171264 bytes Redo Buffers 77824 bytes Database mounted.

SVRMGR> alter database open resetlogs2> /Statement processed.

SVRMGR> show parameter name NAME TYPE VALUE ----------------------------------- ------- ------------------------------ db_file_name_convert string db_name string vilene global_names boolean TRUE instance_name string vilene lock_name_space string log_file_name_convert string oracle_trace_collection_name string oracle_trace_facility_name string oracled service_names string vilen