Database Administrator

When creating tablespaces and files, whether the directory exists and whether the space is satisfied is a concern. To ensure the consistency of system data storage policies and avoid large rework actions, this process must be considered. In many

In this tutorial, we will create a MongoDB cluster with three nodes. The first node is the master node, the second node is the Failover node, and the third node is the arbitration node. 1. Install Mongo and set the configuration file Install three

This DB2 script is very good. When exporting data, you just need to add the table name. In fact, you can refer to the same method for import or load data: #! /Usr/bin/sh Db2 connect to webList ="DB2INST1. ACCESS_IDDB2INST1. ACCESS_ID_HISTDB2INST1.

Lab requirements: 1. Configure two MySQL servers (192.168.100.2, 192.168.100.3) and one proxy server (192.168.100.1) to implement read/write splitting of the MySQL proxy. 2. You only need to access the MySQL proxy server. The actual SQL query and

At work today, my colleagues mentioned how to obtain the space occupied by the LOB in a table. We usually use syscat. tables queries information such as fpages and npages In the table, but this does not separate the common field from the LOB field.

Lab requirement: Build a mysql Graphics Management Tool on the server Linux: CentOS 6.5 1. Simple deployment of LAMP Platform # Yum-y install httpd mysql-server php-mysql php-pdo # Rpm-ivh php-mbstring-5.3.3-26.el6.x86_64.rpm // this package is not

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

Database is 10.2.0.4 operating system is aix, when executing expdp export multiple scheme objects times ORA-39014, ORA-39029, ORA-31671, ORA-39079, ORA-06512, ORA-04031: error message is as follows:Export: Release 10.2.0.4.0-64bit Production on

Prerequisites: The RMAN backup was performed before the loss, and the full database The control file, archiving, and online log files are intact. SYS @ PROD> conn amy/amy Connected. AMY @ PROD> create table t_amy02 (B int );   Table created.     AMY

Objective: To set up a test environment without stopping the master database and allow non-synchronization of a small amount of data without the need for logical import and export, use rman to replicate databases on the same machine-131 the PROD

ORA-03113: The file End Process ID4781 of the communication channelView alter. logAn error occurred while prompting the online log file.I am not very familiar with the methods on the Internet. I see many errors.Ora-16038: logs cannot be archivedOra-0

Oracle has been started. After connecting to sqlplus, perform the query. the following error occurs: A ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directorySQL> shutdown

The Helper house has mentioned mysql installation many times, but these are basically installed through rmp or common binary format. This will introduce how to install mysql through source code. MySQL authoritative guide (original book version 2nd)

My php environment is WAMP, which has been configured and used for a while. Yesterday I saw an article about setting a password under the permission in phpMyAdmin. I changed the original NO passwor (default) to 1234 with the permission, click the

I/o throughput is a factor that affects data redo. Oracle media recovery depends on I/o. If I/o has a bottleneck, this will inevitably affect the recovery of the standby database media. I/o stack contains hbas, storage related switches, and storage

Diagnose and resolve ORA-04031 errors When we try to allocate large blocks of continuous memory in the Shared Pool, Oracle first clears all the objects currently not used in the pool to merge idle memory blocks. A ORA-04031 error occurs if the

Generally, no one modifies the dbid and dbname of Oracle unless in special cases, such as database cloning.Steps: 1. back up the database 2. start data to mount status 3. nid command modification (if you only modify the dbid, you do not need the

Question: Here are some of our Oracle backup scripts that run in the production database. They are correct! Environment: SUSE Linux 10sp2 + Oracle 11gR1 Note: Small databases generally perform full backup once a week, while large databases perform

I recently tested MySQL master-slave Database Synchronization and found some problems. The master-slave synchronization latency problem is one of them. The following describes some explanations found on the internet and records them for your own

1.1.1. ORA-19502, ORA-27072 Date: Environment: Testing Machine [Error code] $ Oerr ora 1, 19502 19502,000 00, "write error on file \" % s \ ", block number % s (block size = % s )" // * Cause: write error on output file // * Action: check the file $