3 Replies Latest reply: Jun 14, 2012 4:40 AM by Tim Vincent RSS

    ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach

    936666
      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!
        • 1. Re: ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach
          Tim Vincent
          Check the tnsnames.ora that you specified for TNS_ADMIN at install time, is correct.
          And check that it has an entry for the OracleNetServiceName <orcl_db> that you have defined in your DSN.
          • 2. Re: ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach
            936666
            Hi Thanks for the replay,

            Where to find tnsnames.ora ?
            What is TNS_ADMIN ?

            I have downloaded TT from the website and working on it i did not install another database do i need to install any external database to access

            And check that it has an entry for the OracleNetServiceName <orcl_db> that you have defined in your DSN.

            Ans: I have specified as orcl_db while defining DSN

            I am not using Oracle database here whether i need to have Oracle database inorder to proceed further steps
            under---->Setting Up a Cache Database --------> 4. Associate the Oracle Cache Administration user with the Cache Database

            Thanks!
            • 3. Re: ERROR: 5220: Permanent Oracle connection failure error in OCIServerAttach
              Tim Vincent
              Ok, so TimesTen can be used as a standalone alone database or as a cache in front of the Oracle Database.

              The steps you are going through here are to configure TimesTen to be an in-memory cache in front of the Oracle database and to do so it's looking for an Oracle database to connect to.

              To create a TT database without the need for an Oracle database take a look here:

              http://www.oracle.com/webfolder/technetwork/tutorials/demos/db/timesten/quickstart/tt1122_learning_library.html

              In particular: 'How to Create an Oracle TimesTen 11.2.2 Database on Linux' (or Windows) http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5962,2

              I also suggest you review the quick start material here:
              http://download.oracle.com/otn_hosted_doc/timesten/1122/quickstart/html/main/home.html

              And this introductory manual is a good place to start:
              http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21631/toc.htm