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

1	./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

[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 <span style="color: #ff0000;">pid 31208</span> port 53396 instance tt1122
TimesTen server <span style="color: #ff0000;">pid 31217</span> started on port 53397
------------------------------------------------------------------------
Data store /u01/app/oracle/product/aggregate_store/tt_aggr_store
<span style="color: #ff0000;">There are no connections to the data store</span>
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]$

[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.