14952 - "Oracle prepare error" when Oracle password due to expire or in password grace period

Problem Note 14952: "Oracle prepare error" when Oracle password due to expire or in password grace period

You you run a query against an Oracle instance where the password is due
to expire or is in the password grace period, the following error
message might appear:

   Error: ORACLE prepare error:

The character after the word 'Error:' varies.

In SQLPlus, if you connect to the same instance, the following error
message might appear:

   Error: ORA-28002: the password will expire within 1 days

The workaround is to have the Oracle DBA adjust the password so that
it is not due to expire.


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014952

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014952

Operating System and Release Information

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Oracle	Microsoft Windows XP Professional	9.1 TS1M3	9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	9.1 TS1M3	9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter Edition	9.1 TS1M3	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	9.1 TS1M3	9.2 TS2M3
		Linux	9.1 TS1M3	9.2 TS2M3
		64-bit Enabled Solaris	9.1 TS1M3	9.2 TS2M3
		64-bit Enabled AIX	9.1 TS1M3	9.2 TS2M3
		Tru64 UNIX	9.1 TS1M3	9.2 TS2M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	medium
Topic:	Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines

Date Modified:	2006-01-04 15:41:03
Date Created:	2005-04-07 11:20:10