如何更改ORACLE的实例名

显示全部楼层 · 2012-7-12 18:47:29

用户想更改ORACLE数据库的实例名(SID)和服务名(SERVICE NAME)，但是，本人不敢确定能不能改，请各位老大指教！！

千问 · 2012-7-12 18:47:29

在线等待各位老大答复呀！！！

千问 · 2012-7-12 18:47:29

SID好改，用ORADIM 删除重新创建即可。注意INIT也要和此一样。
SERVICE_NAME 比较啰嗦。

千问 · 2012-7-12 18:47:29

9i下有一个dbnewid
我没有试验过。

千问 · 2012-7-12 18:47:29

http://www.oracle-base.com/articles/9i/DBNEWID.php
是nid

千问 · 2012-7-12 18:47:29

如果不该数据库名字，直接把instance_name改掉就完事了

千问 · 2012-7-12 18:47:29

各位老大：
环境是UNIX操作系统：IBM AIX V5302，数据库版本是ORALE V9204，各位老大请指教：在这种环境下，如何修改ORACLE 的SID？？？

千问 · 2012-7-12 18:47:29

为什么要修改SID？
说说目的吧，因为绝大多数情况下是不需要改这个的

千问 · 2012-7-12 18:47:29

最初由 Dragonc 发布
[B]各位老大：
环境是UNIX操作系统：IBM AIX V5302，数据库版本是ORALE V9204，各位老大请指教：在这种环境下，如何修改ORACLE 的SID？？？ [/B]
用Nid,见如下的eg:
==================================================
SQL> STARTUP PFILE=init$Log1.ora EXCLUSIVE MOUNT;
SQL> EXIT;
% nid TARGET=SYS/CHANGE_ON_INSTALL DBNAME=LOG2
Connected to database PRIM (DBID=1456557175)
Control Files in database:
/private2/ade/oradata/log2/t_cf1.f
Change database ID and database name PRIM to LOG2? (Y/[N])
=> y
Proceeding with operation
Changing database ID from 1456557175 to 416458362
Changing database name from PRIM to LOG2
Control File /private2/ade/oradata/log2/t_cf1.f - modified
Datafile /private2/ade/oradata/log2/t_db1.f - dbid changed,
wrote new name
Datafile /private2/ade/oradata/log2/log_mnrts.f-dbid changed,
wrote new name
Control File /private2/ade/oradata/log2/t_cf1.f-dbid changed,
wrote new name
Database name changed to LOG2.
Database ID for database LOG2 changed to 416458362.
All previous backups and archived redo logs for this
database are unusable.
Shut down database and open with RESETLOGS option.
Successfully changed database name and ID.
DBNEWID - Completed successfully.
SQL> SHUTDOWN IMMEDIATE
=====================================================
然后把参数文件、监听、trace文件目录等该改的都改一下就Ok了。

千问 · 2012-7-12 18:47:29

最初由 hrb_qiuyb 发布
[B]
用Nid,见如下的eg:
==================================================
SQL> STARTUP PFILE=init$Log1.ora EXCLUSIVE MOUNT;
SQL> EXIT;
% nid TARGET=SYS/CHANGE_ON_INSTALL DBNAME=LOG2
Connected to database PRIM (DBID=1456557175)
Control Files in database:
/private2/ade/oradata/log2/t_cf1.f
Change database ID and database name PRIM to LOG2? (Y/[N])
=> y
Proceeding with operation
Changing database ID from 1456557175 to 416458362
Changing database name from PRIM to LOG2
Control File /private2/ade/oradata/log2/t_cf1.f - modified
Datafile /private2/ade/oradata/log2/t_db1.f - dbid changed,
wrote new name
Datafile /private2/ade/oradata/log2/log_mnrts.f-dbid changed,
wrote new name
Control File /private2/ade/oradata/log2/t_cf1.f-dbid changed,
wrote new name
Database name changed to LOG2.
Database ID for database LOG2 changed to 416458362.
All previous backups and archived redo logs for this
database are unusable.
Shut down database and open with RESETLOGS option.
Successfully changed database name and ID.
DBNEWID - Completed successfully.
SQL> SHUTDOWN IMMEDIATE
=====================================================
然后把参数文件、监听、trace文件目录等该改的都改一下就Ok了。 [/B]
呵呵，应该还要加参数SETNAME=YES吧？楼主只要求改DBNAME～