oracle11g更改sid和dbname.docx

?viewspace-768094/oracle 11g 更改sid和dbname?分两个阶段描述，第一阶段改sid，第二阶段改dbname下面描述详细步骤首先要更改sid?1、登录数据库查看先前的sid，总共三步[oracle@localhost ~]$ sqlplus /as sysdba ?SQL*Plus: Release .0 Production on Fri Aug 9 05:53:08 2013Copyright (c) 1982, 2009, Oracle. ?All rights reserved.Connected to an idle instance.SQL startup ?ORACLE instance started. ??Total System Global Area ?539848704 bytes ?Fixed Size ? ? ? ? ? ? ? ? ?1337748 bytes ?Variable Size ? ? ? ? ? ? 360711788 bytes ?Database Buffers ? ? ? ? ?171966464 bytes ?Redo Buffers ? ? ? ? ? ? ? ?5832704 bytes ?Database mounted. ?Database opened. ?SQL select instance from v$thread ; ??INSTANCE ? ?orcl ?2、关闭数据库[sql] view plaincopyprint?SQL shutdown immediate; ?Database closed. ?Database dismounted. ?ORACLE instance shut down. ?SQL exit ?Disconnected from Oracle Database 11g Enterprise Edition Release .0 - Production ?With the Partitioning, OLAP, Data Mining and Real Application Testing options ?3、编辑/etc/oratab文件，把所有orcl换成oat[oracle@localhost ~]$ vim /etc/oratab4、更改oracle用户的 .bash_profile文件[oracle@localhost ~]$ vim .bash_profile ?5、使改好的.bash_profile文件生效?:%s/oral/oat/g[oracle@localhost ~]$ . .bash_profile ?7、查看系统环境变量[oracle@localhost ~]$ env |grep ORACLE ?ORACLE_SID=oatORACLE_BASE=/u01/appORACLE_HOME=/u01/app/oracle效果一生成。8、进入$ORACLE_HOME/dbs查看目录，看那些有orcl[oracle@localhost ~]$ cd $ORACLE_HOME/dbs ?[oracle@localhost dbs]$ ll ?total 64-rw-rw 1 oracle oinstall 1544 Jun 29 00:35 hc_DBUA0.dat-rw-rw 1 oracle oinstall 1544 Aug ?9 05:56 hc_oat.dat-rw-r--r-- 1 oracle oinstall 2851 May 15 ?2009 init.ora-rw-r 1 oracle oinstall ? 24 Aug ?8 06:46 lkHXY-rw-r 1 oracle oinstall ? 24 Jun 29 00:47 lkOAT-rw-r 1 oracle oinstall 2048 Aug ?9 06:09 orapwoatdrwx 2 oracle oinstall 4096 Jun 28 22:50 peshm_DBUA0_0drwx 2 oracle oinstall 4096 Aug ?8 06:45 peshm_hxy_0drwx 2 oracle oinstall 4096 Jun 28 23:02 peshm_oat_0-rw-r 1 oracle oinstall 3584 Aug ?9 05:53 spfileoat.ora9、更改文件名orcr oat，ORCLOAT，命令如下：?[oracle@localhost dbs]$ mv hc_orcl.dat hc_oat.dat[oracle@loc