Database Administrator

Solve the Problem of port occupation during Oracle Database Installation Solve the Problem of port occupation during Oracle Database Installation Configure the/etc/hosts file when creating an Oracle listener using the graphical interface Add 192.168.

MySQL multi-instance configuration details For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is used to manage multiple

How Does Oracle capture archived logs from the backup set? In the actual environment, the database is in the archive state. However, after archiving, rman automatically uses crontab to archive logs and delete the archived log files on the system.

Indirect interruption of ORA-12519 database connection Current number of connections Select count (*) from v $ process; Set the maximum number of connections (default value: 150) Select value from v $ parameter where name = 'processs '; Modify

Add, delete, modify, and query an Oracle 11g monitoring table Preface:The data in a table in the online Oracle database is a little messy. No change was found based on the application database log and Application log, therefore, we decided to

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

Install and configure a MongoDB database under CentOS 6.5 _ X64 Linux: CentOS6.5 _ X64IP Address: 192.168.1.12 Purpose:Install and configure the MongoDB DatabaseSpecific operations:1. Disable SElinux and Configure Firewall1. vi/etc/selinux/config#

GoldenGate specifies a time point to re-extract transaction changes Today's experiment demonstrates how to re-extract transactions at a specified time point in goldengate. Tutorial steps:1. Create a re-extracted SCN2. Locate the start time based on

When the Oracle tablespace is in hot backup, the instance restart error is disabled to reproduce and solve the problem.A recent database of a customer reported an error during OPEN and needed to be restored. The reason was that a TABLESPACE was

Summary of methods for detecting Oracle data block corruption 1: Use initialization parameters You can use the initialization parameter db_block_checksum \ db_block_checking to set the database's physical consistency and logical consistency check

Mysql relay log parameter Summary MySQL generates a relay log under the home Directory when performing master-slave replication or master-slave replication. This document summarizes the definitions and explanations of these parameters. 1. What is

How to compile and install the MariaDB database in Linux This article describes how to compile and install the MariaDB database in Linux. For more information, see. Note: Operating System: CentOS 5.10 32-bitMariaDB: mariadb-5.5.33aMariaDB database

Important parameter log_slave_updates for MySQL master-slave Synchronization Note: The MySQL cluster environment has been deployed recently. For details, refer to M01 and M02 for Master replication, while M01 and R01 for Master replication. The

Differences between Oracle index unusable and invisible This document is excerpted from the Oracle 11g official document: UNUSABLE Specify UNUSABLE to mark the index or index partition (s) or index subpartition (s) UNUSABLE. the space allocated for

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

DBMS_REPAIR package Usage Details Oracle provides the DBMS_REPAIR package to discover, identify, and modify Bad blocks in data files. Any tool is not omnipotent. Using this package may cause data loss, inconsistent data returned from tables and

Hibernate cannot obtain MySQL database updates in real time. hibernatemysql Hibernate has been used in recent projects, but after each database record is updated, the updated data cannot be found with hibernate. I found many tutorials on the

How to Use redis to implement distributed locks and redis to implement distributed locksIntroduction Redis, as a powerful key/value database, can also be used to implement lightweight distributed locks. 1. Implementation solution 1 The earliest

Mysql searches for the field name through field annotation, and mysql field annotation name Sometimes there are too many fields in the table, just remember the table comment. To search for the field name through the field comment, you can use the

The query conditions in MongoDB include fields in the collection. The data structure to be queried is as follows: Take the versionLimitList field as an example. MongoOperations tool-related query statements Criteria criteria1 =