网创优客建站品牌官网
为成都网站建设公司企业提供高品质网站建设
热线:028-86922220
成都专业网站建设公司

定制建站费用3500元

符合中小企业对网站设计、功能常规化式的企业展示型网站建设

成都品牌网站建设

品牌网站建设费用6000元

本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...

成都商城网站建设

商城网站建设费用8000元

商城网站建设因基本功能的需求不同费用上面也有很大的差别...

成都微信网站建设

手机微信网站建站3000元

手机微信网站开发、微信官网、微信商城网站...

建站知识

当前位置:首页 > 建站知识

Oracle修改db_name方法

------- 修改数据库db_name的方法 

我们注重客户提出的每个要求,我们充分考虑每一个细节,我们积极的做好网站设计制作、成都网站建设服务,我们努力开拓更好的视野,通过不懈的努力,创新互联赢得了业内的良好声誉,这一切,也不断的激励着我们更好的服务客户。 主要业务:网站建设,网站制作,网站设计,小程序开发,网站开发,技术开发实力,DIV+CSS,PHP及ASP,ASP.Net,SQL数据库的技术开发工程师。

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.


文章题目:Oracle修改db_name方法
本文路径:http://bjjierui.cn/article/peciio.html

其他资讯