新聞中心
某些系統(tǒng)是因為Oracle數(shù)據(jù)庫的名稱不是很規(guī)范,如果你不想對Oracle數(shù)據(jù)庫重新創(chuàng)建的話,你可以使用Oracle自帶的工具即nid來修改Oracle數(shù)據(jù)庫的名稱。在整個修改過程中,對控制文件和數(shù)據(jù)文件進行修改,且重置dbid,建議在修改前對數(shù)據(jù)進行備份。

在連江等地區(qū),都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局,加強發(fā)展的系統(tǒng)性、市場前瞻性、產(chǎn)品創(chuàng)新能力,以專注、極致的服務(wù)理念,為客戶提供成都網(wǎng)站設(shè)計、網(wǎng)站建設(shè)、外貿(mào)網(wǎng)站建設(shè) 網(wǎng)站設(shè)計制作定制網(wǎng)站開發(fā),公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),高端網(wǎng)站設(shè)計,營銷型網(wǎng)站,外貿(mào)營銷網(wǎng)站建設(shè),連江網(wǎng)站建設(shè)費用合理。
在本例子中,我們將Oracle數(shù)據(jù)庫中的instance_name和db_name從“oratest”修改為“test”,數(shù)據(jù)庫版本為10.2.0.3。
查看數(shù)據(jù)庫信息。
- SQL> show parameter instance_name
- NAME TYPE VALUE
- stance_name string ORATEST
- SQL> show parameter db_name
- NAME TYPE VALUE
- db_name string ORATEST
- SQL>show parameter service_name
- NAME TYPE VALUE
- db_name string ORATEST
- SQL>select dbid from v$database;
- DBID
- 3213300265
修改前Oracle數(shù)據(jù)庫名為"oratest",dbid="3213300265"。接下來修改數(shù)據(jù)庫名稱,先停止數(shù)據(jù)庫,然后啟動到mount狀態(tài)下,使用nid工具修改dbname。
- SQL> shutdown immediate
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
- SQL> startup mount
- Total System Global Area 268435456 bytes
- Fixed Size 1261272 bytes
- Variable Size 117440808 bytes
- Database Buffers 146800640 bytes
- Redo Buffers 2932736 bytes
- Database mounted.
- SQL> host;
- $ nid target="sys/password" dbname=test
- DBNEWID: Release 10.2.0.3.0 - Production on Wed Feb 4 11:12:36 2009
- Copyright (c) 1982, 2005, Oracle. All rights reserved.
- Connected to database ORATEST (DBID=3213300265)
- Connected to server version 10.2.0
- Control Files in database:
- /u02/oradata/test/control01.ctl
- /u02/oradata/test/control02.ctl
- /u02/oradata/test/control03.ctl
- Change database ID and database name ORATEST to TEST? (Y/[N]) => y
- Proceeding with operation
- Changing database ID from 3213300265 to 1976074532
- Changing database name from ORATEST to TEST
- Control File /u02/oradata/test/control01.ctl - modified
- Control File /u02/oradata/test/control02.ctl - modified
- Control File /u02/oradata/test/control03.ctl - modified
- Datafile /u02/oradata/test/system01.dbf - dbid changed, wrote new name
- Datafile /u02/oradata/test/undotbs01.dbf - dbid changed, wrote new name
- Datafile /u02/oradata/test/sysaux01.dbf - dbid changed, wrote new name
- Datafile /u02/oradata/test/users01.dbf - dbid changed, wrote new name
- Datafile /u02/oradata/test/example01.dbf - dbid changed, wrote new name
- Datafile /u02/oradata/test/temp01.dbf - dbid changed, wrote new name
- Control File /u02/oradata/test/control01.ctl - dbid changed, wrote new name
- Control File /u02/oradata/test/control02.ctl - dbid changed, wrote new name
- Control File /u02/oradata/test/control03.ctl - dbid changed, wrote new name
- NID-00600: Internal Error - [28] [12152] [0] [0]
- Change of database name and ID failed during validation -database is intact.
- DBNEWID - Completed with validation errors.
以上的相關(guān)內(nèi)容就是對Oracle數(shù)據(jù)庫中如何使用nid的修改數(shù)據(jù)庫名的介紹,望你能有所收獲。
【編輯推薦】
- Oracle數(shù)據(jù)庫中的時間處理的實際操作步驟
- Oracle通過其實際存儲過程中返回相關(guān)數(shù)據(jù)集
- Oracle提高SQL的執(zhí)行效率的3種好用方法
- Oracle Redo的并行機制運行中要用到的代碼
- Oracle數(shù)據(jù)庫與Access互導(dǎo)實例
標(biāo)題名稱:Oracle數(shù)據(jù)庫中使用nid來修改數(shù)據(jù)庫名
文章分享:http://fisionsoft.com.cn/article/cdhjgoc.html


咨詢
建站咨詢
