Database Administrator

The logical structure of a database includes data blocks, zones, segments, and tablespaces. OracleThe data block is ORacleDatabase storage base, which consists of several bytes of disk space. The data block isOracleThe minimum logical unit of the

First download the MySQL installation package, and then install it step by default. In the last step, check the instance Configuration box. Remember to select it. After the installation is complete, the instance Configuration Wizard will pop up

1. Create a tablespace in Oracle Create tablespace tianzh Logging Datafile'/Opt/oracle/oradata/dqjz/jwzh01.dbf' Size 30720 m Autoextend on Next 50 m maxsize 32768 m Extent management local; 2. Expand the tablespace based on the original

MySQL version: Mysql5.5.19 (master) Mysql5.1.59 (slave) During replication from a lower version to a higher version, MySQL restarts repeatedly and a BUG message appears in the error log. Note: For synchronization from a lower version to a

Oracle Data Pump I. Role of Data Pump: 1. implement logical backup and logical recovery 2. move objects between database users 3. move objects between databases 4. Implement table space Transfer Ii. Differences between Data Pump

1. Explain the differences between cold backup and hot backup and their respective advantages Answer: Hot Backup is applicable to databases in the archive mode. When the database is still in the working state, it is backed up. Cold backup refers to

This is the case. One of my servers installed Oracle11gR201, And the grid Infrastructure and Database software were respectively installed by the Grid and oracle users. As a result, when using the dbca tool to create a Database, when the progress

Here we briefly describe two important parameters in the management process: DYNAMICPORTLIST: Specifies the ports that Collector can dynamically allocate.If a firewall is being used at an Oracle GoldenGate target location, additional ports

What is the restoration method for MySQL InnoDB table structure? The following describes in detail the restoration steps of the MySQL InnoDB table structure. If you are interested in this, take a look. MySQL InnoDB Table Structure

It is often encountered that, due to business needs, some summarized data needs to be apportioned to a pile of data according to certain principles.In fact, if the logic is clear, this type of program is better.This article focuses on using a simple

In an application system, the function of running orqcle SQL is provided. Simple SQL statements run normally, and complex SQL statements with subqueries often encounter errors. However, this statement runs in dql plus. For example: ORA-00907: The

We all know what kind of execution method is selected for Oracle SQL statements starting from 10 Gb, whether full table scanning or indexing is based on the execution cost. How can we see the execution cost information? With the 10053 event, Oracle

The following error is reported when you log on to a node in Oracle using an ORACLE account. An error occurred while loading or saving configuration information in gnome-session. Some of your configuration settings may not work properly. An error

Exact match For a single key-Value Pair: {"age": 28}, all documents whose "age" value is 28 are returned. Multiple key-value pairs: {"username": "tom", "age": 28} combine multiple query conditions, equivalent: condition 1 AND condition 2 AND...

The configuration of the Oracle RAC listener is slightly different from that of a single instance, but its principles and implementation methods are basically the same. In Oracle, the tns process is used to provide service registration for one or

Function Returns a non-null value from two expressions. Syntax NVL (eExpression1, eExpression2) Parameters The eExpression1 (e1) and eExpression2 (e2) parameters can be of any data type. If the calculation result of e1 is null, e2 is returned.

ORA-12519: TNS: no appropriate service handler found after Windows 2003 is upgraded to CentOS 5.7. Recently, the company upgraded its system from windows2003 Oracle10.2.0.1 to Centos5.7 x64 Oracle11.2.0.3 x64. Through optimization of the array and

1. The client cannot connect to the database. 2. Check that the database instance status is OPEN and alert_SID.log is correct. 3. The following information is displayed when you view the Database Listener: $ Lsnrctl status LSNRCTL for IBM/AIX assume

In the Oracle10g + rac + raw environment, the error "ORA-12545: connection failed because the target host or object does not exist" is often encountered during multiple connections: After the following statements are executed on the two nodes of

This exercise uses RMAN to create backup sets for various database objects.(1) Use RMAN to connect to the database through operating system authentication in the default NOCATALOG mode. Enter the following command at the operating system prompt:Rman