Database Administrator

ORA-21561, ORA-15055, ORA-25253 causes the DG slave database to be unable to apply ArchiveYesterday I went to a customer to do inspection, by the way, to see whether the last build of the RAC-DG environment is normal, the last DG was run in August 20

MySQL user and permission management The main function of the MySQL permission system is to verify the user connected to a given host and grant the user the related DML and DQL permissions on the database. MySQL access control involves two phases:

ORA-28001: the password has expired Oracle prompt error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle11G User Creation is 180 days (6 months ), if the user password

Install MySQL WorkBench in CentOS 7 Install MySQL WorkBench in CentOS 7 Install MySQL Community Yum Source Wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm Rpm-Uvh mysql-community-release-el7-5.noarch.rpm 2. Install

Oracle parameter file Introduction After the Oracle database is started, you can use the select * from v $ parameter statement to view all the parameters used by the Oracle database. Oracle parameter files are divided into spfile binary files and

When sqlplus is started, it searches for and loads two files: login. SQL and glogin. SQL. Environment Settings after sqlplus is startedSqlplus searches for and loads two files: login. SQL and glogin. SQL.The glogin. SQL file is stored in the $

One Oracle instance is bound to multiple services Background: In the early stage of the project, two instances were created on one server, and two connections were configured on the client. Now, you need to integrate the two instances into one of

Lock (lower), lock ( (2) Unlock MethodAlter system kill session '2010 3';/* 878,177 is SID, 878 is SERIAL #*/ Select/* + rule */s. username,Decode (l. type, 'Tm ', 'table lock', 'tx', 'row lock', null) lock_level,O. owner, o. object_name, o.

Install 11g_rac configuration equivalence, 11g_rac Configuration Brief Introduction to oracle 11gssh equivalence configuration on linux   Configure the grid user trust relationship Perform the following operations on the login, rac1, and rac2: $

JPA 2.0 lock mechanism and jpa2.0 Lock Mechanism A lock is a technique used to process database transaction concurrency. When two or more database transactions concurrently access the same data, the lock ensures that only one transaction can modify

Batch create log table information scripts in mysql, mysql logs In mysql, the script for creating log information tables in batches through the stored procedure is as follows: drop PROCEDURE if EXISTS reqSp;DELIMITER //create procedure reqSp(sTime

Table schema designer (EZDML) version 1.98 released, ezdml1.98The Zookeeper table structure designer (EZDML) is a free small software for table creation in databases. It allows you to quickly design database table structures and build data models,

Expdp export multi-path and expdp export pathI. Preface:Some users do not use RMAN for Backup recovery because the DBA level is not too high, training RMAN for on-site engineers or users will lead to additional expenses and unnecessary troubles.

SQL hierarchical summary and SQL Classification -- Test Data create table tb ([DB-ID] varchar (10), ENTITY varchar (10), DATE varchar (10), [CUST-NO] int, AMOUNT decimal ), TAX decimal (2004) insert tb select 'rchq', '001', '2017-11-10 ', 200000,100.

The 15th tip of DB Query Analyzer,   The 15th tip of DB Query Analyzer ----SQL Execute Schedule function is realized in 6.01 Ma Genfeng (Guangdong Unitoll Services ininitialized ated, Guangzhou 510300)   AbstractThe latest version of DB Query

SQL exists, in, sqlexistsinTips:1. When the External table is a large table and the inner table is a small table, use exist2. When the External table is a small table and the internal table is a large table, the inExample: The External table is

Redis source code analysis (17) --- multi transaction operation, redismulti As a non-relational database, redis has the same transaction operations with RDBMS, which surprised me. A dedicated file in redis is used to perform transaction-related

Basic mysql knowledge ReviewCreate a databaseCreat table test (# An integer usually uses an int.Test_id int,# Decimal is usually used for decimals.Test_price decimal,# Common text is usually used and Default is used to specify the Default

Database backup and recovery, database backup and recoveryBackup and recovery of databases 1. Open SQL Server Management Studio → Database: practice_20.gl is the database we need to back up.2. Right-click the database to be backed up.3. Click

[SQL] Introduction to triggers-Special stored procedures and SQL triggers A trigger is a special type of stored procedure that automatically takes effect when data in a specified table changes. The difference between a trigger and a common stored