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.