Database Administrator

Accidental deletion of redo log file group causes startup Database Error ORA-03113 Speaking of more than one person, learning technology requires Constant tossing and destruction. For example, backup and recovery, you can try to delete files,

ORA-00600 troubleshooting and analysis examples Yesterday to deal with a ORA-00600 of errors, which also experienced various twists and turns, really look at the flowers in the fog, after seeing through a lot of problems are found to have a reason.

Troubleshooting of default temporary tablespace and redo log files in Oracle Problem: I want to synchronize Oracle Data to MySQL now. the ETL tool is used because the data volume is large and temporary tablespace is used for subqueries, resulting in

Actual RMAN Migration Operations-additional common commands Operation scenarios Source server OEL 6.3 11G R2 11.2.0.3Target Server OEL 6.3 11G R2 11.2.0.3The data storage path of the source server and target server is the same. Source Server[Oracle @

Error Caused by Oracle 11g import to 10g Environment Introduction Old Environment   New Environment   Operating System: RedHat5.8 64-bit   Redhat6.4 64-bit Database Version: Oracle 10.2.0.4 64-

Install PostgreSQL and centos7postgresql on CentOS7 Install the postgresql Software Package sudo yum install postgresql-server postgresql Initialize db sudo su - postgresinitdb -D /var/lib/pgsql/data Start/stop a service systemctl status

[C3p0] Article 1: a simple introduction to c3p0,Preface According to the c3p0-0.9.5.1 version of the official documents, coupled with their own understanding, compiled into the translation. Limited capabilities. If the translation content is

Redis configuration cluster, redis ClusterConfigure the cluster configuration environment in redis Environment centos 6.6 redis 3.0.2 For convenience, copy three copies of the redis environment under a folder, with the suffix representing the

In oracle, how does one obtain the local IP address and the domain name based on the IP address ?, Oracleip----- Resolve the ip addressSQL> select utl_inaddr.get_host_address ('Google. com') from dual;UTL_INADDR.GET_HOST_ADDRESS ('Google. com ')-----

SQL optimization skills (Oracle), SQL optimization skills oracle SQL optimization tips (1): Connection sequence in the Where clause: oracle parses the where clause in order from bottom to top. According to this principle, the connection between

MySQL Study -- MySQL stress testing tool mysqlslap, -- mysqlmysqlslapMySQL Study-MySQL stress testing tool mysqlslap1. Introduction to MysqlslapMysqlslap is a benchmark testing tool provided after MySQL5.1. It is similar to the Apache benchmark load

MySQL combined with multi-Table update and deletion, mysql combined updateMulti-Table updateIn MySQL 3.23, you can use LIMIT # to ensure that only the specified number of record rows is changed.If an order by clause is used (supported since MySQL 4.0

HBase Write Request analysis, hbase Write Request As a distributed NoSQL database system, HBase not only supports wide lists, but also provides high performance for random read/write. HBase can maintain transaction consistency while performing

Fault case: problems that may be caused by regular backup and fault case backup Scenario 1: The database memory is 1.5 GB, with few businesses. The qps is less than 10 at ordinary times. The memory usage soared to 100% from to every morning. When

Linux monitoring (OS, MySQL, Tomcat, Apache), tomcatapache My Opinion on gradually moving away from the development position has been approved by the boss. My next major job is "O & M + database management". I would like to thank Jie Minmin and Xiao

Mysql database installation and configuration, mysql Database Configuration Http://blog.csdn.net/pipisorry/article/details/46773507 Download and install mysql Download MySQL Installer Set the Administrator account and password during

Column not found caused by mysql alias in SQL, mysqlcolumn Caused by: java. SQL. SQLException: Column 'btn _ ICON 'not found. The error message indicates that a field in the table cannot be found, but this field does exist in the table. This

Oracle Advanced Programming, oraclesql Advanced Programming Oracle's advanced programming mainly involves the use of the ten objects in the database. Here, I will share with you some of my notes on these skills. Hope to help you! Before reading this

Download MATLAB and matlabMATLAB-SQL connection technology [pure code] code block Code block syntax follows standard MATLAB code Function conn_matlab dB () % UI 2015.6.27 MATLAB R2013b % function Description: establish a connection between matlab

Is not null and! in SQL! = NULL difference, sqlnull These two methods are often used: is not null and! = NULL. We often encounter database conditions! = NULL, but the returned result is a NULL set. In fact, the difference is not fully understood. By