Database Administrator

In general, CentOS has installed the libevent binary library by default, but no header file for development is installed.Therefore, you can use the following command to install: Yum install libevent-devel Next, you can download the latest memcached

1. Install the rpm package Nano/v. sh Copy the following content #! /Bin/bash Rpm-Uvh compat-db-4.2.52-5.1.i386.rpm Rpm-Uvh compat-libstdc ++-33-3.2.3-61.i386.rpm Rpm-Uvh make-3.81-3.el5.i386.rpm Rpm-Uvh setarch-2.0-1.1.i386.rpm Rpm-Uvh libgomp-4.4.0

With the release of MySQL 5.5, Oracle began to promote the Web application function of this open source database, while its Oracle database is mainly for enterprise-level applications. Monica Kumar, Senior Manager of Oracle product marketing

Refer to the official Oracle documentation to install oracle 10 GB on Linux systems to meet the following requirements:System KernelRequired kernel version: 2.4.9-e.25 (or later)Run the following command to check the kernel version:Uname-rRequired

1. OracleThe role of Package:   It can simplify application design, improve application performance, hide information, and overload subprograms. 2. Functions in ORACLE, Package, packageThe differences between bodies and procedure are the

During routine DB2 maintenance, transaction log full is a common problem, and the usage of log space is also a matter of great importance. How can we view the log space usage?In fact, we mentioned archive settings yesterday. We know that DB2 has

Use of Oracle Flashback table Oracle ensures that recyclebin is enabled SQL> show parameter recyclebin NAME TYPE VALUE-----------------------------------------------------------------------------Recyclebin string ON creates a table SQL> create table

1. Download MySQL 5.6Download Page: http://dev.mysql.com/downloads/mysql/this option is selected using Red Hat Enterprise Linux 6/Oracle Linux 6 (x86, 32-bit), RPM Bundle. Download to/root/Downloads "2. decompress the tar package

Phenomenon: Customer GG do extract report error OGG-00053OGG-00053: No extraction maps specifiedCause: There are no TABLE parameters in the Extract parameter file to specifySource tables for which to capture data.Action: Add one or more TABLE

This experiment simulates the restoration of log files in non-archive mode with no backup conditions.All the redo logs here are deleted. The following error and database mode are reported:SQL> startupORACLE instance started.Total System Global Area 8

Java JDBC uses the configuration file to connect to the database: Create a file with the suffix ". properties". The file content includes: Database driver, connected database address, user name, password ......Take Mysql as an example to create the

Recently, I contacted the monitoring platform Zenoss, which involves the Oracle plug-in ZenPacks. community. OracleMon. To use this plug-in, you must install Python cx_Oracle. Next, let's talk about how to install it. 1. software packages involved 1.

Several important parameters in Oracle 11g RAC Par num describ ------------------------------------------------------------------------- _ Lm_lms 2Number of background gcs server processes to start _ Lm_lms_waittime 3Default wait time for lms in

Because Oracle 11gr1 needs to be installed on RHEL5.5 for testing, there are many problems, first sort out the following and search a lot online Reference connection, oracle documentation:

I. backgroundToday, I received a development call saying that Oracle cannot be remotely connected. It may be that archivelog is full. I tried logging on to Oracle and promptedORA-00257: archiver error. Connect internal only, until freed.Considering

Recently, a large BI Project was implemented. The KPI indicator data was stored on a monthly basis, but the user requested to perform a daily calculation and replace the calculation results of the previous day until the end of the month. The Oracle

The day before yesterday, the deployment and implementation company xx production center entered a set of DG databases, but before that, one of the primary was a test machine before I N. I remember that I installed version 11.2g 03 in the form of

DBMS_ERRLOG provides a stored procedure CREATE_ERROR_LOG, which creates an error log table. When a DML error occurs, the operation will not terminate or roll back, but related errors will be written to the error log table. CREATE_ERROR_LOG does not

In the morning, you receive an alert email from a Linux server disk and an email from the monitoring Alert Log program. After the check, it is found that there is no space for a partition in the Linux server. The main reason is that the programmer

A foreground SQL statement is simplified as follows:SELECT products_name, products_viewed FROM 'products _ description'Order by products_viewed DESC, products_name LIMIT 0, 20; This statement often appears in large batches in slow logs! A