Oracle 11gR2 uses RMAN to copy full-database records
Oracle 11gR2 uses RMAN to copy full-database records
TNS and listener are configured on the source and target ends (11g dynamic listening sys cannot log on in nomount status, and static listening
Process interruption caused by connection interruption between OGG-01031 and OGG-01232 and target host
Error reported by Extraction Process:06:03:05 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys
The rman backup script in the Oracle database is very practical.
The rman backup script in the Oracle database is very practical.
Query character sets
SQL> select * from nls_database_parameters;
NLS_CHARACTERSETAL32UTF8
Character Set is very
Deploy multiple MySQL instances on a [DELL R720] Server
Deploy multiple MySQL instances on a [DELL R720] Server
I. Prepare for installing mysql
1.1 download the mysql package
Mkdir-p/home/xuekun/mysql
Cd/home/xuekun/tools/mysql
Wgethttp: //
Configure the snmp service in linux and snmp in linux-- How to Configure snmp on Linux-- Attach an iso CD image file firstMount-o loop/soft/rhel-server-6.4-x86_64-dvd.iso/mnt/cdrom-- Check whether the snmp package is installed first.# Rpm-qa | grep
CentOS6.5 install mysql cluster7.3.7 to build a mysql database cluster environment (dual-Management Center), centos6.5 install mysqlMySQL Cluster is a technology that allows you to deploy the "in memory" Database Cluster in a non-shared system.
MySQL Study -- MySQL schema_information database, mysql database schema
MySQL Study-MySQL schema_information Database
The information_schema database is generated after mysql 5.0. A virtual database does not exist physically.
The information_schema
Learning MongoDB 5: MongoDB query (array, embedded documentation) (2), mongodb embedded1. Introduction We introduced db in the previous article. collection. find () can be used to query conditions and specify fields returned by using the projection
In oracle, what happens when a value in date time format is inserted into a field in varchar2 format ?, Oraclevarchar2
-- Create Table test1
Create table TEST1(ID VARCHAR2 (40) default sys_guid (),TDATE VARCHAR2 (200))Tablespace APP_TX_DATAPctfree
Oracle Exadata All-in-One and cloud computing applications (I), oracleexadata1. Exadata
1.1 Introduction to Oracle cloud computing
As the cloud computing infrastructure continues to mature, more and more enterprises are paying attention to the
Oracle calculates the total (very useful), oracle1-12 for 1-12 months of a yearCase studies
Query the total number of real population from January 2015 to 12 months and the number of real population from January 2014 to 12 months in previous years.
SQL statement Optimization-query different rows of the two tables NOT IN, NOT EXISTS, Join query Left Join, existsleft
In actual development, we often need to compare the differences between two or more tables and compare the data that is the same
Addnode. sh failed, log file error PRKC-1025 & java. lang. OutOfMemoryError: Java heap space,Environment:
Linux 5.5 + RAC 11203
Problem description:
The command to add a cluster member is as follows:
$ GRID_HOME/oui/bin/addNode. sh-silent
[Use rman to copy the Database 10 Gb -- clone-1], rman10g -- clone-1
Target Database: jadl0g
Replicated result Database: d10g
Note: *** the target database and clone result database are on the same host ****
1.
Sqlserve Data Type Details, sqlserve Data Type
Decimal exact numeric typeThe decimal data type can be used to store the fixed precision and range of numeric data of 38 power-1 to 10 from-10. When using this data type, you must specify the range and
Use mysqlbinlog to extract binary logs and mysqlbinlog binary logs
The MySQL binlog log records all changes to the current database since the MySQL database is enabled. Binlog logs are binary files. We can extract binary logs to generate readable
PL/SQL cursor usage, plsql cursor usageZookeeper
Use of cursors
① Cursor ConceptTo process SQL statements, ORACLE must allocate a region called context area to process required information,This includes the number of rows to be processed, a pointer
Monitor the remaining time of SQL Execution, and monitor the remaining time of SQL
-- Monitor the remaining time of SQL Execution. Do you know how long the running SQL takes? Do you know that the running SQL statement has completed about a few
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.