安装Oracle 11g后无法打开sql plus [英] sql plus not opening after installing oracle 11g

问题描述

我安装了oracle 11g，我试图从命令提示符下打开sqlplus，但是它在一秒钟之内就打开和关闭了.我也尝试从安装位置打开sqlplus.它仍然显示相同的行为.谁能帮助我解决方案.我已经两次卸载并安装了oracle，以解决其他一些错误.之前它可以正常工作，但是当我第二次安装它时，sql plus无法打开.

I installed oracle 11g and im was trying to open sqlplus from command prompt but it is opening and closing in a fraction of second..I tried opening the sqlplus from the installed location as well. It still shows the same behaviour. Can anyone help me with a solution. I already uninstalled and installed the oracle twice for some other errors. Earlier it was working fine, but when I installed it the second time, sql plus is not opening .

我感谢任何建议.

谢谢

推荐答案

Manasa，

如果错误消息显示为

SP2-0750:您可能需要将ORACLE_HOME设置为Oracle软件目录

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

如您所述，

然后答案可能取决于您使用的操作系统.假设您使用的是Windows，可以转到系统属性->高级选项卡->环境变量->系统变量，然后检查变量ORACLE_HOME和PATH.

as you stated then the answer can depend on what OS you are using. Let's say you are using some flavor of windows, you can go to the system properties -> advanced tab -> environment variables -> system variables and check the variables ORACLE_HOME and PATH.

假设您在C:\ oracle \ ora11 \

Let's say that you installed oracle at C:\oracle\ora11\

在PATH变量以及其他值中，您需要具有oracle bin目录的位置；在这种情况下:

In the PATH variable, among other values, you need to have the location of oracle bin directory; in this instance:

'C:\oracle\ora11\bin;'

现在，我应该注意，当oracle引用path变量时，它将查找oracle路径的第一个实例.因此，假设您在以下位置安装了两个oracle:

Now, I should note that when oracle references the path variable, it looks for the first instance of an oracle path. So let's say you had two installations of oracle at the following locations:

'C:\oracle\ora9i\'
'C:\oracle\ora11\'

路径变量设置如下:

'C:\oracle\9i\bin;C:\oracle\ora11\bin;'

结果将是这样，当您打开sqlplus时，它将自动引用位于'C:\ oracle \ 9i \ bin \'-可能是哪个版本的sqlplus程序. (这对于在bin目录中找到的所有oracle实用程序(例如DBCA或expdp而言也是如此)(这还假设您已注意到已明确声明要运行哪个sqlplus，即，您只需在命令提示符下键入"sqlplus"，而不是在命令行中输入"sqlplus" 'c:\ oracle \ ora11 \ bin \ sqlplus')

The result would be so that when you open sqlplus, it would automatically reference the sqlplus program located at 'C:\oracle\9i\bin\' - whichever version that may be. (this would also be true for any oracle utility found in the bin directory such as DBCA or expdp) (this is also assuming you are note explicitly declaring which sqlplus you want to run i.e. you just type 'sqlplus' in a command prompt rather than 'c:\oracle\ora11\bin\sqlplus')

oracle_home变量将设置为'C:\ oracle \ ora11 \'，但是我会注意到我的Windows 7桌面版本在此值为null的情况下可以正常运行.但是，它不是您想象中的生产桌面.

The oracle_home variable would be set to 'C:\oracle\ora11\' however i'll note that my windows 7 desktop version runs fine with this value null. It is, however, not a production desktop as you would imagine.

这篇关于安装Oracle 11g后无法打开sql plus的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！