1. Operations Guide
  2. Managing TimesTen Databases
  3. Opening and Closing the Database for User Connections

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 Classic, the database is automatically opened and user connections can connect.

  • By default in TimesTen Scaleout, the database is closed until manually opened. See Open the Database for User Connections in Oracle TimesTen In-Memory Database Scaleout User's Guide.

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

  • TimesTen Classic: 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 Classic 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 Classic for an example.

  • TimesTen Scaleout: Before unloading a database from memory, you must manually close the database. See Unloading a Database from Memory in Oracle TimesTen In-Memory Database Scaleout User's Guide.

Use the following to see the status of your database:

  • TimesTen Classic: 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.

  • TimesTen Scaleout: Use the ttGridAdmin dbStatus command to see the status of the database. See Monitor the Status of a Database (dbStatus) in Oracle TimesTen In-Memory Database Reference.