Database Administrator

Oracle RAC Database 11.1.0.6 listening fault case After receiving a call, the customer's core Oracle RAC database cannot be connected, and no listening program is available at the time of connection. The customer's Oracle RAC version is 11.1.0.6 and

Use pt-table-sync to restore inconsistent data In the previous article, pt-table-checksum was used to verify data consistency. This section describes how to verify master-slave data consistency. when determining whether master-slave data is

Simple tutorial for SQL statements in linux --- CREATE TABLE, simple tutorial --- create A table is the basic architecture for storing data in a database. In most cases, the database vendor cannot know how to store your data. Therefore, you usually

SSDB basic instructions and usage, SSDB basic instructions There are several reasons for using SSDB at that time. First, when designing the contest module, You need to query the Rank of the current competition multiple times because you click to

Mysql monitoring tools: zabbix + MPM (Performance Monitor for MySQL), zabbixmpm MPM is mainly used to monitor various mysql parameter performance indicators. The following describes the configuration of MPM and zabbix: The following figure shows the

How to Write custom IP address algorithms and custom IP address Algorithms Through the IP address, you can see the algorithm rule, write it as a custom IP address, or convert the IP address to a custom IP address. It can also be used to encrypt

Oracle Stored Procedure record exception, Oracle Stored Procedure record For Oracle stored procedures, an exception can be thrown to the code or recorded in a table. If your system application has many nodes, such as our 40 nodes, if an error is

SQL Server Report statistics-parameterized Dynamic Compaction row-to-column, sqlserverregression List all table structures first: -- Title Report -- table real-time Water Fee: hx_t_received -- field Charge Department id: hx_f1_mentid 1. Charge

The mysqli extension is missing. Check the PHP configuration ., Mysqliphp A new lamp is installed and you want to open the database. The following error occurs: PhpMyAdmin-the error message "mysqli extension" is missing. Check the PHP

Rebuild the rollback tablespace and the rollback tablespace Author: iamlaosong The data in the rollback segment is not submitted due to unexpected reasons (power loss or manual killing), and a large amount of data retained in the rollback segment

2. add, delete, and manage multi-node Master/Slave clusters in Windows 7 of mongodb cluster. mongodbwin7 Reprinted please indicate Source: http://blog.csdn.net/tianyijavaoracle/article/details/41744557 I. mongo Replica Sets three nodes are deployed

Description of Oracle 12c CDB and PDB database startup and shutdown, 12 cpdb     In Oracle 12c, it is divided into CDB and PDB. Their startup and shutdown operations are as follows.  1 Container Database (CDB)   For CDB, the startup and shutdown

Mysql Tomcat C3p0 System Performance Tuning personal summary, System Information The application logic is to use c3p0 to query data in the database and return Json data over http.   1. the initial test result JMeter test result before optimization

Upgrade Android databases and Android Databases public class MySQLiteHelper extends SQLiteOpenHelper { public static final String SQL_CREATE= "create table news (" + "_id integer primary key autoincrement, " +

Oracle 10G tablespace movement, all applicable routines of the TNS listener cannot establish a new connection, service_died 12537, c3p0 connection pool parameters, One Oracle O & M experience while learning and working, step by step. A few days ago,

[MongoDB] The Capped Collection set of Mongodb databases, mongodbcapped Capped Collection is a set of excellent performance with a fixed size. It executes age-out (aging removal) processing in the LRU (least Recently Used, least Recently Used) rule

Project Summary-basic steps for JDBC database access-jdbc Data AccessFollow these steps to access the database through JDBC:(1) load the JDBC driver of the database to classpath. during actual development of Java ee-based web applications,Usually

MongoDB (IV)-management architecture and mongodb Management Architecture We have introduced the basics of MongoDB. We recommend two websites here. You can check them and explain them in detail #. Let's take a look at MongoDB's data management and

Database: JDBC programming, database jdbc Programming JDBC (Java Data Base Connectivity, java database connection) is a Java API used to execute SQL statements. It can provide unified access to multiple relational databases, it consists of a group

Oracle _ advanced subquery, oracle _ advanced subqueryZookeeper Oracle _ advanced subquery ① SubqueryA subquery is another SELECT statement nested in an SQL statement.Subquery (internal query) is executed before the master query is executed.Main