Database Administrator

Oracle media sorting before 10 GB Sort out the official Oracle 10g media for friends who need it. Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows

Install MongoDB 3.4 on yum in CentOS 7 Install MongoDB 3.4 on yum in CentOS 7. Step 1 check whether the yum source is configured for Mongodb Switch to the yum directory cd/etc/yum. repos. d/ View File ls The second part does not add the yum

Comparison of iOS databases: SQLite vs. Core Data vs. Realm If you want to develop a great application that can quickly run without bugs, you must carefully consider all aspects of your application. There is one thing you must solve: how to store

MongoDB import, export, backup, recovery, user authorization (4), mongodb ImportV. MongoDB import, export, backup, recovery, and user authorizationI. Data export and Data ImportAs a DBA (Administrator), you often need to import and export data. The

Network-related or instance-specific errors occur when you establish a connection with SQL Server. Just like before, I learned the video of the Niuke news publishing system, typed the code, opened the database, and displayed a frame. The details are

Data room charging system VB (1)-system analysis, charging system vb First, let's answer two questions: 1. What is the charging system for the IDC room "? 2. What should I do with the data room charging system "? My answer: 1. As the name suggests,

In the process of installing Oralce in Linux, if the Linux release version is not the recommended version of 0racle, the following error may be reported, causing the runInstaller to fail:Java code [Oracle@ LocalhostDatabase] $./runInstaller

Unable to open the connection to SQL Server, SQL Server After several days of login to the restructured version of the data room charging system, the login form was finally knocked out, and the code debugging was almost done, and the problem was in

How to Use kettle's official website to find out how to set the carte service, kettlecarte Original Works are from the "Deep Blue blog" blog. Be sure to indicate the source when reprinting. Otherwise, you have the right to pursue legal liability for

Mysql, sqlsever, oracle, redis, mongo, postgres and other database backup and recovery commands, sqlseverredis The following is a simple example of how to back up and restore each database. For more detailed parameters and configurations, refer to

Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the

Speaking of mysql, we immediately think of its small size, fast speed, and open source features, so it is widely used. Today, we will summarize the two most frequent mysql operations: insert and query, and the optimization methods. Insert: I. Text

Oracle 11g slave uard Duplicate physical standby database configuration (1) physical standby database creation Configuration# Ver: 1.5 fifth Modification# Modify: 2013.8.16# Author: koumm Read more: Configure Oracle 11g replicuard test and create a

Why percona-xtrabackup We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a

Alertsid. log error message: Fri Sep 27 15:18:39 2013Started redo scanFri Sep 27 15:18:39 2013Errors in file/oracle/admin/lixora/udump/lixora_ora_23439.trc:ORA-00314: log 2 of thread 1, expected sequence #335 doesn't match 331ORA-00312: online log 2

NUMBER (x, y) Data Types in Oracle databases, oraclenumber Test preparation Analyze and Experiment Processing of 1 decimal part 2. Maximum value that can be saved 3. Minimum value that can be saved Summary The NUMBER data type

Different Nic mtu values cause rac 2-node ASM not to start ORA-27550 at the same time: Target ID protocol check failed., mtuora-27550 After installing 10205 rac, prepare to configure asm dg and find that ASM on node 2 cannot be started: En12 is a

About Oracle Database shutdown and Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three

This article assumes that the use of informix starts from scratch, and describes the detailed steps for maximizing the use of informix from scratch. Note: The content about vi editing in this article is placed between the equal signs of two rows.

Many parameters can be selected during script generation. reasonable configuration of these parameters makes it easy for us to generate scripts as expected. Script generation options, such: Here is the SQL 2005 option, which is slightly different