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]

1              Applies to:

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

2              Symptoms

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.

3              Changes

 Installed Oracle Client 10.2.0.1.0 on Windows 7 32 bit.

4              Cause

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
 

5              Solution

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.

6              References

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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21605631/viewspace-759476/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21605631/viewspace-759476/