修改ORACLE_SID.docxVIP

修改ORACLE_SID 检查现在数据库sid oracle@oracle[/home/oracle] echo $ORACLE_SIDorcloracle@oracle[/home/oracle] sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 20 11:14:49 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL select instance from v$thread;INSTANCE--------------------------------------------------------------------------------orcl SQLshow parameter instance INSTANCE--------------------------------------------------------------------------------orcl 现有数据库是spfile启动的,创建pfile SQLcreate pfile from spfile; 1.3、关闭数据库 SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options 修改环境变量中ORACLE_SID为修改后的SID 修改/etc/oratab中的数据库信息 /etc/oratab中记录系统中数据库的信息，如果想用$ORACLE_HOME/bin/dbstart启动数据库,需要将/etc/oratab文件中相应的数据库的项置为Y,此处主要修改实例的信息： oracle@oracle[/home/oracle] cat /etc/orataborcl:/oracle/app/10.1:Yorcl是想要改成的ORACLE_SID名称。 修改$ORACLE_HOME/dbs下相关设置 将所有文件名中包含原来的sid的修改为对应的新sid的: hc_orcl.dat-hc_cnhtm.dat lkORCL-lkCNHTM orapworcl-orapwcnhtm snapcf_orcl.f-snapcf_cnhtm.f spfileorcl.ora-spfilecnhtm.ora 修改pfile中ORACLE_SID 把pfile中ORACLE_SID设置成想要修改的实例名 修改listener.ora 修改$ORACLE_HOME/network/admin下面的listener.ora中ORACLE_SID的设置。 重建口令文件 oracle@oracle[/oracle/app/10.1/dbs]orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=yoracle@oracle[/oracle/app/10.1/dbs] ls -lrt orapw*-rw-r----- 1 oracle oinstall 2048 Dec 20 11:27 orapwcnhtm 启动收据库 oracle@oracle[/oracle/app/10.1/dbs] sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 20 11:29:53 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL startupORACLE instance started.Total System Global Area 167