Kbase P17593: Users receive message that database is shutting down when attempting to log into database. (1384)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/26/2009 |
|
Status: Verified
SYMPTOM(s):
Users get message, database is shutting down when logging into database. (1384)
Disconnecting dead user <number>. (2527)
The database is in a hung state.
Promon shows three remote users still connected although everyone has logged out.
User <num> died with <num> buffers locked. (2523)
CAUSE:
Shutdown process unable to disconnect all users from the database.
FIX:
Use UNIX kill process to disconnect remaining users.
Identify processes with pe -ef | grep <username> of user that started the database.
In this case kill -9 was needed to disconnect the PIDs.
Run proshut dbname to shut down the database after all users are disconnected .
Run pro dbname to allow crash recovery in single user mode.
Exit the single user session
Start the database in multi-user mode.