Invention Grant
- Patent Title: Database connection refresh for server instances and live database updates
-
Application No.: US17146744Application Date: 2021-01-12
-
Publication No.: US11544237B2Publication Date: 2023-01-03
- Inventor: Pradip Kumar Pandey
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Kilpatrick Townsend & Stockton LLP
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/25 ; G06F8/65 ; G06F9/52 ; G06F9/48

Abstract:
Threads and kernels across multiple server instances may maintain static connections to a database during operation. To apply a patch or other upgrade to the database, a notification may be sent to the database system that causes the database system to redirect new incoming connection requests for the database to a backup database. A second notification may also be sent to each of the server instances where threads maintain active connections to the database. These threads may be allowed to finish executing a current job, then when entering the idle state these threads may be directed to refresh their connections. This refresh operation may be redirected to the backup database. The patch may be applied after all connections have been switched to the backup database. This process switches static connections to the backup database as quickly as possible without interrupting existing thread operations.
Public/Granted literature
- US20220222224A1 DATABASE CONNECTION REFRESH FOR SERVER INSTANCES AND LIVE DATABASE UPDATES Public/Granted day:2022-07-14
Information query