ORACLE實例分享：DB

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:appcswggodproduct11.2.0dbhome_1database
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.
Total System Global Area  501059584 bytes
Fixed Size                  2214736 bytes
Variable Size             318768304 bytes
Database Buffers          176160768 bytes
Redo Buffers                3915776 bytes
Database mounted.
Database opened.
SQL> exit
2.數據庫更名後，配置靜態監聽
[oracle@h1 dbs]$ netmgr
#-------------------1.配置監聽文件
 

配置遠程namespace：
 
驗證： 
 
#----------------2.修改靜態監聽參數

SQL> show parameter listener;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string      BITC
remote_listener                      string
SQL> alter system set local_listener="BITC";
System altered.
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the P