1 2 Previous Next 21 Replies Latest reply: Jul 26, 2013 2:10 AM by 997436 Go to original post RSS
      • 15. Re: Memory Specifications for TimesTen DB and In-Memory Cache
        Chrisjenkins-Oracle

        For 2, this is not possible. A single TImesTen database can cache data from at most a single oracle database. This is a technical restriction not a licensing issue.

         

        For 1, this is technically possible. If you are using the IMDB Cache features of TimesTen then you need to purchase an IMDB Cache license. This is sold as an Oracle Database Enterprise Edition Option and is only supported / permitted when the backend is an Oracle DB EE. SE/SE1 are not supported/permitted. You must purchase as many CPU licenses for IMDB Cache as there are CPUs in the machines where you will be installing TimesTen (in total).

         

        Hope that helps clarify.

         

        Regards,

         

        Chris

        • 16. Re: Memory Specifications for TimesTen DB and In-Memory Cache
          997436

          Hi Chris,

          Thank you very much for providing detailed explanation with clarity for the queries I posted.

           

          Best Regards,

          Mallaiah Papinni

          • 17. Re: Memory Specifications for TimesTen DB and In-Memory Cache
            997436

            Hi Chris,

            We are planning to implement TimesTen for some of the applications running on IBM-AIX platform with WebLogic application server, as of now.

            1) The users with admin/system privileges can install TimesTen software. Is it possible to install this software with any other privileges? If so, what are those privileges?

            2) The user who installed this software can create the TimesTen database. Is it possible to create more than one (multiple) TimesTen database with single TimesTen software installation per application server (WebLogic) in order to cache tables from more than one (multiple) database?

            3) If there are multiple cache databases with single TimesTen installation, is it possible to start and stop those databases separately/individually without affecting other databases? And what are privileges the users should have to start and stop those TimesTen databases separately/individually?

             

            Thanks in advance.

             

            Best Regards,

            Mallaiah Papinni

            • 18. Re: Memory Specifications for TimesTen DB and In-Memory Cache
              Chrisjenkins-Oracle

              Here are some answers. This information is all in the documentation...


              1)   The users with admin/system privileges can install TimesTen software. Is it possible to install this software with any other privileges? If so, what are those privileges?


              You should *not* install TimesTen as root or equivalent. TimesTen should be installed as a regular user. Control of who can install TimesTen is via the directory /etc/TimesTen (which has to be created by root of course). You choose an OS group (often a dedicated group called 'timesten' but you can also use 'oinstall' or any other group) and give group ownership of that directory to this group and permissions of 770. Only users who are members of this group will be able to install a TimesTen instance.


              2)   Yes, a single TimesTen instance can support any number of databases concurrently subject to system resource constraints.


              3)    Yes, individual databases within an instance can be started, stopped, backed up, recovered etc. without affecting other databases in the instance.


              Chris




              • 19. Re: Memory Specifications for TimesTen DB and In-Memory Cache
                997436

                Hi Chris.

                Thank you very much for answering to all of my questions patiently. I have one more question for you - is it required to purchase both TimesTen In-Memory Database and In-Memory Cache in order to use only In-Memory Cache for caching tables from Oracle 11g database which is running on AIX platform?

                 

                Thanks in advance.

                 

                Best Regards,

                Mallaiah Papinni

                • 20. Re: Memory Specifications for TimesTen DB and In-Memory Cache
                  Chrisjenkins-Oracle

                  You only need to purchase In-Mempory Database Cache. This is licensed as an Oracle Database Enterprise Edition option not as a standalone product. You need to purchase the number of CPUs based on the machines where you will install and use IMDB Cache (usually *not* the same servers as the Oracle database).

                   

                  Chris

                  • 21. Re: Memory Specifications for TimesTen DB and In-Memory Cache
                    997436

                    Great. Thanks you very much Chris.

                    1 2 Previous Next