Database Administrator

In Linux, MySQL is configured with master-slave nodes. Linux: CentOS 6.5Master1: 192.168.100.204Master2: 192.168.100.205Mysql version: mysql-5.6.19Note: The configuration methods for versions earlier than mysql 5.5 and later are different. Install

SQL Server C # connection and object existence judgment This article provides a comprehensive overview of C # database connection. For C # connection to ms SQL Server, sqlconnection is primarily used. The authentication mode is windows integrated

Requirements for installing Oracle 11.2.0.4 on RHEL7 or OEL7 Requirements for Oracle 11.2.0.4 db installation on RHEL7 or OEL7Source:Requirements for Installing Oracle 11.2.0.4 RDBMS on RHEL7 or OL7 64-bit (x86-64) (Document ID 1962100.1) Applicable:

The heartbeat timeout detection of ASM -- Delayed asm pst heart beats Recently, we have received the dismount of the ASM disk and the error "Waited 15 secs for write IO to PST". This is the unique heartbeat timeout detection of ASM, the ASM instance

How to clear the execution plan of an SQL statement in the share pool in Oracle 11g In the past, if the execution plan was slow due to binding snoop on Oracle 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it

Oracle 10g Lsnrctl does not reflect database connection failure Symptom Description: The Oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is entered, no

Oracle Database Upgrade (10gR2 to 11gR2) I have a general understanding of Oracle Database Upgrade today, but there are still many things worth considering. First, preparations before the upgrade require a lot of work: 1. Testing and preparation,

Exception in initAndListen: 12596 old lock file, terminating, fileexception # Mongd-f/etc/mongodb. conf error reported Monogdb. log analysis Unclean shutdown detected. Please visit http://dochub.mongodb.org/core/repair for recovery

[PLSQL] variable binding, dynamic SQL, hard parsing and soft parsing, plsqlsql**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column******************************

Solution to Environment variable ORACLE_UNQNAME not defined error reported by CentOS Oracle, environmentvariable After installing Oracle on CentOS today, the "Environment variable ORACLE_UNQNAME not defined" error is reported when the "emctl start

Create temporary tablespace group in oracle and create in oracleAfter oracle11g, you can create a temporary tablespace group. A temporary tablespace group can contain one or more temporary tablespaces.A temporary tablespace group must consist of at

Add, delete, modify, query, and add, delete, and modifyPreface: LanguageIntegrated Query is a set of extensions for c # and Visual Basic languages. It allows you to write C # Or Visual Basic code to query memory data in the same way as a

Cursor: pin S, cursorpin Cursor: pin S OTN is explained as follows: Cursor: pin SA session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same

MongoDB time zone and mongodb Time Zone For work reasons, I recently worked on a mongoDB java project. The time in the project is found to be faulty. Each time the data is saved, it will be less than 8 hours. Solution Add annotation before

Database Operations-triggers, databases-triggers A trigger is a special type of stored procedure. Unlike a stored procedure, a trigger is triggered by an event and automatically called for execution, the stored procedure can be called by the name of

2015 Xin Xing MySQL tutorial Spring edition fourth optimization modeling, Xin Xing mysql After some time, the fourth tutorial of the xinxing MySQL tutorial in 2015 was finally completed. It was positioned as modeling optimization. For example,

Find the corresponding SQL statement using the PID in the operating system, and find the SQL statement using the pid.In linux, we generally use the TOP command to view the processes with the largest performance consumption. If oracle is used, we

Detailed introduction of WAL mechanism in SQLite, sqlitewal Mechanism 1. What is WAL? The full name of WAL is Write Ahead Logging. It is a mechanism used in many databases to implement atomic transactions. SQLite introduced this feature in version 3.

TNS-12535: TNS: operation timed out and TNS-00505: Operation timed out processing, tns-12535tns-00505Preface: View alert logs and find many error messages:[Oracle @ localhost trace] $ more alert_powerdes.log**************************************** **

Summary of oracle flashback database, oracleflashback Flashback database is a very important feature of oracle databases. Compared with the function of retrieving historical versions of table data through undo and executing logical error recovery,