Database Administrator

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

[Mysqld]Port = 3306Serverid = 1Socket =/tmp/mysql. sockSkip-locking # Avoid external locks of MySQL to reduce the chance of errors and enhance stability. Skip-name-resolve Prohibit MySQL from performing DNS resolution on external connections. This

Innodb_buffer_pool_size of innodb can only be up to 2 GB on 32 machines. In this way, the increase in memory is insufficient to speed up. I heard that the 64-bit environment can use more than 2 GB of memory, so I began to

I just re-installed the system yesterday, so I was wondering if I could install Oracle.Oracle has been installed on other Linux systems. 1. Select software development when installing the system, because tools such as gcc are required for installing

How to Get Discuz recently! Apply Memcache to do some things and record the Memcache installation process. The detailed method is as follows: 1. Download memcached and libevent respectively and put them in the/tmp directory:# Cd/tmp# Wget http://www.

When Oracle11g is installed on RedHat as5, the GUI cannot be started and the following error is reported:[Oracle @ sense disk1] $./runInstallerStarting Oracle Universal Installer...Checking Temp space: must be greater than 80 MB. Actual 1184 MB

How to restore damaged online logs Corrupt non-current online logs It is clear that online logs are divided into current online logs and non-current online logs. the corruption of Non-current online logs is relatively simple. Generally, you can

1. Perform all replication operations in the foreground where the Master node is not offline Basic Steps for recall:1. premise: the Master opens the binary log file and sets server-id = 1.2. account required to establish a slave service connection

Source code compilation and installation of MySQL 5.5.30 0. Install cmake[Root @ www.bkjia.com ~] # Tar-zxvf cmake-2.8.11.2.tar.gz[Root @ www.bkjia.com cmake-2.8.11.2] #./configure[Root @ www.bkjia.com cmake-2.8.11.2] # make[Root @ www.bkjia.com

These two names are very common in alert log. Apart from Oracle, they are inevitably prone to a variety of problems and some are well solved, but some are heartbroken. Example: ORA-00600 The description given by OERR is as follows: // * Cause:

V $ parameter The modification of Oracle parameters is complex. Some parameters can be modified at the session level, while others must be modified at the system level. Some parameters take effect immediately after modification (no restart is

To connect to the mssql database in Ubuntu, I found SQuirreL SQL Client for a long time. SQuirreL SQL Client Official Website: http://sourceforge.net/projects/squirrel-sql, 00402_2427. SQuirreL SQL Client has the following charm: Based on Java, it

Oracle 11g new collection function listparts implements column forwarding First, the syntax is as follows:Listparts (column | expression,Delimiter) within group (order by column | expression) is a clustering function. Use an example to describe its

Note: server, ip, and system planning are not performed for this installation. Objective: To learn how to install weblogic11g without graphics in linux Java version of the official website; http://www.Oracle.com/technetwork/java/javase/archive-139210

This article focuses on backing up and recovering data files. For more information about rman, see my other article: First, let's look at the data files: SQL> selectfile_name, file_id, tablespace_name from dba_data_files;   FILE_NAME FILE_ID

Environment: 11.2.0.3 + OEL5.7 192.168.1.55zlm sid: zlm11g 192.168.1.60zlm2 sid: zlm11g Gg package: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit Oracle DML Process PL/SQL ORA-14551: cannot perform DML operations in queries solved Common MySQL DDL, DML,

For innodb independent tablespaces, delete cannot recycle the space occupied by the disk. You can use truncate (the principle is to delete or recreate it first; Directly alter table .... engine = innodb can be used to sort shards and reclaim some

1. Configure the master database environment Enable Archiving SQL> alter system set log_archive_dest_1 = 'location =/Oracle/archive_log/arch _ % t _ % s _ % r. arc' scope = spfile; The system has been changed. SQL> ALTER SYSTEM SET

Key points about setting a reasonable log buffer size 1, default size MAX (0.5 M, (128 K * number of cpus )) 2, On most systems, sizing the log buffer larger than 1 M does not provide any Performance benefit. It merely uses extra memory. 3. View

Abstract: This article introduces two global ID generation solutions for the Distributed Environment. Directory: 1. database auto-increment ID-solution from Flicker2. independent applications-solutions from Twitter In large Internet applications, as