------- 修改数据库db_name的方法
目前
成都创新互联公司已为成百上千的企业提供了网站建设、域名、网络空间、
成都网站托管、企业网站设计、
松溪网站维护等服务，公司将坚持客户导向、应用为本的策略，正道将秉承"和谐、参与、激情"的文化，与客户和合作伙伴齐心协力一起成长，共同发展。
SQL> startup mount
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2213896 bytes
Variable Size 335546360 bytes
Database Buffers 71303168 bytes
Redo Buffers 4308992 bytes
Database mounted.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
[oracle@OEL6 dbs]$ nid target=sys/yuanlei@orcl2 dbname=orcl
DBNEWID: Release 11.2.0.1.0 - Production on Tue Aug 19 22:22:39 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to database ORCL2 (DBID=836865814)
Connected to server version 11.2.0
Control Files in database:
/u01/app/oracle/oradata/orcl2/control01.ctl
/u01/app/oracle/oradata/orcl2/control02.ctl
Change database ID and database name ORCL2 to ORCL? (Y/[N]) => y
Proceeding with operation
Changing database ID from 836865814 to 1383851439
Changing database name from ORCL2 to ORCL
Control File /u01/app/oracle/oradata/orcl2/control01.ctl - modified
Control File /u01/app/oracle/oradata/orcl2/control02.ctl - modified
Datafile /u01/app/oracle/oradata/orcl2/system01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/sysaux01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/undotbs01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/users01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/example01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl02.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl03.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl04.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl05.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl06.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl07.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/tbs_yl08.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/rcatalog.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/orcl2/temp01.db - dbid changed, wrote new name
Control File /u01/app/oracle/oradata/orcl2/control01.ctl - dbid changed, wrote new name
Control File /u01/app/oracle/oradata/orcl2/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to ORCL.
Modify parameter file and generate a new password file before restarting.
Database ID for database ORCL changed to 1383851439.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
文章标题：Oracle修改db_name方法-创新互联
当前网址：
http://cdkjz.cn/article/csdppd.html
