Database Administrator

Create and set a MySQL user through the command line in Linux Q: I want to create a new user account on the MySQL server and grant it appropriate permissions and resource restrictions. How can I create and set a MySQL user through command line? To

"Panic" caused by redo logs when RMAN_RAC is restored to a single machine" I. Summary In fact, this problem was caused by negligence. Previously, RAC was used to recover data from a single machine. The production environment was not involved. At

Quickly deploy an Oracle RAC environment using an Oracle VM Template Oracle VM templates are pre-packaged and pre-configured virtual machines. In the communication between enterprise-level customers, I often use "simple, fast, and error-free" to

Enable Oracle NUMA support in Oracle 11gR2 Enable Oracle NUMA support in Oracle db 11gR2 Reference Original:Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID 864633.1)Applicable:Oracle Database-Enterprise Edition-Version 11.2.0

When creating an instance in Oracle 11gR2 RAC, the following configuration types are selected: Admin-Managed and Policy-Managed: The official website documents are explained as follows: 6.1 Understanding ServerPools Server pools arelogical

I installed Oracle 11g on SUSE Enterprise Linux 11 Enterprise Edition. This is already very rare. I remember that 10 years ago, if you could install Oracle on Linux, it would be awesome. Now it is much simpler to install Oracle in linux than before,

Control files are used to record and maintain databases. When the database is restored, the server process and background process need to read various backup-related information from the control file. If the control file is corrupted, the backup

Database migration can be seen as a special software development project. Different from other development projects, the requirements of this project are fixed, and the technical barriers are low. The main task is coding and testing. For database

Tools used: FineReport report designer, Access Database Requirement Description: There are two tables, order table and order list 1. Order table structure: 2. Order schedule structure: Objective: To create the following table based on the two

XML query in SQL SERVER: FOR XML specifies AUTO Preface In SQL SERVER, you can specify RAW, AUTO, EXPLICIT, and PATH for XML queries. This article uses some examples to introduce the XML query of AUTO in SQL SERVER. Basic example Section 1: With

The earthdistance () function in postgreSQL is used in the project to calculate the distance between two points on the earth. There is too little Chinese information. I found a good English article, hope to help those who will use earthdistance in

Case statements and case expressions are an important part of plsql Process Control. Although they are easy to use, they are easy to confuse. This article describes the case statement and case expression, and provides a demonstration to better

TNS-12532: TNS: invalid argument, Oracle error messages too speechlessSymptom:Tnsping error:[Oracle @ unicomGZ01 admin] $.../../bin/tnsping orclTNS Ping Utility for Linux: Version 11.1.0.6.0-Production on 16-MAY-2013 15:27:00Copyright (c) 1997,200 7,

Path to mathematics-sas memo (17), path to mathematics-sas memo 17SAS Date and Time FormatData _ null _;Input mydate YYMMDD10 .;Put mydate YYMMDDB10 .;Put mydate YYMMDDC10 .;Put mydate YYMMDDD10 .;Put mydate YYMMDDN8 .;Put mydate YYMMDDP10 .;Put

Migration of login accounts and database users in SQL Server, SQL Server 1. Create a login name for SQL Server Authentication and map it to the database. For example, if you create a user [kk] To map to the database [mytest], the database [mytest]

Redis Research (15th)-task queue, redis research task queue During website development, page rendering will be blocked when pages require long-time operations such as sending emails and complex data operations. To prevent users from waiting too long,

Oracle special character escape: & and ', oracle special character escapeWhen we run the SQL show all command in SQL * PLUS, we can find a parameter: define & (hex 26), as shown below:Concat. (hex 2e)Copycommit 0Copytypecheck ONDefine & (hex

Mysql5.5 master-slave synchronous replication configuration, mysql5.5 master-slave Synchronization In the previous article "mud: learning the principles of mysql database master-slave synchronous replication", we introduced the basic principles of

How vacuum template0, vacuumtemplate0 [Pg @ h1 ~] $ Vacuumdb -- freeze template0vacuumdb: cocould not connect to database template0: FATAL: database "template0" is not currently accepting connections [pg @ h1 ~] $ Psql template0psql: FATAL:

[MongoDB] Build a mongodb sharding cluster on the windows platform (2). mongodb Cluster In the previous blog, we talked about the main principles of Mongodb sharding clusters. In this blog, we will mainly describe how to build a sharded cluster.