Linux Centos 7.x Interface-free Quiet Installation of Oracle 11gR2
In order to provide the maximum performance of the system in Linux production environment, graphical desktops are generally not installed. So when we install a more complex database like Oracle, we are at a loss. Otherwise, Oracle has already considered the installation situation in this environment for us, which is the quiet ...
Posted by steviez on Sun, 03 Feb 2019 19:15:16 -0800
12c Grid Infrastructure Management Repository
After installing grid in Grid Infrastructure 12.1.0.2, you can see that there are more ora.MGMTLSNR and ora.mgmtdb in the resources. At the same time, you start an instance, sid=-MGMTDB.
[grid@prodb1 ~]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Serve ...
Posted by fresch on Thu, 31 Jan 2019 02:30:15 -0800
MyBatis Learning (6)
This video viewing address: https://edu.51cto.com/sd/3ec2c
1. Caching
1.1. The Significance of Caching
By putting the data that users often query in the cache (memory), users can query the data from the cache instead of from the disk (relational database data files), thus improving the query efficiency and solving the performance problems of ...
Posted by prue_ on Wed, 30 Jan 2019 20:45:15 -0800
SpringBoot integrated PageHelper (Oracle database)
Reference webpage
https://blog.csdn.net/gnail_oug/article/details/80229542
Integration steps
Pom
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
a ...
Posted by adelinewss on Mon, 28 Jan 2019 19:03:14 -0800
Using mybatis to operate AS400 database
Let's briefly talk about how to use [jt400.jar] to connect to the DB2 database on AS400.
jt400.jar resource, if you have AS400 client installed, refer to IBM official website
※ http://www-01.ibm.com/support/docview.wss?uid=swg21398042
Installation directory has jt400.zip, suffix can be used.
If you don't have AS400 client installed, download it ...
Posted by mazman on Sat, 26 Jan 2019 05:12:15 -0800
Oracle to Mysql Question Record
Recently, there is a new project to change the existing engineering data source into mysql, and to achieve compatibility between oracle and MySQL after the transformation. Record the problems encountered in the process.
Database Table Conversion and Data Conversion
Download PowerDesigner and Navicat Premium
2. Export user bu ...
Posted by akop on Fri, 25 Jan 2019 23:12:15 -0800
Detailed description of oracle parameters open_cursors and session_cached_cursor
SQL> show parameter open_cursors --each session(How many sessions can be opened at most at the same time cursor(Cursor)
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> show pa ...
Posted by myflashstore on Mon, 07 Jan 2019 22:45:10 -0800
physical standby in Oracle-dataguard cannot receive archives from primary database
Experimental environment: Oracle 11.2.04, Linux Centos 6.8
Architectural environment: Oracle-DG dual-node, main library instance_name: mysql1, standby instance_name: mysql2
The main library db_unique_name: mysql1; the backup db_unique_name: mysql2
Master and Standby Log Transfer Mode: maximize availability real-time synchron ...
Posted by jamiel on Mon, 07 Jan 2019 20:42:09 -0800
Java Canning: Character Streams in the Official Guide to I/O Streams
Included in this album: Overview and Index of I/O Stream Official Chinese Guide Series
Most of the content comes from The Java™ Tutorials Official guidelines, the rest from other sources such as Translation of ifeve imooc, book Android interview book and so on.Author: @youyugePersonal blog sites: https://youyuge.cn
I. What is Character Stream ...
Posted by alexk1781 on Mon, 07 Jan 2019 09:03:09 -0800
The Difference between case when External sum and count in SQL Statement
The following table TEST:
category | commdity | price
------------+------------+-------
Clothing | T-shirt | 1000
Office supplies | puncher | 500
Kitchen utensils | kitchen knife | 3000
Kitchenware | Pressure cooker | 6800
Kitchenware | Fork | 500
Kitchenware | Cleaning the Vegetable Board | 880
Office Suppl ...
Posted by volatileboy on Sun, 06 Jan 2019 03:18:10 -0800