修改oracle实例名

最新推荐文章于 2024-09-04 09:30:11 发布

jadesuper6

最新推荐文章于 2024-09-04 09:30:11 发布

阅读量583

点赞数

分类专栏： oracle 文章标签： oracle database application solaris testing 64bit

本文链接：https://blog.csdn.net/jadesuper6/article/details/8094014

版权

oracle 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

目前的实例名是PROD9，我要改为RAC 。

1、创建一个pfile ，一会儿要用。
bash-3.2$sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 21 10:48:59 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL>
SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

2、修改环境变量里的ORACLE_SID ,改为新的RAC 。

Linux 是里.bash_profile 。
Solaris 里是.profile 。执行下面的命令使其生效。
bash-3.2$source .profile
bash-3.2$ echo $ORACLE_SID
RAC
bash-3.2$
bash-3.2$ cd /export/home/ora10/prod10db/10.2.0/db
db4_BI10/ dbs/
bash-3.2$ cd /export/home/ora10/prod10db/10.2.0/dbs/
bash-3.2$ echo $ORACLE_SID
RAC
bash-3.2$
bash-3.2$ ls -al
total 87186
drwxr-x---   2 ora10    dba          512 May 21 10:43 .
drwxr-xr-x 70 ora10    dba         1536 Aug 13 2009 ..
-rw-r--r--   1 ora10    dba            0 Nov 10 2010 PROD9_db_ifile.ora
-rw-r-----   1 ora10    dba      22249472 May 15 13:46 c-4167122059-20120515-00
-rw-r-----   1 ora10    dba      22249472 May 15 14:36 c-4167122059-20120515-01
-rw-rw----   1 ora10    dba         1544 May 15 17:40 hc_BI10.dat
-rw-rw----   1 ora10    dba         1544 May 21 10:43 hc_PROD9.dat
-rw-r-----   1 ora10    dba         8385 Sep 11 1998 init.ora
-rw-r--r--   1 ora10    dba        20713 May 15 14:16 initBI10.ora
-rw-r--r--   1 ora10    dba        20716 May 15 14:14 initBI10.orabak
-rw-r--r--   1 ora10    dba         2655 May 21 10:43 initPROD9.ora
-rw-r--r--   1 ora10    dba        12920 May 3 2001 initdw.ora
-rw-rw----   1 ora10    dba           24 Aug 11 2009 lkBI10
-rw-rw----   1 ora10    dba           24 Nov 10 2010 lkPROD9
-rw-rw----   1 ora10    dba           24 May 21 10:37 lkRAC
-rw-r-----   1 ora10    dba         1536 May 17 2011 orapwBI10
-rw-r-----   1 ora10    dba         2560 Nov 10 2010 spfileBI10.ora.bak
-rw-r-----   1 ora10    dba         6656 May 21 10:38 spfilePROD9.ora

#创建新实例的pfile
bash-3.2$cp initPROD9.ora initRAC.ora
bash-3.2$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 21 10:48:59 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL>conn / as sysdba
Connected to an idle instance.

#使用新的实例名启动数据库
SQL> startup mount pfile='/export/home/ora10/prod10db/10.2.0/dbs/initRAC.ora';
ORACLE instance started.

Total System Global Area 5.3687E+10 bytes
Fixed Size                  2239008 bytes
Variable Size            1245238752 bytes
Database Buffers         5.2429E+10 bytes
Redo Buffers               10813440 bytes
Database mounted.
SQL>
SQL> select instance_name from v$instance;

INSTANCE_NAME
--------------------------------
RAC

SQL> alter database open;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME                    STATUS
-------------------------------- --------------------
RAC                              OPEN

SQL>create spfile from pfile;

File created.

SQL>
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
SQL>