oracle切换instance,三、更改INSTANCE_NAME

三、更改INSTANCE_NAME

1、检查当前的instance_name 是wwl

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

wwl

2、创建pfile参数文件

SQL> create pfile from spfile;

File created.

3、关闭数据库

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> host

4、切换到操作系统命令行，修改用户环境下的.bash_profile参数文件，将ORACLE_SID的值由原来的wwl改为wwl01

[oracle@ora10g ~]$ cd

[oracle@ora10g ~]$ 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_SID=wwl01

export ORACLE_BASE=/orasoft/

export ORACLE_HOME=$ORACLE