如今數據庫得到了廣泛的應用，關于數據庫名大家可以修改，下文中將為大家講解修改數據庫名的方法。

1.用oracle自帶的工具nid改數據庫名

在本例中，假設原來的數據庫名為test,要改成testdb,原實例名(service_name,instance_name)test,要改成testdb.

nid是自帶的工具，在oracle_home/bin目錄中.以下方法假設登陸到數據庫本機做。

1.1 sqlplus "sys/password as sysdba"

1.2 sql>shutdown immediate --先停掉數據庫

1.3 sql>startup mount --nid需要在mount狀態下才能做。

1.4sql>host nid target=sys/password dbname=new_dbname --nid是一個在操作系統下執行的命令，在sqlplus環境中用host 去調用操作系統環境下的命令。命令中，當你想將數據庫名字改為TESTDB時，應寫成dbname=testdb

1.5執行后程序會詢問：

Change database ID and database name TEST to TESTDB? (Y/[N]) =>y

敲y確定。

之后程序會對控制文件，數據文件進行修改：

Control File C:ORACLEORADATATESTCONTROL01.CTL - modified

Control File C:ORACLEORADATATESTCONTROL02.CTL - modified

Control File C:ORACLEORADATATESTCONTROL03.CTL - modified

Datafile C:ORACLEORADATATEST YSTEM01.DBF - dbid changed, wrote new name

Datafile C:ORACLEORADATATESTUNDOTBS01.DBF - dbid changed, wrote new nam

Datafile C:ORACLEORADATATESTINDX01.DBF - dbid changed, wrote new name

Datafile C:ORACLEORADATATESTTOOLS01.DBF - dbid changed, wrote new name

Datafile C:ORACLEORADATATESTUSERS01.DBF - dbid changed, wrote new name

Datafile D:DATAFILEPORMALS_SPA.DBF - dbid changed, wrote new name

Datafile C:ORACLEORADATATESTOEM_REPOSITORY.DBF - dbid changed, wrote ne

name

Datafile D:DATAFILEPORMALS_SPA_01.DBF - dbid changed, wrote new name

Datafile C:ORACLEORADATATESTTEMP01.DBF - dbid changed, wrote new name

Control File C:ORACLEORADATATESTCONTROL01.CTL - dbid changed, wrote new

name

Control File C:ORACLEORADATATESTCONTROL02.CTL - dbid changed, wrote new

name

Control File C:ORACLEORADATATESTCONTROL03.CTL - dbid changed, wrote new

name

Database name changed to TESTDB.

Modify parameter file and generate a new password file before restarting.

Database ID for database TESTDB changed to 2321050327.

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.

1.6 停庫再到mount狀態下改db_name:

sql>shutdown immediate;

sql>startup mount

sql>alter system set db_name=testdb scope=spfile;

sql>shutdown immediate;

1.7 重新創建sys的password文件：

passwd文件通常放在oracle_home/database目錄下，文件命名形式為PWDsid.ora，sid為實例名(Service_name)，如當前的數據庫名及service_name為test,則passwd文件為PWDtest.ora

sql>host orapwd file=c:oracleora92databasepwdtest.ora password=123456 entries=5

要注意一下，此時雖然數據庫名已經改成testdb了，但instance_name還是test，所以，passwd文件必須跟以前一樣。否則會出錯。

1.8 開啟數據庫：（要open resetlogs)

sql>startup mount

sql>alter database open resetlogs;

1.9 檢查：

sql>select dbid,name from v$database;

2.改好數據庫名后，接著改instance_name

2.1如果是windows系統，要先把所有的oracle服務先關閉，否則會出錯。

2.2先將原來的service_name刪除:

在操作系統中，進入cmd，

oradim -delete -sid test

2.3創建密碼文件

orapwd file=c:/oracle/ora92/database/pwdtestdb.ora password=....entries=

2.4創建一個新的sid，也就是你想改名的sid：

oradim -new -sid testdb -intpwd 密碼 -startmode a -pfile c:oracleora92databaseinittestdb.ora

當數據庫啟動時，會在database目錄中找spfile，如果spfile不在就找initSID.ora這個文件來頂。所以，可以把pfile直接創建在這里。方便數據庫的啟動。

2.5 進入oracle并創建spfile：

c: set oracle_sid=testdb

c:sqlplus "sys/password as sysdba"

sql>create spfile from pile='c:oracleora92databaseinittestdb.ora';

2.6 reload listener：

c:lsnrctl reload

2.7 open resetlogs:

改數據庫名字精簡版

1.用oracle自帶的工具nid改數據庫名

1.1 sqlplus "sys/zhuzerp as sysdba"

1.2 sql>shutdown immediate

1.3 sql>startup mount

1.4 sql>host nid target=sys/zhuzerp dbname=ORCLERP

1.5 Change database ID and database name zhuzerp to ORCLERP? (Y/[N]) =>y

1.6 sql>shutdown immediate

sql>startup mount

sql>alter system set db_name=ORCLERP scope=spfile;

sql>shutdown immediate

1.7 重新創建sys的password文件

host orapwd file=D:\Oracle\database\PWDzhuzerp.ora password=orclerp entries=5

1.8 sql>startup mount

sql>alter database open resetlogs;

1.9 sql>select dbid,name from v$database;

2.更改instance_name

2.1 net stop oracleservicezhuzerp

2.2 oradim -delete -sid zhuzerp

2.3 orapwd file=D:\Oracle\database\PWDORCLERP.ora password=orclerp entries=5

2.4 修改文件中的db_name和instance_name

D:\Oracle\admin\test\pfile\init.ora.8252009155525

2.5 oradim -new -sid ORCLERP -intpwd orclerp -startmode a -pfile D:\Oracle\admin\zhuzerp\pfile\init.ora

2.6 set oracle_sid=orclerp

2.7 sqlplus "sys/orclerp as sysdba"

2.8 create spfile from pfile='D:\Oracle\admin\zhuzerp\pfile\init.ora';

2.9 lsnrctl reload

相信大家通過上文的學習之后，對于如何修改數據庫名已經有所了解，以后在工作中遇到類似問題就能夠輕松解決了，希望上文中涉及到內容對待大家能夠有所幫助。