PHP

Common Oracle Database faults: 1. system faults: sudden power failure during server operation, system restart caused by operating system errors, and other faults. Problems: Internal Common Oracle Database faults: 1. system faults: sudden power

Today to do Linux under the DG configuration, encountered a phenomenon, tnsname. ora file configuration are normal, tnsping is also normal, listening is also normal, but still reported ORA-12514 error: Today to do Linux under the DG configuration,

A ORA-12516 error occurs when you use swingbench to perform a stress test on the oracle database. This error is generally reported because the number of oracle sessions exceeds the limit. A ORA-12516 error occurs when you use swingbench to perform a

When developing an Oracle testing environment, companies sometimes need fake data to test the functions and performance of applications. It is really troublesome to manually enter a bunch of SQL statements every time, just recently Learning When

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 database on server B ( This document records an Oracle Data Import experience for future review.

Because the customer's database needs to be patched, similar test environments are installed. Install OracleRAC10.2.0.1 before upgrading to 10.2.0.5. Because I have many articles about security Because the customer's database needs to be patched,

This script starts four channels, each of which reads 10 Gb segments of 16 data files. Each channel will generate copies of segments (separate physical files ). If the file is This script starts four channels, each of which reads 10 Gb segments of 1

Automatic undo Management (AUM) requires almost no configuration. Basically, you only need to define the time needed to keep the previous image available. This is through Parameters Automatic undo Management (AUM) requires almost no configuration.

Use the EXPIMP derivative tool to set the client character set. The client character set is completed by setting NLS_LANG (language_territory.clientscharacterset ). Note the setting of the client character set when using the EXP/IMP derivative tool.

Currently, the Oracle optimizer uses the cost-based cbo method to optimize SQL statements. Therefore, the optimizer's judgment relies heavily on the statistical analysis information of database objects. Only available Currently, the Oracle optimizer

Profile file or. bash_profile file (system-level environment variable file: homeOracle); oratab file (oracle self-run file: etcoratab); in Profile file or. bash_profile file (system-level environment variable file:/home/Oracle); oratab file (oracle

Oracle prompt error message ORA-28001: thepasswordhasexpired, caused by new features of Oracle11G, Oracle11G default password expiration restrictions when creating a user Oracle prompt error message ORA-28001: the password has expired, due to new

The oracle database has an internal initialization parameter instance_name, which is used to indicate the name of the database instance. The default value is usually oracle_sid. However, the initialization parameter ins The oracle database has an

Install the MySQL-Cluster7.3.4 Process notes on CentOS6.5 (for 2 days to find various materials for hands-on test results ). CentOS6.5 + MySQL-Cluster7.3.4 (latest GA Install MySQL-Cluster 7.3.4 Process notes on CentOS6.5 (two days to search for

1. Oracle control file multiplexing 1. showparametercontrol -- View Control File Information showparameterspfile -- check whether spfile exists 1. Oracle control file multiplexing 1. show parameter control -- View control File Information show

OracleGoldenGate is a log-based copy and backup software for structured data. It parses the online logs or archive logs of the source database to obtain incremental data changes. Oracle Golden Gate is a log-based copy and backup software for

When a MySQL-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is an effective way to get help When a MySQL-related fault occurs in the

During the design of the Oracle table, developers always disagree with the field type. The following example shows how to design the field as number and the result is varcha. During the design of the Oracle table, developers always disagree with the

After the Oracle database is started, you can use the select * fromv $ parameter statement to view all the parameters used by the Oracle database. For Oracle parameter files After the Oracle database is started, you can use the select * from v $

Oracle configuration sharing server: 1. Configure the second listener netca Manual: listener. oraLSNR_2 (DESCRIPTION_LIST (DESCRIPTION Oracle configuration sharing server: 1. Configure the second listener netca/manual: listener. ora LSNR_2 =