Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for automatically deploying oracle rac environment variable

An environment variable and automatic deployment technology, applied in the field of database deployment, can solve problems such as database installation failure, heavy workload, and error-prone, and achieve the effect of improving implementation efficiency, reducing labor costs, and ensuring zero failure rate

Inactive Publication Date: 2018-01-09
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, manual modification of the parameters of the two K1s is a heavy workload, so it takes a day to deploy a set of rac
In addition, the database installation fails due to human involvement in the deployment operation which is error-prone

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for automatically deploying oracle rac environment variable
  • Method for automatically deploying oracle rac environment variable

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0018] This embodiment proposes a method for automatically deploying oracle rac environment variables, which mainly includes the following parts:

[0019] 1) Determine the precondition parameters of the automation script:

[0020] Determine the host name, root password, database name, business physical IP, heartbeat IP, VIP, and oracle user passwords of several K1s as the pre-condition parameter input of the automated script. The prior condition parameters determined by the automated script and the specific parameter types can be changed according to actual conditions, and all fall within the protection scope of the present invention.

[0021] 2) Several oracle users on K1 realize automatic login:

[0022] Create an automatic login function auto_login_ssh(), which allows several K1s to switch and log in to each other freely.

[0023] 3) Several oracle users on K1 realize automatic interactive copy:

[0024] Create an automatic copy function auto_scp(), which allows several K1 different ...

Embodiment 2

[0031] This embodiment proposes a method for automatically deploying oracle rac environment variables. The oracle rac is deployed by two Tiansuo K1s. The following takes two K1 deployed oracle racs as an example to describe the automatic deployment of oracle rac in the present invention in detail. The technical content of the environmental variable method.

[0032] By writing automated shell scripts, the oracle rac environment variables are automatically deployed on two K1s. The main contents include:

[0033] 1) Determine the precondition parameters of the automation script;

[0034] Determine the host name, root password, database name, business physical IP, heartbeat IP, VIP, and oracle user password of the two K1s, as the pre-condition parameter input of the automated script; and these pre-condition parameters can be changed at will according to customer needs, enhanced The flexibility of human-computer interaction.

[0035] 2) Automatic login of oracle users on two K1s;

[0036] ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for automatically deploying an oracle rac environment variable, and relates to a database deployment technology. Firstly, an automatic script is written, the completeautomatic script is deployed on a K1 machine, then antecedent condition parameters are input, and the automatic script can complete a configuration script according to a sequence of environment configuration; and then by an automatic login function and an automatic copying function, the configuration script is automatically transmitted onto other K1 machines, and by related scripts, environment configuration of other K1 machines is completed. According to the method disclosed by the invention, original artificial manual modification on the rac environment variable is changed into script automatic modification, so that implementing efficiency is improved, and labor cost is reduced; parameter changing of man-machine interaction is adopted, so that flexibility of man-machine interaction is reinforced; and a fault rate of artificial construction is avoided, a zero fault rate is ensured, and the satisfaction of a client on implementing work is obviously improved.

Description

Technical field [0001] The present invention relates to database deployment technology, specifically, a method for automatically deploying oracle rac environment variables. Background technique [0002] Oracle rac (oracle real application clusters, oracle real-time application clusters) is a high-availability new technology adopted in the new version of oracle database. It can build a high-availability database system on low-cost servers and deploy applications freely without modifying the code; When the application scale needs to be expanded, users can expand the system as needed to ensure system performance. Oracle rac has the following advantages: 1) Multi-node load balancing; 2) Provides high availability, fault tolerance and seamless switching functions; 3) Improves transaction response time through parallel execution technology for data analysis systems; 4) Improves through horizontal expansion The number of transactions per second and the number of connections are used in...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): H04L12/24G06F17/30
Inventor 薛强
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com