5 Replies Latest reply: Jun 14, 2012 4:49 AM by Tim Vincent RSS

    Need to install Oracle 11g and Oracle TimesTen separately

    936666
      I have Downloaded Oracle TimesTen from

      http://www.oracle.com/technetwork/products/timesten/downloads/index.html
      Whether i need to install Oracle 11g separately inorder to run the Timesten database .
      Or whether i need to install Oracle database separately

      Thanks!
        • 1. Re: Need to install Oracle 11g and Oracle TimesTen separately
          hitgon
          Hi.....

          Generally Oracle Timesten IMDB is running without need the Oracle Database but
          If you want to use the oracle timesten cache connect then you need to install the Oracle database separately in same box where you want to install TT

          please refer the documentation
          http://www.oracle.com/technetwork/products/timesten/overview/timesten-imdb-086887.html
          http://download.oracle.com/otn_hosted_doc/timesten/1121/doc/timesten.1121/e14261/arch.htm#BAABJBEH
          http://www.oracle.com/technetwork/products/timesten/documentation/index.html

          Regards
          Hitgon
          • 2. Re: Need to install Oracle 11g and Oracle TimesTen separately
            936666
            Thanks for your reply !
            Whether i need to install oracle 11g and then i need to install TT or how?
            I need to place the records in memory for faster access so i am going for TT.
            • 3. Re: Need to install Oracle 11g and Oracle TimesTen separately
              Tim Vincent
              It doesn't really matter which you install first.

              Just to be clear TimesTen is a standalone database in it' own right and can be used as the database of record. TimesTen doesn't need an Oracle database in order to operate.

              You can however use TimesTen as an In-memory database cache in front of an Oracle database to accelerate data access. Typically you would not install TimesTen on the same server as the Oracle database. You would typically install TimesTen in the mid-tier where your application resides. The links provided above should get you started.

              Tim
              • 4. Re: Need to install Oracle 11g and Oracle TimesTen separately
                936666
                My requirement:
                Our project which holds nearly 1 million records on peak and some 10k on non peak hours all these are at present kept in files and the process is going smoothly. We would like to go with an In-memory database which reduces the I/O cost since all the process are kept in memory it would be faster than the current one.

                After records inserted into database (In-memory) we would like to replicate to a disk database (Oracle or MS SQL or MY SQL)

                so i need to keep the records in memory and pass the rows to disk database

                For this is Oracle TT will be a right choice?
                • 5. Re: Need to install Oracle 11g and Oracle TimesTen separately
                  Tim Vincent
                  Ok, yes Oracle TT could help you here.

                  You could use Oracle TT as a cache to insert your records which are currently in files then as changes/inserts are made to these records in Oracle TT they are propagated to a backend Oracle database. To do this you would use a AWT (Asynchronous Writethrough) Cache Group. An overview is here http://www.oracle.com/technetwork/products/timesten/overview/timesten-imdb-cache-101293.html

                  BTW: Please also remember that Oracle TT can be the database of record and has it's own local checkpoint files and logs file to persist data.