Database Administrator

After mysql is installed, login finds that there are only two databases:Mysql> show databases;+ -------------------- +| Database |+ -------------------- +| Information_schema || Test |+ -------------------- +,Mysql> use mysqlERROR 1044 (42000):

Redo and Undo Redo and its Functions Undo and its Functions Relationship between Redo and Undo Submit and roll back LogMiner-based Log Analysis 11.1 Redo and its Functions 1.1.1Redo is used to restore committed transactions, so as to ensure

ORA-01031: insufficient privileges solution ################################### ############ NAME: troubleshoot connect internal.txt## DESCRIPTION:# Connect internal# Connect/as sysdbaPassword problems: # Refer (METALINK, OracleDOC ),# Metalink

# CentOS 4.7 Oracle 10.2.0.1 # Scp user @ host 10201_database_linux_x86_64.cpio/local Decompress the package to/home/oracle/database. # Cpio-ivmd ####################### # System Environment Settings ####################### 1) view the kernel

Question: today, I want to create a user for the monitoring server I2000 in the current network database, requiring the user's permissions to be consistent with the permissions of an existing user in the database! I have provided my practice here.

There are three installation methods for mysql in Linux: 1. yum/rpm 2. Source Code installation 3. Binary Installation The first installation method is not mentioned here. The upgrade method is mainly binary installation, which is very

-- Book tableCreate table book (Book_id VARCHAR2 (20 ),Book_name VARCHAR2 (100 ),Book_publish VARCHAR2 (100)); -- In indicates the input parameter. The default value is in.-- Out indicates the output parameter.Create or replace procedure sp_pro7

1. Create users and groupsGroupadd-g 700 beaUseradd-u 700-g bea-G dba weblogic-d/home/weblogicPasswd weblogic 2. Create an installation directoryMkdir-p/Oracle/product/9.2.0/bea/Chown-R weblogic: bea/oracle/product/9.2.0 3. Change the configuration

Data Block overview Oracle manages the storage space in the database data file. The unit is data block ). A data block is the smallest (logical) data unit in a database. The minimum physical storage unit of all data at the operating system level is

Stored procedures are commonly used in programs, and I often write some in projects. But I make a mistake: I always write the SQL statement process into a long string of SQL statements, run the SQL statement normally. As a result, the code is too

Some colleagues asked a few MySQL parameter settings. Here is a simple record: Innodb_thread_concurrency, used to limit the number of threads that can enter the innodb Layer When read_row/write_row/update_row/delete_row is called at the innodb layer,

The ebs form cannot export Master-slave relationship (Master Detail) data to EXCEL.The following describes how to solve the problem that the EBS standard export function cannot export master-slave relationship data. Solution: 1. Add an export button

In an External table file, if the fields in the file are separated by ctrl + F, the ctrl + F separator cannot be recognized after the Chinese characters, causing an error in External table import, the solution is to add the following content when

Restore archived logs: select * from v $ log_history t where t. THREAD # = '1'Order by t. FIRST_TIME descInstance 1: Restore an archived log:Run {Allocate channel 'dev _ 0' type 'sbt _ tape'Parms 'sbt _ LIBRARY

1) download the Linux-Generic package of Mysql5.5: http://download.softagency.net/mysql/downloads/mysql-5.5/ I download the license mysql-5.5.17-linux2.6-x86_64.tar.gz.2) Confirm that the installed mysql has been thoroughly uninstalled. For details,

I. mysql multi-character set support1. Set the mysqld service to support multiple character sets at the same timeChange the default Character Set of the mysqld service to utf8 and support the latin1, gbk, gb2312, big5, and ascii character sets.

1. Create a stored procedure1. Basic Syntax:Create procedure sp_name ()Begin.........End2. parameter transferIi. Call the Stored Procedure1. Basic Syntax: call sp_name ()Note: The stored procedure name must be enclosed in parentheses, even if the

Rollback segment Overview: Rollback segments are used to store values before data modification (including locations and values before data modification ). A transaction can use only one rollback segment to store its rollback information, while a

There are some differences between multi-master-slave mutual backup and master-slave replication, because the multi-master can have write permissions on the server, so it is designed to repeat the problem from self-growth. Problem (Multiple Primary

Several Propagation Features of transactions1. PROPAGATION_REQUIRED: if a transaction exists, the current transaction is supported. Enable if no transaction exists2. PROPAGATION_SUPPORTS: if a transaction exists, the current transaction is supported.