Database Administrator

Oracle manually switches log files and clears log files Oracle switch log file groupLog File groups are used cyclically. When a group of log files is full, the Oracle system automatically switches to the next group of log files. When necessary, the

Why MySQL cannot log on locally after a user is created After installing MySQL, we usually add common users with corresponding permissions to access the database. When you log on to the database locally, you can log on from other mysql

Oracle reported EXP-0006: internal inconsistency Error When the system was deployed at the electronic Institute in March October, the export and import of the Oracle database were successful using the exp and imp export database commands, I have

MySQL can be connected locally, and the remote connection fails. I have encountered the problem that MySQL can be connected locally but cannot be connected remotely. I have not recorded the problem. I encountered this problem on the new server

MHA configuration file sample description, Similar to most Linux applications, the correct use of MHA depends on a reasonable configuration file. MHA configuration file and mysql my. the cnf file configuration is similar. The configuration file is

PL/SQL _ Developer _ the export tool is not recognized. pldeveloper Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally

The restoration of RAC when the OCR disk is faulty and there is a backup, racocr Problem description: CRS startup failed, and all RAC processes quit. View the messages log: ...... Apr 10 15:58:31 node74 logger: Cluster Ready Services waiting on

Impdp experience ORA-39029, ORA-31671, ORA-06512, impdpora-39029[Oracle @ rac1 ~] $ Impdp \ '/as sysdba \' directory = expdp dumpfile = wxlun0402.dmp logfile = wxlun0402.impdplog REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun:

Install mysql in linux [practice edition] And linuxmysql practice Edition [Environment and file version] Red hat linux v6.2 Mysql linux x86-x64 v5.6 [Prepare required files] First, go to the official website to download the linux version of mysql.

Mysql transaction processing and mysql transaction Transaction processing is widely used in various management systems. For example, in the personnel management system, many synchronous database operations require transaction processing. For example,

Let's talk about FoundationDB and foundationFoundationDB Apple acquired FoundationDB1, and the latter immediately changed from open source to closed source. To be honest, I have never noticed such a DBMS product 2 before. From the official website,

A tablespace after offline alert Log reports ORA-01135 and ORA-01110 problems, ora-01135ora-01110 This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44336789 In a recent case,

How to start the Oracle Database Service and oracle Database in Windows Sometimes we may encounter database connection failures. Of course, there are many reasons for this problem, one of which is because the database service is not started. The

Oracle XE installation and oraclexe InstallationI. unmount the original databaseThe database uninstallation is not much said. Let's talk about the process: 1. Execute Oracle Uninstall, uninstall Oracle product 2, delete all Oracle related items

Modify tablespaces (modify the automatic scalability of data files) and Data scalabilityModify tablespaces (modify the automatic scalability of data files)When creating a tablespace, you can set the automatic scalability of the data file. When a new

Mysql partition and instance demonstration, mysql partition instance demonstration I. Why partition? Requirement: big data. Solution: divide and conquer. Divides large tables and large indexes into a smaller operation unit. In mysql,

Query the number of fields (columns) in a table in Oracle. If a table contains many fields and we want to know the number of fields in the table, it is very troublesome to use the following method to calculate the number one by one. The

Why should a riak cluster have at least five nodes and five riak clusters? Link: http://blog.csdn.net/ddjohn/article/details/43523983 First, ensure that you have correctly installed riak. When you use Riak Fast Track to quickly create three nodes

Oracle Advanced query over (partition by...), advanced query .. To facilitate learning and testing, all examples are created under Scott, an Oracle user. create table EMP(  empno    NUMBER(4) not null,  ename    VARCHAR2(10),  job      VARCHAR2(9),

Five tips to easily collect SQL Server Data Sometimes you want SQL Server to return an aggregation result set, rather than a detailed result set. The GROUPBY clause of SQL Server provides a way to aggregate SQL Server data. The group by clause