CN113094088A - Database configuration information acquisition method and device, computer equipment and storage medium - Google Patents
Database configuration information acquisition method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN113094088A CN113094088A CN202110405187.3A CN202110405187A CN113094088A CN 113094088 A CN113094088 A CN 113094088A CN 202110405187 A CN202110405187 A CN 202110405187A CN 113094088 A CN113094088 A CN 113094088A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- configuration
- script
- configuration information
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/74—Reverse engineering; Extracting design information from source code
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for acquiring database configuration information, computer equipment and a storage medium, which support an oracle database new version 19c, and configure an operating environment for a preset information acquisition script according to database basic information acquired by operating the preset management script; analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class; and calling an information acquisition script to acquire the configuration information of the database in the target configuration class. Based on the invention, the collection efficiency of the database configuration information can be improved, and the situations that the collection of the database configuration information is incomplete and the data support cannot be efficiently provided for the operation and maintenance of the database due to the manual collection of the database configuration information by workers can be avoided.
Description
Technical Field
The invention relates to the field of database operation and maintenance, in particular to a method and a device for acquiring database configuration information, computer equipment and a storage medium.
Background
In the field of database operation and maintenance, the database configuration information is the bottom-layer basic data of the database operation and maintenance and can provide data support for other operation and maintenance links, so that the acquisition of the database configuration information is a crucial link in the database operation and maintenance links.
In the prior art, usually, a worker manually collects database configuration information, and the manner of manually collecting the database configuration information by the worker not only has low collection efficiency of the database configuration information, but also can cause the situations that the collection of the database configuration information is incomplete and data support cannot be efficiently provided for the operation and maintenance of the database.
Disclosure of Invention
In view of this, the present application provides a method and an apparatus for acquiring database configuration information, a computer device, and a storage medium, so as to improve the efficiency of acquiring database configuration information, and avoid situations that the acquisition of database configuration information is incomplete and data support cannot be efficiently provided for database operation and maintenance due to manual acquisition of database configuration information by a worker. The technical scheme is as follows:
the invention discloses a database configuration information acquisition method in a first aspect, which comprises the following steps:
running a preset management script to obtain basic information of a database, and configuring a running environment for a preset information acquisition script according to the obtained basic information of the database;
analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
calling the information acquisition script to acquire the configuration information of the database in the target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
Optionally, the running a preset management script to obtain the basic information of the database, and configuring a running environment for a preset information acquisition script according to the obtained basic information of the database includes:
running a preset management script to determine a database process;
reading basic information of the database according to the database process, wherein the basic information of the database comprises a database user name, a database process number, a database process name, a database script name, a script path, a database instance type, a database home directory, a database SID and a database perl version;
and configuring an operating environment for a preset information acquisition script by using the basic information of the database.
Optionally, the analyzing the operation parameters of the information acquisition script and transmitting the analyzed operation parameters to the information acquisition script includes:
analyzing a database configuration information acquisition instruction to acquire a target configuration class required to be acquired by the database configuration information acquisition instruction;
and transmitting the target configuration class to the information acquisition script.
Optionally, the invoking the information collection script to collect the configuration information of the database in the target configuration class includes:
acquiring a preset index identification corresponding to the target configuration class, adding the index identification into a queue to be acquired, and synchronously preparing an acquisition instruction corresponding to the target configuration class;
sequentially acquiring index identifications of the target configuration classes from the queue to be acquired, executing acquisition instructions corresponding to the target configuration classes according to the index identifications, and acquiring configuration information of a database in the target configuration classes, wherein the target configuration classes are one or more even full configuration classes, and the configuration information of the database in the target configuration classes comprises configuration information of each configuration item of the database in the target configuration classes.
Optionally, the method further includes:
and storing the configuration information of the target configuration class of the database to a target path indicated by the management script.
Optionally, the method further includes:
displaying a database configuration information query interface, wherein the database configuration information query interface comprises three dimensional information for a user to select;
receiving a selection operation of a user on target dimension information in the three dimension information, and displaying a detailed information query interface related to the target dimension information, wherein the detailed information query interface is composed of at least one parameter item;
and responding to the setting operation of the user on the parameter value of the target parameter item in at least one parameter item in the detailed information query interface, and querying and displaying the target configuration information matched with the parameter value from the configuration information.
Optionally, the three dimensional information includes host dimensional information, configuration item dimensional information, and statistical dimensional information.
The second aspect of the present invention discloses a database configuration information acquisition apparatus, including:
the configuration unit is used for running a preset management script to acquire basic information of the database and configuring a running environment for a preset information acquisition script according to the acquired basic information of the database;
the analysis unit is used for analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
the acquisition unit is used for calling the information acquisition script to acquire the configuration information of the database in the target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
A third aspect of the present invention discloses a computer apparatus comprising: at least one memory and at least one processor; the memory stores a program, and the processor calls the program stored in the memory, where the program is used to implement the database configuration information acquisition method disclosed in any one of the first aspects of the present invention.
A fourth aspect of the present invention discloses a computer-readable storage medium, in which computer-executable instructions are stored, and the computer-executable instructions are used in the method for acquiring database configuration information disclosed in any one of the first aspects of the present invention.
The invention provides a method and a device for collecting database configuration information, computer equipment and a storage medium, configuring an operation environment for a preset information acquisition script according to database basic information acquired by operating a preset management script, analyzing operation parameters of a database configuration information acquisition instruction sent by a user and transmitting the analyzed operation parameters to the information acquisition script, the configuration information of the database in the target configuration class is collected by the convenient-to-call information collection script, the prior art is not required to manually collect the configuration information of the database through workers, the collection efficiency of the configuration information of the database is improved, the condition that the collection of the configuration information of the database is incomplete and the data support cannot be efficiently provided for the operation and maintenance of the database due to the fact that the workers manually collect the configuration information of the database is avoided, and the collected configuration information can be subjected to multi-dimensional all-directional analysis and display.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a schematic flowchart of a database configuration information acquisition method according to an embodiment of the present invention;
fig. 2 is a schematic flowchart of a method for running a preset management script to obtain basic data information and configuring a running environment for a preset information acquisition script according to an embodiment of the present invention;
fig. 3 is a schematic flowchart of a method for displaying database configuration information according to an embodiment of the present invention;
FIG. 4 is a diagram of an information query interface according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a database configuration information acquisition apparatus according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The database configuration information refers to all setting contents of the database software.
The management and maintenance of the database configuration information refers to: defining and controlling the configuration indexes of the database, maintaining the history, the planning and the current state of the configuration indexes, and ensuring the integrity and the stability of the configuration information of the database.
In the prior art, generally, a worker manually queries and obtains configuration information of each configuration item in a database one by one, and then the worker analyzes and displays the obtained configuration information in sequence. However, such database configuration information is inefficient to collect, and there may be cases where only part of the configuration information is collected; the obtained configuration information is analyzed and displayed by the staff in sequence, and the function is single, and the obtained configuration information is not analyzed and displayed in a multi-dimensional and all-directional mode.
Therefore, the invention provides a method and a device for acquiring database configuration information, computer equipment and a storage medium, which can improve the acquisition efficiency of the database configuration information, avoid the occurrence of the conditions that the acquisition of the database configuration information is incomplete and the data support cannot be efficiently provided for the operation and maintenance of the database caused by the manual acquisition of the database configuration information by workers, and can also perform multi-dimensional omnibearing analysis and display on the acquired configuration information.
Referring to fig. 1, a schematic flow chart of a method for acquiring database configuration information according to an embodiment of the present invention is shown, and supports an oracle database new version 19c, and in addition, the method supports acquisition of all instances of a database, such as multiple database instances and ASM instances, and specifically includes the following steps:
s101: running a preset management script to obtain basic information of a database, and configuring a running environment for a preset information acquisition script according to the obtained basic information of the database;
referring to fig. 2, a method for running a preset management script to obtain basic data information and configuring a running environment for a preset information acquisition script according to an embodiment of the present invention is shown, where the method specifically includes the following steps:
s201: running a preset management script to determine a database process;
in the embodiment of the application, the management script can be generated through the shell script language, and then the database process is determined by running the generated management script. The database process may be a database pmon process.
S202: reading basic information of the database according to the database process;
in the embodiment of the application, after a preset management script is operated to determine a database process, reading basic information of the database according to the determined database process; the basic information of the database comprises a database user name, a database process number, a database process name, a database script name, a script path, a database instance type, a database home directory, a database SID and a database perl version.
In the embodiment of the application, if the determined database process is the database pmon process, the read database process number is the database pmon process number, and the read database process name is the database pmon process name.
S203: and configuring the running environment for the preset information acquisition script by using the basic information of the database.
In the embodiment of the application, after the basic information of the database is read according to the database process, the read basic information of the database is used for configuring the running environment for the preset information acquisition script.
S102: analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
in the embodiment of the application, after determining the configuration class that the user wants to acquire, the user sends a database configuration information acquisition instruction, where the database configuration information acquisition instruction carries the configuration class that the user wants to acquire (for convenience of distinguishing, the configuration class carried by the database configuration information is referred to as a target configuration class). After configuring the operating environment for the preset information acquisition script according to the acquired basic information of the database, analyzing the received database configuration information acquisition instruction sent by the user, acquiring a target configuration class carried by the database configuration information acquisition instruction, and further transmitting the target configuration class to the information acquisition script.
In the embodiment of the present application, the target configuration class carried by the database configuration information acquisition instruction may be one or more or even a full number of configuration classes, and the configuration information of the database in the target configuration class includes the configuration information of each configuration item of the database in the target configuration class. For example, if the target configuration class is a cluster, the configuration information of the target configuration class (cluster) includes configuration information of each configuration item (cluster information, cluster state) of the database in the target configuration class (cluster).
In the embodiment of the application, the operation and maintenance indexes of the database are comprehensively analyzed, and the configuration acquisition range of the whole database is determined to comprise 14 configuration classes and 47 configuration items; the 47 configuration items cover the aspects of the database operation and maintenance links, complete management of configuration information is achieved, and complete configuration data support can be provided for other database operation and maintenance links. The configuration collection range of the whole database includes 14 configuration classes, and the specific information of 47 configuration items is shown in table 1.
TABLE 1
S103: and calling an information acquisition script to acquire the configuration information of the database in the target configuration class.
In the embodiment of the present application, for each configuration class in at least one configuration class, an index identifier corresponding to the configuration class is preset. After the target configuration class is transmitted to the information acquisition script, the information acquisition script is called to acquire a preset index identification corresponding to the target configuration class, the acquired index identification is added into a queue to be acquired, and an acquisition instruction corresponding to the target configuration class is synchronously prepared; and sequentially acquiring the index identification of the target configuration class from the queue to be acquired so as to execute the acquisition instruction corresponding to the target configuration class according to the index identification and further acquire the configuration information of the database in the target configuration class.
In the embodiment of the application, in the process of calling the information acquisition script, the repeated execution of the information acquisition script is avoided by monitoring the execution state of the information acquisition script, and the pressure on the database is avoided.
Further, in the embodiment of the present application, the configuration information of the database in the target configuration class may be stored in the target path indicated by the management script in advance, so that the subsequent configuration information is centralized and stored in a warehouse and displayed.
The invention provides a method for collecting database configuration information, which comprises configuring an operation environment for a preset information collection specimen according to database basic information obtained by operating a preset management script, analyzing operation parameters of a database configuration information collection instruction sent by a user and transmitting the analyzed operation parameters to the information collection script, the configuration information of the database in the target configuration class is collected by the convenient-to-call information collection script, the prior art is not required to manually collect the configuration information of the database through workers, the collection efficiency of the configuration information of the database is improved, the condition that the collection of the configuration information of the database is incomplete and the data support cannot be efficiently provided for the operation and maintenance of the database due to the fact that the workers manually collect the configuration information of the database is avoided, and the collected configuration information can be subjected to multi-dimensional all-directional analysis and display.
Further, on the basis of the database configuration information acquisition method provided in the above embodiment of the present invention, as shown in fig. 3, the method further includes the following steps:
s301: displaying a database configuration information query interface;
in the embodiment of the application, the database configuration information query interface comprises three dimensional information which can be selected by a user. The three dimensional information included in the database configuration information query interface comprises host dimensional information, configuration item dimensional information and statistical dimensional information.
In the embodiment of the application, the points concerned by the analysis of the configuration information mainly comprise the configuration information of a certain machine; setting conditions of a certain configuration item; and counting the information meeting certain machine conditions and configuration conditions. Aiming at the above concerned points, three dimensional information are set by combining the collected configuration information, namely host dimensional information, configuration item dimensional information and statistical dimensional information. The host dimension information shows the configuration information of a certain machine, and the full and partial configuration information of the machine can be seen from the host dimension information; the dimension information of the configuration items shows the specific configuration information of the host and the instances, and the specified configuration class, configuration items and configuration indexes can be checked; the statistical dimension information display configuration item meets the statistical result of a certain condition, and statistical display (such as attribution, product and use) is carried out according to the statistical dimension concerned by the user, and the content to be displayed can be specified, so that statistical display of the configuration information is simplified.
The following may be assigned: the city where the data center is located, such as the data center in the Guangzhou region; the product can be: an operating system platform, such as a Linux platform, on which the database runs; the application can be as follows: practical application of the equipment, such as production equipment and disaster recovery equipment.
S302: receiving the selection operation of a user on target dimension information in the three dimension information, and displaying a detailed information query interface related to the target dimension information, wherein the detailed information query interface is composed of at least one parameter item;
in the embodiment of the application, the database configuration information query interface is displayed for a user, so that the user can select the dimension information which the user wants to view according to the displayed database configuration information query interface; and when the selection operation of a user on the target dimension information in the three dimension information in the database configuration information query interface is received, displaying a detailed information query interface related to the target dimension information.
For example, if the target dimension information selected by the user is host dimension information, a detailed information query interface related to the host dimension information is displayed, and a detailed information query interface design diagram with different dimensions is shown in fig. 4.
S303: and responding to the setting operation of the user on the parameter value of the target parameter item in at least one parameter item in the detailed information query interface, and querying and displaying the target configuration information matched with the parameter value from the configuration information.
In the embodiment of the application, a detailed information query interface related to the target dimension information selected by the user is displayed to the user, so that the user can set the parameter value of the target parameter item in at least one parameter item in the detailed information query interface. When the setting operation of the user on the parameter value of the target parameter item in at least one parameter item in the detailed information query interface is detected, responding to the operation, and querying and displaying the target configuration information matched with the parameter value from the configuration information.
In the embodiment of the application, a database configuration information query interface containing a plurality of dimension information is displayed for a user, so that the user can select the dimension information which the user wants to view from the displayed database configuration query interface, and a detailed information query interface related to the target dimension information is displayed according to the target dimension information selected by the user, so that the user can query the required parameter item through the displayed detailed information query interface.
Corresponding to the method for acquiring the database configuration information provided by the embodiment of the present invention, an embodiment of the present invention further discloses a device for acquiring the database configuration information, as shown in fig. 5, the device for acquiring the database configuration information includes:
the configuration unit 51 is configured to run a preset management script to acquire basic database information, and configure a running environment for a preset information acquisition script according to the acquired basic database information;
the analysis unit 52 is configured to analyze an operation parameter of the information acquisition script and transmit the analyzed operation parameter to the information acquisition script, where the operation parameter at least includes a target configuration class in at least one preset configuration class;
the acquisition unit 53 is used for calling an information acquisition script to acquire the configuration information of the database in the target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
The specific principle and the execution process of each unit in the database configuration information acquisition device disclosed in the embodiment of the present invention are the same as those of the database configuration information acquisition method disclosed in the embodiment of the present invention, and reference may be made to corresponding parts in the database configuration information acquisition method disclosed in the embodiment of the present invention, which are not described herein again.
The invention provides a database configuration information acquisition device, which configures an operation environment for a preset information acquisition script by acquiring database basic information according to a preset management script, analyzes operation parameters of the information acquisition script and transmits the analyzed operation parameters to the information acquisition script so as to call the information acquisition script to acquire configuration information of a database in a target configuration class.
In the embodiment of the present application, preferably, the configuration unit includes:
the first determining unit is used for running a preset management script to determine the progress of the database;
the reading unit is used for reading basic information of the database according to the database process, wherein the basic information of the database comprises a database user name, a database process number, a database process name, a database script name, a script path, a database instance type, a database home directory, a database SID and a database perl version;
and the configuration subunit is used for configuring the running environment for the preset information acquisition script by using the basic information of the database.
In the embodiment of the present application, preferably, the parsing unit includes:
the first acquisition unit is used for analyzing the database configuration information acquisition instruction and acquiring a target configuration class to be acquired by the database configuration information acquisition instruction;
and the transmission unit is used for transmitting the target configuration class to the information acquisition script.
In this embodiment, preferably, the collecting unit includes:
the second acquisition unit is used for acquiring a preset index identifier corresponding to a target configuration class, adding the index identifier into a queue to be acquired, and synchronously preparing an acquisition instruction corresponding to the target configuration class;
the acquisition subunit is configured to sequentially acquire the index identifiers of the target configuration classes from the queue to be acquired, execute acquisition instructions corresponding to the target configuration classes according to the index identifiers, and acquire configuration information of the database in the target configuration classes, where the target configuration classes are one or more or even the entire configuration classes, and the configuration information of the database in the target configuration classes includes configuration information of each configuration item of the database in the target configuration classes.
Further, the database configuration information acquisition device provided in the embodiment of the present application further includes:
and the storage unit is used for storing the configuration information of the target configuration class of the database to the target path indicated by the management script.
Further, the database configuration information acquisition device provided in the embodiment of the present application further includes:
the first display unit is used for displaying a database configuration information query interface, and the database configuration information query interface comprises three dimensional information which can be selected by a user;
the second display unit is used for receiving the selection operation of a user on the target dimension information in the three dimension information and displaying a detailed information query interface related to the target dimension information, wherein the detailed information query interface is composed of at least one parameter item;
and the query unit is used for responding to the setting operation of the user on the parameter value of the target parameter item in at least one parameter item in the detailed information query interface, and querying and displaying the target configuration information matched with the parameter value from the configuration information.
In the embodiment of the present application, preferably, the three dimensional information includes host dimensional information, configuration item dimensional information, and statistical dimensional information.
The following describes in detail a hardware structure of a computer device to which the database configuration information acquisition method provided in the embodiment of the present application is applied, by taking an example in which the database configuration information acquisition method is applied to the computer device.
The database configuration information acquisition method provided by the embodiment of the application can be applied to computer equipment, and the computer equipment can be a server.
Optionally, fig. 6 shows a hardware structure block diagram of a computer device to which the database configuration information collection method provided in the embodiment of the present application is applied, and referring to fig. 6, a hardware structure of the computer device may include: a processor 61, a memory 62, a communication interface 63 and a communication bus 64;
in the embodiment of the present invention, the number of the processor 61, the memory 62, the communication interface 63, and the communication bus 64 may be at least one, and the processor 61, the memory 62, and the communication interface 63 complete mutual communication through the communication bus 64;
the processor 61 may be a central processing unit CPU, or an application Specific Integrated circuit asic, or one or more Integrated circuits configured to implement embodiments of the present invention, or the like;
the memory 62 may comprise a high-speed RAM memory, and may further comprise a non-volatile memory (non-volatile memory) or the like, such as at least one disk memory;
wherein the memory stores a program, the processor may invoke the program stored in the memory, and the program is operable to:
running a preset management script to obtain basic information of a database, and configuring a running environment for a preset information acquisition script according to the obtained basic information of the database;
analyzing the operation parameters of the information acquisition script and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
calling an information acquisition script to acquire configuration information of a database in a target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
For the functions of the program, reference may be made to the above detailed description of the database configuration information acquisition method provided in the embodiments of the present application, which is not described herein again.
Further, an embodiment of the present application further provides a computer-readable computer storage medium, where computer-executable instructions are stored in the computer-readable storage medium, and the computer-executable instructions are used to execute the database configuration information acquisition method.
For specific contents of the computer executable instructions, reference may be made to the above detailed description of the database configuration information acquisition method provided in the embodiments of the present application, which is not described herein again.
The database configuration information acquisition method, the database configuration information acquisition device, the computer equipment and the storage medium provided by the invention are described in detail, specific examples are applied in the text to explain the principle and the implementation mode of the invention, and the description of the examples is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include or include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for collecting database configuration information is characterized by comprising the following steps:
running a preset management script to obtain basic information of a database, and configuring a running environment for a preset information acquisition script according to the obtained basic information of the database;
analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
calling the information acquisition script to acquire the configuration information of the database in the target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
2. The method according to claim 1, wherein the executing the preset management script obtains the basic information of the database, and configuring the operating environment for the preset information acquisition script according to the obtained basic information of the database comprises:
running a preset management script to determine a database process;
reading basic information of the database according to the database process, wherein the basic information of the database comprises a database user name, a database process number, a database process name, a database script name, a script path, a database instance type, a database home directory, a database SID and a database perl version;
and configuring an operating environment for a preset information acquisition script by using the basic information of the database.
3. The method of claim 1, wherein parsing the operational parameters of the information collection script and passing the parsed operational parameters to the information collection script comprises:
analyzing a database configuration information acquisition instruction to acquire a target configuration class required to be acquired by the database configuration information acquisition instruction;
and transmitting the target configuration class to the information acquisition script.
4. The method of claim 1, wherein said invoking the configuration information of the information collection script collection database in the target configuration class comprises:
acquiring a preset index identification corresponding to the target configuration class, adding the index identification into a queue to be acquired, and synchronously preparing an acquisition instruction corresponding to the target configuration class;
sequentially acquiring index identifications of the target configuration classes from the queue to be acquired, executing acquisition instructions corresponding to the target configuration classes according to the index identifications, and acquiring configuration information of a database in the target configuration classes, wherein the target configuration classes are one or more even full configuration classes, and the configuration information of the database in the target configuration classes comprises configuration information of each configuration item of the database in the target configuration classes.
5. The method of claim 1, further comprising:
and storing the configuration information of the target configuration class of the database to a target path indicated by the management script.
6. The method of claim 1, further comprising:
displaying a database configuration information query interface, wherein the database configuration information query interface comprises three dimensional information for a user to select;
receiving a selection operation of a user on target dimension information in the three dimension information, and displaying a detailed information query interface related to the target dimension information, wherein the detailed information query interface is composed of at least one parameter item;
and responding to the setting operation of the user on the parameter value of the target parameter item in at least one parameter item in the detailed information query interface, and querying and displaying the target configuration information matched with the parameter value from the configuration information.
7. The method of claim 6, wherein the three dimensional information comprises host dimensional information, configuration item dimensional information, and statistical dimensional information.
8. A database configuration information acquisition apparatus, comprising:
the configuration unit is used for running a preset management script to acquire basic information of the database and configuring a running environment for a preset information acquisition script according to the acquired basic information of the database;
the analysis unit is used for analyzing the operation parameters of the database configuration information acquisition instruction and transmitting the analyzed operation parameters to the information acquisition script, wherein the operation parameters at least comprise a target configuration class in at least one preset configuration class;
the acquisition unit is used for calling the information acquisition script to acquire the configuration information of the database in the target configuration class;
the management script is generated by adopting a shell script language, and the information acquisition script is generated by adopting a perl script language.
9. A computer device, comprising: at least one memory storing a program and at least one processor calling the program stored in the memory, the program being for implementing the database configuration information collection method according to any one of claims 1 to 7.
10. A computer-readable storage medium having computer-executable instructions stored thereon for performing the database configuration information collection method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110405187.3A CN113094088A (en) | 2021-04-15 | 2021-04-15 | Database configuration information acquisition method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110405187.3A CN113094088A (en) | 2021-04-15 | 2021-04-15 | Database configuration information acquisition method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113094088A true CN113094088A (en) | 2021-07-09 |
Family
ID=76677818
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110405187.3A Pending CN113094088A (en) | 2021-04-15 | 2021-04-15 | Database configuration information acquisition method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113094088A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116450622A (en) * | 2023-06-16 | 2023-07-18 | 建信金融科技有限责任公司 | Method, apparatus, device and computer readable medium for data warehouse entry |
-
2021
- 2021-04-15 CN CN202110405187.3A patent/CN113094088A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116450622A (en) * | 2023-06-16 | 2023-07-18 | 建信金融科技有限责任公司 | Method, apparatus, device and computer readable medium for data warehouse entry |
| CN116450622B (en) * | 2023-06-16 | 2023-09-22 | 建信金融科技有限责任公司 | Method, apparatus, device and computer readable medium for data warehouse entry |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11409645B1 (en) | Intermittent failure metrics in technological processes | |
| US10922361B2 (en) | Identifying and structuring related data | |
| US10592327B2 (en) | Apparatus, system, and method for analyzing logs | |
| CN111130987A (en) | Automatic acquisition method and device for AWR report, electronic equipment and storage medium | |
| CN111966762B (en) | Index collection method and device | |
| CN109445768B (en) | Database script generation method and device, computer equipment and storage medium | |
| JP5740338B2 (en) | Virtual environment operation support system | |
| CN113094088A (en) | Database configuration information acquisition method and device, computer equipment and storage medium | |
| WO2016153500A1 (en) | Standardized custom surveys | |
| CN111159131A (en) | Performance optimization method, device, equipment and computer readable storage medium | |
| JP2004206308A (en) | Design support system | |
| CN110874365B (en) | Information query method and related equipment thereof | |
| JP6267398B2 (en) | Service design support system and service design support method | |
| CN109684156B (en) | Monitoring method, device, terminal and storage medium based on mixed mode application | |
| CN114039878B (en) | Network request processing method and device, electronic equipment and storage medium | |
| CN110727565A (en) | Network equipment platform information collection method and system | |
| CN114706893A (en) | Fault detection method, device, equipment and storage medium | |
| CN112087323A (en) | Alarm correlation analysis method, device, equipment and readable storage medium | |
| CN111339174A (en) | Data exchange method and device, readable storage medium and data exchange system | |
| CN111143398A (en) | Extra-large set query method and device based on extended SQL function | |
| CN115277481B (en) | Performance index monitoring method, device, equipment and storage medium | |
| CN112988507B (en) | Service monitoring method, device, equipment, storage medium and computer program product | |
| JP2011118575A (en) | Failure countermeasure information acquisition method and management server | |
| US20240211823A1 (en) | Operation content presentation method, operation content presentation device, and operation content presentation system | |
| JP2018045724A (en) | Service design support system and service design support method |
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 |