Database Administrator

Install MySQL server and client in Ubuntu 14.04 Now the software in Linux is getting better and better to install, especially when installing software in Ubuntu, It is not skillful. You only need to use apt-get inatll when connected. Before deciding

Oracle database backup and recovery (expdp and impdp) Refer: Oracle 11g beginner's Guide The materials on the Internet are fragmented, and most of them cannot complete the required functions. Preparations 1. configure it in the bin directory of the

Create a tablespace in Oracle Note: 1. If you open it in PL/SQL or other tools, directly modify the [italic bold part] in the following code to execute 2. Make sure that the path exists, for example, [D: \ oracle \ oradata \ Oracle9i \], that is,

Oracle flash back table experiment Oracle job: flashback table experiment 1. Construct the flb_test table, with no less than 10000 rows of data; TEST_USER1 @ PROD> create table flb_test (id number, dd date ); Table created. TEST_USER1 @ PROD> begin2

Recovery after the Oracle data table is dropped Oracle Data Tables store drop tables and indexes in the recycle bin (the recycle bin function must be set for the production database) Because the current generation environment has re-created many

Memory_target cannot be started because of improper settings. Today, I encountered another "strange" problem during troubleshooting.The SGA Automatic Storage Management has been disabled in the Test Library. As a result, the shared_pool_size

Notes for getting records using rowid and rownumWe know that rowid and rownum can be used as fake and shoddy in Oracle and are mainly used to locate specific records in the table, but they are different, rowid corresponds to the physical address of

Use shell to customize awr scripts When you diagnose performance problems, awr is an indispensable tool? /Rdbms/admin/awrrpt. SQL may be used too much, and sometimes it may be too cumbersome to input parameters. Copying a snapshot list is not

ORA-03113 Solution Scenario: A solution to full ORA-00257 archiving logs the archived logs described in this log are full (SEE ). Now I want to switch the database to non-archive mode. Refer to how to start or disable Oracle ARCHIVELOG mode for

RMAN recovery steps and troubleshooting1. Install OS + Oracle Software on the testing machine, including configuring oracle users, groups, and environment variables (omitted). 2. Start recovery from different machines. copy the latest backup set,

How to install and configure MySQL5.7.3.0 How to install and configure MySQL5.7.3.0 First, the MySQL official website downloads the mysqlserver installation software package from http://dev.mysql.com/downloads/. Mysql-installer-community-5.7.3.0-m13.

Differences between statistical information collected by Oracle at 11g and 12C The transaction-based temporary tables in Oracle are under 11 GB and 12C. After the statistical information of the temporary tables is collected, the former records are

Slow MySQL subquery When you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit ". Related books: High-

Notes for using a session-based temporary table in Oracle There are two temporary tables in Oracle. One is session-based, that is, data is cleared after a commit occurs, and the other is session-based. When a session is disconnected, data is

Incorrect upgrade leads to ORA-27468 errors and full flashback (ORA-16014) ORA-27468 error in Oracle 10.2.0.5 environment Alert Log. View alert logs: Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:ORA-12012: Automatic job 5329

ORA-12518: TNS: listener cocould not hand off client connection, ora-12518tns 1. ORA-12518: TNS: listener cocould not hand off client connection When the number of team members increases, problems such as "unable to distribute client connections"

Hadoop mapreduse debugging environment in Eclipse, hadoopmapreduse After the environment is set up, debug the mapreduse program. However, an error occurs constantly. I hate setting in my OS environment variables, including linux. You usually like to

Mysql user permission assignment and master-slave synchronous replication, mysql user permissionGrant wgdp user query permission: grant select on wg_dp. * to 'wgdp '@' % 'identified by 'weigou123'; grant all privileges on *. * to 'yangshao' @ '%'

[MongoDB] Build a Mongo database replica set (similar to a cluster) on the windows platform and mongodbmongo Replica Sets (Replica set) is a new feature in mongodDB1.6, which enables automatic failover and Automatic Repair of node members. The data

Use JDBC to change the session parameter NLS_DATE_FORMAT and oraclenlslang of Oracle Except for one problem recently, this is probably the case. The project is developed abroad and a large number of Oracle functions TO_DATE are used in the project