CN106020857A - Automatic disposition method used for Oracle Real Application Cluster database cluster - Google Patents
Automatic disposition method used for Oracle Real Application Cluster database cluster Download PDFInfo
- Publication number
- CN106020857A CN106020857A CN201610209828.7A CN201610209828A CN106020857A CN 106020857 A CN106020857 A CN 106020857A CN 201610209828 A CN201610209828 A CN 201610209828A CN 106020857 A CN106020857 A CN 106020857A
- Authority
- CN
- China
- Prior art keywords
- module
- configuration
- oracle
- execution module
- python
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
- Exchange Systems With Centralized Control (AREA)
Abstract
The invention relates to the field of operation and maintenance automation, and discloses an automatic disposition method used for an Oracle Real Application Cluster database cluster. The method comprises: importing a configuration file into a configuration reading module, through information reading of the configuration reading module, accessing a task execution module, the task execution module including a local execution module, a remote execution module, and a background execution module, and the local execution module, the remote execution module, and the background execution module cooperating with each other. Creativity of the method is that the method jumps out specified steps for installing a document given by the official Oracle Company, the method says goodbye to manual step-by-step complex operation which may has faults, and through program packaging, installation of a RAC cluster is convenient, automatic, and normalized, the method greatly reduces time consumption of an installation process, and prevents a problem that a common technicist frequently goes wrong in an installation process.
Description
Technical field
The present invention relates to O&M automatic field, particularly related to a kind of for Oracle Real Application
The automatic deployment method of Cluster data-base cluster.
Background technology
Python is a kind of object-oriented, explanation type computer programming language, and nowadays, it is got over
To apply in IT O&M automatic field manyly.Python advantage on system administration is powerful opening
Sending out ability and complete tools chain, Python has become the sharp weapon in operation maintenance personnel hands.
Summary of the invention
The present invention is actually needed and solves the technical problem that and be: for expense during current Oracle RAC cluster installation fee
The present situation of power, it is provided that a kind of automatic deployment method for Oracle Real Application Cluster cluster,
Carry for system manager (System administrator) and data base administrator (Database administrator)
For convenient.The creativeness of the present invention is to have jumped out that official of Oracle company provides installs document defined
Step, has been taken leave of the manual loaded down with trivial details operation the most easily made mistakes step by step, has been encapsulated by program, by RAC collection
The installation facilitation of group, automatization, standardization, greatly reduce installation process time-consuming while, also keep away
The problem having exempted from frequently to make mistakes in those of ordinary skill installation process.
In order to solve above-mentioned technical problem, the present invention is addressed by following technical proposals:
A kind of automatic deployment method for Oracle Real Application Cluster data-base cluster, will join
Put file and import configuration read module, read by the information configuring read module and enter into task execution module,
Task execution module includes locally executing module, remotely performing module and background executing module, locally executes mould
Block, remotely execution module and background executing module cooperate and carry out, and comprise the following steps:
(1) check user's configuration and for installing whether the main frame of RAC starts, arbitration disk is formatted；
(2) call configParser module by python and directly read configuration file, be automatically performed by
The public IP of cluster, private ip, virtual IP address, SCAN IP are configured in all local parsing files；
(3) call zip module by python and automatically decompress Oracle medium；
(4) call pexpect by python and automatically configure the equivalence of Oracle user between node, including
Generate ssh PKI and key, the PKI of each node is filled in the authorized keys file to all nodes
In, and file attribute is set；
(5) read the configuration information needing to realize in configuration file, be automatically performed Grid Infrastructure soft
The installation of part；
(6) by the paramiko module of python, automatic remote signs in destination host to be carried out
The operation of orainstRoot.sh script；
(7) by the paramiko module of python, automatic remote signs in destination host to carry out CRS and joins
Put the operation of script $ GRID_HOME/root.sh, then run cfgtoolllogs, carry out joining of CRS resource
Put work, including startup and the registration work of monitor resource；
(8) read the configuration information needing to realize in configuration file, be automatically performed Oracle RDBMS software
Install；
(9) by the paramiko module of python, automatic remote signs in destination host to be carried out
The operation of $ ORACLE_HOME/root.sh script, completes to install.
Due to the fact that and have employed above technical scheme there is significant technique effect: by jumping out Oracle
The step installing document defined that official of company is given, has taken leave of manual step by step loaded down with trivial details and has the most easily made mistakes
Operation, encapsulated by program, by the installation facilitation of RAC cluster, automatization, standardization, greatly
Ground reduce installation process time-consuming while, it also avoid asking of frequently makeing mistakes in those of ordinary skill installation process
Topic.
Accompanying drawing explanation
Fig. 1 is a kind of automatic portion for Oracle Real Application Cluster data-base cluster of the present invention
Arranging method schematic flow sheet.
Detailed description of the invention
With embodiment, the present invention is described in further detail below in conjunction with the accompanying drawings.
Embodiment 1
As it is shown in figure 1, a kind of automatic portion for Oracle Real Application Cluster data-base cluster
Arranging method, imports configuration read module by configuration file, is read by the information configuring read module and enters into
Task execution module, task execution module includes that locally executing module, remotely execution module and backstage performs mould
Block, locally executes module, remotely execution module and background executing module and cooperates and carry out, including following step
Rapid:
(1) check user's configuration and for installing whether the main frame of RAC starts, arbitration disk is formatted；
(2) call configParser module by python and directly read configuration file, be automatically performed by
The public IP of cluster, private ip, virtual IP address, SCAN IP are configured in all local parsing files, compare biography
In system step, technical staff typically requires manual a line a line and adds, the most uninteresting and loaded down with trivial details, by automatically
Change configuration, time saving and energy saving and the most error-prone, save the time of half an hour more than；
(3) call zip module by python and automatically decompress Oracle medium, save and manually solve one by one
The triviality of pressure；
(4) call pexpect by python and automatically configure the equivalence of Oracle user between node, including
Generate ssh PKI and key, the PKI of each node is filled in the authorized keys file to all nodes
In, and file attribute is set, in traditional approach, Oracle official document requires that technical staff's manual configuration saves
The equivalence of oracle user between point, and this paper series to arrange special file attribute, operates different
The most complicated, call pexpect and be automatically performed above operation, it is not necessary to any manual intervention, directly saving one is little
The more than time time；
(5) read the configuration information needing to realize in configuration file, be automatically performed Grid Infrastructure soft
The installation of part, in traditional approach, Oracle official document requires that technical staff uses Xwindow graphically boundary
Face mode calls its installation tool runInstaller, and it is higher to environmental requirement to open graphical interfaces, because figure
The port of interface transmission is generally all by firewall filtering, and the such business of client XManager to be installed
Industry paying instrument, and DISPLAY environmental variable is set in shell, after opening graphical interfaces, need a step
Step is filled in installation information needed and is installed, and the scheme that the present invention proposes is achieve installation silent, nothing
Graphic interface tool need to be called, directly read the information realizing configuration in configuration file, automatically complete Grid
The installation of Infrastructure software, directly saves the time of more than 3 hours；
(6) by the paramiko module of python, automatic remote signs in destination host to be carried out
The operation of orainstRoot.sh script, in traditional approach, Oracle official document requires that technical staff saves one by one
Point runs orainstRoot.sh script, and technical staff to sign in destination host one by one and run this script, this
The scheme of bright proposition is the paramiko module by python, and automatic remote signs in destination host and carries out foot
This operation；
(7) by the paramiko module of python, automatic remote signs in destination host to carry out CRS and joins
Put the operation of script $ GRID_HOME/root.sh, then run cfgtoolllogs, carry out joining of CRS resource
Put work, including startup and the registration work of monitor resource；
(8) read the configuration information needing to realize in configuration file, be automatically performed Oracle RDBMS software
Install；
(9) by the paramiko module of python, automatic remote signs in destination host to be carried out
The operation of $ ORACLE_HOME/root.sh script, completes to install.
The present invention, by jumping out the step installing document defined that official of Oracle company provides, has taken leave of hands
The work loaded down with trivial details operation the most easily made mistakes step by step, is encapsulated by program, by the installation facilitation of RAC cluster,
Automatization, standardization, greatly reduce installation process time-consuming while, it also avoid those of ordinary skill
The problem frequently made mistakes in installation process.
In a word, these are only presently preferred embodiments of the present invention, all impartial changes made according to scope of the present invention patent
Change and modify, all should belong to the covering scope of patent of the present invention.
Claims (1)
1. for an automatic deployment method for Oracle Real Application Cluster data-base cluster, will configuration literary composition
Part imports configuration read module, is read by the information configuring read module and enters into task execution module, appoints
Business performs module and includes locally executing module, remotely performs module and background executing module, locally execute module,
Remotely perform module and background executing module cooperate and carries out, it is characterised in that comprise the following steps:
(1) check user's configuration and for installing whether the main frame of RAC starts, arbitration disk is formatted；
(2) call configParser module by python and directly read configuration file, be automatically performed cluster
Public IP, private ip, virtual IP address, SCAN IP be configured in All hosts configuration file；
(3) call zip module by python and automatically decompress Oracle medium；
(4) call pexpect by python and automatically configure the equivalence of Oracle user between node, including generating
Ssh PKI and key, fill in the PKI of each node to the authorized keys file of all nodes,
And file attribute is set；
(5) read the configuration information needing to realize in configuration file, be automatically performed Grid Infrastructure software
Install；
(6) by the paramiko module of python, automatic remote signs in destination host and carries out orainstRoot.sh
The operation of script；
(7) by the paramiko module of python, automatic remote signs in destination host and carries out CRS configuration foot
The operation of this $ GRID_HOME/root.sh, then runs cfgtoolllogs, carries out the configuration work of CRS resource
Make, including startup and the registration work of monitor resource；
(8) read the configuration information needing to realize in configuration file, be automatically performed the installation of Oracle RDBMS software；
(9) by the paramiko module of python, automatic remote signs in destination host to be carried out
The operation of $ ORACLE_HOME/root.sh script, completes to install.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610209828.7A CN106020857A (en) | 2016-04-06 | 2016-04-06 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610209828.7A CN106020857A (en) | 2016-04-06 | 2016-04-06 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106020857A true CN106020857A (en) | 2016-10-12 |
Family
ID=57081002
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610209828.7A Pending CN106020857A (en) | 2016-04-06 | 2016-04-06 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106020857A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109976897A (en) * | 2017-12-27 | 2019-07-05 | 航天信息股份有限公司 | A kind of dispositions method, data interactive method and the corresponding intrument of big data cluster |
| CN111427592A (en) * | 2020-03-20 | 2020-07-17 | 广州锦行网络科技有限公司 | High-availability system for virtual deployment of mysql |
| WO2023155176A1 (en) * | 2022-02-18 | 2023-08-24 | 京东方科技集团股份有限公司 | Etl system construction method and apparatus, data processing method and apparatus, and etl system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
| CN104809015A (en) * | 2015-05-05 | 2015-07-29 | 浪潮电子信息产业股份有限公司 | Method for automatically deploying Oracle rac environment based on Linux system |
| CN105072211A (en) * | 2015-08-12 | 2015-11-18 | 网宿科技股份有限公司 | Domain name deployment system and domain name deployment method based on DNS (Domain Name Server) |
| WO2015188617A1 (en) * | 2014-06-11 | 2015-12-17 | 中兴通讯股份有限公司 | Method and device for installing mysql databases |
| US20160036667A1 (en) * | 2014-07-29 | 2016-02-04 | Commvault Systems, Inc. | Customized deployment in information management systems |
| CN105426208A (en) * | 2015-11-16 | 2016-03-23 | 山东超越数控电子有限公司 | OpenStack offline automatic installation method of cloud computing system |
-
2016
- 2016-04-06 CN CN201610209828.7A patent/CN106020857A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
| WO2015188617A1 (en) * | 2014-06-11 | 2015-12-17 | 中兴通讯股份有限公司 | Method and device for installing mysql databases |
| US20160036667A1 (en) * | 2014-07-29 | 2016-02-04 | Commvault Systems, Inc. | Customized deployment in information management systems |
| CN104809015A (en) * | 2015-05-05 | 2015-07-29 | 浪潮电子信息产业股份有限公司 | Method for automatically deploying Oracle rac environment based on Linux system |
| CN105072211A (en) * | 2015-08-12 | 2015-11-18 | 网宿科技股份有限公司 | Domain name deployment system and domain name deployment method based on DNS (Domain Name Server) |
| CN105426208A (en) * | 2015-11-16 | 2016-03-23 | 山东超越数控电子有限公司 | OpenStack offline automatic installation method of cloud computing system |
Non-Patent Citations (2)
| Title |
|---|
| 刘天斯: "《Python自动化运维 技术与最佳实践》", 31 December 2014, 机械工业出版社 * |
| 刘甫迎，饶斌，刘焱: "《数据库原理及技术应用教程 Oracle》", 30 September 2009, 中国铁道出版社 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109976897A (en) * | 2017-12-27 | 2019-07-05 | 航天信息股份有限公司 | A kind of dispositions method, data interactive method and the corresponding intrument of big data cluster |
| CN109976897B (en) * | 2017-12-27 | 2021-06-22 | 航天信息股份有限公司 | Deployment method of big data cluster, data interaction method and corresponding device |
| CN111427592A (en) * | 2020-03-20 | 2020-07-17 | 广州锦行网络科技有限公司 | High-availability system for virtual deployment of mysql |
| CN111427592B (en) * | 2020-03-20 | 2021-06-22 | 广州锦行网络科技有限公司 | High-availability system for virtual deployment of mysql |
| WO2023155176A1 (en) * | 2022-02-18 | 2023-08-24 | 京东方科技集团股份有限公司 | Etl system construction method and apparatus, data processing method and apparatus, and etl system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111061817B (en) | Adaptive business construction system, method and computer readable medium | |
| CN102034152B (en) | The method for integrating of heterogeneous software system data and system based on SOA framework | |
| CN106254127B (en) | Automatic deployment method of RabbitMQ cluster service based on virtualization platform | |
| CN107678946B (en) | Model-based airborne embedded software test environment construction method | |
| CN107566165B (en) | Method and system for discovering and deploying available resources of power cloud data center | |
| CN105700888A (en) | Visualization rapid developing platform based on jbpm workflow engine | |
| CN106681775A (en) | Method for achieving online batch upgrading of hard disk firmware through RAID card under Linux system | |
| CN103235725A (en) | Linux-based rapid deployment method for Oracle database in cloud computing | |
| CN109951564A (en) | A kind of generation method of smart machine micro services | |
| CN103457761B (en) | Cross-platform command line configuration interface implementation method | |
| CN109343854A (en) | Intelligent automation Compilation Method and system based on zynq system | |
| CN106020857A (en) | Automatic disposition method used for Oracle Real Application Cluster database cluster | |
| CN112199157A (en) | Cloud environment management method | |
| CN112364106A (en) | Data association visualization method and system for automatically generating service topological graph | |
| CN106484452B (en) | unified configuration management method and device for software platform | |
| US7124397B1 (en) | Power builder for power management control system automation software | |
| CN108055142B (en) | Automatic interface configuration method and system for vCPE (virtual customer premise equipment) | |
| CN117369790A (en) | Intelligent node and traditional function node service flow mixed-editing engine system | |
| CN112416805A (en) | Test management cloud platform and method | |
| CN111723417A (en) | Method for creating BIM model filter based on Revit software | |
| CN111880883A (en) | Dynamic combined primitive realization method based on equipment object | |
| CN110969414A (en) | Cross-platform workflow implementation method and system based on Java | |
| CN110941422A (en) | Code automatic generation method, code generator and readable storage medium | |
| CN114115998A (en) | Abstract instruction conversion method and system for heterogeneous cloud network equipment | |
| CN114327498A (en) | Automated deployment method, system, electronic device and computer readable medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161012 |
|
| RJ01 | Rejection of invention patent application after publication |