Database Administrator

Install MySQL 5.6.15 in Linux This article briefly explains how to install MySQL 5.6.15 in Linux. 1. Download MySQL 5.6Download Page: http://dev.mysql.com/downloads/mysql/Select "Red Hat Enterprise Linux 6/Oracle Linux 6 (x86, 32-bit), RPM Bundle"

Oracle SQL statement tracking 1. SQL statement tracking The execution of SQL statements must be performed on the Oracle server. The Oracle server detects and records all SQL statements executed by the access process. The commands used below are all

ORA-12545: the connection failed because the target host or object does not exist 1. Problem Description In the Windows XP system, the AX1 application and the upgraded version of AX2 are installed at the same time to connect to the same connection

Oracle DBMS_RANDOM package details DBMS_RANDOM is a PL/SQL package provided by Oracle to generate random data and characters. It has the following functions. Among them, the initialize, random, and terminate functions are not recommended in

Oracle EM 12C monitoring MySQL [Preface] Oracle EM 12C itself does not provide MySQL monitoring. The plug-in can be used to monitor the database on EM 12C. Pythian Group developed the corresponding plug-ins, by installing this plug-in, you can

An error occurred while using create pfile form spfile In the RAC environment. I. Problem Solving 1. Check the parameter records in the normal RAC. Node spfile location SQL> show parameter pfile NAME TYPE VALUE ---------------------------------------

Common Oracle commands in Linux Common Oracle commands in Linux 1. Start the oracle database: // Switch to an Oracle user: [Root @ server36 ~] # Su-oracle // Enter the sqlplus environment. The nolog parameter indicates no Logon: [Oracle @ server36 ~]

Functions of standby redo log We all know that dataguard has three data protection modes: maximum protection mode, maximum available mode, and maximum performance mode.In the maximum protection mode, standby redo log must be used in the highest

Oracle filling tables with random data A script from AskTom can also fill in random data for a table. Create or replaceProcedure gen_data (p_tname in varchar2, p_records in number)-- This routine is designed to be installed ONCE pre database, hence--

ORA-01727 view authorization with grant option ORA-01720: grant option does not exist for 'Scott. lock1'This problem occurs when a view is granted to another user, and the view references the table under the third user. For example:I have three

Use Oracle PROFILE to control session idle time The following is an example of how the customer wants to control the idle time of a session.Microsoft Windows [version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved. C: \ Users

The corresponding index cannot be deleted when the primary key is deleted. drop constraint -- The index is not deleted when a table primary key is deleted. If the primary key index is created with the primary key constraint,The index is

Oracle Outline usage I. Overview Oracle Outline, also known as the storage Outline in Chinese, is the earliest mechanism to control SQL Execution plans based on prompts. It is also the only tool in 9i and earlier versions that can be used to

Specific SQL processing procedures in Oracle Shows the general phases of SQL processing in Oracle: parsing, optimization, generation of row sources and execution. The database may ignore some steps, depending on the specific statements. 1. SQL

MySQL study note _ 3_MySQL create a data table (medium) and study note _ 3_mysqlCreating a data table in MySQL 3. Data field attributes 1. unsigned [unsigned] Space can be doubled, for example,-128 ~ 127 increase to 0 ~ 255 Note: Only numeric fields

SP2-0678: Column or attribute type can not be displayed by SQL * Plus, sp2-0678displayedIn Oracle10g and earlier versions of sqlplus, blob or bfile data cannot be directly displayed:SQL> create table t (B blob );Table created.SQL> insert into t

MySQL study note _ 4_MySQL create a data table (below) and study note _ 4_mysqlCreating multiple MySQL Data Tables (below) V. Data Table types and storage locations 1. Unlike most databases, MySQL has a storage engine concept. MySQL can select

MongDB start WARNING: soft rlimits too low, mongdbrlimits # MongoMongoDB shell version: 3.0.2Connecting to: testServer has startup warnings:T12: 34: 19.688-0700 I CONTROL [initandlisten]T12: 34: 19.688-0700 I CONTROL [initandlisten] ** WARNING: soft

Prerequisites for changing a Windows database server to a Linux Database Server The prerequisite is: Please contact the application software developer and O & M personnel for confirmation: First, whether the Window database server has an

Use dbcp to configure the data source and dbcp Data Source1. Configure the dbcp data source requires two jar packages, commons-dbcp-x.x.x.jar and commons-pool.x.x.x.jar, the version difference is not very big, of course also need database driver2.