ORACLE 11g 修改db_unique_name参数

1，查看原有的db_unique_name信息

SQL> show parameter name;

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert             string
db_name                  string  orcl
db_unique_name               string  orcl
global_names                 boolean     FALSE
instance_name                string  orcl
lock_name_space              string
log_file_name_convert            string
service_names                string  orcl
SQL>

2，创建临时pfile，修改db_unique_name

SQL> create pfile='/oracle/p1.ora' from spfile;

File created.

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

修改临时pfile文件（/oracle/p1.ora）里面的db_unique_name值为orcl_m1，以临时pfile启动

vim /oracle/p1.ora
*.db_unique_name=orcl_m1

3，更新spfile、pile文件

根据修改的临时参数文件，更新默认的启动参数文件，

SQL> create spfile from pfile='/oracle/p1.ora';

File created.

SQL>

根据新的spfile，然后更新默认的pfile

SQL> create pfile from spfile;

File created.

SQL>

4，启动数据库，查看db_unique_name已经变成新的名称

SQL> startup;
ORACLE instance started.

Total System Global Area 2.6991E+10 bytes
Fixed Size          2213976 bytes
Variable Size        1.9596E+10 bytes
Database Buffers     7247757312 bytes
Redo Buffers          145174528 bytes
Database mounted.
Database opened.
SQL> 
SQL> show parameter name;

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert             string  /home/oradata/orcl,/home/
                         oradata/orcl
db_name                  string  orcl
db_unique_name               string  orcl_m1
global_names                 boolean     FALSE
instance_name                string  orcl
lock_name_space              string
log_file_name_convert            string  /home/oradata/orcl,/home/
                         oradata/orcl
service_names                string  orcl
SQL>

5，最后有一种直接在线上online改然后重启生效

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

System altered.

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

Total System Global Area 2.6991E+10 bytes
Fixed Size          2213976 bytes
Variable Size        1.9596E+10 bytes
Database Buffers     7247757312 bytes
Redo Buffers          145174528 bytes
Database mounted.
Database opened.
SQL> 
SQL>  show parameter db_unique_name;

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
db_unique_name               string  orcl_m1
SQL>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!