Wiki

Case Status
Log In

Wiki

 
Database Starting, Stopping, B…
  • RSS Feed

Last modified on 7/14/2014 2:13 PM by User.

Database Starting, Stopping, Backing up, and Connecting - Version 9

Starting, Stopping, Removing and Backing up the database (Version 9)

The ASA Configuration program is found under the Oasis > Database program directory in the Start Menu. The database is managed from the main window. All ASA databases are shown here. In this case, only one database is running on the server:

The following operations are available:

  • Start – starts the database showing any errors (if encountered) will likely show a generic windows error (e.g. “service start pending”). Starting the database manually will show any database errors (e.g. recovery in progress).
  • Stop – If running, the database will stop
  • Remove – The service is removed from the server and the database will not automatically start when the server restarts. Most users should not use.
  • Backup – The database – regardless of the server or PC it is running on – is copied to the local machine. Use this method to backup the database from the server to another server or workstation.

Connecting to the database and starting automated backups (Version 9)

The ODBC tab shows the different ways to connect to an ASA database. Most installations of OASIS 2.7 have the following ODBC database source (connections) available:

  • Oasis – this is the primary connection to the OASIS database. DO NOT USE WITH OTHER APPLICATIONS.
  • Oasis_l – this is an alternate connection used to automatically start the database when OASIS starts. DO NOT USE WITH OTHER APPLICATIONS.
  • Oasis_ro – use this connection with Microsoft’s Access or other ODBC compliant programs to read data from OASIS.

The buttons under each connection perform the following tasks:

  • Test – test the connection showing whether or not the computer, network and database are operational. An error is returned if any component between the local PC and the server is improperly configured or if a firewall is blocking the connection.
  • Remove – removes the connection. Most users should not use.
  • Backup – The database – regardless of the server or PC it is running on – is copied to the local machine. Use this method to backup the database from the server to another server or workstation.
  • Connect – Connect to and manage the database

When the connect button is pressed, the following screen shows:

The screen shows who the database is licensed to, the database identifier and when the automated backup is scheduled to run (10PM in the example). The following features are available from the file menu:

  • Set Backup – Sets the time and directory the database will create a backup each day:
  • Run SQL - Runs a script created by Ingen Software to perform an action on the database. DO NOT USE UNLESS CONTACTED BY INGEN SOFTWARE!
  • Run Query – a diagnostic tool used by Ingen Software. DO NOT USE UNLESS CONTACTED BY INGEN SOFTWARE!
  • Disconnect All – disconnects all users from the database (including virtual users like websites).
  • Rotate Log – Causes the database to “rotate” the recovery log file. Most users should not use without contacting Ingen Software.