Database Administrator

This article provides a complex method to compress logs and database files. 1. Clear logs: dump transaction database name WITH NO_LOG. 2. truncate transaction logs: backup log database name WITH NO_LOG. 3. Compress database files (if not compressed,

Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behaviors. However, most people do not know that the

Environment: OS: rhel4MySQL version: 4.1Master database 192.168.1.115Slave database 192.168.1.1161. Create/etc/my. cnf in the master database and modify the key value in [mysqld] to open the master item.Server-id = 1Log-bin2. Add users to the master

I have installed Multiple MySQL service notes in the Linux environment. For more information, see! 1. Install it as usual.[Root @ ff_girl mysql5122] # chown-R root.[Root @ ff_girl mysql5122] # chown-R mysql data[Root @ ff_girl mysql5122] # chgrp-R

Insert a large amount of data into a table in the MySQL database: Usage: DELIMITER $USE 'macross _ wudi '$Drop procedure if exists 'test' $Create procedure 'test '()BEGINDECLARE I INT DEFAULT 333;DECLARE j int default 333;WHILE (I Replace into

Today to the customer data recovery, found that the use of the hidden parameter _ allow_resetlogs_upload uption, the result of a 2662 error in ORA-00600. The customer said that a data file CUUG was lost. DBF, there is only one cold backup (the

ORA-00600 [KSLFFRE_PVT2] abnormal termination of instance: Sat Oct 20 02:00:22 2012 Errors in file/u01/Oracle/app/oracle/admin/demo/bdump/demo_lms2_774478.trc: ORA-00600: internal error code, arguments: [KSLFFRE_PVT2], [0x700000CE1327F90], [23058

1. Execution per minute Interval => TRUNC (sysdate, 'mi') + 1/(24*60) Or Interval = & gt; sysdate + 1/1440 2. daily scheduled execution Example: Execute at every day Interval => TRUNC (sysdate) + 1 + 5/(24) 3. scheduled weekly execution For

Incorrect database listening status$ Lsnrctl status LSNRCTL for IBM/aix risc System/6000: Version 10.2.0.5.0-Production on 05-NOV-2012 08:54:08 Copyright (c) 1991,201 0, Oracle. All rights reserved. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL =

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. To avoid the trouble, you can use the 'database Configuration Assistant 'Wizard to create a Database, an error will

Recently in the use of swingbench encountered a ORA-01157 fault, the following is the specific description and solution. 1. Fault-- ORA-01157 fault occurred when querying view dba_data_filesSQL> select file_name, tablespace_name from dba_data_files

# Rpm-qa | grep-I mysql view installed mysql versions Delete an existing mysql version To install the server and client, go to the Oracle official website to download: # Rpm-ivh MySQL-server-5.5.28-1.linux2.6.i386.rpm # Rpm-ivh MySQL-client-5.5.28-1.

When installing 10g rac on linux 5, you will often encounter the error "libpthread. so.0: cannot open shared object file", which is caused by the failure of vipca. There are two solutions to this error:Method 1Ignore this problem. Select continue,

When installing the Oracle 11g Database, the password setting item is skipped. When you need to use sys and system later, the system always prompts that the password is incorrect. Here, we provide a way to reset these user passwords. Use sqlplus to

Today, I suddenly wanted to use em to input http: // localhost: 5500/em/in IE and found that it could not be opened. Later I thought that the OracleDBConsoleorcl service was not started. So we started the OracleDBConsoleorcl service and found that

Oracle user management========================================================== ============================Create a user whose username is bkjia and password is 88181Creat user bkjia identified by 88181 Change User Password:SQL> password

You can use the package dbms_metadata.get_ddl to view a table or table space DDL. Detailed parameters of the get_ddl function in the dbms_metadata PackageThe GET_DDL function returns the DDL statement of the original data of the created object. The

Database Version: Oracle 11.2.0.2 Operating system version: AIX 6.1   Two operations are performed this time. One is to add the new PV to ASM, the other is to delete the VG that is no longer in use, and add the released disk to ASM.   1. Add unused

Symptom: When installing Oracle Grid11gR2, an error is reported: INS-40904 ORACLE_HOSTNAME Does not Resolve to a Valid Host Name Problem Analysis: The cause is that the ORACLE_HOSTNAME parameter does not parse the valid host name. Solution: 1.

Original article: What to tune in MySQL 5.6 after installationOriginal Article Date: January 1, September 17, 2013Translated on: February 1, June 01, 2014Translated by: Tie WithImprovement on a large number of default optionsMySQL 5.6 has fewer