CN101251803A - Method for Oracle RAC to automatically add and delete node - Google Patents
Method for Oracle RAC to automatically add and delete node Download PDFInfo
- Publication number
- CN101251803A CN101251803A CNA2008100144591A CN200810014459A CN101251803A CN 101251803 A CN101251803 A CN 101251803A CN A2008100144591 A CNA2008100144591 A CN A2008100144591A CN 200810014459 A CN200810014459 A CN 200810014459A CN 101251803 A CN101251803 A CN 101251803A
- Authority
- CN
- China
- Prior art keywords
- node
- rac
- nodes
- oracle
- new
- 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
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000012217 deletion Methods 0.000 claims abstract description 26
- 230000037430 deletion Effects 0.000 claims abstract description 26
- 230000008569 process Effects 0.000 claims abstract description 10
- 230000004044 response Effects 0.000 claims description 7
- 230000007613 environmental effect Effects 0.000 claims description 4
- 238000009434 installation Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000001172 regenerating effect Effects 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- KIYMLWIZXQPEHU-UKELCRPCSA-N virip Chemical compound CC(C)C[C@H](N)C(=O)N[C@@H](CCC(O)=O)C(=O)N[C@@H](C)C(=O)N[C@@H]([C@@H](C)CC)C(=O)N1CCC[C@H]1C(=O)N[C@@H](CCSC)C(=O)N[C@@H](CO)C(=O)N[C@@H]([C@@H](C)CC)C(=O)N1[C@H](C(=O)N2[C@@H](CCC2)C(=O)N[C@@H](CCC(O)=O)C(=O)N[C@@H](C(C)C)C(=O)N[C@@H](CCCCN)C(=O)N[C@@H](CC=2C=CC=CC=2)C(=O)N[C@@H](CC(N)=O)C(=O)N[C@@H](CCCCN)C(=O)N2[C@@H](CCC2)C(=O)N[C@@H](CC=2C=CC=CC=2)C(=O)N[C@@H](C(C)C)C(=O)N[C@@H](CC=2C=CC=CC=2)C(O)=O)CCC1 KIYMLWIZXQPEHU-UKELCRPCSA-N 0.000 description 1
Images
Landscapes
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention provides a method of automatic adding and deleting Oracle RAC nodes. The method supposes the mutual visits between management nodes and nodes of the RAC without passwords; when the method is used on the management nodes, only by providing IP addresses of the nodes to be added and deleted, IP addresses of the main nodes in RAC and names of the database instances to be added and deleted, the method can automatically execute operations of adding and deleting the nodes; automatically finish the configuration of environment variable of the nodes to be added, the addition of new nodes in the Oracle RAC, the updating of lists and the setup of new node instances; automatically stop the database instances of the nodes to be deleted, finish the deletion of the nodes in the Oracle RAC and the deletion of related oracle files on the deleted nodes. The method of the invention can execute the operations of adding and deleting the nodes in the Oracle RAC automatically and rapidly, simplify the complicated input process in artificial configuration, improve work efficiency; besides, the real time online automatic deletion and addition of nodes can not affect the operation and running of the prior database and improve the expandability of the Oracle RAC.
Description
Technical field
The present invention relates to computer realm, be specifically related to the technology of automatic interpolation deletion Oracle RAC (RealApplication Cluster) node in a kind of cluster environment, online expansion RAC node does not influence existing user and uses.
Technical background
Oracle RAC is a kind of real cluster application program, realizes the dynamic deletion node that adds automatically, can regulate cluster node resource, improves the cluster utilization factor.The process complexity of adding, deleting node if realize adding automatically the program of deletion node, can be simplified the enforcement personnel and dispose installment work in node interpolation delete procedure.The process that manually adds node of Oracle RAC mainly contains the following step: dispose the rsh and the OCFS (Oracle Cluster File System) of other node among new node and the RAC, and various environmental variance; Call OUI (Oracle Universial Installer) on the major node and on new node, CRS is installed; Call OUI once more and on new node, expand Product DB, when Product DB installs end, call VIPCA, carry out the configuration of virtual interface; Call dbca then and create database.The process of the manual deletion node of Oracle RAC mainly contains the following step: all database instances that stop and deleting this node; Stop and deleting the audiomonitor of this node; Stop and deleting the nodeapplications of this node; Delete the CRS and the Product DB of this node, upgrade the node tabulation; The relevant configuration file of deletion RAC.In the process of above-mentioned interpolation and deletion node, need with cluster in each node constantly mutual, import required information, amount to the configuration that hundreds of goes on foot.If a skilled operators guaranteeing to finish the operation steps that node adds, deletes under the right-on prerequisite of every configuration, needs to spend several hours time at least.If realize the interpolation delete procedure of robotization, realize that said process takes only use tens minutes time.For being unfamiliar with the personnel that configuration effort is installed, also can finish interpolation, the work of deletion node smoothly especially.
Summary of the invention
The purpose of this invention is to provide the method that a kind of Oracle RAC adds the deletion node automatically, comprise following two steps:
The step that node adds:
A) the IP information and the title of RAC configuration information and new node are saved in configuration file rac.conf;
B) the basic environment of the new node of configuration: ocfs file system, IP address, the environmental variance identical with major node;
C) on major node, specify Response file by command line parameter, call OUI CRS, CRS is expanded on the new node, operation runInstaller upgrades the node tabulation;
D) on major node, specify Response file by command line parameter, call OUI Product DB, Product DB is expanded on the new node, operation runInstaller upgrades the node tabulation;
E) the Virtual IP of the new node of configuration;
F) on new node, add and start audiomonitor listener;
G) on new node, add the also example in log-on data storehouse.
The node deletion step:
A) obtain the name list of all nodes among the RAC, the IP address, nodelist and the RAC that obtain this node go up the Database Lists of operation;
B) each database in the Database Lists, list its all example at this node, stop and deleting these examples;
C) stop and deleting the audiomonitor of this node;
D) stop the VIP resource of this node by srvctl stop nodeapps-n`hostname`; The rootdeletenode.sh that calls this node deletes node applications from RAC, and by far call, operation runInstaller upgrades the node tabulation in remaining any node;
E) call rootdelete.sh this node is deleted from CRS, and by far call, operation rootdeletenode.sh deletes this node surplus resources in remaining any node, and operation runInstaller upgrades the node tabulation;
F) by far call, on each residue node this node information from/etc/hosts ,/root/.rhosts deletes among～the oracle/.rhosts;
G) revise IP address configuration file, the IP address that deletion is used in Oracle RAC;
H) leave out Oracle associated documents and catalogue.
The invention has the beneficial effects as follows: robotization Oracle RAC adds the layoutprocedure of deletion node, simplify human configuration, online expansion RAC node, not influencing existing user uses, improved the efficient that cluster resource uses, this method is applied widely, and windows operating system and linux operating system all are suitable for, and the 9i/10g/11g version of Oracle RAC also all is suitable for.
Description of drawings
Accompanying drawing 1 is the synoptic diagram that adds node automatically;
Accompanying drawing 2 is to add CRS and Product DB expansion synoptic diagram in the node automatically;
Accompanying drawing 3 is a synoptic diagram of deleting node automatically.
Embodiment
In order to make the purpose, technical solutions and advantages of the present invention more clear,, the present invention is done following detailed description below in conjunction with drawings and Examples.
The objective of the invention is to realize adding automatically among the Oracle RAC program of deletion node, carry out the operation of adding the deletion node among the OracleRAC fast and accurately, simplify loaded down with trivial details input process in the human configuration, increase work efficiency; And real-time online is deleted node automatically and is added node from Oracle RAC, do not influence existing database operation and operation, and the extensibility of increase Oracle RAC is regulated cluster node resource automatically, improves the cluster utilization factor.
The layoutprocedure of the interpolation node of Oracle RAC among the present invention, be decomposed into the rsh and the OCFS (Oracle Cluster File System) of other node among new node of configuration and the RAC, and various environmental variances, call OUI (Oracle UniversialInstaller) on the major node and on new node, expand CRS and Product DB, and upgrade node and tabulate, when Product DB installs end, call VIPCA configuration virtual IP, call netca then and add listener, call dbca establishment database.Wherein various input informations are to read from configuration file automatically, and the configuration file note is made rac.conf, and wherein content comprises: the information of node title, IP, RAC data storage location, oracle calling party and password; The expansion of OUI CRS, OUI RDBMS is by when the calling program, specifies Response file by command line parameter, and user's input that needs are obtained is read from response file and realized.Response file is the responseFile template according to CRS and RDBMS, before carrying out rootadd.sh and rootaddnode.sh, reads required information from rac.conf, generates automatically.Wherein the method for the generation of template is by operation Oracle OUI when Oracle RAC disposes, and adds the record order, and the input of user on graphical interfaces noted, save as responseFile, as the template of responseFile, only need to generate once, use from now on.
The process of the deletion node of Oracle RAC comprises among the present invention: obtain the name list of all nodes among the Oracle AC, the IP address, nodelist and the RAC that obtain this node go up the Database Lists of operation; Stop and deleting database instance on this node; Stop and deleting the audiomonitor of this node; Stop and deleting the node applications of this node; Delete the CRS and the Product DB of this node, upgrade the node tabulation; The relevant configuration file of deletion RAC.
Embodiment:
Add the specific implementation of RAC node
Add the RAC node, realize by on management node, calling addToAppMngr.sh.The method of calling of addToAppMngr.sh is:
#～addToAppMngr.sh＜new node IP〉＜major node IP〉[database 1[database 2...]]
The idiographic flow of addToAppMngr.sh:
1. all script files are copied on new node and the major node
2. calculate the IP address and the corresponding name of new node, and correlation parameter is saved in the RAC message file
3. new node is made as the trust main frame of major node, and the RAC message file is copied on the major node
4. checking whether new node starts finishes and the RAC message file is copied on the new node, then the AddToApp.sh on the new node of far call
4-1. the basic configuration file of copy function system from major node
4-2. calculate new memory device name and regenerate/etc/fstab
4-3. from the RAC message file, read parameters such as IP address and name
4-4. according to the parameter modification local profile that reads
5. utilize rsh on new node, regenerating new ocfs guid, and restart the ocfs service, then carry ocfs file system again
6. the AddToRAC.sh on the far call major node expands to the CRS on the major node, Product on the new node, and adds the VIP resource for new node
6-1. from the RAC message file, read parameters such as IP address and name
6-2. notify existing other all nodes among the RAC IP and the name of new node
6-3., revise the template of responseFile, to generate suitable responseFile according to the parameter that reads
6-4., revise the template that monitors script file, to generate suitable supervision script file according to the parameter that reads
6-5. calling crs installation monitor carries out in back way, monitor the log file that the new node interpolation of crs program produces, when needs are carried out script with the root identity, automatically carry out this script with the root identity, and call the new node of crs and add program, monitor the log file that the new node interpolation of crs program produces, wait for installation
6-6. calling product installation monitor carries out in back way, monitor the log file that the new node interpolation of product program produces, when needs are carried out script with the root identity, automatically carry out this script with the root identity and call the new node interpolation of product program, monitor the log file of the generation that the new node interpolation of product program produces, wait for installation
6-7. the configuration of the vipca on the new node of far call VIP resource
7. the AddListener.sh on the new node of far call is new node interpolation audiomonitor
7-1. from the RAC message file, read parameters such as IP address and name
7-2. according to the parameter modification Listener configuration file that reads
7-3. start Listener
8. for each data designated storehouse, call the AddToDB.sh on the new node
8-1. produce a untapped Instance Name
8-2. on new node, add a database instance
8-3. start new example
The specific implementation of deletion RAC node
Deletion RAC node is realized by call delAppMngr.sh on management node.The method of calling of delAppMngr.sh is:
#～delAppMngr.sh＜wait to delete node IP〉[database 1[database 2...]]
Database Lists must be write entirely.If write inentirely, can cause deletion failure.
1. wanting the execution script document copying on the node that will delete and major node
2. on the node that will delete, carry out delApp.sh
2-1. collect deleted node information, comprise nodelist and the databaselist of title, node VirIP/PubIP/PirIP and RAC
2-2. delete the database instance on this node
2-3. stop and deleting listener on this node
2-4. stop and deleting nodeapps on this node
2-5. on major node, upgrade nodelist
2-6. on major node, carry out rootdelete.sh and rootdeletenode.sh, remove DB and CRS information on the deleted node
2-7. in RAC in other node, by far call, on each residue node this node information from/etc/hosts ,/root/.rhosts, deletion is removed among～the oracle/.rhosts
2-8. delete relevant All Files and the catalogue of RAC on this node
3. check whether to delete to finish, withdraw from execution
By technical scheme of the present invention as seen, the present invention not only, the process of simplification improved the efficient of cluster management, and this method is applied widely.
Claims (1)
1, Oracle RAC adds the method for deletion node automatically, it is characterized in that
The step that node adds is as follows:
A) the IP information and the title of RAC configuration information and new node are saved in configuration file rac.conf;
B) the basic environment of the new node of configuration: ocfs file system, IP address, the environmental variance identical with major node;
C) on major node, specify Response file by command line parameter, call OUI CRS, CRS is expanded on the new node, operation runInstaller upgrades the node tabulation;
D) on major node, specify Response file by command line parameter, call OUI Product DB, Product DB is expanded on the new node, operation runInstaller upgrades the node tabulation;
E) the Virtual IP of the new node of configuration;
F) on new node, add and start audiomonitor listener;
G) on new node, add the also example in log-on data storehouse.
The process of node deletion is as follows:
A) obtain the name list of all nodes among the RAC, the IP address, nodelist and the RAC that obtain this node go up the Database Lists of operation;
B) each database in the Database Lists, list its all example at this node, stop and deleting these examples;
C) stop and deleting the audiomonitor of this node;
D) stop the VIP resource of this node by srvctl stop nodeapps-n`hostname`; The rootdeletenode.sh that calls this node deletes node applications from RAC, and by far call, operation runInstaller upgrades the node tabulation in remaining any node;
E) call rootdelete.sh this node is deleted from CRS, and by far call, operation rootdeletenode.sh deletes this node surplus resources in remaining any node, and operation runInstaller upgrades the node tabulation;
F) by far call, on each residue node this node information from/etc/hosts ,/root/.rhosts deletes among～the oracle/.rhosts;
G) revise IP address configuration file, the IP address that deletion is used in Oracle RAC;
H) leave out Oracle associated documents and catalogue.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100144591A CN101251803A (en) | 2008-03-11 | 2008-03-11 | Method for Oracle RAC to automatically add and delete node |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100144591A CN101251803A (en) | 2008-03-11 | 2008-03-11 | Method for Oracle RAC to automatically add and delete node |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101251803A true CN101251803A (en) | 2008-08-27 |
Family
ID=39955205
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008100144591A Pending CN101251803A (en) | 2008-03-11 | 2008-03-11 | Method for Oracle RAC to automatically add and delete node |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101251803A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106815318A (en) * | 2016-12-24 | 2017-06-09 | 上海七牛信息技术有限公司 | A kind of clustering method and system of time series database |
| CN106874343A (en) * | 2016-12-24 | 2017-06-20 | 上海七牛信息技术有限公司 | The data-erasure method and system of a kind of time series database |
-
2008
- 2008-03-11 CN CNA2008100144591A patent/CN101251803A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106815318A (en) * | 2016-12-24 | 2017-06-09 | 上海七牛信息技术有限公司 | A kind of clustering method and system of time series database |
| CN106874343A (en) * | 2016-12-24 | 2017-06-20 | 上海七牛信息技术有限公司 | The data-erasure method and system of a kind of time series database |
| CN106874343B (en) * | 2016-12-24 | 2020-07-14 | 上海七牛信息技术有限公司 | Data deletion method and system for time sequence database |
| CN106815318B (en) * | 2016-12-24 | 2020-08-04 | 上海七牛信息技术有限公司 | Clustering method and system for time sequence database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7818740B2 (en) | Techniques to perform gradual upgrades | |
| CN111027921B (en) | Service processing method and device, electronic equipment and storage medium | |
| CN101251802A (en) | Unattended operation automatic installing method of Oracle RAC | |
| CN102591679A (en) | Quick application software arrangement method for cluster system | |
| CN104572202B (en) | A kind of method that enterprise-level application software is disposed under cloud computing | |
| CN105740003A (en) | Method and device for recovering virtual machine, as well as method and device for upgrading virtual machine | |
| CN103327108A (en) | Cross-platform software management platform based on cloud and construction method thereof | |
| CN111475515A (en) | Compensation management method and device for failed task, computer equipment and storage medium | |
| CN111737227A (en) | Data modification method and system | |
| CN104021020A (en) | Automatic software installation method | |
| KR100923161B1 (en) | Portable storage apparatus for providing working environment migration service, and method for providing working environment migration service in that | |
| CN111158957B (en) | Virtual machine file recovery method, system, device and storage medium | |
| CN103984621B (en) | log separation method and system | |
| CN103678007A (en) | Method and system for deploying software in batches | |
| CN101251803A (en) | Method for Oracle RAC to automatically add and delete node | |
| CN102281326A (en) | Data automatically synchronizing and updating method based on WEB server procedures | |
| CN111857862A (en) | Plug-in management method and device, electronic equipment and computer readable storage medium | |
| CN101373464B (en) | Method, apparatus and system for automatically adopting form setting | |
| CN114490189A (en) | Cloud platform database backup method and device, electronic equipment and storage medium | |
| Paokin et al. | Unified approach for provision of supercomputer center resources | |
| CN106100909A (en) | The method that program based on WEB server updates with data automatic synchronization | |
| Cisco | Upgrading to Cisco Info Center 3.4.1 | |
| KR100506069B1 (en) | A system for repackaging application software for streaming of application software and method thereof | |
| CN106357777A (en) | Method for automatically and synchronously updating program and data based on Web server | |
| CN113064698A (en) | Method for providing product environment and corresponding device, system, equipment and 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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080827 |