red hat linux64
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.
Posted by scottrad on Sun, 05 Jul 2020 17:42:16 +0200
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_list >
< left_table > < join_type >
JOIN < right_table > ON < join_condition >
< wh ...
Posted by rlhms09 on Sun, 21 Jun 2020 04:28:16 +0200
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
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
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
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
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
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
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
This course will use the ...
Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200
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