CN107943471A

CN107943471A - Carry out the method in monitoring data storehouse in a kind of Linux dual systems using program

Info

Publication number: CN107943471A
Application number: CN201711226002.2A
Authority: CN
Inventors: 孙孟
Original assignee: Zhengzhou Yunhai Information Technology Co Ltd
Current assignee: Zhengzhou Yunhai Information Technology Co Ltd
Priority date: 2017-11-29
Filing date: 2017-11-29
Publication date: 2018-04-20

Abstract

The present invention provides a kind of method for coming monitoring data storehouse in Linux dual systems using program, is related to database monitoring technology, and the close coupling of traditional duplex software is changed into loose coupling by the present invention, and the program function being internally integrated is discharged into outside to load.Program code amount is reduced, reduces the competency profiling and workload of developer, deployment is improved and safeguards easness.

Description

Carry out the method in monitoring data storehouse in a kind of Linux dual systems using program

Technical field

The present invention relates to come monitoring data storehouse using program in database monitoring technology, more particularly to a kind of Linux dual systems Method.

Background technology

In modern IT systems, the monitoring importance of upper layer application state is self-evident, the business software such as various two-shippers also layer Go out not poor.But present duplex software be all close coupling deployment monitoring, the exploitation amount for software, the requirement of developer, The quality of exploitation and the deployment maintenance in later stage are proposed very high requirement.

For conventional duplex software system, a usual software is undertaken the whole things, and various functions are all integrated in the inside, one Software million or even several G sizes of many hundreds easily.Software architecture is extremely complex, and dependence is very strong between modules, leads one Start whole body, it is very high to exploitation personnel requirement, putting maintenance into practice personnel are also required also higher.And dispose for host The resource requirement of machine is very high, otherwise cannot meet the requirement of software.And there is BUG in some function, for developer For be all very intractable.

Because the drawbacks of this software development above, a kind of software deployment development deployment mode of loose coupling is increasingly subject to Client, the welcome of developer, putting maintenance into practice personnel.Before market plane, such a demand is more and more stronger.

The content of the invention

In order to solve the above technical problems, the present invention is proposed in a kind of Linux dual systems monitors number using program According to the method in storehouse.Software architecture carries out qualitative change, is changed into loose coupling from original close coupling.Software code quantitative change is few, developer Competency profiling reduce, development quality lifting, the deployment in later stage and safeguard complexity reduction.

The close coupling of traditional duplex software is changed into loose coupling by the present invention, and the program function being internally integrated is discharged into exterior next Loading.Program code amount is reduced, reduces the competency profiling and workload of developer, deployment is improved and safeguards easness

Specific practice is as follows：

（1）, first finish writing external program first, the startup and stopping of the function database of this program, database With the detection of database oracle listener.The literary style of program is very much, without inflexible requirement.It can realize corresponding function.

Database starts：

connect / as sysdba

startup

exit;

Database stops：

connect / as sysdba

shutdown immediate

exit;

Detection to database：

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}' `

done

The detection monitored database：

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

done

The one kind simply illustrated above is of coursed, as long as developer can realize corresponding function when exploitation, flexibly Processing, it is not inflexible, it is not limited to form etc..

（2）, can be with for the place of startup and then the duplex software system of deployment loose coupling mode comes monitoring data storehouse Use the program in log-on data storehouse developed above.Similarly, for closing database, the program for closing database above is used. The monitoring monitored for database and database, the resource that EXCE can perform is created in duplex software system, is called in resource Monitoring data library developed above, monitoring data storehouse oracle listener.

Program is the executable file of the SH forms set in advance, is called with software.Software simply calls, non-self Function, sets and simplifies, loose coupling, runs into failure easy to separate independent investigation, increase is maintainable.

The design of program can be not limited to form, as long as pull-up database and the work(of Test database state can be realized Energy.Flexibly write, it is low to personnel requirement, reduce cost of implementation.

The function that program is realized in itself is fairly simple, and the monitoring of database is realized not for caller in dual systems It is very complicated, there is very strong operability and universality in reality, improves work efficiency.

The beneficial effects of the invention are as follows

The duplex software system of loose coupling is so disposed, for the relevant certain operations of database and monitoring just all by exterior journey Sequence completes.The operation of duplex software system in itself is reduced, while the exploitation of corresponding software inhouse also reduces complexity. Function is transferred to outside to realize.Realize duplex software system in Linux and loose coupling is changed into monitor number by original close coupling According to the method in storehouse.

Embodiment

More detailed elaboration is carried out to present disclosure below：

Specific practice is as follows：

（1）, first finish writing external program first, the startup and stopping of the function database of this program, database With the detection of database oracle listener.Following is exactly a kind of：

Database starts：

connect / as sysdba

startup

exit;

Database stops：

connect / as sysdba

shutdown immediate

exit;

Detection to database：

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}' `

done

The detection monitored database：

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

done

（2）And then the duplex software system of deployment loose coupling mode comes monitoring data storehouse, for the place of startup, uses above The program in the log-on data storehouse of exploitation.Similarly, for closing database, the program for closing database above is used.For data The monitoring that storehouse and database are monitored, the resource that EXCE can perform is created in duplex software system, is called in resource developed above Monitoring data library, monitoring data storehouse oracle listener.

After the present invention disperses function, a kind of natural benefit is just generated, is exactly function loose coupling, functional independence portion Administration, deployment and later maintenance all very targetedly, specific deployment are done for specific function, behind specific function except problem Do specific maintenance.

Present invention substantially reduces human cost and cost of implementation, has very strong operability and implementation, for promoting With natural advantage.

Claims

1. carry out the method in monitoring data storehouse in a kind of Linux dual systems using program, it is characterised in that

The close coupling of traditional duplex software is changed into loose coupling, the program function being internally integrated is discharged into outside to load.

2. according to the method described in claim 1, it is characterized in that,

Specific practice is as follows

（1）, finish writing external program first, the startup and stopping of the function database of this program, database and The detection of database oracle listener；

（2）And then the duplex software system of deployment loose coupling mode comes monitoring data storehouse, for the place of startup, uses above The program in the log-on data storehouse of exploitation；Similarly, for closing database, the program for closing database above is used；For data The monitoring that storehouse and database are monitored, the resource that EXCE can perform is created in duplex software system, is called in resource developed above Monitoring data library, monitoring data storehouse oracle listener.

3. according to the method described in claim 2, it is characterized in that,

Program is the executable file of the SH forms set in advance, is called with software.

4. according to the method described in claim 3, it is characterized in that,

Specific procedure is：

Database starts：

connect / as sysdba

startup

exit;

Database stops：

connect / as sysdba

shutdown immediate

exit;

Detection to database：

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |grepora_pmon_orcl |grep -v grep |awk '{print $2}' `

done

The detection monitored database：

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

while [ $check ]

do

sleep 3

check=`ps -aef |greptnslsnr |grep -v grep |awk '{print $2}'`

done。