Database Administrator

Analysis of PostgreSQL pg_cmd.conf File I recently tried PostgreSQL 9.04 and shared my experiences with pg_mirror.conf configuration. Pg_cmd.conf is the configuration file for client authentication, which defines how to authenticate the client. The

MariaDB: Selective binary log event As the first article on MariaDB's series of interesting features, we started from selectively skipping the replication of binlog events. MariaDB 5.5 and 10 support this feature. By default, when the MySQL standard

Query errors caused by corrupted MongoDB index files Problem description: When MongoDB is disabled abnormally, the index file may be damaged, and the data is not reflected in the index when the data is updated. Solution: Use scripts to recreate

Redhat 6 Oracle 11g RAC Installation notes I recently installed 11g RAC on RedHat 6. I have encountered several precautions to share with you: Install Oracle 11gR2 (x64) in CentOS 6.4) Steps for installing Oracle 11gR2 in vmwarevm Install Oracle 11g

Solution to Oracle TNS-12535: TNS: Operation timeout System Environment: OEL6.5 _ x86 Database Version: Oracle 11g 11.2.0.3.0 Client environment: Windows 7 flagship edition x86_64 I. [fault symptom] After the "Oracle Client" is installed on the

Oracle 9i reported ORA-01036: Invalid variable name/Number The The problem is the variable name. SQL method: @ username I use the Oracle database in the following way: username Just change to Oracle. Public StringInsertUser (UsersUser) { //

Use shell scripts to view database load In normal times, you may feel confused when viewing database problems. If no one gives feedback on the problem, you will not take the initiative to find the problem direction. awr, ash searches for relevant

Common Oracle ASM commandsIn the Oracle RAC environment, run asmcmd with the grid account to enter the asm command mode, for example: [Grid @ oradb-node1 ~] $ Asmcmd ASMCMD>   ASMCMD> du // display all disk space occupied by the ASM file in the

How to solve ORA-12170 TNS connection timeout Recently, when I suddenly connected to the local Oracle database through plsql for a while, I reported that the ORA-12170 TNS connection timed out! The phenomenon is that the network is not connected

DB2 SQL0902C solution instance On Sunday, when the development environment archives and deletes the database, after the database is restarted, the database cannot be opened, and the database will be restored in the future because it is the

DML operation DDL trigger Today, the application side told me that a DML operation caused the database to report an error, said "ORA-234567, do not allow development to execute DDL operations, please contact DBA" To ensure security, DBAs create

Why not record slow queries ?, Slow recording(I) Background:At on May 18, I received a message from the front-end about player disconnection. I checked the CPU, slow query, and DB Request volume. No exception was found. The DB performance was as

Oracle11 tablespace dbf File migration, oracle11dbf When the disk space of the oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2.

Mysql Data truncated for column, mysqltruncated 1. Describe your problems first. If you want to remove the flag that allows null values... It happens that the data processed_f in the database is null and there is no value .... When you

Install and uninstall EM12C.Version: em12c 12.1.0.4 OS: redhat 5.7 x86_64bit (CentOS6.2, tested. At that time, due to glibc *. i686 package installation error, I gave up)==> After em12c is installed, you can skip this step. You can click here on the

Removing temporary table empty ora-25152 error, removing ora-25152 Error Deleting a temporary tablespace or shrinking a temporary tablespace often results in table space occupation. Next we will handle this situation, First, find the locked

Custom function programming in mysql and mysql Syntax: New: Create function function_name (parameter list) returns Return Value Type Function body Function name, which must be a valid identifier and should not conflict with an existing keyword. A

MySQL inserts the data queried in Table a into Table B. mysql MySQL inserts the data queried in Table a into Table B. If table B exists insert into b select * from a; If table B does not exist create table b as select * from a; Extension: Insert

Implement a micro-database and a micro-Database Write a simple database by yourself,PrincipleThere are the following points: 1. Data is saved as text Write the data to be saved to a text file, which is a database. For easy reading, data must be

[Translated from mos] relationship between oracle linux and external storage systems, mosoracle Relationship between oracle linux and External Storage Systems Reference Original:Oracle Linux and External Storage Systems (Doc ID