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

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

A method of using program to monitor database in Linux dual-computer system

technical field

The invention relates to a database monitoring technology, in particular to a method for using a program to monitor a database in a Linux dual-computer system.

Background technique

In modern IT systems, the importance of monitoring the status of upper-layer applications is self-evident, and various dual-machine and other business software are also emerging in an endless stream. However, the current dual-machine software is tightly coupled deployment monitoring, which puts forward high requirements for the amount of software development, the requirements of developers, the quality of development, and the later deployment and maintenance.

For a conventional dual-machine software system, usually a single software package contains all kinds of functions, and the size of a software can be hundreds of megabytes or even several gigabytes. The software architecture is very complex, and the dependencies between various modules are very strong, which affects the whole body. It has high requirements for developers and implementation and maintenance personnel. And the resource requirements of the host machine are very high when deployed, otherwise the software requirements cannot be met. And if there is a bug in a certain function, it is very difficult for developers.

Because of the disadvantages of the above software development, a loosely coupled software deployment and development deployment method is more and more welcomed by customers, developers, and implementation and maintenance personnel. In front of the market, this demand is getting stronger and stronger.

Contents of the invention

In order to solve the above technical problems, the present invention proposes a method for using a program in a Linux dual-computer system to monitor a database. The software architecture undergoes a qualitative change, from tight coupling to loose coupling. The amount of software code is reduced, the quality requirements of developers are lowered, the quality of development is improved, and the complexity of later deployment and maintenance is reduced.

The invention changes the tight coupling of traditional two-machine software into loose coupling, and releases the internally integrated program functions to the outside for loading. Reduce the amount of program code, reduce the quality requirements and workload of developers, and improve the ease of deployment and maintenance

The specific method is as follows:

(1) First, write the external program. The function of this program completes the start and stop of the database, and completes the detection of the database and the database monitoring program. There are many ways to write the program, and there are no rigid requirements. The corresponding function can be realized.

Database startup:

connect / as sysdba

startup

exit;

Database stopped:

connect / as sysdba

shutdown immediate

exit;

Detection of the 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

Detection of database monitoring:

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

Of course, the above is just an example. Developers only need to be able to realize the corresponding functions when developing, and they can handle them flexibly, not rigidly, and not sticking to the format.

(2), and then deploy a loosely coupled two-machine software system to monitor the database. For the starting place, the program for starting the database developed above can be used. Similarly, for closing the database, use the procedure for closing the database above. For the monitoring of the database and database monitoring, create EXCE executable resources in the dual-machine software system, and call the monitoring database program developed above in the resources to monitor the database monitoring program.

The program is an executable file in SH format set in advance, which is called by software. The software is only called, not its own function, the setting is simplified, loosely coupled, and it is easy to separate and independently troubleshoot when encountering a fault, increasing maintainability.

The design of the program may not be limited to the format, as long as it can realize the functions of pulling up the database and detecting the state of the database. Flexible writing, low requirements for personnel, and reduced implementation costs.

The functions realized by the program itself are relatively simple, and it is not very complicated to call the program to realize the monitoring of the database in the dual-computer system. In reality, it has strong operability and universality, and improves work efficiency.

The beneficial effect of the present invention is

In this way, the loosely coupled two-machine software system is deployed, and some operations and monitoring related to the database are all completed by external programs. The operation of the dual-computer software system itself is reduced, and the corresponding internal development of the software also reduces the complexity. The functionality is shifted to the outside for implementation. Realized the method of monitoring the database in the dual-computer software system in Linux from tight coupling to loose coupling.

Detailed ways

The content of the present invention is described in more detail below:

The specific method is as follows:

(1) First, write the external program. The function of this program completes the start and stop of the database, and completes the detection of the database and the database monitoring program. The following is one:

Database startup:

connect / as sysdba

startup

exit;

Database stopped:

connect / as sysdba

shutdown immediate

exit;

Detection of the 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

Detection of database monitoring:

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 deploy a loosely coupled two-machine software system to monitor the database. For the start-up place, use the program to start the database developed above. Similarly, for closing the database, use the procedure for closing the database above. For the monitoring of the database and database monitoring, create EXCE executable resources in the dual-machine software system, and call the monitoring database program developed above in the resources to monitor the database monitoring program.

After the present invention disperses the functions, it produces a natural benefit, that is, the functions are loosely coupled, the functions are deployed independently, and the deployment and post-maintenance are very targeted. Specific deployments are made for specific functions. Specific maintenance will do.

The invention greatly reduces labor costs and implementation costs, has strong operability and implementability, and has natural advantages for popularization.

Claims (4)

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。