问题描述

一位同事在自己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的说明如下

SQL*Plus - Version 10.2.0.1 and later
Information in this document applies to any platform.

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.

 Installed Oracle Client 10.2.0.1.0 on Windows 7 32 bit.

You are encountering a known issue:

Bug 4684738 - 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
 

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.

BUG:4684738 - NON-ADMINISTRATOR USER UNABLE TO USE CLIENT SQLPLUS INSTALL
NOTE:1061272.1 - Statement of Direction: Oracle Database 10g Release 2 Client (10.2.0.5) with Microsoft Windows 7 and Windows Server 2008 R2
NOTE:391401.1 - Unable to Connect in SQL Plus if Windows Vista user is a Non-Administrative User