CN107276841A - A kind of method that health status detection is carried out for Oracle Goldengate - Google Patents
A kind of method that health status detection is carried out for Oracle Goldengate Download PDFInfo
- Publication number
- CN107276841A CN107276841A CN201710282360.9A CN201710282360A CN107276841A CN 107276841 A CN107276841 A CN 107276841A CN 201710282360 A CN201710282360 A CN 201710282360A CN 107276841 A CN107276841 A CN 107276841A
- Authority
- CN
- China
- Prior art keywords
- goldengate
- daily record
- oracle
- database
- server
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
- H04L43/0805—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters by checking availability
- H04L43/0817—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters by checking availability by checking functioning
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/50—Testing arrangements
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Environmental & Geological Engineering (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to O＆M automatic field, a kind of method that health status detection is carried out for Oracle Goldengate is disclosed, is comprised the following steps：(1) configuration parameter file；(2) automatic script detection is performed：(3) daily record output testing result.The present invention makes detection efficiency be greatly improved, during especially for the server up to tens even hundreds of for needing to check, the inspection need of work of single server is completed under normal mode 10 minutes, only needed to using automatic mode less than 1 minute, and with the increase of number of servers, the time of inspection will not be linear growth, whole process also only needed in minute rank.With good generalization, only need to be deployed on the main frame or virtual machine of a network that can connect the server for needing to check, deployment is simple and convenient, it is only necessary to see that the daily record collected just can be appreciated that the Oracle Goldengate health status for the server that needs are checked.
Description
Technical field
It is more particularly to a kind of to carry out health for Oracle Goldengate the present invention relates to O＆M automatic field
The method of state-detection.
Background technology
Oracle Goldengate are as in the market data syn-chronization and the main product of data disaster tolerance, ecology potential in recent years
Head is rapid.Had a wide range of applications at present in industries such as finance, bank, card Securities, insurance, government, manufacturing industry, while in order to more preferable
Management and monitor Goldengate running situation, ORACLE also provides related subsidiary management assembly GoldenGate
Director, GoldenGate Monitor, but still there is certain limitation from financial cost and convenience angle.
The content of the invention
The present invention is directed to for the high shortcoming of Database Systems stability, cost in the prior art there is provided one kind
The method that Oracle Goldengate carry out health status detection.
In order to solve the above-mentioned technical problem, the present invention is addressed by following technical proposals.
A kind of method that health status detection is carried out for Oracle Goldengate, comprises the following steps：
(1) configuration parameter file：Specify a webserver to carry out that automatic interaction bag is installed, the webserver is connected
Other in network need examined Oracle Goldengate servers, create and check script, then will check Oracle
Goldengate daily records set and deposited in the webserver；
(2) automatic script detection is performed：In every Oracle Goldengate server input checking order, check interior
Appearance include operating system daily record, database positioning daily record, cluster state daily record, database monitoring daily record, cluster configuration daily record and
Goldengate process status, and according to the successively regularly arranged order for needing to check；Then the return knot of judgement order is passed through
Fruit Goldengate to Oracle judges that such as returning result is more than 0, then abnormal；Such as returning result is less than or equal to 0,
It is then normal；
(3) obtain and output result：Detected and performed according to step (2) script, obtain Oracle Goldengate databases
Server needs inspection operation system journal to judge whether normal, database positioning daily record is to judge data for operating system
Whether storehouse has exception, cluster state daily record to judge whether normal, database monitors daily record to judge number to data-base cluster
Monitor whether normal, cluster configuration daily record is to judge whether normal, Goldengate is checked to judge database according to storehouse
Whether Oracle Goldengate are normal, and export testing result.
Preferably, in step (1), automatic interaction bag is used to realize creates order and the input of program in server.
The present invention is as a result of above technical scheme, with significant technique effect：
1st, detection efficiency is greatly improved, especially for the server up to tens even hundreds of for needing to check
During platform, the inspection need of work of single server is completed under normal mode 10 minutes, only needed to using automatic mode less than 1
Minute, and with the increase of number of servers, the growth that time of inspection will not be linear, whole process also only needs to minute level
It is not interior.
2nd, with good generalization, it is only necessary to which the main frame of network for the server for needing to check can be connected by being deployed in one
Or on virtual machine, dispose simple and convenient, it is only necessary to see that the daily record collected just can be appreciated that the server that needs are checked
Oracle Goldengate health status.
Brief description of the drawings
Fig. 1 is a kind of operation signal of method that health status detection is carried out for Oracle Goldengate of the present invention
Figure.
Embodiment
The present invention is further described in detail with embodiment below in conjunction with the accompanying drawings.
As shown in figure 1, a kind of method that health status detection is carried out for Oracle Goldengate, including following step
Suddenly：.
A kind of method that health status detection is carried out for Oracle Goldengate, comprises the following steps：
(1) configuration parameter file：A webserver is specified to carry out that automatic interaction bag is installed, automatic interaction bag is used for real
Present server creates order and the input of program；Other in webserver connected network are needed to examined Oracle
Goldengate servers, create and check script, then will check that Oracle Goldengate daily records are set and deposit in network clothes
It is engaged in device；
(2) automatic script detection is performed：In every Oracle Goldengate server input checking order, check interior
Appearance include operating system daily record, database positioning daily record, cluster state daily record, database monitoring daily record, cluster configuration daily record and
Goldengate process status, and according to the successively regularly arranged order for needing to check；Then the return knot of judgement order is passed through
Fruit Goldengate to Oracle judges that such as returning result is more than 0, then abnormal；Such as returning result is less than or equal to 0,
It is then normal；
(3) obtain and output result：Detected and performed according to step (2) script, obtain Oracle Goldengate databases
Server needs inspection operation system journal to judge whether normal, database positioning daily record is to judge data for operating system
Whether storehouse has exception, cluster state daily record to judge whether normal, database monitors daily record to judge number to data-base cluster
Monitor whether normal, cluster configuration daily record is to judge whether normal, Goldengate is checked to judge database according to storehouse
Whether Oracle Goldengate are normal, and export testing result.
Embodiment 1
1st, on server check_list.txt example parameter files are as follows, and the Parameter File represents to need to check B
Goldengate services on server
Goldengate%B%linux%db%root%password%22%/oracle/admin/mms db/
Bdump/alert_scmms.log%null%null%null%null%null%/goldenga te%null%null
2nd, rolling inspection script auto_check.sh on server
3rd, the goldengate services that may determine that on B servers are returned to according to the check_log of return whether normal.
In a word, presently preferred embodiments of the present invention, all equalizations made according to scope of the present invention patent be the foregoing is only
Change and modification, should all belong to the covering scope of patent of the present invention.
Claims (2)
1. a kind of method that health status detection is carried out for Oracle Goldengate, it is characterised in that including following step
Suddenly：
(1) configuration parameter file：A webserver is specified to carry out that automatic interaction bag is installed, by webserver connected network
In other need examined Oracle Goldengate servers, create and check script, then will check Oracle
Goldengate daily records set and deposited in the webserver；
(2) automatic script detection is performed：In every Oracle Goldengate server input checking order, scope of examination bag
Include operating system daily record, database positioning daily record, cluster state daily record, database monitor daily record, cluster configuration daily record and
Goldengate process status, and according to the successively regularly arranged order for needing to check；Then the return knot of judgement order is passed through
Fruit Goldengate to Oracle judges that such as returning result is more than 0, then abnormal；Such as returning result is less than or equal to 0,
It is then normal；
(3) obtain and output result：Detected and performed according to step (2) script, obtain Oracle Goldengate database services
Device needs inspection operation system journal to judge whether operating system is normal, database positioning daily record is to judge database
It is no to have exception, cluster state daily record to judge whether normal, database monitors daily record to judge database to data-base cluster
Monitor whether normal, cluster configuration daily record is to judge whether normal, Goldengate is checked to judge Oracle database
Whether Goldengate is normal, and exports testing result.
2. a kind of method that health status detection is carried out for Oracle Goldengate according to claim 1, it is special
Levy and be：In step (1), automatic interaction bag is used to realize creates order and the input of program in server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710282360.9A CN107276841A (en) | 2017-04-26 | 2017-04-26 | A kind of method that health status detection is carried out for Oracle Goldengate |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710282360.9A CN107276841A (en) | 2017-04-26 | 2017-04-26 | A kind of method that health status detection is carried out for Oracle Goldengate |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107276841A true CN107276841A (en) | 2017-10-20 |
Family
ID=60074286
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710282360.9A Pending CN107276841A (en) | 2017-04-26 | 2017-04-26 | A kind of method that health status detection is carried out for Oracle Goldengate |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107276841A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109376026A (en) * | 2018-09-14 | 2019-02-22 | 上海新炬网络信息技术股份有限公司 | A kind of data synchronization check implementation method based on script |
| CN111104310A (en) * | 2019-11-21 | 2020-05-05 | 国网上海市电力公司 | Method for data center platform layer configuration compliance check and log analysis |
| CN111130926A (en) * | 2019-12-03 | 2020-05-08 | 中国建设银行股份有限公司 | State monitoring method, system and device suitable for encryption machine and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7260589B2 (en) * | 2003-12-04 | 2007-08-21 | International Business Machines Corporation | High performance support for XA protocols in a clustered shared database |
| CN102739802A (en) * | 2012-07-06 | 2012-10-17 | 广东电网公司汕头供电局 | Service application-oriented IT contralized operation and maintenance analyzing system |
| CN104954189A (en) * | 2015-07-07 | 2015-09-30 | 上海斐讯数据通信技术有限公司 | Automatic server cluster detecting method and system |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
| CN105323111A (en) * | 2015-11-17 | 2016-02-10 | 南京南瑞集团公司 | Operation and maintenance automation system and method |
| CN105490870A (en) * | 2015-11-20 | 2016-04-13 | 浪潮电子信息产业股份有限公司 | Method for monitoring running states of Linux servers in batch |
-
2017
- 2017-04-26 CN CN201710282360.9A patent/CN107276841A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7260589B2 (en) * | 2003-12-04 | 2007-08-21 | International Business Machines Corporation | High performance support for XA protocols in a clustered shared database |
| CN102739802A (en) * | 2012-07-06 | 2012-10-17 | 广东电网公司汕头供电局 | Service application-oriented IT contralized operation and maintenance analyzing system |
| CN104954189A (en) * | 2015-07-07 | 2015-09-30 | 上海斐讯数据通信技术有限公司 | Automatic server cluster detecting method and system |
| CN105323111A (en) * | 2015-11-17 | 2016-02-10 | 南京南瑞集团公司 | Operation and maintenance automation system and method |
| CN105490870A (en) * | 2015-11-20 | 2016-04-13 | 浪潮电子信息产业股份有限公司 | Method for monitoring running states of Linux servers in batch |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109376026A (en) * | 2018-09-14 | 2019-02-22 | 上海新炬网络信息技术股份有限公司 | A kind of data synchronization check implementation method based on script |
| CN111104310A (en) * | 2019-11-21 | 2020-05-05 | 国网上海市电力公司 | Method for data center platform layer configuration compliance check and log analysis |
| CN111104310B (en) * | 2019-11-21 | 2023-03-24 | 国网上海市电力公司 | Method for data center platform layer configuration compliance check and log analysis |
| CN111130926A (en) * | 2019-12-03 | 2020-05-08 | 中国建设银行股份有限公司 | State monitoring method, system and device suitable for encryption machine and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2002359925B2 (en) | Operation managing method and operation managing server | |
| US11651375B2 (en) | Below-the-line thresholds tuning with machine learning | |
| CN107276841A (en) | A kind of method that health status detection is carried out for Oracle Goldengate | |
| CN112114995B (en) | Terminal abnormality analysis method, device, equipment and storage medium based on process | |
| CN106656536A (en) | Method and device for processing service invocation information | |
| CN105095052B (en) | Fault detection method under SOA environment and device | |
| EP1639513A2 (en) | Methods and apparatus for data analysis | |
| CN109509082B (en) | Monitoring method and device for bank application system | |
| CN105812200A (en) | Abnormal behavior detection method and device | |
| CN112286771A (en) | Alarm method for monitoring global resources | |
| CN102073579A (en) | Method for merging and optimizing audit events of Linux file system | |
| CN111930726B (en) | Off-line form-based grade protection evaluation data acquisition and analysis method and system | |
| Maeyens et al. | Process mining on machine event logs for profiling abnormal behaviour and root cause analysis | |
| CN108156142A (en) | Network inbreak detection method based on data mining | |
| CN113239006A (en) | Log detection model generation method and device and log detection method and device | |
| CN106951360B (en) | Data statistical integrity calculation method and system | |
| CN114111352B (en) | Carbide furnace vacuumizing system abnormity detection method and system | |
| CN116991947B (en) | Automatic data synchronization method and system | |
| CN114500178B (en) | Self-operation intelligent Internet of things gateway | |
| Shilpika et al. | Toward an in-depth analysis of multifidelity high performance computing systems | |
| CN112200663A (en) | Automatic acquisition and intelligent analysis platform | |
| Dasu et al. | Hunting of the Snark: Finding Data Glitches using Data Mining Methods. | |
| CN112491622A (en) | Method and system for positioning fault root cause of business system | |
| CN116562571B (en) | Supply chain management method and system based on block chain | |
| CN113037550B (en) | Service fault monitoring method, system and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171020 |