Database Administrator

Most databases are composed of two distinct parts: the backend (where data is stored) and the front end (a user interface used to connect data components ). This architecture separates the user interface from the data layer. In this way, a third

I. Development Environment: Mini2440, Linux_2.6.32.2 kernel, Ubuntu 9.10, Arm-linux-gcc-4.3.2 Download the sqlitesource code sqlite-3.6.22.tar.gz 2. Migration steps 1. decompress the database source file and enter the decompressed directory,

Nagios's built-in Oracle monitoring check_oracle has fewer functions. You can use the check_oracle_health script written in perl. 1. Install check_oracle_health Wget

One customer consulted on nbu6.5 and failed to back up Oracle10g. The error code is 6. After checking the oracle log, It is shown as follows: RMAN-12001: cocould not open channel ch01RMAN-10008: cocould not create channel contextRMAN-10003: unable

The local_listener parameter has two writing formats and provides different functions. On the listener file, ports 1521 and 1526 have dynamic listening ports. [oracle@dbsv admin]$ cat listener.ora LISTENER= (DESCRIPTION= (ADDRESS_LIST=

Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/32715157   The BASE calculation method is as follows:For ASSM: 76 + (itc-1) * 24 = 52 + itc * 24For MSSM: 68 + (itc-1) * 24 = 44 + itc * 24   gyj@ZMDB> select * from

Customize a mysql STARTUP script according to the working environment --- 1. Save As/usr/local/mysql/scripts/mysql_env.ini # Set mysql init variablesMYSQL_USER = system # mysql UsernameMYSQL_PASS = 'Password' # mysql logon User password # Check

In Java, executing Hive commands or HiveQL does not mean that Hive Client connects HiveServer (or HiveServer2) through JDBC to execute queries, instead, execute the Hive command on the server where HiveServer is deployed. Of course, this is a simple

You can query from v $ SQL or v $ sqlarea in a short period of time. If you want to query within a week or a month, you may not be able to find it in V $ SQLAREA! The following is obtained through history DBA_HIST_SQLSTAT, Which is retained through

1. Download Go to the official website to download the latest PostgreSQL Studio, I downloaded pgstudio_1.2-bin. zip, because my computer does not have tomcat. If Tomcat is configured on your computer, download pgstudio_1.2.zip and decompress the

In the previous article, we mentioned hot standby (), which is to back up data when MySQL or other database services are running. This article shares another backup method, that is, hot copy. Hot copy is similar to hot backup, but hot backup uses

About MySQL AB Replication This article describes how to quickly package and install MySQL, MySQL AB replication, MySQL AB bidirectional replication, and MySQL multi-level master-slave replication to solve the primary key conflict of AB

Step 1: Use the following SQL statement to view the process list and identify the locked table SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ',' | vss. SERIAL # delete number, Lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. action Action,

Sometimes it is necessary for Oracle to terminate the current session. For example, if you want to perform a management operation, you need to terminate all non-Administrator sessions. The following describes all aspects of session termination,

You can use the following methods to conveniently find the SQL statement used to monitor the Oracle tablespace usage: A test database is found to ensure that only one user is connected. Use TOAD to view the table space usage. Refresh the share pool

1. Copy the table structure and data: Create table table_name_new as select * from table_name_old 2. copy only the table structure: Create table table_name_new as select * from table_name_old where 1 = 2; Or: Create table table_name_new like

1. The ORA-00845: MEMORY_TARGET not supported on this system is prompted when the database is started(MEMORY_TARGET, the new memory automatic management parameter in Oracle 11g, can automatically adjust SGA and PGA. This feature requires the/dev/shm

Before installation: The minimum requirement for memory (RAM) is 1 GB. 2 GB or above is recommended. Recommended virtual memory swap: memory is 1 GB ~ We recommend that you set the swap size to 1.5 times of the memory size for 2 GB. The memory

Note: Install MySQL 5.6 On A CentOS Virtual Machine on Windows 7. 1. Download the installation packageMysql5.6: Http://dev.mysql.com/downloads/mysql/ Select the Linux version here: Use Navicat to manage MySQL databases on a remote Linux Server 2

In RHEL5, the automatic backup script of RMAN is written and regularly executed on the server: Requirements (1) Full backup of the database, backup of control files and archive log files at the same time, and automatic deletion of archived logs