Database Administrator

Oracle 11 Client installation file: Download the following files from www.oracle.com: Oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm Oracle-instantclient-basic-11.1.0.1-1.i386.rpm 1> install the oracle 11 client in Linux # Rpm-ivh

RAID, a Redundant Array of cheap disks, is a method of storing the same data in different locations on multiple hard disks. RAID has many different types (called RAID "level"). Each type has its own advantages and disadvantages.　　For Oracle9i

1. Create an Informix group and an Informix userUse the root user to pass the Informix Installation File to LinuxUse the root user to install Informix in the/bank/informi directory 2. Use Informix to configure the installation.Modify

The developers of the MySQL project team announced a new software version release model, which aims to create a more dynamic, accessible, open, and understandable development model. This means that the existing development mode will not be used in

Data Files in Oracle databases have a feature that allows you to set whether to go offline. If you set the data file to offline, the database cannot read the data file. The database can read contents only when files are online. Therefore, changing

It's easy. First, we need to download and install MSSQL in Linux to support Freetds, and then re-compile (compile) in the PHP installation source folder. -------------------------------------------# Wget

Connect to Oracle today error: ORA-18008: can not find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up the error prompt, busy for a while, finally, the solution is

Recent UAT database migration, because multiple databases need to be migrated to the same machine, after part of the completion, start the subsequent database encountered a ORA-27102 error, prompting that the memory exceeds, view the system

I. Glossary: 1: Server_uuid: Server ID. When Mysql is started for the first time, a server_uuid is automatically generated and written to the auto. cnf file in the data directory. It is not recommended to be modified. [Root @ mysql5_6 data] #

Practical Environment Introduction: Server Name IP System MySQL Odd.example.com 192.168.1.116 Rhel-5.8 5.5.16 Even.example.com 192.168.1.115 Rhel-5.8 5.5.16 Assume that the database to be

Generally, mysql requires backup. There are many backup methods. The following is an automatic backup of a remote database that I used in concert with a scheduled task. I. Confirm the backup solution: Backup Machine: ip192.168.8.51 Database Server:

Understanding of Oracle architecture ------- preliminary understanding First of all, the Oracle architecture has a system diagram, which I also understand. In fact, the architecture is the figure. To understand the architecture, you must understand

To test how to store video files in mysql DATA, we do not recommend that you store them directly, because migration is troublesome and prone to problems. The following is only a test function, importing jpg, png, and other images is similar. Create

1. Configuration Planning Name IP Listeners End Port SID Db_name Db_unique_name Service name   Host 127.0.0.1 Listener1 1521 Test1 Test1 Test1 Test1   Slave 127.0.0.1

1. symptom: An error is reported when the database is opened in the last step after the recovery of the data files from different hosts is successful. For example: SQL> alter database open resetlogs; Error: ORA-01152: file 1 was not restored from a

Requirement: LVS performs read load on MySQL. If the master and slave nodes are not synchronized, the problem may occur, how can I remove the slave database from LVS when the master node is not synchronized? And if I remove the slave database when

Environment: Oracle 10g 10.2.0.4 on SUSE 11 + Oracle Data GuardNote: Standby DB is regularly read-only for statistics every morning, and then continues synchronization.Fault symptom:Run the copy datafile command to report the RMAN-10006 error.As

Generally, the database processes SQL statements through three processes: parsing (parse), executing (exec), and returning results (fetch) 1. Resolution When a user initiates an SQL statement, Oracle receives the SQL statement to the oracle instance

A friend asked me to back up the database with exp at every night to a specified directory and automatically delete the data backed up one week ago, record and share the process only. For the case of Oracle automatic backup on Linux (using RMAN),

Backup and recovery are required for any database, which is of much importance and everyone understands. Mongodbalso describes the functions of tracing and restoration, which are the mongdump.exeand mongorestore.exe files downloaded by