這篇文章主要講解了“Oracle怎么修改數(shù)據(jù)庫名稱”，文中的講解內(nèi)容簡單清晰，易于學(xué)習(xí)與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“Oracle怎么修改數(shù)據(jù)庫名稱”吧！

創(chuàng)新互聯(lián)公司網(wǎng)站建設(shè)公司是一家服務(wù)多年做網(wǎng)站建設(shè)策劃設(shè)計制作的公司,為廣大用戶提供了成都網(wǎng)站設(shè)計、網(wǎng)站建設(shè)，成都網(wǎng)站設(shè)計，廣告投放，成都做網(wǎng)站選創(chuàng)新互聯(lián)公司，貼合企業(yè)需求，高性價比，滿足客戶不同層次的需求一站式服務(wù)歡迎致電。

1.關(guān)閉監(jiān)聽，正常關(guān)閉Oracle

 [oracle@node3 ~]$ lsnrctl stop

 LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2019 09:35:04

 Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

 The command completed successfully

 SQL> shutdown immediate

 Database closed.

 Database dismounted.

 ORACLE instance shut down.

2.重啟數(shù)據(jù)庫到mount狀態(tài)

 SQL> startup mount force

 ORACLE instance started.

 Total System Global Area 2.1379E+10 bytes

 Fixed Size                  2262656 bytes

 Variable Size            2.0401E+10 bytes

 Database Buffers          939524096 bytes

 Redo Buffers               36073472 bytes

 Database mounted.

3.nid修改數(shù)據(jù)庫名稱

 nid target=sys/xxx dbname=BDDEV1 logfile=nid_0219.log

 查看日志文件：

 [oracle@node3 ~]$ more nid_0219.log 

 DBNEWID: Release 11.2.0.4.0 - Production on Tue Feb 19 09:33:15 2019

 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 Connected to database BDDEV2 (DBID=2430401913)

 Connected to server version 11.2.0

 Control Files in database:

     /opt/app/oracle/oradata/BDDEV1/control01.ctl

     /opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl

 Changing database ID from 2430401913 to 2391707803

 Changing database name from BDDEV2 to BDDEV1

     Control File /opt/app/oracle/oradata/BDDEV1/control01.ctl - modified

     Control File /opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl - modified

     Datafile /opt/app/oracle/oradata/BDDEV1/system01.db - dbid changed, wrote new name

     Datafile /opt/app/oracle/oradata/BDDEV1/sysaux01.db - dbid changed, wrote new name

     Datafile /opt/app/oracle/oradata/BDDEV1/undotbs01.db - dbid changed, wrote new name

     Datafile /opt/app/oracle/oradata/BDDEV1/users01.db - dbid changed, wrote new name

     Datafile /opt/app/oracle/oradata/BDDEV1/tbs_soe.db - dbid changed, wrote new name

     Datafile /opt/app/oracle/oradata/BDDEV1/temp01.db - dbid changed, wrote new name

     Control File /opt/app/oracle/oradata/BDDEV1/control01.ctl - dbid changed, wrote new name

     Control File /opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl - dbid changed, wrote new name

     Instance shut down

 Database name changed to BDDEV1.

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

 Database ID for database BDDEV1 changed to 2391707803.

 All previous backups and archived redo logs for this database are unusable.

 Database is not aware of previous backups and archived logs in Recovery Area.

 Database has been shutdown, open database with RESETLOGS option.

 Succesfully changed database name and ID.

 DBNEWID - Completed succesfully.

 如果日志文件中有報錯信息，比如：NID-00135: There are 1 active threads，則可能是因為沒有正常關(guān)閉數(shù)據(jù)庫導(dǎo)致的。

4.修改參數(shù)文件中db_name后，啟動Oracle

 SQL> startup nomount

 ORACLE instance started.

 Total System Global Area 1185853440 bytes

 Fixed Size                  2252664 bytes

 Variable Size             436207752 bytes

 Database Buffers          738197504 bytes

 Redo Buffers                9195520 bytes

 SQL> alter system set db_name=BDDEV1 scope=spfile;

 System altered.

 SQL> shutdown immediate

 ORA-01507: database not mounted

 ORACLE instance shut down.

 SQL> startup mount

 ORACLE instance started.

 Total System Global Area 1185853440 bytes

 Fixed Size                  2252664 bytes

 Variable Size             436207752 bytes

 Database Buffers          738197504 bytes

 Redo Buffers                9195520 bytes

 Database mounted.

 resetlogs方式打開數(shù)據(jù)庫：

 SQL> alter database open resetlogs;

 Database altered.

5.打開監(jiān)聽

 lsnrctl start

感謝各位的閱讀，以上就是“Oracle怎么修改數(shù)據(jù)庫名稱”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對Oracle怎么修改數(shù)據(jù)庫名稱這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是創(chuàng)新互聯(lián)，小編將為大家推送更多相關(guān)知識點(diǎn)的文章，歡迎關(guān)注！