Database Administrator

I have just been in touch with Linux for less than a week. I just sorted out several videos from the Internet and watched and learned. If you have time to do something by yourself today, you can use a connection provider ------- to deploy the mysql

In Oracle Data Guard, the Redo Gap is generated because of some network or other problems, resulting in the interruption of the redo transmission. After the fault is eliminated, these redo files that have not been transferred will be discovered by

1. Cause This error will always occur when you recently perform some Oracle operations: ORA-06502: PL/SQL: Number or value error: string buffer is too small with the following error: ORA-00604: recursive SQL Level 1 error ORA-06502: PL/SQL:

After viewing the request and clicking Diagnostic, there is a View XML button, which is sometimes available and sometimes grayed out. Why? Two preparations are required to enable View XML: 1. Output must be XML: After the Output Format is

Substr () function: returns part of the string.Syntax: substr (string, start, length)Required: specifies where the string starts.Positive number-start at the specified position of the stringNegative number-starting from the specified position at the

Because we often perform a lot of changes to the mysql database, such as modifying fields, adding or deleting indexes, we put these operations into SQL statements and then log on to mysql, execute this SQL file using source. In order to keep

Both Oracle and mysql databases provide powerful date formatting formats. This article compares the formatting characters of the two databases for your reference: Common Format String Mysql: DATE_FORMAT (now (), '% Y-% m-% d % H: % I: % s

Environment: Oracle 11g R2 + SQLPlus Problem: Oracle SQL Import Solution: Win + Run -------> Cmd -------> enter the following command: -- Syntax: sqlplus user name/password @ SQL File  Sqlplus system/manager @ H: \ Oracle \ product \ 11.2.0

RAW-format tablespace Resizing in data. The procedure is as follows:View existing bare devices # cd/dev/raw # ls-rtlCheck the raw device size/View previous lvSize # blockdev -- getsize/dev/raw/raw3720488192 # blockdev -- getsize/dev/raw/raw3820488192

[Oracle @ node1 pfile] $ export ORACLE_SID = MRAC1 [Oracle @ node1 pfile] $ sqlplus/as sysdba   SQL * Plus: Release 10.2.0.1.0-Production on Thu Sep 27 10:27:35 2012   Copyright (c) 1982,200 5, Oracle. All rights reserved. Oracle Database 10g

Integrity and consistency are the core content of a database in business applications. MySQL uses the InnoDB engine to implement transaction processing ), therefore, more checks and restrictions are required for data tables using the InnoDB engine.

1. display the current configuration information======================================1.01 RMAN> show all;1.02 check non-default values in RMAN settings:SQL> select name, value from v $ rman_configure; -- before 11gSQL> SELECT CONF #, NAME, VALUE

Today, we help you modify a report, and design the warehouse receiving and warehouse receiving operations in it. We need to list the Daily portal information of each product. This may happen: 1. The product has data in the warehouse receiving table,

PL/SQL 9.2 cannot connect to the Oracle database. When the system is installed with Oacle 11 GB and the client is installed with Oacle 10 Gb, when pl/SQL is used to connect to the database, the connection fails. The reason is that the oracle home

The following error is always reported when you manually configure the Oracle 11g EM: WARNING: ORA-00001: unique constraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violatedORA-06512: at "SYSMAN. EMD_LOADER", line 4986ORA-06512: at line 1 No solution was

In a single instance, to modify a data block, the process must modify it on the Current copy of the data block. The same is true for RAC environments. This involves a series of problems: How to obtain the distribution chart of data block versions

After installing the asm rpm package today, the last step of configure always fails when running/etc/init. d/Oracleasm configure: [Root @ localhost nick] #/etc/init. d/oracleasm configureProcessing the Oracle ASM library driver. This will configure

Sometimes we have such an application. In SQL left join, we need to make a column with a NULL value not return NULL, but a specific value, such as 0. At this time, using is_null (field, 0) will not work, and an error will be reported. It can be

Related Parameters and export examples: 1. DIRECTORY Specifies the directory where the dump and log files are located DIRECTORY = directory_object Directory_object is used to specify the DIRECTORY object name. Note that the DIRECTORY object is an

The big data mentioned here is relatively speaking. The data size used in the experiment is 4 GB... First, describe the situation. First, use vmware workstation 9 to create a virtual machine and install CentOS 6. Then, download the online