NAV: SLTechnology News&Howtos > Database >

• 

  Oracle database 12cR2 (one of the project practices): install Oracle12.2 on Windows

  Oracle database 12cR2 (project practice II): linux system installation Oracle 12.2, course topic: Fengge Oracle database tutorial 12cR2 (project practice II): install Oracle12.2 in the linux operating system. two

  2022-06-01 16:10:26 Views: 209
• 

  Postfix, dovecot configuration

  (1) postfix configuration 1 configure dns1 yum install bind-y2 systemctl start named3 vim / etc/named.conf content: options {/ /

  2022-06-01 16:09:56 Views: 284
• 

  ORACLE profile

  The functions of the configuration file: manage passwords and limit the resources that can be consumed by the session. Oracle recommends using resource managers to restrict resource management. 1. Syntax: create configuration file: CREATE PROFILE profile LIMIT {resource_p

  2022-06-01 16:09:55 Views: 283
• 

  ORA-06553: PLS-553: character set name is not recognized, while starting Content Store

  Today, when using PLSQL to import data through EXCEL, it is found that all Chinese are displayed as? Confirm that the database character set is not set properly: compared with the normal database, it is found that NLS_CHARACTERSET is ZHS16GBKSQL > select name

  2022-06-01 16:09:55 Views: 224
• 

  50 suggestions for MongoDB developers Tip7

  This series of articles are translated from "50 Tips and Tricks for MongoDB Developers". I can't find the Chinese version for the time being. Anyway, I have been studying mongodb deeply recently, so I just want to translate it. On the one hand, strengthen yourself.

  2022-06-01 16:09:55 Views: 226
• 

  Hashes type and operation of redis

  Hashes type and operation Redis hash is a mapping table of field and value of string type. Its add and delete operations are all O (1) (average). Hash is particularly suitable for storing objects. Instead of saving each field of an object as a single s

  2022-06-01 16:09:55 Views: 298
• 

  [oracle] solve the problem of Chinese garbled code in oracle under centos 7

  First of all, the reason for the formation of Chinese garbled code is due to the disunity of the character set, different character sets are bound to appear garbled in the process of conversion, of course, it can be converted. Therefore, in order to solve the problem of Chinese garbled code, the idea is to unify the character set involved in the process of input, storage, display and so on.

  2022-06-01 16:09:54 Views: 301
• 

  [summary] synchronize the organization in the relational database to LDAP

  Code reference: https://github.com/chocolateBlack/db2LdapQQ group: 223460081 synchronize the relational data organization to the LDAP 1, obtain the organizational relationship in the relational DB 2, spanning tree

  2022-06-01 16:09:54 Views: 230
• 

  Advantages and disadvantages of micro-service architecture

  With the concept of DevOps, continuous delivery and other concepts deeply rooted in the hearts of the people, micro-service architecture began to enter our field of vision. So is microservice a long-awaited solution in the industry? Or is micro-service simpler than the overall solution? Let's first define microservices: microservices are those that use a set of small services.

  2022-06-01 16:09:54 Views: 286
• 

  The database used by BAT

  Today, with the rapid development of big data, the amount of data is constantly increasing, especially the rise of Internet web2.0 applications and the development of mass storage and massive computing needed by cloud computing. The traditional relational database has exposed many insurmountable problems and has been unable to meet the needs of this aspect. Not relational type.

  2022-06-01 16:09:44 Views: 227
• 

  Common optimization operations for database configuration

  When we were hired to monitor MySQL performance, people wanted us to take a look at the MySQL configuration and give some suggestions for improvement. Many people were surprised afterwards because we advised them to change only a few settings, even if there were hundreds of configuration items. The purpose of this article is to

  2022-06-01 16:09:32 Views: 225
• 

  Master-Slave synchronization configuration and implementation of MySql

  With the development of mysql master-slave replication technology, in the actual production environment, a single MySQL database server can not meet the actual needs. At this time, the database cluster solves this problem very well. Using MySQL distributed cluster, we can build a set with high concurrency and load balance.

  2022-06-01 16:09:32 Views: 270
• 

  MySQL error: Last_Errno: 1008 | Last_SQL_Errno: 1008

  MySQL master-slave replication cannot be synchronized. Check the slave status and report an error as follows: mysql > show slave status\ gateway * 1. Row *

  2022-06-01 16:09:32 Views: 205
• 

  [docker] build mysqld service image based on Dockerfile

  First, create the build directory structure # mkdir-pv docker/mysql# cd docker/mysql/ second write Dockerfile file # vim Dockerfile

  2022-06-01 16:09:32 Views: 276
• 

  Mongodb Key File file generation

  Reference: http://docs.mongodb.org/manual/tutorial/generate-key-file/Generate a Key FileOverviewThis section

  2022-06-01 16:09:31 Views: 258
• 

  Oracle_GG

  Concept: real-time data synchronization between users OLTP and OLAP, originally developed by a company in San Francisco, acquired and promoted by Oracle, with high performance; subsecond latency; TPS can be thousands; heterogeneity: support data synchronization between different types of databases; transactionality: support

  2022-06-01 16:09:20 Views: 221
• 

  Multi-table query based on SQL (10)

  JOINS type and its syntax Natural joins (natural join):-NATURAL JOIN clause-USING clause-ON clause self-join non-equivalent join Outer joins (outer join):-LEFT O

  2022-06-01 16:09:20 Views: 214
• 

  Automatically modify mysql5.7 initialization password

  Mysql5.7 for security reasons, after initialization, the root password is generated randomly, and the password is placed in the error log. There are two steps: the first step is to obtain error.log password. Change the default password, passwd= `grep 'generated for

  2022-06-01 16:09:20 Views: 280
• 

  Oracle uses parallel trampled pits

  1. A brief introduction to parallel mechanisms the mechanism of parallel processing actually divides a data set to be scanned into many small data sets. Oracle will start several parallel service processes to process these small data sets at the same time according to the value of the initialization parameter PARALLEL_MIN_SERVERS=n.

  2022-06-01 16:09:20 Views: 249
• 

  Java sql Editor dynamic report Database backup restore quartz

  Get [download address] QQ: 313596790 [free updates] three major databases mysql oracle sqlsever is more professional, more powerful, and suitable for different user groups [newly recorded video tutorials for this system, hand-in-hand teaching the development of a module

  2022-06-01 16:08:50 Views: 284