首页 > 技术文章 > 修改 db_unique_name

kramer 2014-02-24 15:37 原文

在创建DB的时候 db_unique_name设置错了。本来我是想让

db_name=itid

db_unique_name=itid1

 

不过想改回来很简单的。

SQL> alter system set db_unique_name='itid1' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  502181888 bytes
Fixed Size                  1345912 bytes
Variable Size             390071944 bytes
Database Buffers          104857600 bytes
Redo Buffers                5906432 bytes
Database mounted.
Database opened.
SQL> show parameter db_unique_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      itid1

 

推荐阅读