Database Administrator

For the installation process of Oracle 9i in Ubuntu, refer to this article. This article is mainly based on kubuntu to install Oracle 10g. Refer to this article to easily install 10g, however, oracle 9204 has encountered many obstacles and the

When you encounter an error "cocould not start the service MySQL error: 0" when installing or reinstalling mysql, you can try the following two methods. I. method 1 When installing MySQL, the error "cocould not start the service mysql error: 0" is

I encountered a problem during development a few days ago. During the debugging process, I found that the transaction configured on the service layer does not work. After an exception is thrown, the database is updated successfully and the

GXPT is a distributed system that temporarily includes the permission system, basic system, evaluation system, and examination system. Each system has its own oracle database. Our group is responsible for the evaluation system, and the normal

Extract Process recovery Principle BR Applicable to Extract processes (for Oracle databases only) You can use the BR parameter to control the Bounded Recovery (BR) function of GoldenGate. The Bounded Recovery function only supports Oracle databases.

The EBS system password is divided into four types. The change of password must comply with the regulations and specifications, especially backup.1. Operating System users, such as root, ora, appl, and grid users.[Modification method] use the OS

I received a development email last night, saying that the following error was prompted when I used PL/SQL DEV to log on to the database: I am also depressed when I see this error. I have never encountered this situation. So we created a test user

The B + tree is a classic data structure generated by the combination of the Balance Tree and the binary search tree. It is a balanced search tree designed for disks or other direct access devices, in the B + tree, all record nodes store the key

When sorting operations, re-indexing, and other large operations cannot be completed in the memory, the temporary tablespace will facilitate sorting. Generally, temporary tablespace is shared by multiple users and multiple sessions. The quota cannot

In some cases, you need to associate different databases for Data Query and operations. In Oracle, database links are used to associate tables with different databases ). There are two ways to create a DB link: Creating an SQL statement and creating

MariaDB is installed on CentOS 6.5 By chszs, which must be noted in the reprint. Blog homepage: http://blog.csdn.net/chszs1. software environment: CentOS 6.5x64MariaDB 5.5.362. Installation Process 1) Create the MariaDB. repo file in the/etc/yum.

1. Install phpPgAdminDecompress the downloaded package Run the following command for tar.gz: Copy codeThe Code is as follows: gunzip phpPgAdmin-* .tar.gzTar-xvf phpPgAdmin-*. tar Run the following command for tar.bz2: Copy codeThe Code is as follows:

I received an email this morning and saw the failed rman recovery email sent by Master. The content is as follows:   The data has been decompressed. Under/orabak/Oracle_bak However, an error is always reported when the backup file is read during

Those of us who use Rails will not be surprised when they see 5. weeks. from_nowor3.days.ago + 2. hours. Similarly, PostgreSQL can also achieve the same functionality by simply calling the built-in functions of PostgreSQL. PostgreSQL deletes

Oracle 12c R1 physical standby uard physical standby database enable real-time apply The physical standby database is always in the mount state, which is inconvenient for Data Synchronization verification. Enabling real-time apply enables real-time

Cold backup (off, slow, time point recovery)Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. Cold backup is a way to copy key files to another location.

When Data guard is used as the HA solution, one problem to be solved is that the master-slave switchover occurs in the background database. How can the client connection be automatically switched to the new primary database? For general solutions,

When the application redo log is started, the redo log is canceled when the application is disabled:8.1 Starting Up and Shutting Down a Physical Standby Database This section describes the SQL * Plus statements used to start up and shut down a

8.3 Managing Primary Database Events That Affect the Standby Database8.3 Managing the master Database can Affect the Events of the slave Database To prevent possible problems, you must be aware of events on the primary database that affect a standby

Oracle Data Guard is an important component of the Oracle HA Architecture system and a key technical solution for Maximum Availability Architecture. With the Switchover and Failover features of Data Guard, we can achieve high availability