ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach
936666Jun 14 2012 — edited Jun 14 2012I am getting the below error how to resolve it
I am just following the "Setting Up a Cache Database" Steps in the book/site i am unable to login
4. Associate the Oracle Cache Administration user with the Cache Database
fails for me
Command> connect "dsn=cachedb1_1122;uid=cacheadm;oraclepwd=cacheadm";
Enter password for 'cacheadm':********
Connection successful: DSN=cachedb1_1122;UID=cacheadm;DataStore=C:\TimesTen\cach
edb1_1122;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=C
:\TimesTen\TT1122~1\bin\ttdv1122.dll;LogDir=D:\TimesTen\Log\cachedb1_1122;PermSi
ze=40;TempSize=32;TypeMode=0;PLSCOPE_SETTINGS=IDENTIFIERS:NONE;OracleNetServiceN
ame=orcl_db;
(Default setting AutoCommit=1)
con8: Command> call ttcacheuidpwdset ('cacheadm','cacheadm');
5220: Permanent Oracle connection failure error in OCIServerAttach(): ORA-12154
: TNS:could not resolve the connect identifier specified rc = -1
5935: Could not validate Oracle login: uid = CACHEADM, pwd = HIDDEN, OracleNetS
erviceName = orcl_db, TNS_ADMIN = "C:\TimesTen11.2.2", ORACLE_HOME= ""
The command failed.
Thanks!