Categories
Blog

TimesTen Tip IPCS

So you are restarting the timesten daemon and for some reason, you are getting an error when you try to restart.
Whenever you stop the process, always check it has released the process and memory.

./ttDaemonAdmin -stop

To check if it has stopped:

[oracle@Srv1 bin]$ ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 776503299 oracle 660 630240313344 1 dest
0x00000000 776536068 oracle 660 33554432 1 dest
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages

We can see from the above it is still attached, First try the stop command again, if that fails, run the ttstatus command to find the pid.

[oracle@Srv1 bin]$ ttstatus
 TimesTen status report as of Fri Sep 12 11:50:19 2014
Daemon pid 31208 port 53396 instance tt1122
TimesTen server pid 31217 started on port 53397
------------------------------------------------------------------------
Data store /u01/app/oracle/product/aggregate_store/tt_aggr_store
There are no connections to the data store
RAM residence policy: Manual
Data store is manually unloaded from RAM
Replication policy : Manual
Cache Agent policy : Manual
PL/SQL enabled.
------------------------------------------------------------------------
Accessible by group oinstall
End of report
[oracle@Srv1 bin]$

You can see there is no connections to the data store.
Kill the pid’s via the kill command. You should be OK to start it now.