Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach

936666Jun 14 2012 — edited Jun 14 2012
I 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2012
Added on Jun 14 2012
3 comments
730 views