PHP

Today I upgraded Oracle Database 10.2.0.1 to 10.2.0.5, and then started the database with an error: ORA-01092: ORACLEinstanceterminated. Disconnectio Oracle Database 10.2.0.1 was upgraded to 10.2.0.5 today, and then an error occurred while starting

Scenario: 1. archive is enabled for the database; 2. All archived logs are online after the data file is created; 3. No backup is performed for the data file or tablespace, and no full database backup is performed for the database. Scenario: 1.

Install Oracle11gR2 silently under CentOS5.10 Silent Installation of Oracle 11g R2 in CentOS 5.10 Homepage → Database Technology Background:Read News Silent Installation of Oracle 11g R2 in CentOS 5.10 [Date: 2014-10-10] Source:

Code for creating a shell script instance in Oracle :#! Binbash # ocpyang@126.com # createuserif [$ #-ne4]; thenecho-ee [1; 32 m *** Code for creating a shell script instance in Oracle :#! /Bin/bash # ocpyang@126.com # create user if [$ #-ne 4];

There are more processes in the mongolerac database than in a single instance database. These processes are unique to RAC and are set to implement cluster database functions. This article will be unique to RAC There are more processes in the Oracle

For more information about how to view and remove Oracle blocking sessions, here we will only talk about the operation steps, not the principles. For more information about how to view and remove Oracle blocking sessions, here we will only talk

The MySQL status variable is the system status information accumulated after the current server is started. It is mainly used to evaluate the usage of the current system resources to further analyze the system performance. The MySQL status variable

[Environment Introduction] operating system: centos6.5i686i1_mysql version: MySQL-community-5.1.73-1.rhel5.i386.rpm-bundle.tar [installation step [Environment Introduction] operating system: CentOS 6.5 i686 i386 MySQL version: MySQL-community-5.1.73-

One of the built-in optimization mechanisms provided by Hive includes MapJoin. Before Hivev0.7, you need to provide MapJoin instructions so that Hive can optimize MapJoin. After Hivev0.7 One of the built-in optimization mechanisms provided by Hive

(In the creation of mongouard, run rman recovery when the error ORA-12528 error; configure the database listening for static parameter steps: ORACLE_HOMEnetwork) (In the creation of mongouard, run rman recovery when the error ORA-12528 error;

Oracle databases mainly consist of data file databases and database instance instances. The User links to serverprocess through the user process. When the database is started Oracle databases mainly consist of data file databases and database

Although deleteinput is configured in the script to delete the archive after the archive is backed up, to reduce the disk space occupied by the archive, you can see in the backup log of the RMAN script, from January 1, August 3 Although the archive

Multiple processes can work together to create indexes. Compared with an index created by a single server process in sequence, you need to allocate the work required to create an index between multiple server processes, Multiple processes can work

Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Today, we will paste an Oracle database backup feature that has been implemented very early. This feature

Automatic asmdiskheader backup mechanism after Oracle10.2.0.5 Automatic Backup of asm disk header after Oracle 10.2.0.5 Before Version 10.2.0.5, the ASM disk header is not automatically backed up. You must manually run kfed read or dd to back

ORA-24247 errors when sending messages to external via Oracle11, detailed error messages are as follows: ORA-24247 errors when sending messages to external via Oracle 11, detailed error messages are as follows: Preface: ORA-24247 errors when

There is a new feature in Oracle11g. When the table has no data, no segment is allocated to save space. Oracle 11g has a new feature. When the table has no data, no segment is allocated to save space. Oracle 11g has a new feature. When the

Xtrabackup is an open source backup tool developed by percona, which is different from ibbackup. Ibbackup is a paid backup tool, and Xtrabackup is an open source backup tool developed by percona, which is different from ibbackup. Ibbackup is a paid

If the connected value in CONCAT is not a string, Oracle will try to convert it to a string. Unlike MySQL's CONCAT () function, Oracle's CONCAT () function only supports two parameters. If the connected value in CONCAT is not a string, Oracle will

The nagios graphic interface is still quite troublesome. Let's take mysql as an example. There are many plug-ins for monitoring mysql. Here we will learn about the method, instead of moving hard. 1. Install pnp4nagios refer to nagiospnp4nagios