ORACLE 11g 修改db_unique_name参数

来源：互联网发布：福建摩尔软件骗局编辑：程序博客网时间：2024/05/16 03:07

1，查看原有的db_unique_name信息

SQL> show parameter name;NAME                     TYPE    VALUE------------------------------------ ----------- ------------------------------db_file_name_convert             stringdb_name                  string  orcldb_unique_name               string  orclglobal_names                 boolean     FALSEinstance_name                string  orcllock_name_space              stringlog_file_name_convert            stringservice_names                string  orclSQL>

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 bytesFixed Size          2213976 bytesVariable Size        1.9596E+10 bytesDatabase Buffers     7247757312 bytesRedo Buffers          145174528 bytesDatabase mounted.Database opened.SQL> SQL> show parameter name;NAME                     TYPE    VALUE------------------------------------ ----------- ------------------------------db_file_name_convert             string  /home/oradata/orcl, /home/                         oradata/orcldb_name                  string  orcldb_unique_name               string  orcl_m1global_names                 boolean     FALSEinstance_name                string  orcllock_name_space              stringlog_file_name_convert            string  /home/oradata/orcl, /home/                         oradata/orclservice_names                string  orclSQL>

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 bytesFixed Size          2213976 bytesVariable Size        1.9596E+10 bytesDatabase Buffers     7247757312 bytesRedo Buffers          145174528 bytesDatabase mounted.Database opened.SQL> SQL>  show parameter db_unique_name;NAME                     TYPE    VALUE------------------------------------ ----------- ------------------------------db_unique_name               string  orcl_m1SQL>

2 0