Database Administrator

Oracle ADG Heartbeat failed to connect to standby fault case The customer's primary Database is a standalone Database of Oracle Database 11gR2 for AIX. The ibm hacmp software is deployed at the system level, the database is made into a master-slave

Install the Visual Database Browser SQLite Browser 16.04 on Ubuntu 3.8 SQLite Browser 3.8 was released at the end of last year. SQLite Browser is a visual database Browser that can be installed through PPA. SQLite Browser is a visualization tool

Redhat 5 disables IPv6 and redhat5 disables ipv6Redhat 5 Disable IPv6 IPv6 has not been fully popularized yet, but IPv6 is effective after the system is installed, which affects network performance to a certain extent. Therefore, we recommend that

MySQL is a simple and easy-to-use basic operation guide. (1) Introduction to mysql basic operations System: Ubuntu 14.04 LTS Installation: Apt-get install mysql // install the database apt-get install mysql-workbench // install the graphical

How to handle archived log files and RMAN log files when using rman backupI went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed

The correct method to restart MySQL in Linux: 1. MySQL installed through the rpm package Service mysqld restart 2. Install MySQL from the source code package // Linux Command to disable MySQL $ Mysql_dir/bin/mysqladmin-uroot-p shutdown // Linux

Oracle 10g 10.2.0.1 in Oracle Linux 5.4 32Bit RAC installation manual (a touch of Xiangyang), 10.2.0.1 installation manual Oracle 10g 10.2.0.1 installation manual in Oracle Linux 5.4 32Bit rackets (step by step) Http://download.csdn.net/detail/rlhua/

The prefix index of MySQL is similar to that of Oracle. MySQL has an interesting index type called prefix index. It can index the front part of a text field separately to reduce the index size. In fact,Oracle has similar implementations. For text,

1. Result Set Caching description   For instructions on the Oracle official website, refer: 7.6 Managing the Server and ClientResult Caches Http://docs.oracle.com/cd/E11882_01/server.112/e16638/memory.htm#BGBCABED   1.1 Overview You can enable

Python module knowledge 2: Time and date Calendar module Time, Datetime, Calendar, pythondatetime 1. time Module Why did the time start in 1970? Because Linux was used in that year, the time is usually represented by the following methods:

Mysql-workbench is a graphical MySQL management tool, which has been well done and can be used for database management and development. The following describes how to install the tool: 1. Download mysql-workbench. :

MySQL Optimization-Delete Insert update and mysql optimization insert update Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46581769 Insert Insert multi-row query results into the table Syntax INSERT INTO

The PXE method is used to batch push the Complete Oracle 11gR2 RAC environment from bare metal, and the Shell script is used to deploy 32 Oracle11gR2 RAC backup and recovery cases on the launched RAC nodes in batches. Consultant for ARP Project

Oracle purchase price research (2): oracle purchase price researchRead Oracle purchase price researchFocus of this Article The previous article wrote online materials and theoretical research. This article mainly describes the actual enterprise

When dbca deletes OracleserviceXXX in windows, the following error occurs: dim-00014 Cannot open the Windows NT Service Control Manager, cadmanagercontrol When dbca deletes OracleserviceXXX in windows, the following Error occurs: dim-00014 Cannot

JDBC: database connection pool, jdbc database connection pool Required tools Commons-pool2-2.3.jar: dependency library implemented by connection pool Commons-dbcp2-2.0.1.jar: Implementation of Connection Pool C3p0-0.9.2.1.jar If Method

Typical use cases of MySQL MHA and typical use cases of mysqlmha1 Management node deployment location 1.1. Dedicated Manager server and multiple MySQL (master, slaves) servers Use a dedicated management server to manage multiple groups of MySQL

Alex's Hadoop cainiao Tutorial: tutorial 10th Hive getting started, hadoophiveInstall Hive Compared to many tutorials, I first introduced concepts. I like to install them first, and then use examples to introduce them. Install Hive first. First

Php supports connection to the SQL server database and SQL server 1. Software Configuration Win7 64 + wampserver2.2d-x32 + SQL Server 2008 R2 database. The php version in wamp2.2 is 5.3.10. The Php environment can also be changed to php + apache. 2.

SQL Server skills: how to monitor and optimize OLAP Databases It is very important to optimize the performance of online analysis and processing. Fortunately, some tools can help monitor and improve the operation of OLAP databases. The Microsoft