ORACLE实例RENAME，DB_LINK同步(Materialized View,Snapshot）

1.修改数据库名1.查看oracle实例名2.shutdownimmediate3.lsnrctlstop$ORACLE_SID#----------windows下关闭使用oracle服务4.修改/etc/oratab的$ORACLE_SID#------

1.修改数据库名

1.查看oracle实例名
2.shutdown immediate
3.lsnrctl stop $ORACLE_SID#----------windows下关闭使用oracle服务
4.修改 /etc/oratab 的$ORACLE_SID#------------windows没有
5.修改用户环境变量.bashprofile  #------------windows没有
6.linux下$ORACLE_HOME/dbs 修改有关$ORACLE_SID的文件名
  windows下$ORACLE_HOME/database 修改有关$ORACLE_SID的文件名
7.重新生成密码文件，启动数据库
liunx：orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y
windows：
在一个cmd运行oracle %ORACLE_ORCL%
在另一个cmd运行
set ORACLE_HOME=E:\app\cswggod\product\11.2.0\dbhome_1\database
set ORACLE_ORCL=orcl
orapwd file=%ORACLE_HOME%/ORACLE_HOME/dbs/orapw%ORACLE_SID% password=oracle entries=5 force=y
startup

#-------------------1.选择orcl实例

[oracle@h1 ~]$ sqlplus "/as SYSDBA"

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 12 03:07:58 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

#-------------2.查看实例

SQL> select * from v$thread; 
 

SQL> select instance_name from v$instance;
 
INSTANCE_NAME
----------------
orcl
#-----------------3.关机 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

#-------------4.关闭监听

[oracle@h1 ~]$ lsnrctl stop orcl

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-NOV-2012 03:20:11

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.5.130)(PORT=1522)))
The command completed successfully

#--------------5.修改/etc/oratab

[oracle@h1 ~]$ su root
Password:
[root@h1 oracle]# vi /etc/oratab

#------------orcl 修改为bitc

bitc:/app/oracle/product/11.2.0/dbhome_2:N
test:/app/oracle/product/11.2.0/dbhome_2:N
"/etc/oratab" 24L, 764C written
[root@h1 oracle]#

#-----------------6.修改.bash_profile并生效

[root@h1 oracle]# su oracle

[oracle@h1 ~]$ pwd
/home/oracle

[oracle@h1 ~]$ vi .bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_2
export ORACLE_SID=bitc
export PATH=$ORACLE_HOME/bin:.:$PATH

".bash_profile" 16L, 323C written                            
[oracle@h1 ~]$ . .bash_profile

[oracle@h1 ~]$ echo $ORACLE_SID
bitc

#---------------------7.修改配置文件名

[oracle@h1 ~]$ cd $ORACLE_HOME/dbs
[oracle@h1 dbs]$ ls -al
total 56
drwxr-xr-x.  2 oracle oinstall 4096 Nov 12 03:18 .
drwxr-xr-x. 76 oracle oinstall 4096 Nov 10 00:52 ..
-rw-rw----.  1 oracle oinstall 1544 Nov 10 00:40 hc_DBUA0.dat
-rw-rw----.  1 oracle oinstall 1544 Nov 12 03:18 hc_orcl.dat
-rw-rw----.  1 oracle oinstall 1544 Nov 12 03:03 hc_test.dat
-rw-r--r--.  1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r-----.  1 oracle oinstall 1906 Nov  9 23:35 initorcl.ora
-rw-r-----.  1 oracle oinstall   24 Nov  3 07:13 lkORCL
-rw-r-----.  1 oracle oinstall   24 Nov 10 00:45 lkTEST
-rw-r-----.  1 oracle oinstall 1536 Nov 10 06:40 orapworcl
-rw-r-----.  1 oracle oinstall 1536 Nov 10 04:23 orapwtest
-rw-r-----.  1 oracle oinstall 2560 Nov 12 03:04 spfileorcl.ora
-rw-r-----.  1 oracle oinstall 2560 Nov  9 23:05 spfileorcl.ora.bak
-rw-r-----.  1 oracle oinstall 3584 Nov 12 03:03 spfiletest.ora

[oracle@h1 dbs]$ chmod 777 *

[oracle@h1 dbs]$ mv hc_orcl.dat hc_bitc.dat
[oracle@h1 dbs]$ mv lkORCL lkBITC
[oracle@h1 dbs]$ mv orapworcl orapwbitc
[oracle@h1 dbs]$ mv spfileorcl.ora spfilebitc.ora
[oracle@h1 dbs]$

[oracle@h1 dbs]$ ls
hc_bitc.dat   init.ora      lkTEST     spfilebitc.ora
hc_DBUA0.dat  initorcl.ora  orapwbitc  spfileorcl.ora.bak
hc_test.dat   lkBITC        orapwtest  spfiletest.ora

#-----------------8.生成密码文件

[oracle@h1 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y

#---------------9.启动数据库

[oracle@h1 dbs]$ echo $ORACLE_SID
bitc
[oracle@h1 dbs]$ sqlplus "/as SYSDBA"

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 12 03:35:11 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.