CN102855319A - ORACLE database operation monitoring system - Google Patents
ORACLE database operation monitoring system Download PDFInfo
- Publication number
- CN102855319A CN102855319A CN2012103236430A CN201210323643A CN102855319A CN 102855319 A CN102855319 A CN 102855319A CN 2012103236430 A CN2012103236430 A CN 2012103236430A CN 201210323643 A CN201210323643 A CN 201210323643A CN 102855319 A CN102855319 A CN 102855319A
- Authority
- CN
- China
- Prior art keywords
- database
- monitored
- monitoring
- data structure
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Telephonic Communication Services (AREA)
Abstract
The invention discloses an ORACLE database operation monitoring system, wherein the system comprises a monitored data configuration table for storing the monitored database, a result table for recording the monitoring result, a database setting module for maintaining the various basic information of the monitored database, and increasing, modifying and deleting the monitored database, a monitoring type setting module for increasing, modifying and deleting the monitored data structure type, a database operation monitoring service module for monitoring the change of the monitored data structure operation, and a monitoring result management module for confirming the changed database structure information. The system provided by the invention can discover the change circumstance of the monitored database structure in time, notice the change circumstance to a database manager and check the details and modifying time of the data structure changed this time through managing the monitoring result. The system provided by the invention can check whether the content of the operation order is in accordance with the practical operation, thereby improving the technical supervising manner, normalizing the database operation and reducing the operation risk.
Description
Technical field
The present invention relates to a kind of ORACLE database, especially a kind of ORACLE database manipulation supervisory system.
Background technology
At present, data base administrator fast and effectively policer operation personnel causes the super range operation of operating personnel to the modification of data library structure, lacks effectively supervision, has potential safety hazard.
Summary of the invention
The technical problem to be solved in the present invention provides the supervisory system that a kind of fast and effectively policer operation personnel revise the ORACLE database structure.
For solving the problems of the technologies described above, the technical solution used in the present invention is:
A kind of ORACLE database manipulation supervisory system is included on the basis of existing ORACLE Database Systems and arranges:
Monitored data configuration table: be used for storing monitored database;
Table as a result: be used for the record monitored results;
Database arranges module: realize the maintenance to the various Back ground Informations of monitored database, and to monitored database increase newly, modification and deletion action;
The monitoring type arranges module: the attended operation that realization increases newly, revises, deletes monitored type of data structure;
Database manipulation Monitoring Service module: realize the monitoring to monitored data structure operation change, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the local backup table in the monitored database, and the outcome record that change will be arranged is in table as a result;
The monitoring result administration module: the database structure information to change is confirmed, if the content of change meets the requirements, then upgrades data structure corresponding in the local backup table.
Wherein, described database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring.
Wherein, described monitoring type type of data structure that the module setting is set comprises: TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER.
Wherein, described local backup table is used for storing the database in monitored database dba_objects, the dba_tab_cols table.
Wherein, described database manipulation Monitoring Service module as the Windows service operation at server end.
A kind of ORACLE database manipulation method for supervising may further comprise the steps:
S1. create monitored data configuration table and table as a result, by the monitoring type module is set, monitored type of data structure is safeguarded;
S2. by database module is set, the link information of monitored database is entered in the system, and the synchronous operation in the executive system, the database in dba_objects, the dba_tab_cols table in the monitored database is imported in the local backup table with to be checked;
S3. the search access right that creates the user and distribute dba_objects, dba_tab_cols table, and open the access port that this Windows service place server connects database;
S4. by database manipulation Monitoring Service module, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the backup sheet in the monitored database, if identical, finish this time scanning, if not identical, then the data structure information with change is recorded to as a result in the table;
S5. by the monitoring result administration module, the database structure information of change is confirmed, if the content of change meets the requirements, then upgraded data structure corresponding in the local backup table.
Wherein, among the described step S1, monitored data configuration table is used for storing monitored database, and table is used for the record monitored results as a result; Monitored type of data structure comprises TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER.
Wherein, among the described step S2, database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring.
Wherein, among the described step S4, when having scanned change, enable the note sending function for setting, will send in the user mobile phone of corresponding data lab setting with short message mode simultaneously.
The beneficial effect that adopts technique scheme to produce is: the present invention can monitor a plurality of Database Systems of physically sharing simultaneously, scan by the database user data structure of regularly needs being monitored, find that in time the user is to the update status of data structure, for the database that change is arranged, after scanning is finished, to send to the data base administrator with the form of note, and the change outcome record that will scan becomes in the data base administrator and checks whether corresponding operation is carried out in accordance with regulations to table as a result.
Whether the present invention can verify the operation order content consistent with practical operation, the supervision means that develops skill, and the normative database operation reduces operational risk.The present invention can in time find the data structure alteration of monitored database, and timely notification data library manager, by the monitoring result management, can check data structure detailed content and modification time that this time change is revised.The present invention can be as the Windows service in the server end long-time running, can better serve actual data base administration need of work, realized the standardized management of database manipulation, data base administrator's management level have been promoted, standardization, standardized management that operation order uses have been promoted, improve the technical supervision means, reduced operational risk.
Description of drawings
Fig. 1 is that database manipulation supervisory system of the present invention consists of synoptic diagram;
Fig. 2 is database manipulation method for supervising process flow diagram of the present invention;
Fig. 3 is monitoring scan database process flow diagram;
Fig. 4 is the monitored results management flow chart.
Embodiment
The present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
Be illustrated in figure 1 as database manipulation supervisory system of the present invention and consist of synoptic diagram.ORACLE database manipulation supervisory system of the present invention is included on the basis of existing ORACLE Database Systems and arranges: monitored data configuration table: be used for storing monitored database; Table as a result: be used for the record monitored results; Database arranges module: realize the maintenance to the various Back ground Informations of monitored database, and to monitored database increase newly, modification and deletion action; The monitoring type arranges module: the attended operation that realization increases newly, revises, deletes monitored type of data structure; Database manipulation Monitoring Service module: as the Windows service operation at server end, realization is to the monitoring of monitored data structure operation change, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the local backup table in the monitored database, and the outcome record that change will be arranged is in table as a result; The monitoring result administration module: the database structure information to change is confirmed, if the content of change meets the requirements, then upgrades data structure corresponding in the local backup table.
Wherein, database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring; The type of data structure that the monitoring type arranges the module setting comprises: TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER; The local backup table is used for storing the database in monitored database dba_objects, the dba_tab_cols table.
Be illustrated in figure 2 as database manipulation method for supervising process flow diagram of the present invention.ORACLE database manipulation method for supervising of the present invention may further comprise the steps:
S1. create monitored data configuration table and table as a result, by the monitoring type module is set, monitored type of data structure is safeguarded; Wherein, monitored data configuration table is used for storing monitored database, and table is used for the record monitored results as a result; Monitored type of data structure comprises TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER;
S2. by database module is set, the link information of monitored database is entered in the system, and the synchronous operation in the executive system, the database in dba_objects, the dba_tab_cols table in the monitored database is imported in the local backup table with to be checked; Wherein, database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring;
S3. the search access right that creates the user and distribute dba_objects, dba_tab_cols table, and open the access port that this Windows service place server connects database;
S4. as shown in Figure 3 monitoring scan database process flow diagram, by database manipulation Monitoring Service module, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the backup sheet in the monitored database, if identical, finish this time scanning, if not identical, then the data structure information of change is recorded to as a result in the table; And, when having scanned change, enabling the note sending function for setting, will send in the user mobile phone of corresponding data lab setting with short message mode simultaneously;
S5. as shown in Figure 4 monitored results management flow chart by the monitoring result administration module, is confirmed the database structure information of change, if the content of change meets the requirements, then upgrades data structure corresponding in the local backup table.
Claims (9)
1.ORACLE the database manipulation supervisory system is characterized in that being included on the basis of existing ORACLE Database Systems and arranges:
Monitored data configuration table: be used for storing monitored database;
Table as a result: be used for the record monitored results;
Database arranges module: realize the maintenance to the various Back ground Informations of monitored database, and to monitored database increase newly, modification and deletion action;
The monitoring type arranges module: the attended operation that realization increases newly, revises, deletes monitored type of data structure;
Database manipulation Monitoring Service module: realize the monitoring to monitored data structure operation change, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the local backup table in the monitored database, and the outcome record that change will be arranged is in table as a result;
The monitoring result administration module: the database structure information to change is confirmed, if the content of change meets the requirements, then upgrades data structure corresponding in the local backup table.
2. ORACLE database manipulation supervisory system according to claim 1 is characterized in that: described database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring.
3. ORACLE database manipulation supervisory system according to claim 1, it is characterized in that: the type of data structure that described monitoring type arranges the module setting comprises: TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER.
4. ORACLE database manipulation supervisory system according to claim 1 is characterized in that: described local backup table is used for storing the database in monitored database dba_objects, the dba_tab_cols table.
5. ORACLE database manipulation supervisory system according to claim 1 is characterized in that: described database manipulation Monitoring Service module as the Windows service operation at server end.
6.ORACLE the database manipulation method for supervising is characterized in that may further comprise the steps:
S1. create monitored data configuration table and table as a result, by the monitoring type module is set, monitored type of data structure is safeguarded;
S2. by database module is set, the link information of monitored database is entered in the system, and the synchronous operation in the executive system, the database in dba_objects, the dba_tab_cols table in the monitored database is imported in the local backup table with to be checked;
S3. the search access right that creates the user and distribute dba_objects, dba_tab_cols table, and open the access port that this Windows service place server connects database;
S4. by database manipulation Monitoring Service module, circulation searching has been enabled the database of monitoring in monitored data configuration table, contrast whether identical in data structure and the backup sheet in the monitored database, if identical, finish this time scanning, if not identical, then the data structure information with change is recorded to as a result in the table;
S5. by the monitoring result administration module, the database structure information of change is confirmed, if the content of change meets the requirements, then upgraded data structure corresponding in the local backup table.
7. ORACLE database manipulation method for supervising according to claim 6 is characterized in that: among the described step S1, monitored data configuration table is used for storing monitored database, and table is used for the record monitored results as a result; Monitored type of data structure comprises TABLE, VIEW, INDEX, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER.
8. ORACLE database manipulation method for supervising according to claim 6, it is characterized in that: among the described step S2, database arranges the primary attribute information that module safeguards and comprises: database-name, monitored user, database IP address, port numbers, database SID, the database of database connect user name and password, sweep time, monitored object type, whether enable the phone number that note sends, will send and whether enable monitoring.
9. ORACLE database manipulation method for supervising according to claim 6, it is characterized in that: among the described step S4, when having scanned change, enable the note sending function for setting, will send in the user mobile phone of corresponding data lab setting with short message mode simultaneously.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012103236430A CN102855319A (en) | 2012-09-05 | 2012-09-05 | ORACLE database operation monitoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012103236430A CN102855319A (en) | 2012-09-05 | 2012-09-05 | ORACLE database operation monitoring system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102855319A true CN102855319A (en) | 2013-01-02 |
Family
ID=47401907
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012103236430A Pending CN102855319A (en) | 2012-09-05 | 2012-09-05 | ORACLE database operation monitoring system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102855319A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095056A (en) * | 2015-08-14 | 2015-11-25 | 焦点科技股份有限公司 | Method for monitoring data in data warehouse |
| CN105335527A (en) * | 2015-12-04 | 2016-02-17 | 浪潮(北京)电子信息产业有限公司 | Method and system for monitoring database operation |
| CN105512567A (en) * | 2015-12-07 | 2016-04-20 | 中国电力科学研究院 | Easily-extensible rule customization data monitoring method |
| CN105975361A (en) * | 2016-04-27 | 2016-09-28 | 浪潮(北京)电子信息产业有限公司 | ORACLE database-based object backup method and apparatus |
| CN106096057A (en) * | 2016-06-30 | 2016-11-09 | 华东电网有限公司 | Configurable loss of data inspection and monitoring method and system |
| CN106339500A (en) * | 2016-09-09 | 2017-01-18 | 浪潮软件股份有限公司 | Different-place database comparison tool and method |
| CN109783470A (en) * | 2018-12-13 | 2019-05-21 | 中国平安人寿保险股份有限公司 | Owner's follow-up mechanism, method and the storage medium of database subsystem |
| CN109857720A (en) * | 2018-12-20 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Database table monitoring method, device, computer installation and readable storage medium storing program for executing |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1673972A (en) * | 2004-08-04 | 2005-09-28 | 上海宝信软件股份有限公司 | Dynamic monitoring system and method for data base list update |
| CN102231161A (en) * | 2011-06-30 | 2011-11-02 | 北京新媒传信科技有限公司 | Method for synchronously verifying and monitoring databases |
| CN102355499A (en) * | 2011-10-09 | 2012-02-15 | 广州亦云信息技术有限公司 | Cloud computing system |
| CN102508833A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data monitoring device and data monitoring method |
-
2012
- 2012-09-05 CN CN2012103236430A patent/CN102855319A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1673972A (en) * | 2004-08-04 | 2005-09-28 | 上海宝信软件股份有限公司 | Dynamic monitoring system and method for data base list update |
| CN102231161A (en) * | 2011-06-30 | 2011-11-02 | 北京新媒传信科技有限公司 | Method for synchronously verifying and monitoring databases |
| CN102508833A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data monitoring device and data monitoring method |
| CN102355499A (en) * | 2011-10-09 | 2012-02-15 | 广州亦云信息技术有限公司 | Cloud computing system |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095056A (en) * | 2015-08-14 | 2015-11-25 | 焦点科技股份有限公司 | Method for monitoring data in data warehouse |
| CN105095056B (en) * | 2015-08-14 | 2018-01-12 | 焦点科技股份有限公司 | A kind of method of data warehouse data monitoring |
| CN105335527A (en) * | 2015-12-04 | 2016-02-17 | 浪潮(北京)电子信息产业有限公司 | Method and system for monitoring database operation |
| CN105512567A (en) * | 2015-12-07 | 2016-04-20 | 中国电力科学研究院 | Easily-extensible rule customization data monitoring method |
| CN105512567B (en) * | 2015-12-07 | 2020-08-28 | 中国电力科学研究院 | Easily-extensible rule customized data monitoring method |
| CN105975361A (en) * | 2016-04-27 | 2016-09-28 | 浪潮(北京)电子信息产业有限公司 | ORACLE database-based object backup method and apparatus |
| CN106096057A (en) * | 2016-06-30 | 2016-11-09 | 华东电网有限公司 | Configurable loss of data inspection and monitoring method and system |
| CN106339500A (en) * | 2016-09-09 | 2017-01-18 | 浪潮软件股份有限公司 | Different-place database comparison tool and method |
| CN109783470A (en) * | 2018-12-13 | 2019-05-21 | 中国平安人寿保险股份有限公司 | Owner's follow-up mechanism, method and the storage medium of database subsystem |
| CN109783470B (en) * | 2018-12-13 | 2024-02-06 | 中国平安人寿保险股份有限公司 | Owner tracking device, method and storage medium of database subsystem |
| CN109857720A (en) * | 2018-12-20 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Database table monitoring method, device, computer installation and readable storage medium storing program for executing |
| CN109857720B (en) * | 2018-12-20 | 2024-02-02 | 中国平安人寿保险股份有限公司 | Database table monitoring method, device, computer device and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102855319A (en) | ORACLE database operation monitoring system | |
| AU2019201687B2 (en) | Network device vulnerability prediction | |
| CN106202444A (en) | Method for realizing database operation and maintenance monitoring | |
| CN101582811A (en) | Method for establishing integration of network monitoring and operating management | |
| CN105225190A (en) | The large data sharing platform of a kind of warehouse logistics | |
| CN101582812A (en) | Monitoring and operation managing system | |
| CN105335527A (en) | Method and system for monitoring database operation | |
| EP2410783B1 (en) | Self optimization method and system | |
| US9311175B2 (en) | Method and system for processing log information | |
| CN105989436A (en) | Background management system of charging pile | |
| CN102354296B (en) | A kind of monitoring system and method that can expanding monitoring resources | |
| CN102694873B (en) | A kind of address pool distribution system and method | |
| CN110063042B (en) | Database fault response method and terminal thereof | |
| CN109905492B (en) | Safety operation management system and method based on distributed modular data center | |
| CN102207978A (en) | Database access method and system | |
| CN103944763A (en) | Network-assistant management system and method of electrical power system | |
| CN103684900A (en) | Business polling method and system | |
| CN104240137A (en) | Intelligent management method for electrical equipment | |
| CN106254173A (en) | The monitoring system of public transport automatic fare collection terminal and monitoring method | |
| CN105071959A (en) | Plug-and-play management method and system based on unified registration of power network devices | |
| CN105894142A (en) | Electronic process based filing and modeling method | |
| CN102255657B (en) | Method for managing service configuration data in passive optical network service management system | |
| CN110633274B (en) | Alarm management method and device | |
| CN100414883C (en) | Method for obtaining information by network manager at upper layer | |
| CN111143876B (en) | Method for processing redundancy safety group attached to AD domain user |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: INFORMATION AND COMMUNICATION BRANCH OF STATE GRID Free format text: FORMER OWNER: HEBEI ELECTRIC POWER CORPORATION HEBEI ELECTRIC POWER CORPORATION INFORMATION COMMUNICATION BRANCH Effective date: 20150123 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20150123 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Applicant after: Information Communication Branch, State Grid Hebei Electric Power Co., Ltd. Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Grid Corporation of China Applicant before: Hebei Electric Power Corporation Applicant before: Hebei Electric Power Corporation Information Communication Branch |
|
| C05 | Deemed withdrawal (patent law before 1993) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130102 |