Opening and Closing the Database for User Connections

For an application to be able to connect to a database, the database needs to be open. When a database is closed, any new user connection attempts fail.

By default in TimesTen, the database is automatically opened and user connections can connect.

You can close the database to reject any new user connections to a database. The instance administrator can still connect to the database.

Use the ttAdmin -close command to close the database to any new user connections.

Since the database can be automatically loaded or unloaded as set by the RAM policy, the status of a database (open or closed) is not aligned with whether the database is currently loaded into memory. Thus, the database could be in an open state as well as unloaded or in a closed state when loaded. See Loading a Database into Memory for TimesTen for an example of the RAM policy.

You should close a database before manually unloading a database. When loading a closed database into memory, the database cannot be opened until the load operation completes. You can re-open the database with the ttAdmin -open command. See Unloading a Database from Memory for TimesTen for an example.

To see the status of your database, use the ttStatus or ttAdmin -query utilities to see the status of the database. See ttStatus or ttAdmin in Oracle TimesTen In-Memory Database Reference.