Database Administrator

Solve the problem of Chinese garbled characters stored in MySQL 5.5 and hibernate When using hibernate and mysql for data storage, you will find garbled characters in the database if you store Chinese characters. The solution is as follows: Change

Whether the path change of the bare device in ASM affects the operation of the database Use asm to store database files. In linux, you can use asmlib to manage Block devices, or use bare devices to create an asm disk. In asmlib mode, changing the

Oracle cloud control 12c startup and Shutdown The entire installation of Oracle cloud control 12c is complicated. The installation path, logon password, port number, and many other configurations are confusing. This article describes how to obtain

Analysis on solutions for creating and last updating timestamp fields in MySQL Before writing this article, clarify my MySQL version. Mysql> select version ();+ ------------ +| VERSION () |+ ------------ +| 5.5.29-log |+ ------------ +1 row in set (0

Oracle left Outer Join tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table (Id number,Age

Oracle Database optimization and optimization steps Identify the current status of the system System server model CPU speed and quantity Memory size I/O device status Network Conditions Number of system users and number of concurrent

DBCP data source usage, dbcp Data SourceDBCP: DataBase Connection Pool1, the need for jar: commons-dbcp.jar commons-pool.jar 2. Copy the DBCP configuration file (dbcpconfig. properties) to the build path. 3. Create a class: DBCPUtil Dbcpconfig.

Learn the skills that Oracle should prepare and the oracle preparation skills First, database skills:Database architecture, basic concepts and basic theories, database management, backup, recovery, SQL development, PLSQL development, and use of

[A trap] Mysql users, permissions, and passwords. (The created user cannot log in), mysql Login Mysql Version: Mysql 5.6. The user permissions in Mysql are not only related to the user, but also to the user's login password (password. For example,

How does mysql count the number of entries in a table? The following is a common SQL statement used to count the entries in a table: Select count (*) from tableName; # orselect count (1) From tableName; # or counts a column, such as IDselect count

MHA + non-root user SSH equivalent configuration, mha non-rootssh Environment: CentOS5.8 MySQL5.5.17 Experiment: Set up the MHA high-availability architecture (non-root user SSH equivalent configuration) SSH equivalent user configuration: concert

WAS cluster series (2): low-level database connection error-network connection problem, was Cluster Environment Project point Metrics WAS version 7.0 Application Server Operating System Windows 2008

Train of Thought and solution for attendance Issues, and train of thought for attendance Issues Recently, I am working on an attendance system. Attendance mainly focuses on absenteeism, late arrival, and early departure. Currently, the punching

MySql database connection pool and mysql database connection 1.Traditional links(As shown below) Note: (1). the traditional method of finding DriverManager to connect is limited. (2). the traditional method of close () does not reuse the

Troubleshooting "Global Enqueue Services Deadlock detected" (Doc ID 1443482.1), enqueuedeadlock In this Document   Purpose   Troubleshooting Steps   1. TX deadlock in Exclusive (X) mode  

Mysql enables remote services and mysql enables Enter mysqlserver As follows: Enter password :******Welcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id is 810Server version: 5.6.10 MySQL Community Server (GPL)Copyright

Selecting the most efficient table name sequence for Oracle performance optimization learning notes, and oracle Performance OptimizationSelect the most efficient table name sequence (only valid in the rule-based Optimizer) The ORACLE parser

WAS cluster series (6): cluster creation: Step 4: Install WAS upgrade software, cluster was Click "Next" step by step and pay attention to one process, as listed below: We recommend that you set the path for "upgrade software" installation, which

WAS cluster series (5): Cluster Construction: Step 3: Install HIS software, cluster his Select the "install IBM HTTPServer" option and click "Installation Wizard", as shown in the following figure: Installation tips: click "Next" step by step,

Blob field value for accessing the oracle Data Link, oracleblob Access photo table Select * from zp @ dblink1 where a1 = '201312 '; Error: The ora-22992 cannot use the LOB locator selected from the remote table Change to the following method: Method