Database Administrator

1. Install cmakeMySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and configuration method.Therefore, we must first compile and install the cmake tool in the system source code. # Wgethttp: //

A transient network disconnection causes the dpe process ABENDING of ogg. view the dpe Process report. 2013-09-2422: 19: 51errogg-01031thereisaprobleminnetworkcommunication, aremotefileproblem, encryptionkeysfortargetandsourcedonotmatch

-- ====================================== -- Oracle Hot Backup -- ====================================== Oracle Hot Backup refers to a series of backup operations on database data files, control files, parameter files, and password files when the

I. Management of ASM files 1. ASM file Overview: The names of ASM files are different from those of common files. The names of their files are not directly specified. And the management method is OMF. If specified, the file management method is no

Recently, the Hive Query Platform has many considerations. One of them is to limit the user's query volume for partition tables, mainly because you must specify the partition key. at the beginning, the idea step was to do HQL parsing. However, due

I ran a Hive query yesterday and found that the number of started maps is much larger than expected. It is strange that the query can be simply abstracted as follows: For example, there is a table t partition key dt string; query select count (*)

① ASM file conversion Take the created asmtest tablespace as an example. (I) convert OS files to ASM files Sys @ ORCL> create tablespace asmtest datafile size 10 m; Tablespace created. Sys @ ORCL> alter tablespace asmtest offline; Tablespace

[Oracle @ localhost ~] $ Asmcmd help = y Commands: -------- Cd Du Find Help Ls Lsct Lsdg Mkalias Mkdir Pwd Rm Rmalias ① List Directory Information ASMCMD> ls DATA/ ASMCMD> ls-al State Type Rebal Unbal Name Mounted normal n data/ ② Alias ASMCMD>

(I) striping There are two ways to strip ASM: coarse and fine-gained. AU is the smallest space allocation unit. The default value is 1 M. Each AU is composed of eight K strip spaces by default. In coarse striping, a disk corresponds to an

Mysql-uroot-p Enter the password. An error occurred! ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YSE) Leave the password Blank Or error! ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using

Step 1: Download from http://www.mongodb.org/downloads Step 2: Decompress the downloaded file to a location on the disk and copy its bin path, for example, H: \ DevelopmentTools \ mongodb2.4.6 \ bin. And add Step 3: Create a configuration file

Problem background:To facilitate troubleshooting and reduce the log file size, you need to poll slow query logs and error logs by day. Round Robin script/data/scripts/mysql-log-rotate ): "/data/dbdata/otherlog/slow_query.log" "/data/dbdata/otherlog/

I. Index Analysis According to the description in the ORACLE document, rebuild the index as follows: 1. analyze index your_index_name validate structure; 2. query index fragmentation: Select name, del_lf_rows, lf_rows, round (del_lf_rows/(lf_rows + 0

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/2026294J6-0.jpg "title =" QQ20130926180734.jpg "alt =" 171749773.jpg"/> The customer has a set of 10 Gbit/s RAC running on Windows and plans to add a dedicated uard. The

With my hand-written installation experience, the Oracle Installation process is really amazing, and it completely makes me enter the secondary element. How is it more difficult than installing Mac on a PC? But the first installation is inevitable,

Job functions:Database Engineer/Administrator Job description:Requirements:1. Familiar with Oracle 10g and 11g database features, more than 3 years of database experience2. Have a deep understanding of Oracle technical architecture, be

E @ host10g ~] $ Netca OracleNetServicesConfiguration:Xlib: connectionto ": 0.0" refusedbyserverXlib: Noprotocolspecified Java. lang. NullPointerExceptionAtoracle. ewt. lwAWT. BufferedApplet. (UnknownSource)Atoracle.net. ca. NetCA. (UnknownSource)

1. oracle only provides cascading deletion when creating tables, and sqlserver provides cascading deletion and update. Although the primary key value of the primary table cannot be modified frequently after the primary-foreign key relationship is

1. An error is reported when the database is started. [Oracle @ servers ~] $ Rlwrap sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Sunday October 6 17:14:35 2013 Copyright (c) 1982,200 5, Oracle. All rights reserved. Already

#! /Bin/bash# Writed by sery 2012-05-16 ################################### ####### install depending packages ############################## ########### yum-y install binutils compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc