Technical data

Unable to validate Oracle username and password
4-6 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
Check library path environment variable
Check the library path environment variable on your platform.
The library path environment variable must include the following information:
Check status of TNS listener and Oracle Server
Try to connect to the Oracle database by using SQL*Plus or use Oracle Enterprise
Manager to verify the status.
Check Oracle privileges
From an Oracle SQL*Plus command prompt, list the current Oracle privileges granted
to you by entering:
SELECT * FROM SESSION_ROLES;
SELECT * FROM SESSION_PRIVS;
Compare the privileges listed against the required privileges for the various IMDB
Cache operations that are specified in "Grant privileges to Oracle users" in the Oracle
In-Memory Database Cache User's Guide. Contact your Oracle Administrator if you
require additional privileges.
Check DSN definition
■ Confirm you have correctly set the DSN attributes as described in "DSN for a
TimesTen database that caches data from an Oracle database" in the Oracle
In-Memory Database Cache User's Guide.
■ Confirm that the DSN definition for IMDB Cache is a system DSN.
■ Confirm that the DSN for IMDB Cache is defined only once.
Dynamic libraries not loading "Verify the loaded dynamic libraries" on
page 4-7.
On this platform... Check this variable...
UNIX except HP-UX LD_LIBRARY_PATH
On 64-bit platforms, LD_LIBRARY_PATH64 takes precedence
over LD_LIBRARY_PATH. Make sure that the library path is
specified in LD_LIBRARY_PATH64.
HP-UX SHLIB_PATH
Windows PATH
TimesTen and platform bit combination Setting
64-bit TimesTen or 32-bit TimesTen on 32-bit
platform
$ORACLE_HOME/LIB and $ORACLE_
HOME/NETWORK/LIB
32-bit TimesTen on 64-bit platform $ORACLE_HOME/LIB32 and $ORACLE_
HOME/NETWORK/LIB32
Possible cause See...