MySQL master replication + Keepalived to create a highly available MySQL Cluster In response to the company's needs, we have created a safer mysql cluster to implement mysql failover. After several days of research, we can finally share the results.
Use GoldenGate to synchronize data from MySQL to Oracle in real time Use GoldenGate to synchronize data from MySQL to Oracle in real time Step 1: Configure mysqlModify the configuration file my. ini# For goldengateLog-bin = "C:/mysql/logbin.
Signalled during ORA-1031 Error message: ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize unlimited... Problem description In the newly deployed Oracle environment, a designer user needs
Solutions to frequent sleep processes in MySQL The company has a Linux server dedicated to running the company's WEB services. due to historical reasons, there are a large number of sites and pages, which often lead to a large number of sleep
Oracle online extended partitions In the Oracle Partition Table operation, when a partition already has the largest partition, how can we expand the partition again? The simple method is to delete the maximum partition first, then add the required
ORA-16014: Log 1 serial number 242 Unarchived, no available destination SQL> alter database open; *Row 3 has an error:ORA-16014: Log 1 serial number 242 Unarchived, no available destinationORA-00312: Online log 1 thread 1:'C: \ Oracle \ PRODUCT \ 10.
Oracle uses regular expressions for four main functions Oracle Regular Expression functions: regexp_like, regexp_substr, regexp_instr, regexp_replace Oracle uses regular expressions for four main functions: 1. regexp_like can only be used for
ORA-12516 TNS: Listeners cannot find available handlers that meet protocol stack requirements Problem scenario: A previous database was used for testing (department A). Last night, another test department (Department B) came to test the program.
ORA-12519 error process error After the system runs normally for one month, the following error occurs on the first day of the launch. After a long time, you have no idea. Later find the database listening exception, found that ORA-12519 rejection
Relationship between Oracle instances and databases Databases are physical and physical storage of data. They consist of files stored on disks, including control files, data files, and redo log files; The instance is logical and consists of the
Brief Analysis of Oracle execution plan 1. How to open the execution plan: Turn on the Execution Plan (execute set autotrace traceonly/off) and if you are prompted for a SP2-0611, SP2-0618, follow these steps to create the appropriate user. 1. log
Oracle configuration file Introduction Profile file or. bash_profile file (system-level environment variable file:/home/Oracle ); Oratab file (oracle self-run file:/etc/oratab ); InitSID. ora or spfileSID. ora file (database instance initialization
Configure DataGuard to report to ORA-12528 (In the creation of DataGuard, run rman recovery error ORA-12528 error; The script is as follows: RMAN> connect auxiliary sys/Oracle @ SCMPRD02 Solution: 1. Check whether the listener is started. Script:
ORA-16753 error troubleshooting 1. Use dgmgrl to set the database to read-only mode: DGMGRL> edit database dg_name set state = read-only; ORA-16753 Resource guard cocould not open standby database Cause: Resource guard cocould not open standby
Oracle uses TRACE for SQL Performance Analysis If the SQL _trace parameter is set to true, the entire instance will be tracked, including all processes: User processes and background processes, which may cause serious performance problems and must
Oracle NET configuration and working principle Oracle NET is a software layer that supports conversion between different network protocols. Different physical machines can communicate with each other through this software layer, specifically
Oracle implements function-based indexing Use Cases:When a query runs slowly. By checking the where clause, it is found that the SQL lower function is applied to a column, and the lower function prevents the use of existing indexes on the column.
Oracle imports data to another database through the data pump network without generating DMP files This document records an Oracle Data Import experience for future review. Because the project needs to import the database (USER1) on server A to the
Create a tablespace in Oracle and test it with the user The Oracle tablespace is described as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory, but
Oracle Character Set Analysis There are many types of character sets. The first character set was ASCII. Since the number of characters supported by ASCII is very limited, many encoding schemes, such as Unicode, were introduced later. Unicode is a