Rename DB with NID

最新推荐文章于 2024-10-31 20:44:33 发布

jiawancai

最新推荐文章于 2024-10-31 20:44:33 发布

阅读量706

点赞数

分类专栏： oracle日记文章标签： database file sun oracle output system

oracle日记专栏收录该内容

43 篇文章 0 订阅

订阅专栏

Rename Database 9i and above

Check the Db name

SQL> select name from v$database;

NAME
---------
SUN

START :

1.shutdown immediate
2.startup mount
3.$nid target=sys as sysdba dbname=orcl setname=yes
OUTPUT :

[oracle@Sunshine dbs]$ nid target=sys as sysdba dbname=orcl setname=yes
DBNEWID: Release 10.1.0.3.0 - Production
Copyright (c) 2001, 2004, Oracle. All rights reserved.

Password:
Connected to database SUN (DBID=1134261166)

Connected to server version 10.1.0

Control Files in database:
/home/oracle/product/10.1.0/oradata/orcl/control01.ctl
/home/oracle/product/10.1.0/oradata/orcl/control02.ctl
/home/oracle/product/10.1.0/oradata/orcl/control03.ctl

Change database name of database SUN to ORCL? (Y/[N]) => Y

Proceeding with operation
Changing database name from SUN to ORCL
Control File /home/oracle/product/10.1.0/oradata/orcl/control01.ctl - modified
Control File /home/oracle/product/10.1.0/oradata/orcl/control02.ctl - modified
Control File /home/oracle/product/10.1.0/oradata/orcl/control03.ctl - modified
Datafile /home/oracle/product/10.1.0/oradata/orcl/system01.dbf - wrote new name
Datafile /home/oracle/product/10.1.0/oradata/orcl/undotbs01.dbf - wrote new name
Datafile /home/oracle/product/10.1.0/oradata/orcl/sysaux01.dbf - wrote new name
Datafile /home/oracle/product/10.1.0/oradata/orcl/users01.dbf - wrote new name
Datafile /home/oracle/product/10.1.0/oradata/orcl/example01.dbf - wrote new name
Datafile /home/oracle/product/10.1.0/oradata/orcl/temp01.dbf - wrote new name
Control File /home/oracle/product/10.1.0/oradata/orcl/control01.ctl - wrote new name
Control File /home/oracle/product/10.1.0/oradata/orcl/control02.ctl - wrote new name
Control File /home/oracle/product/10.1.0/oradata/orcl/control03.ctl - wrote new name
Instance shut down

Database name changed to ORCL.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.

5.mv spfilesun.ora spfileorcl.ora
6.rm orapwsun
7.orapwd file=orapworcl password=orcl
8.EXPORT ORACLE_SID=orcl
9.sqlplus / as sysdba
10.startup force nomount quiet
11.alter system set db_name='orcl' scope=spfile
12.startup force;
13.SQL> select name from v$database;

NAME
---------
ORCL

DB name changed succesfully