An example of ASM disk not found in DBCA Library

Environmental Information red hat linux64  gi 11.2.0.4  oracle 11.2.0.4 Problem Phenomena After installing gi software and oralce database software, the database is built through the dbca user interface. It is found that the database can be built normally on node1, not on node2. The dbca library building process errors on node2. Figur ...

Posted by scottrad on Sun, 05 Jul 2020 17:42:16 +0200

MySQL parsing order

SQL parsing order Next, let's take a look at the past and present life of an SQL statement. First, let's look at the sample statement: SELECT DISTINCT < select_list > FROM < left_table > < join_type > JOIN < right_table > ON < join_condition > WHERE < wh ...

Posted by rlhms09 on Sun, 21 Jun 2020 04:28:16 +0200

[Java] http connection using agent (example of integrating Alibaba cloud SMS service in Intranet environment)

1. Problem description I do project services: start in the Intranet environment, all links related to the Internet need to go through transparent agent.Alibaba cloud sdk: encapsulate all operations related to http. We can't configure HTTP related settings. To solve the problem 1: how can intranet serv ...

Posted by Simmo on Wed, 17 Jun 2020 07:11:50 +0200

LinkedList is 1000 times slower than ArrayList? (dynamic graph + performance evaluation)

Array and linked list are two kinds of data structures commonly used in the program, and they are also one of the interview questions often tested in the interview. However, for many people, they just vaguely remember the difference between them. Maybe they still don't remember it right. And every time they come for an interview, they have to r ...

Posted by nomis on Mon, 15 Jun 2020 07:07:42 +0200

To in Oracle Database_ Usage of the date() function

In an Oracle database, Oracle to_ The date () function is a frequently used function. Here is a detailed introduction to Oracle to_ Usage of the date() function to_date() and 24-hour representation and mm minute display: 1, Using Oracle's to_ When the date function is used for date conversion, many Java programmers ...

Posted by $SuperString on Mon, 01 Jun 2020 17:15:37 +0200

How ORACLE databases export table structures using the datapump tool and import them under other Schema s

This is a brief introduction to how to export and import table structure definitions using the datapump tool of the ORACLE database.Because business scenarios can be very simple, you won't encounter any problems, or business scenarios can be very complex, and you will encounter a lot of problems.Here's a brief description of what you need.A bat ...

Posted by Hexxx on Thu, 28 May 2020 03:39:28 +0200

[12c] Histograms

Histogram, a special type of statistical information of columns, can provide more detailed data distribution information of columns in the table. Histogram stores values in buckets. Based on the number of different values and the distribution of data, the database selects the type of histogram to be created. The types of histogram are as follow ...

Posted by slibob on Wed, 27 May 2020 14:30:00 +0200

Oracle RAC cluster testing - production environment best practices (Oracle 11g/12c/18c/19 RAC)

Production environment Oracle RAC cluster test best method (support Oracle 11g/12c/18c/19c RAC installation post test process) 1, Oracle RAC cluster test background A large and medium-sized manufacturing company has built a set of business system ERP system for new projects. The database environment of this system is Oracle RAC (RHEL Linux7+O ...

Posted by sgtbash on Wed, 20 May 2020 12:29:41 +0200

MySql Foundation - Building MySql Database: Installing MySql-server, MySql-client

1 Build MySQL Server1.1 Question This case requires familiarity with the use of MySQL's official installation package to quickly build a database server: Install MySQL-server, MySQl-client packagesModify the password of the database user rootConfirm MySQL service program is running and root is controllable 1.2 Program This course will use the ...

Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200

Oracle12c? Installation 1 - Preparation

1. Suggest users and groups su root  #Switch to root groupadd oinstall  #Create user group oinstall groupadd dba  #Create user group dba useradd -g oinstall -g dba -m oracle  #Create oracle users and join oinstall and dba user groups passwd oracle  #Set the login password of the user oracle, do not set the password, unable to login i ...

Posted by thomasd1 on Fri, 01 May 2020 13:39:46 +0200