[DataGuard] DG Series

[DataGuard] DG Series I. New Features of the physical standby Database 1. The physical standby database can be queried in real time. In the physical standby database before the Oracle 11g, the Standby database can be opened in read-only mode, but

Set MySQL database to allow remote connection in Linux

Set MySQL database to allow remote connection in Linux If the following error occurs when you use a client tool to connect to a MySQL database in Linux: Host '192. 168.1.3 'is not allowed to connect to this MySQL server solution: 1. Access the

ORA-27102: out of memory error handling

ORA-27102: out of memory error handling Problem description: Originally, SGA 4G and PGA 2G. Alter system set sga_max_size = 30G scope = spfile; Alter system set sga_target = 30G scope = spfile; After, SQL> shutdown immediateDatabase closed.Database

Debugging record of MySQL storage function error [Err] 1064

Debugging record of MySQL storage function error [Err] 1064 1. An error is reported when a user creates a storage function.Create definer = 'root' @ 'localhost' FUNCTION 'stuff '(F_old varchar (1000), f_start int, f_length int, f_replace varchar (100

Having is different in Oracle and MySQL.

Having is different in Oracle and MySQL. In Oracle, having must be used in combination with group by, but in MySQL, the situation is different and can be used separately. C: \ Documents ents and Settings \ guogang> sqlplus test/testSQL * Plus:

Delay Section Function of Oracle 11gR2

Delay Section Function of Oracle 11gR2 In versions earlier than 11gR2, when creating a table, the segment space is automatically allocated, which has several drawbacks: 1. space needs to be allocated during initial table creation, which naturally

Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example

Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example1. Solve the problem: TNS or the database cannot log on.The simplest and most effective method: use the tool netca provided by the Oracle System to configure (delete the

How to Use sqlplus-prelim in Oracle hang

How to Use sqlplus-prelim in Oracle hang In many cases, Oracle hang causes sqlplus to be unable to connect, and thus the Oracle system and process status cannot be obtained, which leads to a lack of a strong foundation for locating the problem.

Create a Neo4j Cluster Environment

Create a Neo4j Cluster Environment Introduction: Neo4j is currently the mainstream graph database. It also provides highly available cluster solutions. This article will try to build a highly available Neo4j environment. 1. What is graph

Binlog Processing Method for MySQL DATA

Binlog Processing Method for MySQL DATA Recently, the disk has grown very fast and it is found that binlog logs occupy a large amount of disk resources. We use manual cleanup, and set Automatic cleanup later. View the specified deletion log Mysql>

MySQL builds a replication environment with filtering

MySQL builds a replication environment with filtering The Organization is preparing to launch some new functions. These functions have nothing to do with the functions of the original production database module and are ready to create a new database

Oracle has ORA-01775: A synonym loop chain problem

Oracle has ORA-01775: A synonym loop chain problem 1. When you use a program to connect or use plsql to query synonyms, if there is a problem like ora-01775: the loop chain of synonyms. It is generally because there is a synonym, but there is no

PowerDesigner 15 Overview

PowerDesigner 15 Overview1. Introduction to PowerDesigner PowerDesigner 15 is a CASE (Computer-Aided Software Engineering) tool integrated with Enterprise Architecture Analysis, UML (Unified Modeling Language), and data modeling launched by Sybase.

How to enable and enable autotrace for Oracle tools

How to enable and enable autotrace for Oracle tools Platform: Oracle 10g RHEL-5.8 The procedure is as follows: 1) sys @ ORCL> @ $ ORACLE_HOME/sqlplus/admin/plustrce. SQL 2) sys @ ORCL> grant plustrace to public; Description of several common

Oracle OWB introduces series 1 introduction and use process

Oracle OWB introduces series 1 introduction and use process OWB, Oracle Warehouse Builder, is a tool for oracle to implement data warehouses. To put it bluntly, it is to clean and convert data from many other databases and load it into a data

The Oracle 11g empty table cannot be exported.

The Oracle 11g empty table cannot be exported. The deferred_segment_creation parameter is added to the Oracle 11g. The default value is true when the database is created. This parameter means delayed loading. When no data exists in the table, no

Use SPFILE to reset the configured initialization parameters to the default values of the system.

Use SPFILE to reset the configured initialization parameters to the default values of the system.Start with SPFILE. If you want to restore the initialization parameter to the default value, use a statement like this:Alter system reset db_create_file_

Oracle transaction processing and instance demonstration JDBC operation batch Deletion

Oracle transaction processing and instance demonstration JDBC operation batch Deletion Transactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database

Processing of ORA-1455 errors reported when Oracle 11g exports data

Processing of ORA-1455 errors reported when Oracle 11g exports data About the handling of ORA-1455 errors when Oracle 11g exports data, this exception may occur because the exported User table may have a NULL data table. First: View: SQL> show

How to Use RMAN to identify corrupted objects in the database

How to Use RMAN to identify corrupted objects in the database How to Use RMAN to identify corrupted segments in the database. Solution: Step 1: identify bad Blocks Run the following RMAN command to record all bad block information in the v $

Total Pages: 1013 1 .... 428 429 430 431 432 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.