Database Administrator

Analysis of ORA-04030 in alert logs Yesterday I went to a customer to do inspection, encountered a classic ora-04030 error, alert Log is as follows: Tue Oct 28 09:57:46 2014Errors in

Mysql kernel: nf_conntrack version 0.5.0 When I want to check the mysql database today, the messages log contains a large number of mysql kernel: nf_conntrack version 0.5.0 connection information. Now I will record the solution and hope to help

How to solve Chinese garbled MySQL installation in CentOS 6.5 No matter whether it is Linux or Windows, new users may encounter Chinese characters and garbled characters After MySQL service is installed. Today I installed CentOS 6.5 and encountered

Solution for importing SQL files from MySQL is too large or connection timeout Some time ago, when I was on a business trip for development at the site, there was always a problem importing MySQL databases. Finally, we found a magic SQL statement

Oracle Index instance description-Basics An Oracle Index is an object in a relational database used to store each record location in a table. It aims to speed up Data Reading and integrity checks. Indexing is a highly technical task. Generally, we

New Feature of RavenDB 3.0: Index backend RavenDB indexing is definitely not a simple storage of key/value, and its functions are much more powerful. Just like other features of version 3.0, It is the crystallization of sweat and wisdom. This

Incremental Backup solves the log GAP in the DataGuard Database Sometimes the standby database lags behind the primary database for a long time, and the archive log of the primary database does not exist. How can we eliminate the log interval at

Execute MySQL statements in Shell scripts For automated O & M, such as backup and recovery, DBA often needs to encapsulate SQL statements into shell scripts. This article describes several methods for calling SQL statements in a MySQL database in a

An example of solution to system downtime caused by full archiving logs of Oracle databases When the first downtime occurs, the system memory overflows. Therefore, the application server is restarted and an error is reported when the application

Relational database integrity 1. Relationship: D1 × D2 ×... * The subset of Dn is called in the domain D1, D2 ,... The relationship on the Dn, expressed as R (D1, D2 ,... Dn), R indicates the name of the link, and n indicates the link ContentsOr

Mysql advanced master-slave replication, mysql master-slave Master-slave replication is more than multiple servers !, One change changes the other, and the content is actually the same! Principle: Operations on the database will generate a file,

[MongoDB] From getting started to mastering the mongdb series learning book, if you want to learn mongodb, please come in, mongdbmongodb I have been studying MongoDB for some time and have compiled more than 40 blogs. Download the mongodb software

How to: How to import UUID function into Postgre 9.3, uuidpostgre 1. Open a command console and go to the directory where you installed Postgre server. E.g. D: \ Program Files \ PostgreSQL \ 9.3 \ bin> 2. Drill down into BIN folder and issue

The definitions of SERVICE_NAME and SERVICE_NAMES and GLOBAL_DBNAME, globaldbnameSERVICE_NAME parameter value in the tnsnames. ora file -- this parameter has different values for Dynamic Registration and static registration.For Dynamic

Configure ORACLE 11g adg and oracle11gadg I installed 10 Gbit/s in the past without taking notes. I used the duplicate method to install an 11 Gbit/s ADG yesterday. The process was hard and I recorded the following:   I. Environment

EXtremeDB, extremedb Open Source The customers got the shared memory 80 error on AIX environment; utility truss is used to track the debug info, eXtremeDB. registry access error is found. release notesdescribed as follows: These names are

Basic Hibernate ing and hibernate ing Before talking about Hibernate ing, let's first take a look at object link ORM ing ORM. The implementation idea of ORM is to map the data of tables in relational databases into objects and present them as

CentOS 6.5 install MongoDB 2.6 (multiple yum data sources) and centosmongodbNext we will install the latest MongoDB 2.6.5 on CentOS 6.5 x64. There are a total of five packages in the MongoDB v2.6.5 software warehouse:1) mongodb-org This package is a

Mysql addition Error For example, add a user Insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234 ")); Error: ERROR 1364 (HY000): Field 'ssl _ cipher 'doesn' t have a default value ERROR For MySQL 5.6

Use JDBC to change the session parameter NLS_DATE_FORMAT and oraclenlslang of Oracle Except for one problem recently, this is probably the case. The project is developed abroad and a large number of Oracle functions TO_DATE are used in the project