CN103235725A - Linux-based rapid deployment method for Oracle database in cloud computing - Google Patents
Linux-based rapid deployment method for Oracle database in cloud computing Download PDFInfo
- Publication number
- CN103235725A CN103235725A CN2013101814746A CN201310181474A CN103235725A CN 103235725 A CN103235725 A CN 103235725A CN 2013101814746 A CN2013101814746 A CN 2013101814746A CN 201310181474 A CN201310181474 A CN 201310181474A CN 103235725 A CN103235725 A CN 103235725A
- Authority
- CN
- China
- Prior art keywords
- oracle
- script
- database
- oracle database
- work
- 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 27
- 238000013515 script Methods 0.000 claims abstract description 43
- 238000009434 installation Methods 0.000 claims abstract description 20
- 238000010367 cloning Methods 0.000 claims abstract description 5
- 230000006870 function Effects 0.000 claims abstract description 4
- 230000002452 interceptive effect Effects 0.000 claims abstract description 4
- 230000009897 systematic effect Effects 0.000 claims description 7
- 238000012986 modification Methods 0.000 abstract description 4
- 230000004048 modification Effects 0.000 abstract description 4
- 230000006835 compression Effects 0.000 abstract description 2
- 238000007906 compression Methods 0.000 abstract description 2
- 238000012544 monitoring process Methods 0.000 abstract description 2
- 238000012856 packing Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 4
- 238000000151 deposition Methods 0.000 description 2
- 230000007613 environmental effect Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000011900 installation process Methods 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000009941 weaving Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a Linux-based rapid deployment method for an Oracle database in cloud computing. The rapid deployment method comprises the steps of 1.1), firstly, installing oracle database software on a Linux host in a conventional mode, and then packing the software into a compressed file oracle.tar by using a tar compression command; 1.2), using a shell programming language for writing an executable script01 and an executable script02, wherein the script01 completes all setting work before installation of the oracle database, and the script02 completes establishing work of a database example; 1.3), cloning a virtual host which only contains a Linux operating system through a cloning function of a cloud platform, and distributing and modifying an operating system network card internet protocol (IP); 1.4), uploading an oracle installation package and executable scripts to a host on which the database is needed to be installed; 1.5), executing the script01 to finish all setting work before installation of the oracle database, wherein the setting work comprises modification of operating system parameters, establishment of user groups and users, setting of environment variables and establishment of installation directories and example storage directories; and 1.6), executing the script02 to enter an interactive interface, setting characteristics of the oracle database example according to prompts, finishing the oracle database example and monitoring establishment work.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology field, specifically a kind of quick deployment method of oracle database in cloud computing based on linux.
Background technology
In the current information age, the use of specialized database is more and more frequent, an enterprise even tens sets of data storehouses are arranged simultaneously in operation, and the deployment of specialized database and install and also need professional skill.
Particularly in recent years, cloud computing, was particularly adopted in telecom operators' cloud computing in IDC to landing on a large scale from concept.Allow empty machine lease, empty machine packing data storehouse lease become a very common behavior.
At a big IDC center, may concentrate many sets of data storehouse of reaching the standard grade in one day, and this is for the O﹠M personnel of IDC, is a job consuming time, as easily to make mistakes.
Summary of the invention
The purpose of this invention is to provide a kind of quick deployment method of oracle database in cloud computing based on linux.
The objective of the invention is to realize in the following manner a kind of method deployment oracle database in cloud computing environment fast and accurately that provides to be solved by this invention.Allow the database of specialty dispose simplification, and shorten the oracle database and dispose the time, compression system is reached the standard grade preceding setup time.
Concrete implementation step is as follows:
1.1 the oracle database software at first is installed on the linux main frame in the usual way, is used the tar compress order to be packaged into a compressed file oracle.tar then;
Can carry out script script01, script02 1.2 use the shell programming language to write.The script01 script is finished preceding all of installation oracle database work is set, and the script02 script is finished the wound of database instance and advanced work;
1.3 use one of the cloning function clone of cloud platform only comprise linux operating system fictitious host computer, and distribute and the network interface card IP of retouching operation system;
1.4 oracle is installed compressed package and can carry out the main frame that script is uploaded to needs installation database;
1.5 carry out the script01 script, finish preceding all of installation oracle database work is set, comprise retouching operation systematic parameter, establishment user group, user, set, create installation directory and example storing directory;
1.6 carry out the script02 script, enter interactive interface, according to the feature of prompting setting oracle database instance, finish the oracle database instance and monitor building work.
Described quick deployment method, the installation in the step 1.2 can be carried out script file, comprising: the script01 script is finished all of installing before the oracle database and work and script02 script are set are finished the wound of database instance and advance work.
Described quick deployment method, to finish all of installing before the oracle database after script01 in the step 1.5 carries out work will be set, comprise: the retouching operation systematic parameter, create user's group, user, set, create installation directory and example storing directory.
Excellent effect of the present invention: adopt the method for the invention, compared with prior art, can realize that the database of quick, simple and robotization is disposed.Refer to that fast conventional method need upload the priginal soft bag, the setting operation system environments is carried out nearly tens steps of installation steps process, and skilled Database Engineer also needs just can finish deployment more than 2 hours.And after employing the present invention, carry out good script prepared in advance to take a three-stage approach, only just can finish the work with 30 minutes.Refer to that simply database deployment slip-stick artist no longer needs the skills training of specialty, just can finish database deployment work.Robotization refers to be written to tens step work that branch is run on foot and can carry out in the script, formulates automatically and finishes.
Because the present invention does not have registration table according to linux operating system, adopt that file directly copies between the different operating system, and revise the method for individual character words parameter by carrying out script.The mistake of having avoided artificial modification systematic parameter to cause has reduced disposing the requirement of personnel's technical ability, shortens database and disposes the time, improves online implementing speed.Be adapted at cloud computing environment, large batch of Database Systems are disposed.
Description of drawings
Fig. 1 is the process flow diagram that usual manner is disposed the oracle database;
Fig. 2 is the process flow diagram of disposing the oracle database behind employing the present invention;
Fig. 3 is the internal process that can carry out script script01;
Fig. 4 is the internal process that can carry out script script02.
Embodiment
Explain below with reference to Figure of description method of the present invention being done.
Implementation step is as follows:
1.1 create fictitious host computer and the (SuSE) Linux OS of corresponding version be installed according to business demand at the cloud platform;
Can carry out script script01 1.2 write, retouching operation systematic parameter configuration file in the script implementation is created database user, group, revises the database user environmental variance;
1.3 upload the initialization installation kit of corresponding oracle database version, and decompress(ion), the installation data library software;
Script script02 be can carry out 1.4 write, database instance, data bank network monitoring in the script implementation, created;
The mounted database software 1.5 pack comprises script01, script02 and can carry out script;
1.6 be uploaded to new fictitious host computer, decompress(ion) is also carried out script, namely finishes database host environment set, software installation, example establishment simultaneously, monitors building work.
Embodiment
Below main the discussion in the cloud computing environment based on the installation of the oracle database of linux operating system and the implementation that database instance is created fast.
In order to increase extendability and compatibility, during specific implementation technology of the present invention, can use the shell language compilation can carry out script.Accomplish in different cloud computing environments (vsphere/Xen/inspurCloudOS), on the different linux platforms (redhat/suse/Ubuntu/redflag), different oracle database versions (oracle9i/10g/11g) all can use method of the present invention.
Fig. 1 is the process flow diagram that usual manner is disposed the oracle database.Step complexity, spended time are longer, and the oracle database that needs the technician to possess specialty is installed technical ability.
Fig. 2 is the process flow diagram of disposing the oracle database behind employing the present invention.By analysis and the conclusion to conventional deployment way among Fig. 1, write a robotization installation process.
In cloud computing environment, usually need to dispose on a large scale database.At first use the virtual machine cloning function of cloud computing support programs (as: vsphere/XenServer/inspur CloudOS), clone a Linux virtual machine, repair network interface card IP address then, the script carried out (script01/script02) of uploading the Oracle software packaging then and weaving.Order is carried out script01 and two of script02 can carry out script under the root user then.Finish personal settings according to script prompt.Data are disposed and are finished.
Fig. 3 is the internal process that can carry out script script01.The technician after carrying out the script01 script under the linux operating system, the internal operation flow process of the background process of script.At first script can be revised/the etc/system file, and the retouching operation systematic parameter is oracle user's set memory section size.Modification/etc/security/limits.conf file again improves the upper limit of oracle user management resource.Modification/etc/profile.local file again arranges oracle user's umask sign indicating number.Create oinstall/dba user's group again, create oracle user.Establishment/oracle catalogue is used for depositing the oracle database software again, and establishment/oradata catalogue is used for depositing the oracle database instance again.The oracle SID that inquiry and input will be set.Automatically revise oracle user's environmental variance.The back output successfully that is finished points out successfully.
Fig. 4 is the internal process that can carry out script script02.The technician can carry out the script02 script behind complete script01 script under the linux operating system.This script will carry out with the foreground interactive mode, whether at first inquire self-defining data storehouse example, not create default instance automatically if select to call the createdb.sql script, and call netca and create oracle listener.Need be according to the quantity of prompting setting data storehouse example Redo daily record group if select, Redo daily record group membership's size, set the size of system table space, set the size in temporary table space, call the netca order and create the database oracle listener, monitor in log-on data storehouse example/log-on data storehouse, and the back output successfully that is finished points out successfully.
Except the described technical characterictic of instructions, be the known technology of those skilled in the art.
Claims (3)
1. the quick deployment method of oracle database in cloud computing based on linux is characterized in that concrete steps are as follows:
1.1 the oracle database software at first is installed on the linux main frame in the usual way, is used the tar compress order to be packaged into a compressed file oracle.tar then;
Can carry out script script01, script02 1.2 use the shell programming language to write, the script01 script is finished preceding all of installation oracle database work is set, and the script02 script is finished the wound of database instance and advanced work;
1.3 use one of the cloning function clone of cloud platform only comprise linux operating system fictitious host computer, and distribute and the network interface card IP of retouching operation system;
1.4 oracle is installed compressed package and can carry out the main frame that script is uploaded to needs installation database;
1.5 carry out the script01 script, finish preceding all of installation oracle database work is set, comprise retouching operation systematic parameter, establishment user group, user, set, create installation directory and example storing directory;
1.6 carry out the script02 script, enter interactive interface, according to the feature of prompting setting oracle database instance, finish the oracle database instance and monitor building work.
2. the described quick deployment method of claim 1, it is characterized in that, installation in the step 1.2 can be carried out script file, comprising: the script01 script is finished all of installing before the oracle database and work and script02 script are set are finished the wound of database instance and advance work.
3. the described quick deployment method of claim 1, it is characterized in that, to finish all of installing before the oracle database after script01 in the step 1.5 carries out work will be set, comprise: the retouching operation systematic parameter, create user's group, user, set, create installation directory and example storing directory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101814746A CN103235725A (en) | 2013-05-16 | 2013-05-16 | Linux-based rapid deployment method for Oracle database in cloud computing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101814746A CN103235725A (en) | 2013-05-16 | 2013-05-16 | Linux-based rapid deployment method for Oracle database in cloud computing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103235725A true CN103235725A (en) | 2013-08-07 |
Family
ID=48883770
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101814746A Pending CN103235725A (en) | 2013-05-16 | 2013-05-16 | Linux-based rapid deployment method for Oracle database in cloud computing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103235725A (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103401940A (en) * | 2013-08-12 | 2013-11-20 | 无锡华云数据技术服务有限公司 | Automatic deploy method for cloud computing application software |
| CN103544319A (en) * | 2013-11-06 | 2014-01-29 | 浪潮(北京)电子信息产业有限公司 | Multi-tenant database sharing method and multi-tenant database as-a-service system |
| CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
| CN105786564A (en) * | 2016-02-22 | 2016-07-20 | 上海新炬网络信息技术有限公司 | Automatic custom installation and deployment method for Oracle |
| CN106372142A (en) * | 2016-08-30 | 2017-02-01 | 广西电网有限责任公司 | DM database and Weblogic combination one-key automatic deployment method |
| CN106598657A (en) * | 2016-12-07 | 2017-04-26 | 国云科技股份有限公司 | One-key deployment method for cloud platform applications |
| CN106603267A (en) * | 2016-08-30 | 2017-04-26 | 广西电网有限责任公司 | Automatic one-key deployment method of MySQL and Weblogic combination |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN106899518A (en) * | 2017-02-27 | 2017-06-27 | 腾讯科技（深圳）有限公司 | A kind of method for processing resource and device based on Internet data center |
| CN106897101A (en) * | 2017-02-28 | 2017-06-27 | 郑州云海信息技术有限公司 | The dispositions method and device of a kind of oracle database |
| CN107332873A (en) * | 2017-05-24 | 2017-11-07 | 杭州沃趣科技股份有限公司 | A kind of method of automatic discovery cluster resource |
| CN107515766A (en) * | 2017-08-24 | 2017-12-26 | 北京锐安科技有限公司 | Generation method, deployment installation method and the device of database deployment file |
| CN107609202A (en) * | 2017-10-25 | 2018-01-19 | 武汉斗鱼网络科技有限公司 | A kind of method, apparatus and computer equipment for disposing database instance |
| CN107861731A (en) * | 2017-11-06 | 2018-03-30 | 郑州云海信息技术有限公司 | A kind of Database Creation Method and device |
| CN108536448A (en) * | 2018-03-21 | 2018-09-14 | 江苏长顺江波软件科技发展有限公司 | A method of modification windows operating systems SID |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN109298856A (en) * | 2017-07-19 | 2019-02-01 | 北京国双科技有限公司 | The method and apparatus of editing machine edition compatibility |
| CN109857411A (en) * | 2018-12-13 | 2019-06-07 | 正方软件股份有限公司 | The method and device of installation database under linux system |
| CN110502252A (en) * | 2019-08-16 | 2019-11-26 | 苏州浪潮智能科技有限公司 | A kind of database all-in-one machine configuration method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040139294A1 (en) * | 2003-01-14 | 2004-07-15 | International Business Machines Corporatin | Backup firmware in a distributed system |
| CN101251802A (en) * | 2008-03-11 | 2008-08-27 | 浪潮电子信息产业股份有限公司 | Unattended operation automatic installing method of Oracle RAC |
| CN101977274A (en) * | 2010-10-25 | 2011-02-16 | 中兴通讯股份有限公司 | System and method for disposing service platforms |
| CN102591694A (en) * | 2012-01-18 | 2012-07-18 | 深圳市同洲视讯传媒有限公司 | Method and device for installing and deploying interactive television demand system |
-
2013
- 2013-05-16 CN CN2013101814746A patent/CN103235725A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040139294A1 (en) * | 2003-01-14 | 2004-07-15 | International Business Machines Corporatin | Backup firmware in a distributed system |
| CN101251802A (en) * | 2008-03-11 | 2008-08-27 | 浪潮电子信息产业股份有限公司 | Unattended operation automatic installing method of Oracle RAC |
| CN101977274A (en) * | 2010-10-25 | 2011-02-16 | 中兴通讯股份有限公司 | System and method for disposing service platforms |
| CN102591694A (en) * | 2012-01-18 | 2012-07-18 | 深圳市同洲视讯传媒有限公司 | Method and device for installing and deploying interactive television demand system |
Non-Patent Citations (1)
| Title |
|---|
| 黄宏志: "Oraclel0g数据库的安装优化方法研究", 《信息技术》 * |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103401940A (en) * | 2013-08-12 | 2013-11-20 | 无锡华云数据技术服务有限公司 | Automatic deploy method for cloud computing application software |
| CN103544319A (en) * | 2013-11-06 | 2014-01-29 | 浪潮(北京)电子信息产业有限公司 | Multi-tenant database sharing method and multi-tenant database as-a-service system |
| CN103544319B (en) * | 2013-11-06 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | A kind of method of many tenants shared data bank and multi-tenant database i.e. service system |
| CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
| CN105204897B (en) * | 2015-09-14 | 2018-09-07 | 上海新炬网络信息技术股份有限公司 | A kind of mass installation and deployment method of MySQL |
| CN105786564A (en) * | 2016-02-22 | 2016-07-20 | 上海新炬网络信息技术有限公司 | Automatic custom installation and deployment method for Oracle |
| CN106372142A (en) * | 2016-08-30 | 2017-02-01 | 广西电网有限责任公司 | DM database and Weblogic combination one-key automatic deployment method |
| CN106603267A (en) * | 2016-08-30 | 2017-04-26 | 广西电网有限责任公司 | Automatic one-key deployment method of MySQL and Weblogic combination |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN106598657A (en) * | 2016-12-07 | 2017-04-26 | 国云科技股份有限公司 | One-key deployment method for cloud platform applications |
| WO2018153218A1 (en) * | 2017-02-27 | 2018-08-30 | 腾讯科技（深圳）有限公司 | Resource processing method, related apparatus and communication system |
| CN106899518A (en) * | 2017-02-27 | 2017-06-27 | 腾讯科技（深圳）有限公司 | A kind of method for processing resource and device based on Internet data center |
| CN106899518B (en) * | 2017-02-27 | 2022-08-19 | 腾讯科技（深圳）有限公司 | Resource processing method and device based on Internet data center |
| CN106897101A (en) * | 2017-02-28 | 2017-06-27 | 郑州云海信息技术有限公司 | The dispositions method and device of a kind of oracle database |
| CN107332873A (en) * | 2017-05-24 | 2017-11-07 | 杭州沃趣科技股份有限公司 | A kind of method of automatic discovery cluster resource |
| CN109298856A (en) * | 2017-07-19 | 2019-02-01 | 北京国双科技有限公司 | The method and apparatus of editing machine edition compatibility |
| CN107515766A (en) * | 2017-08-24 | 2017-12-26 | 北京锐安科技有限公司 | Generation method, deployment installation method and the device of database deployment file |
| CN107609202A (en) * | 2017-10-25 | 2018-01-19 | 武汉斗鱼网络科技有限公司 | A kind of method, apparatus and computer equipment for disposing database instance |
| CN107861731A (en) * | 2017-11-06 | 2018-03-30 | 郑州云海信息技术有限公司 | A kind of Database Creation Method and device |
| CN108536448A (en) * | 2018-03-21 | 2018-09-14 | 江苏长顺江波软件科技发展有限公司 | A method of modification windows operating systems SID |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN109857411A (en) * | 2018-12-13 | 2019-06-07 | 正方软件股份有限公司 | The method and device of installation database under linux system |
| CN110502252A (en) * | 2019-08-16 | 2019-11-26 | 苏州浪潮智能科技有限公司 | A kind of database all-in-one machine configuration method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103235725A (en) | Linux-based rapid deployment method for Oracle database in cloud computing | |
| CN102402446B (en) | Method and device for installing application software | |
| US9280336B2 (en) | Virtual machine disk image installation | |
| CN108376100A (en) | Container scheduling based on safety | |
| CN107733985B (en) | Method and device for deploying functional components of cloud computing system | |
| CN106878334A (en) | The automatically dispose system and method for cloud | |
| CN106469068B (en) | Application program deployment method and system | |
| US10296384B2 (en) | Dynamic workload deployment for data integration services | |
| CN106446019B (en) | A kind of software function treating method and apparatus | |
| CN105094964B (en) | Virtual machine migration method and system | |
| CN103530162A (en) | Automatic online virtual machine software installing method and system | |
| CN112199157B (en) | Cloud environment management method | |
| CN107483243A (en) | A kind of automatic deployment method and equipment of OpenStack platforms | |
| CN109240716B (en) | Big data platform version management and rapid iterative deployment method and system | |
| CN105704188A (en) | Deployment method and apparatus of applications and services | |
| CN104318091B (en) | A kind of moonlet ground test method based on virtualization computer system | |
| CN105653401A (en) | Method and device for scheduling disaster recovery, operation and maintenance, monitoring and emergency start-stop of application systems | |
| CN104965672A (en) | Method for automatically and quickly configuring RAID (redundant array of independent disks) | |
| CN111813420B (en) | Method for carrying out automatic performance test on OpenStack cluster | |
| CN108021427A (en) | Information system deployment and updating management method based on Docker | |
| CN106708573A (en) | System and method used for automatic installation of Hadoop cluster | |
| CN103984621B (en) | log separation method and system | |
| CN108089924A (en) | A kind of task run method and device | |
| CN105653342A (en) | Method and system for achieving automatic domain entering of Windows pool desktop | |
| CN106406978A (en) | Automatic making device and method for private cloud virtual machine template |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130807 |