Database Administrator

1. even if the autoReconnect = true parameter is added to the url when Mysql is created, communication will still occur if the connection time exceeds the wait_timeout time limit on the server side: the last packet successfully received from the

1. OS and DB versions Oracle Version: 11.2.0.2 Operation System: HP-UXItanium 11.312. Alert log Information Tue Oct 22:27:31 2012 Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0xC00000000] [PC: 0x400000000631B880, evaopn3 () + 384] [

Oracle provides a series of predefined exceptions in the STANDARD package. They are useful tools for debugging Oracle PL/SQL programs. For most errors, the negative number is used as the error number. You can use the SQLCODE built-in function to see

Recently, a zabbix monitoring system has been set up in the company. Now we need to use zabbix to monitor the master-slave synchronization of mysql. Now let's take a look at the detailed configuration steps: 1. First assign a monitoring account to

You can set some Oracle database-related settings and backup policies. For example, you can set the concurrent data streams transmitted to the disk drive. You can set the degree of parallelism for disk backup Based on the CPU configuration of the

I analyzed the ORA-00600 error and found that there was a slight change in the Oracle 11g and Oracle 10g syntax, I hope to help everyone! Oracle 10 Gb execution results $ Sqlplus/as sysdba   SQL * Plus: Release 10.2.0.1.0-Production on Thu Nov 1

To eliminate the connection problem between the client and the server, first check whether the client configuration is correct (the client configuration must be consistent with the database server listening configuration), and then solve the problem

The scenario is as follows: All the original table data is stored in the users tablespace. Now you need to replace the tablespace with the ntbs tablespace. When moving, tables with blob, clob, and long types fail to be replaced. Why? Because blob

System Environment: CentOS 6.3 Server Windows 7 Client The IP addresses are 10.1.4.44 server and 10.1.4.180 client respectively. 1. Check whether MySQL is installed? [Root @ Web_Mysql ~] # Rpm-qa | grep mysql   2. Install MySQL using YUM: [Root @

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

1. Install the patch package required by Oracle11g, which is available on the installation disc. Enter the Server Directory of the disc: (it is best to use the official oracle documentation to determine which packages need to be installed) 2. Modify

DRBD: distributed replication block DeviceDRBD --- Distributed Replicated Block Device is a Linux-based software component composed of kernel modules and related programs. It facilitates replacement of shared storage systems through network images.

The following is my first complicated MySQL stored procedure, which is hereby recorded: -- Delete a stored procedure Drop procedure if exists proc_update_term_group; -- Create a stored procedure DELIMITER // Create procedure

Introduction: Oracle locks will have an uncertain feeling when I first came into contact, just as distant aliens could not see but feel it, I encountered a ORA-00054 in my actual work: resource busy acquire with nowait specified error cannot be

I. Redo Log Concept 1. What Is the Redo Log? Redo Log is used to protect the data that modifies the database but is not written into the data file. Redo logs are classified into Online Redo Log (Online Redo log) files and Archived Redo Log (Archived

Oracle Database versions are 11.2.0.1.0 and the operating system is WIN2008 (64-bit). When importing data from server A to server B using impdp, an error is prompted: Features not enabled for the ORA-00439: DEFERRED_SEGMENT_CREATION. 1. Check

Introduction to Partition Partitioning refers to splitting a very large table or index into smaller and manageable logical segments-partitions based on the value of a column. Partitioning a table or index does not affect SQL statements and DML

1. Common Query This is a common and common application scenario of OracleText. Create an index of the Context type in OracleText and generate a large number of keywords to speed up operations similar to common like '% xx %' or query large documents.

This problem occurs when Oracle exp exports tables and data (when the 10g client is used to export 11g tables and data everywhere ); The solution is as follows: 1. Set the value of deferred_segment_creation to false. This method is only valid for

Environment Planning: 1. Hardware: 1.1 node HOST: ESX4.1 creates two hosts with the same configuration. Each computer has two independent NICs. The addresses of each NIC are shown in the table above. 1.2 Storage devices: Log on to the ESC4.1