更改oracle数据库的实例 [英] Change instance of oracle database

问题描述

我有Oracle 11g（windows）数据库，其中我有两个数据库orcl和abc

当我打开oracle数据库控件时它显示数据库实例：orcl

现在我删除数据库orcl，当我打开oracle数据库控件时，它仍然显示数据库实例：orcl但状态已关闭。

我想要新的数据库实例：abc

如何做到这一点。 Plz help

I have Oracle 11g(windows) database in which i had two database "orcl" and "abc"
When i open oracle database control it show Database Instance: orcl
Now i delete database "orcl" and when i open oracle database control it still shows Database Instance: orcl but with status down.
I want new Database Instance: abc
How to do this. Plz help

推荐答案

我认为你的意思是你有两个独立的实例和数据库？通常情况下，两个不同的实例绑定到不同的数据库。



如果您已经拥有实例，那么为了与另一个实例一起运行，您需要更改SID定义。根据您连接数据库的方式，SID可能会有不同的更改。通常使用环境变量指定SID，因此如果这是Windows计算机，则使用命令提示符检查是否已定义ORACLE_SID，并将该环境变量的值更改为正确的SID名称。



请记住，如果在命令提示符中更改变量，则更改仅在您关闭提示符之前有效。

I take it that you mean that you have two separate instances and databases? Typically two different instances are bound to separate databases.

If yo already have the instances, in order to operate with another one, you need to change the SID definition. Depending on how you connect the database the SID may be changed differently. Very often the SID is specified using an environment variable so if this is a Windows machine, using command prompt, check if ORACLE_SID is defined and change the value of that environment variable to proper SID name.

Remember that if you change the variable in a command prompt, the change is effective only until you close the prompt.

这篇关于更改oracle数据库的实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！