6. Troubleshooting Ingres : Problems with Tools Startup : Database Connection Problems : Individual Database Connection Failure
 
Share this page                  
Individual Database Connection Failure
If you can connect to some databases but not others:
1. Check the errlog.log for database connection error messages. These messages can quickly identify the source of the failure.
2. Check that the database is not exclusively locked by another user.
3. Check database permissions and ownership, as described in Check Ingres Installation on Windows (see page Check Ingres Installation on Windows), Check Ingres Installation on UNIX (see page Check Ingres Installation on UNIX), and Check Ingres Installation on VMS (see page Check Ingres Installation on VMS).
Verify that your database still exists and is not being recovered by the recovery system.
4. Check if the database is listed:
Type catalogdb and choose Databases.
Using Actian Director: Select the database from the Instance Explorer, and then select Properties, Information. Make sure the database is not listed as inconsistent.
Using VDBA: Select a server and click Connect DOM. Select Database from the drop down menu and choose infodb. Make sure the database is not listed as inconsistent and that the status indicated is “VALID.”