Database Administrator

Install Oracle 7.1 configurations on AIX 11.2 1. Operating System Installation1. Start the instance and place it on the system disc.2. Select 1.SMS Menu-> 5. Select Boot Options-> 2. Select Boot Devices-> 3.CD/ DVD3. Select F1 enter system console4.

Delete the Oracle tablespace and corresponding data files under Aix and the space is not released. During routine Oracle database maintenance today, because a file system has reached 82% and a new partition table space is created, the first two

Oracle Database hang instance analysis Symptom: Neither common users nor sysdba can log on, resulting in service interruption. Analysis process: 1. Do hanganalyze and systemstate dump first $ Sqlplus-prelim "/as sysdba" SQL> oradebug setmypid

[PL/SQL series] use dynamic SQL for Oracle stored procedures I believe everyone knows about the Oracle stored procedure. The following describes how to use dynamic SQL in the Oracle stored procedure. I hope this will help you. Create or replace

MySQL cross-platform (Windows, Linux, Mac) use and Installation MySQL is actually a cross-platform lightweight database, which is usually used for development. Writing programs may require cross-platform development. Next I will introduce how to use

Oracle processes Clob data warehouse receiving (String warehouse receiving) You can search for a bunch of references from the Internet, either in unknown or not. You can load a pile of data into the database. Please refer to the final: Insert into

MySQL High Availability LVS + Keepalived + MySQL1. Architecture Diagram  Note: (1) Mysql needs to remove the bind-address Configuration; otherwise, virtual ip access cannot be implemented. (2) Disable all linux firewalls:/sbin/iptables-F (may be

Redis Cluster Study Notes Redis officially introduced the cluster feature in version 3.0. Redis cluster is a distributed (distributed), fault tolerant (fault-tolerant) Redis memory K/V service, A cluster can use a subset (subset) of the functions

MongoDB replication (replica set) MongoDB replication is the process of synchronizing data on multiple servers. Replication provides redundant data backup and stores data copies on multiple servers. This improves data availability and ensures data

ORA-00392 ORA-00312 log clearing fault Recently encountered a ORA-00392 after restoring the Oracle database open: log 3 of thread 1 is being cleared, operation not allowed, its literal meaning is that the log file is being cleared, operation is not

Simple Test of Oracle 11g flash back Archiving The new features in Oracle 11g flash back archive provide a possibility for custom query of historical data. After learning this feature, I found that it is clear and easy to use. If used properly, it

Summary of MySQL 5.7.11 compilation and installation and modification of the root password The system is CentOS 6.7 64-bit. By default, MySQL5.7.11 is downloaded to/usr/local/src. The installation directory is in the/app/local/mysql directory, mySQL

ORA-01110 error caused by standby database query and Its Repair Recently, it helped the business department solve a technical problem because it needed to analyze the problematic data to discover data problems. Of course, one difficulty is to filter

Introduction to Oracle High Water Mark (HWM) 1. What is high water level? High water level is the boundary between Oracle and unused space. It can also be understood as the boundary between data files and between non-data files, however, the data

CentOS 6.5 installation of Redis and startup script I. Download and install Redis in CentOS 6.5 1. Download the source code, decompress it, and compile the source code. # Wget http://download.redis.io/releases/redis-2.8.3.tar.gz# Tar xzf redis-2.8.3.

MySQL character collation (garbled) Problem Solving 1. Create a MySQL database 1 CREATE DATABASE `test`2 CHARACTER SET 'utf8'3 COLLATE 'utf8_general_ci'; Create a table 1 CREATE TABLE tp_wechatlocation 2 ( 3 ID INT NOT NULL AUTO_INCREMENT, 4

Using Jedis in Java to operate Redis Using Java Redis operations need jedis-2.1.0.jar, if you need to use Redis connection pool, but also need commons-pool-1.5.4.jar, the two files to the house of HELP Resources station download: --------------------

How to change the asm sys User Password You must use the orapwd command to recreate the password file to modify the password of the sys user, instead of using the alert user command: 1. Set Oracle_HOME and ORACLE_SID of the ASM instance 2.

Use MySQL Databases in Python 1. Install mysqlSudo apt-get install mysql-serverSudo apt-get install mysql-client 2. Install the MySQL-python driverSudo apt-get install mysql-python 3. test whether the installation is successful.Run import MySQLdb In

MySQL improves Insert Performance The time required to insert a record is composed of the following factors, and the number indicates the approximate proportion:• Connection: (3)• Send a query to the server: (2)• Analysis query: (2)• Insert record: (