Database Administrator

This article explains why we should understand Database Consistency detection (DBCC) and how to run DBCC and apply its five extensions. Database Consistency detection (DBCC) may be your most important tool in critical moments. This article briefly

We usually add the with-openssl option when compiling MySQL, but this does not mean that MySQL already supports OpenSSL connections. We can use the following command to check the connection:Show variables like 'have _ openssl ';If DISABLED is

When tomcat is started, the system prompts that port 8080 is occupied. After searching, the following conclusions are found:Install other servers that use port 8080, such as Oracle, tomcat, and jboss, on one machine. The error 8080 port is

1 because orcale10 does not support RHEL5, you need to change/etc/redhat_real.pdf to Red Hat Enterprise Linux Server release 5 (Tikanga) to Red Hat Enterprise Linux Server release 4 (Tikanga)2. Modify the/etc/hosts file to change 127.0.0.1 to your

You may not have used the advantages of these details when optimizing your database. The following are 10 questions about your database performance. Ask yourself.1. assume that your database does not need the ability to store special characters,

Procedure:Open PowerDesigner-> menu bar "Database"-> Database Reverse Engineering-> Using an ODBC data source, select Browse-> connect to an ODBC Data Source-> Machine data source select the data source you configured.(Note: If you need to configure

1. Export the entire databaseMysqldump-u username-p Database Name> exported file nameMysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL2. Export a tableMysqldump-u user name-p database name Table Name> exported file nameMysqldump-u wcnc-p smgp_rj_wcnc users>

RedHat Linux 9.0 is a very good Linux release version with good Chinese support and rich application software, so that many Linux users, including the author, can't help it. However, due to the high GCC version used by Redhat9.0, some compatibility

Question 1:ERROR at line 1: ORA-29538: Java not installedSolution1. Check whether JAVA components are installed.Select * from v $ option t where t. PARAMETER = 'java ';If the returned row is installed, run Oracle Universal Installer to install the

Set the mysql installation directory to system environment variables to facilitate direct execution on the command line terminal. After mysql is installed in linux, the default root password is blank. You can directly log on to mysql. Normal logon

1. Use of DBMS_JOB packageThe DBMS_JOB package is used to arrange and manage job queues. By using jobs, the Oracle database can regularly execute specific tasks.Note: When you use DBMS_JOB to manage jobs, you must ensure that the initialization

The principle and script are both very simple, that is, whether the Slave_IO_Running and Slave_ SQL _Running values in the synchronization state are both Yes. If not, send a text message to the police. [Root @ mysqlb script] # cat

Background A typical operation of a log-type application involves a large number of insert Operations periodically. This type of operation requires extended tablespace. Analysis In InnoDB, the extended tablespace operation is called directly by

Large data tables in the Oracle database are partitioned to improve data reading efficiency: In PLSQL, directly add the Code: -- Purpose: to partition and convert large table data. In this example, only 5000 pieces of data are used;-- Create Table

I am familiar with MongoDB because I recently tested MongoDB. MongoDB is still simple, and I have mastered a lot of content in just one week. It is much easier than other databases. I installed: MongoDB version 2.0.8 System: 64-bit Ubuntu

Assume there are two data types: (Table Name: user) 1) username = admin, password = 000000 2) username = admin, password = 123456 The effect we want to achieve is that you can enter multiple keywords for query. Multiple keywords are separated by

Merging Partitions Use the alter table.. merge partition statement to MERGE the content of the two partitions into the other PARTITION. Both the source partitions and the associated local indexes will be dropped. Cannot be used for hash partition

Today, when deploying Oracle Summit Demo to a standalone Weblogic, ORA-01005 exceptions are reported, and running in Integrated Weblogic is always normal. The main exception Log is as follows: #### WatchRuleType: LogWatchRule: (SEVERITY = '

1. Source Code download and preparationPostgreSQL uses the flex and yacc scripts respectively for lexical and Syntax Parsing, that is, the. l and. y files in the source code are generated by them. c and. H files.For more details,

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time