Shell script analysis dblink method based on Linux platform

A script parsing and platform technology, applied in the database field, can solve problems such as high requirements, omissions, and heavy manual inspection workload, and achieve the effect of lowering the work threshold, overcoming inefficiency, and simplifying the inspection.

Pending Publication Date: 2020-07-10
杭州美创科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to overcome the problems of heavy workload and high requirements of manual inspection in the prior art, and omissions may occur, the present invention provides a simple and safe way to obtain the dblink associated with the current database without any configuration of the database. The Linux platform-based shell script analysis dblink method of the end database ip address

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
  • Shell script analysis dblink method based on Linux platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The present invention will be further described below in conjunction with accompanying drawing and specific embodiment:

[0032] Such as figure 1 The illustrated embodiment is a Linux platform-based shell script analysis dblink method, comprising the following steps:

[0033] Step 100, obtaining the current database as a client to access all the ip addresses of other databases;

[0034] Step 101, obtain the connection string through the host column in the dba_dblinks view, and obtain n records;

[0035] Use the sql script "select regexp_replace(lower(host),'\s+',")host from dba_dblinks where db_link not in('SYS_HUB','DBMS_CLRDBLINK')and host is notnull)" to get the connection string, use regexp_replace regular The replacement function removes useless spaces, newlines and tabs to ensure that each connection string occupies only one line, and writes the above-mentioned processed content into the file / tmp / dblink.txt line by line, and the processed Results come in three...

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 shell script analysis dblink method based on a Linux platform. The shell script analysis dblink method comprises the following steps: acquiring all ip addresses of a currentdatabase as a client for accessing other databases; obtaining all ip addresses, accessed by other databases through dblink, of the current database as a server; and identifying the obtained ip addresses and then combining and displaying the ip addresses. Compared with the prior art, the method has the advantages that the dblink interconnection relationship can be checked more simply, efficiently and stably, and the working threshold of a checker is lowered; meanwhile, the correctness of a checking result is guaranteed through a program, omission caused by human errors is avoided, and the configuration modification operation risk of the database is avoided.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a Linux platform-based shell script analysis dblink method that is simple and safe and can obtain the ip address of a peer database associated with the dblink associated with the current database without any configuration of the database. Background technique [0002] Oracle released an early warning document on March 17, 2019: Recommended patches and actions for Oracle databases versions 12.1.0.1, 11.2.0.3 and earlier–before June 2019 (document number 2361478.1). This article strongly recommends that all database administrators (DBAs) check all Oracle databases using dblink, and upgrade or patch according to the recommendations to solve potential problems of dblink interoperability in the future. The "potential problem of dblink interoperability" mentioned in the article refers to the situation that the access between databases through dblink is denied, which causes business a...

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): G06F11/30G06F16/21
CPCG06F11/302G06F11/3051G06F16/21
Inventor 姜宜民柳遵梁顾皓天
Owner 杭州美创科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap