2 Replies Latest reply: Feb 5, 2014 10:51 AM by 1611275 RSS

    Unable to increase permsize; 836: error 22; 703 TT836

    1611275

      Hello All,

      New to TimesTen. Please help.

       

      Getting the following error when trying to increase the PERMSIZE:

       

      [timesten@localhost info]$ ttisql -connstr "dsn=D1_TTDB;permsize=1024000";

       

      Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.

      Type ? or "help" for help, type "exit" to quit ttIsql.

       

       

       

      connect "dsn=D1_TTDB;permsize=1024000";

        836: Cannot create data store shared-memory segment, error 22

        703: Subdaemon connect to data store failed with error TT836

      The command failed.

      Done.

       

      Followed MOS note 1504153.1

       

      Here is the shmmax setting:

      [timesten@localhost info]$ grep shmmax /etc/sysctl.conf

      # Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1

      kernel.shmmax = 4398046511104

       

       

      I have not used hugepages, and also there is no other db running.

      [timesten@localhost info]$ cat /proc/meminfo| grep Huge

      HugePages_Total:       0

      HugePages_Free:        0

      HugePages_Rsvd:        0

      HugePages_Surp:        0

      Hugepagesize:       2048 kB

       

      [timesten@localhost info]$ ipcs -m

       

      ------ Shared Memory Segments --------

      key        shmid      owner      perms      bytes      nattch     status

      0x00000000 2031617    root      644        80         2

      0x00000000 2064386    root      644        16384      2

      0x00000000 2097155    root      644        280        2

      0x45008121 2818061    timesten  660        1048576    1

       

      ##############################################################################################

      Here is my env details:

      [timesten@localhost info]$ uname -a

      Linux localhost.localdomain 2.6.32-100.26.2.el5 #1 SMP Tue Jan 18 20:11:49 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

      [timesten@localhost info]$

       

      [timesten@localhost info]$ ttversion

      TimesTen Release 11.2.2.6.0 (64 bit Linux/x86_64) (ttdev:53396) 2013-11-21T02:09:30Z

        Instance admin: timesten

        Instance home directory: /home/timesten/TimesTen/ttdev

        Group owner: ttadmin

        Daemon home directory: /home/timesten/TimesTen/ttdev/info

        PL/SQL enabled.

       

      [timesten@localhost info]$ ttstatus

      TimesTen status report as of Tue Feb  4 21:01:11 2014

       

      Daemon pid 6584 port 53396 instance ttdev

      TimesTen server pid 6593 started on port 53397

      ------------------------------------------------------------------------

      Data store /home/timesten/TimesTen/ttdev/D1_TTDB

      There are no connections to the data store

      Replication policy  : Manual

      Cache Agent policy  : Manual

      PL/SQL enabled.

      ------------------------------------------------------------------------

      Accessible by group ttadmin

      End of report

      [timesten@localhost info]$

       

       

      =========================

      Appreciate all the help.