SP2-1503:无法初始化 Oracle 调用接口 SP2-0152:ORACLE 可能无法正常运行

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/26773785/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 02:36:25  来源:igfitidea点击:

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

oraclewindows-8.1

提问by Kumar

I have install the Oracle Client 10.2.0 in my windows 8.1 machine. After installation this oracle client is able to connect with the database when we login in as a Administrator into the machine/pc. If we are login with the normal user into machine/pc then we are not able to connect with the database. In this scenario the oracle client application is getting close after enter username, password and database name and press button to connect into oracle client/Sqlplus to connect.

我已经在我的 Windows 8.1 机器上安装了 Oracle Client 10.2.0。安装后,当我们以管理员身份登录机器/PC 时,此 oracle 客户端能够与数据库连接。如果我们以普通用户登录到机器/电脑,那么我们将无法与数据库连接。在这种情况下,在输入用户名、密码和数据库名称后,oracle 客户端应用程序正在关闭,然后按下按钮连接到 oracle 客户端/Sqlplus 进行连接。

We are getting the below error after type sqlplus from the command prompt from normal user login.

从普通用户登录的命令提示符下键入 sqlplus 后,我们收到以下错误。

SP2-1503: Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

Thanks in advance.

提前致谢。

回答by Lalit Kumar B

For Windows 7and up, right clickon your client tooland Run as Administrator.

对于Windows 7和向上,右键单击您的client tool以管理员身份运行

回答by Kumar

I found this solution and fix this issue from the below steps.

我找到了这个解决方案并通过以下步骤解决了这个问题。

Assign the "Create global objects" user right to the non-Administrator account.

1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
2. Expand Local Policies, and then click User Rights Assignment.
3. In the right pane, double-click Create global objects.
4. In the Local Security Policy Setting dialog box, click Add.
5. In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK.
6. Click OK.