Database Administrator

Error handling during Oracle database installation [INS-35172] The following error is reported when Oracle is installed on the desktop when SGA is assigned:[INS-35172] Target database memory (XXMB) exceeds the systems available shared memory ({0}

Install and configure MySQL in CentOS MySQL is preferred. The first MySQL database version is released on Linux. Other options include postgreSQL and Oracle. Install the mysql database on Linux. You can download the rpm package of the MySQL database

ORA-01157 & ORA-01110 troubleshooting When starting the Virtual Machine Test Library today, the database reported a ORA-01157 and ORA-01110 error prompting that a data file could not be found. When I read the file name, I knew where the problem was.

MySQL common error analysis and solution Summary 1. Can't connect to MySQL server on 'localhost' (10061)Translation: cannot connect to mysql on localhostAnalysis: This indicates that the "localhost" computer exists, but the MySQL service is not

ORA-01555 Problem Analysis and Solution Today, my colleague sent me a problem, throwing a ORA-01555 error when running a Job, hope we can see what can be found from the database layer. The error log is as follows: Function: EntitySQLCursor:

Analysis and Solution to the Problem that MRP cannot be started in Data Guard I have a dedicated uard environment on hand, because it has been useless for some days. As a result, I was suddenly prepared to start learning, and suddenly found that

Mysql installation illustration 1. Several common methods for mysqldump: (1) Export the entire database (including data in the database) Mysqldump-u username-p dbname> dbname. SQL (2) Export the database structure (excluding data) Mysqldump-u

Hibernate establishes one-to-one association, and hibernate multiple-to-one Association The following content is organized from the second edition of Hibernate Ing code: The element establishes a customer ing between the customer attribute and

Regularly back up mysql Databases and linuxmysql databases on linuxRegular Database Backup/Usr/sbin/backupmysqlTimestamp = 'date + "% Y-% m-% d-% H-% M-% S "'Mysqldump-uroot-p '123456 databasename>/db $ timestamp. SQLChmod + x backupmysqlInstall

Centos 6.5 final installation xtrabackup 2.2.11 note, centosxtrabackup(1) download xtrabackupwget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.2.11/binary/redhat/6/x86_64/percona-xtrabackup-2.2.11-1.el6.x86_64.rpm(2) rpm

Error code: 1305 PROCEDURE world. insert_data does not exist, doesnotexist 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: call insert_data () error code: 1305 PROCEDURE world. insert_data does not exist execution

Encapsulate PL/SQL code in a smart package, and plsql package Encapsulate code in a smart packageHttp://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13plsql-1872456.html The vast majority of PL/SQL-based applications are composed of

Thinkphp environment configuration and Thinkphp environment Configuration 1. After wampserver is installed, we will see the related icons turn green;2. After Entering localhost in the browser, we can see the corresponding introduction interface.3.

SQL score statistical analysis-ranking and SQL score statistical analysis ROW_NUMBER (), RANK (), DENSE_RANK (), NTILE () I recently wrote the Performance Statistics Service for nearly half a month, and was tortured by SQL. The following describes

Report example -- use BIRT for irregular month statistics and report example birt Source: http://developer.actuate.com/community/forum/index.php? /Topic/36323-months-and-quarters-group-issue/ Irregular month statistics: If the start time is, select

Make progress every day-MySQL-myisampack and mysqlmyisampack I. Introduction Myisampack is a tool for compressing tables using the MyISAM engine. Generally, it compresses 40% ~ 70%. When you need to access data, the server will read the required

5th million,5. Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT ('hm _ RUN_1061 ') Run Name: HM_RUN_1061 Run Id: 1061 Check Name: Data Block Integrity Check Mode: REACTIVE Status: COMPLETED Start Time: 22:11:02. 03229

Fun SQL-create a specified data type and fun SQL data type Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46908843    Fun SQL -- create a specified data type   In an article, I found

Three major database design paradigms and three database paradigms In order to establish a database with low redundancy and reasonable structure, certain rules must be followed when designing the database. In relational databases, such a rule is

SQL Sever -- cannot connect to (local ). Sqlsever Solved the "remote process call failed (0x800706be)" mentioned in the previous blog. New problems are coming soon... I, Solution: In the SQLSever Configuration Manager, find "SQL Sever service" and