Local XE Database Extract Error ORA-28001 (Doc ID 2267655.1)

Last updated on MAY 18, 2017

Applies to:

Siebel Tools - Version 15.10 [IP2015] to 16.10 [IP2016] [Release V15 to V16]
Microsoft Windows x64 (64-bit)

Symptoms

On : 15.10 [IP2015] version, Installation

When attempting to extract a Local Siebel Tools database, the following error occurs.

ERROR
-----------------------
ODBCSQL: (ODBC SQL Interface) Start at 5/17/17 16:00 (pid 8240)
Spooling started to "C:/Siebel/15/Tools/BIN\LocalDbTemplate\tablelist.out".
ODBC error S1000 in SQLConnect:
[tp][ODBC Oracle driver][Oracle]ORA-28001: the password has expired
(native error 28001).
Unable to login using specified ODBC parameters.

ODBCSQL: Exit at 5/17/17 16:00 (status -1)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run C:\Siebel\15\Tools\bin\LocalDBSetup.exe -s C:\Siebel\15\tools -o "CRM_15_DEV" -t SIEBEL -u MRJ7 -p ******** -r "Siebel Repository" -d LOCAL_XE -x "C:\Siebel\15\tools\oraclexe" -l C:\Siebel\15\Tools\Bin\LocalDBSetup.log -w N -y "Runtime Tables"
2. Error occurs at stage 4 of 7 (Truncate the existing data of LOCAL_XE)
3. [tp][ODBC Oracle driver][Oracle]ORA-28001: the password has expired

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot start development process on local machine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms