Database Administrator

During MySQL installation using source code compilation in Fedora, various errors may occur, mostly because no dependency package is installed and the rpm command is used for installation, which may cause less trouble: Required software:

1. install Linux I installed Linux 4.4 compiled by Oracle. 1. If the most important role of this server is to install Oracle, allocate a file system directly to Oracle. For example: /Boot 100 M,/15G,/swap 2G,/opt 20G (ORACLE programs will be placed

I started a project a few days ago. I used MySQL, but the project needed an Oracle database. After a month, I changed all the programs to an Oracle database, some differences between MySQL and Oracle are found during the operation. 1. mySQL can

Alas, the project requires Oracle. I really don't want to use this large database for computers with low memory and CPU clock speed. No way. I may need to use my computer during review. I have to configure the database first. It is very convenient

The MySQL database in Linux has three functions:1. Create a folder named by date to store mysql Database backups.2. If the folder named by date exceeds 30, it is automatically deleted to save server space3. Go to the/var/lib/mysql directory and pack

SQLJet is an independent pure Java implementation of the popular SQLite database management system and a software library that provides APIs. This API enables Java applications to read and modify SQLite databases. SQLJet does not support SQL queries,

1. ORA-12541: TNS: No listener Cause: the listener is not started or damaged. If it is the former, run the net start OracleOraHome81TNSListener command (the name may be different; If it is the latter, add a listener using "Listener Configuration" in

Installation environment:System: RHEL 5. Select Chinese during installationHardware environment: P4 3.4G, 2G memoryDisk Partition: boot: 100 M; swap: 1998 M; all others are/partition;Oracle uses 10201_database_linux32, 1. RHEL Environment1. Install

Use dbv and rman blockrecover to repair bad Oracle Database blocks. (1) alert. log reports the following error during rman backup: Fri Jul 2 12:41:36 2010 Hex dump of (file 12, block 2718618) in trace

Modifying db_recovery_file_dest causes flashback off. Error reported during startup [Oracle @ node3 dbs] $ srvctl start instance-d momorac-I momo1 PRCR-1013: Failed to start resource ora. momorac. db PRCR-1064: Failed to start resource ora. momorac.

Oracle instance Startup Process and file operations Initialize an instance Then mount the database Then load and open the database Initialize instance startup nomount First, oracle goes back to pfile and spfile to initialize the instance,

Here we will first describe the database startup process: 1. when the instance/routine is started (nomount status), read the parameter file (PFILE in a text file or SPFILE in a server parameter file), allocate the SGA, start the background process,

Purpose of a crosscheck command If the backup is damaged or does not exist on the disk and the backup set is still recorded in the rman database or the archive is available, you need to run crosscheck to perform cross-validation to update outdated

MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for adjusting and optimizing MySQL installation. Some tips are applicable to specific

I. in Linux   The Startup Script of app01 application server is as follows:   #! /Bin/sh ---- # Under aix or hpux #! /Bin/ksh If ['whoam '! = 'Weblogic ']; thenEcho 'login User error! 'Exit 9Fi Export srvName = app01Export adminUrl = http: // Manage

1. MySql + Memcached architecture Problems MySQL is suitable for storing massive data. Many companies have used this architecture to load hotspot data to the cache through Memcached to accelerate access. However, as the business data volume

Recently, when I was using redis Master/Slave, I did the following two things: 1. You want to analyze redis master-slave operations. All write operations are performed on the master node, and all read operations are performed on the master node. 2

The vs debugging pg source code used in the pg kernel source code parsing class, VS is easy to use, but it is a little troublesome to configure the debugging environment. First, you have to install a windows system, preferably xp or win7, which is a

Define a subquery• Describes the types of problems that subqueries can solve • lists the types of subqueries • Write single-row and multi-row subqueries • subqueries: types, syntaxes, and guidelines • single-row subqueries: -Group function in

Arraysize defines the number of rows returned to the SQLPLUS client at a time. After scanning the arraysize row, stop scanning, return data, and continue scanning. This process is the SQL * Net roundtrips to/from client in the statistics. Because