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