Database Administrator

Use Sqoop to import MySQL Data to Hadoop The installation and configuration of Hadoop will not be discussed here.Sqoop installation is also very simple. After Sqoop is installed and used, you can test whether it can be connected to mysql (Note: The

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

Oracle Active Data Guard adjustment case [2] The customer's Oracle 11gR2 Active Data Guard environment, the master database's standby_file_management = AUTO, the Standby database's standby_file_management = MANUAL, resulting in the Data file

Configure the MySQL server for Master-master Replication StatementAuthor: Last Night starsBlog: http://yestreenstars.blog.51cto.com/This article was created by myself. If you need to reprint it, please indicate the source. Thank you for your

7. mysql-cluster and mysql-cluster This article describes how to install Mysql-Cluster. First, let's take a look at the following: (linux User, debian myself) MySQL Cluster is a technology that allows you to deploy the "in memory" Database Cluster

ORA-31693, ORA-02354 and ORA-01555 with Export Datapump (Doc ID 1580798.1), ora-31693datapump The following error is returned from the development email: ORA-31693: Table data object "YCDATA ". "T_MESSAGESYNC_HIS" failed to load/unload and is being

Huge pages Series 3, hugepages Series Use the following shell script to calculate the large page configuration parameters. Make sure that the data instance has been started before using the script, If the database version is 11 GB, check whether

Multiple SQL tables query and computing statistics code based on ACCESS and ASP, accesssql Recently, I am writing a few management systems about "Project-Subitem-Task", saying that the system is a bit exaggerated. It is basically a multi-Table query

Use of mysql monitor MONyog and mysql monitor monyog MONyog is a commercial paid software, but you can find the cracked version. I use the 4.72 cracked version. 1. Fig 1.1 In the server settings, 1.1. Enable sniffing in Sniffer Settings? Select

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

Mysql cursor example mysql cursor simple tutorial, mysql cursor example tutorial From mysql V5.5, a major change was made, that is, InnoDB was used as the default storage engine. InnoDB supports transactions and has the relevant RDBMS features:

ORACLE 11G from scratch-20141208, 11g-20141208 Section 1.3.6 It is used to store all the data of an object with an independent storage structure defined in a tablespace. It consists of one or more zones. 1. Data Segment Used to store all data in

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

ORA-00600 [kqlInvObj: user] processing, ora-00600kqlinvobj Today, our brother called us to say that after I installed 11.2.0.1.0 on the Development Database (win7 64bit), I had a problem with the Data Pump derivative, which was hard to solve. Then I

JDBC data source and connection pool, jdbcJDBC data source and Connection PoolThe database connection pool is used to create enough database connection pools when the application starts.A free connection can be obtained through the data source when

XMPP protocol for instant messaging underlying writing (2) -- IOS XMPPFramework Demo + analysis, xmppxmppframework I hope This is a new day! Before reading the code, I think you should first sort out your mood and let me say a few words: First, I

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

About file # In v $ datafile and v $ tempfile #, The v $ datafile view stores information about data files, and the v $ tempfile view stores information about temporary files. There are file # Fields in both views. Let's take a look at the

Install oracle software using NFS and nfsoracle Software Yesterday, I used openfiler to create a nas storage system and install the oracle software. Everything went well before that. A ora error was reported when I created a database. When I used

How to Restore Archive logs from a backup set in oracle How Does oracle capture archived logs from the backup set? In Dalian Hospital, the database is archived. However, after archiving, rman uses crontab to automatically archive the logs and delete