使用NID修改Oracle数据库名

来源：这里教程网时间：2026-03-03 16:38:52 作者：

1 登陆数据库把数据库变成mount 状态

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 4 月 17 15:10:42 2006

SQL> conn /as sysdba

已连接。

NAME TYPE VALUE

------------------------------------ ----------- ---------------

db_file_name_convert string

db_name string drew

global_names boolean FALSE

instance_name string drew

SQL> shutdown immediate;

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

SQL> startup mount

ORACLE 例程已经启动。

Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

数据库装载完毕。

SQL>

2 使用NID 命令来修改数据库instanc_name 和dbname C:\>nid target=sys/oracle@drew dbname= kbdv2DBNEWID: Release 9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved. Connected to database DREW (DBID=2198138346) Control Files in database: D:\ORACLE\ORADATA\TEST\CONTROL01.CTL D:\ORACLE\ORADATA\TEST\CONTROL02.CTL D:\ORACLE\ORADATA\TEST\CONTROL03.CTL Change database ID and database name DREW to KBDV2? (Y/[N]) => Y Proceeding with operationChanging database ID from 2198138346 to 1048877256Changing database name from DREW to KBDV2 Control File D:\ORACLE\ORADATA\TEST\CONTROL01.CTL - modified Control File D:\ORACLE\ORADATA\TEST\CONTROL02.CTL - modified Control File D:\ORACLE\ORADATA\TEST\CONTROL03.CTL - modified Datafile D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\DRSYS01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\INDX01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\TOOLS01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\USERS01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\XDB01.DBF - dbid changed, wrote new name Datafile D:\ORACLE\ORADATA\TEST\TEMP01.DBF - dbid changed, wrote new name Control File D:\ORACLE\ORADATA\TEST\CONTROL01.CTL - dbid changed, wrote new name Control File D:\ORACLE\ORADATA\TEST\CONTROL02.CTL - dbid changed, wrote new name Control File D:\ORACLE\ORADATA\TEST\CONTROL03.CTL - dbid changed, wrote new name Database name changed to KBDV2.Modify parameter file and generate a new password file before restarting.Database ID for database KBDV2 changed to 1048877256.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 immediate;ORA-01109: 数据库未打开已经卸载数据库。ORACLE 例程已经关闭。

3 修改创建参数文件(pfile/Spfile) instance_name= kbdv2 ############################################ Miscellaneous###########################################compatible=9.2.0.0.0 ############################################ Security and Auditing###########################################remote_login_passwordfile=EXCLUSIVE ############################################ Sort, Hash Joins, Bitmap Indexes###########################################pga_aggregate_target=25165824sort_area_size=524288 ############################################ Database Identification###########################################db_domain=""db_name= kbdv2 SQL> CREATE SPFILE FROM PFILE='D:\oracle\admin\test\pfile\init.ora'; 文件已创建。

4 创建修改口令文件[ 区别windows 系统和unix （linux ）系统] 本人操作是在windows 系统下的，所以先修改物理服务名C:\>oradim -edit -sid drew -newsid kbdv2 并且修改注册表 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\ORACLE_SID 如果是unix 系统，就在oracle 用户下修改.profile 里的oracle_sid 创建口令文件orapwd file=D:\oracle\ora92\database\PWDkbdv2.ora password=oracle entries=5 修改listener.ora 和tnsname.ora 文件LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = kbdv2) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = kbdv2) ) ) kbdv2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = kbdv2) ) )

5 登陆数据库检查修改是否正确SQL> startupORACLE 例程已经启动。 Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytes 数据库装载完毕。ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项SQL> alter database open resetlogs; 数据库已更改。 SQL> show parameter name NAME TYPE VALUE------------------------------------ ----------- -----------db_file_name_convert stringdb_name string kbdv2global_names boolean FALSEinstance_name string kbdv2 SQL> select instance_name from v$instance; INSTANCE_NAME----------------kbdv2 这样数据库的instance 和dbname 就全部修改完成