mysql 错误 0152_Sqlplus连接oracle 报SP2-1503, SP2-0152问题

问题描述

一位同事在自己windows机器上面使用PLSQL DEVELOPER登陆Oracle数据库时弹出一个空白窗口，使用sqlplus直接登陆时报错如下：

SP2-1503: Unable to initialize Oracle call interfa

SP2-0152: ORACLE may not be functioning properly

网上查了一下，很多人说是环境变量的问题，仔细检查了环境变量发现没有问题，重置环境变量问题照样存在，怀疑是权限问题，使用windows操作系统管理员权限操作时没有问题，去掉管理员权限又报错了，重装Oracle客户端之后,把操作系统管理员权限收掉后还报同样的错，最后在metalink找到了这是一个oracle 10.2.0.1的bug

解决方案

安装Oracle 11g客户端后，问题解决！

Bug的说明如下

SP2-1503

When Run SQLPlus 10.2.0.1 as a Non-Admin User on Windows 7 [ID 1531248.1]

1Applies to:

SQL*Plus - Version 10.2.0.1

and later

Information in this document applies to any platform.

2Symptoms

When attempting to run SQL*Plus 10.2.0.1 as a

user other than Administrator, the following error occurs:

SP2-1503:

Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

1. Run sqlplus from the command line as a non-Administrator user.

2. Errors occur.

3. Run the sqlplus command as Administrator user, then the errors do not occur.

3Changes

Installed Oracle Client 10.2.0.1.0 on

Windows 7 32 bit.

4Cause

You are encountering a known issue:

- NON-ADMINISTRATOR

USER UNABLE TO USE CLIENT SQLPLUS INSTALL

The minimum version of Oracle Database Client that is certified with Windows 7

(32 bit) is 10.2.0.5.0.

Version 10.2.0.1.0 is not certified for

Windows 7.

The error does not occur using SQL*Plus 10.2.0.5.0

5Solution

Upgrade SQL*Plus from 10.2.0.1.0 to

10.2.0.5.0.

Oracle Database 10g Release 2 Client 32 bit

(10.2.0.5 and higher) is certified for Windows 7 32 bit.

6References

- NON-ADMINISTRATOR

USER UNABLE TO USE CLIENT SQLPLUS INSTALLNOTE:1061272.1- Statement of

Direction: Oracle Database 10g Release 2 Client (10.2.0.5) with Microsoft

Windows 7 and Windows Server 2008 R2NOTE:391401.1- Unable to Connect

in SQL Plus if Windows Vista user is a Non-Administrative User