Database Administrator

SPFILE causes Oracle Database startup failure After the server is powered off and restarted, it is reported that Oracle Database Service cannot be started, on the server to use as sysdba login to connect to a null instance, use startup times 'ora-24

After MySQL is installed, only the following hosts are recognized: localhost and 127.0.0.1. The only hosts recognized after MySQL is installed are localhost and 127.0.0.1. If you want to allow the IP address on your machine to log on normally, there

Oracle uses with as and hint materialize to optimize SQL to solve low FILTER efficiency During project creation, a page uses SQL statements similar to the following to query data, I replaced the table name and field in the project with the system

Oracle Spatial Database Function usage Recently, I have been using Oracle's spatial database for some spatial data processing and analysis functions. I wrote this article mainly to take notes. After all, good memory is not as bad as writing. First,

Detailed description of the installation process of Oracle 11g Database in Linux Oracle11g database installation specification in LinuxI. Instructions on downloading Database Installation Software (including patches) How to install software in

Dual in Oracle For Oracle dual, we need to clarify the following points: First pointDual is not a acronym but a complete word. Dual refers to logarithm, Which is dual and dual when used as an adjective. Second pointThe dual table in Oracle is a

Database paradigm explanation The design paradigm of databases is the specifications that need to be met by database design. databases that meet these specifications are concise and have clear structures. At the same time, there will be no insert or

Solution to impdp exceptions and interruptions Check the database load today and find that the cpu consumption is abnormally high. There are many dw processes, but the impdp process does not exist.Check the process of datapump and find a large

Undo tablespace and redo logs Differences between undo and redo and their respective functions 1. Features of undo data: 1. It is a backup before data modification, mainly to ensure the user's read consistency 2. generated when the transaction

Oracle Database Development In the Oracle database system, tables are the basic objects of databases, and all data in the database exists as tables. Environment-Oracle 11g I. Table typeCommon tables in Oracle Database systems include: heap

Full version of MySQL5.6 cluster configuration under Redhat6.5 1. Prepare three servers 2. Install the Linux operating system for the three machines respectively (Oracle Linux/RHEL 6.5 x86_64bit) 3. Separate IP addresses Management node 192.168.1.110

[Oracle] ROWNUM and paging Rownum is a poor Oracle database, and its order increases progressively according to the order in which records are obtained from the table. Note that because records are stored unordered In the table, therefore, you

Clever Use of xmltype to parse clob data For clob data, xml format is used in many cases, but data query and processing is always insufficient. When conditions permit, if xmltype can be cleverly used for data processing, it is accidentally a

How to solve the problem that the maximum number of MySQL connections exceeds the limit Recently, the User database name has already more than 'max _ user_connections 'active connections error is reported on the website. It is necessary to study

[Translated from mos] When the parallel transaction recovery process is running, disable the parallel transaction recovery method. When the parallel transaction recovery process is running, disable the parallel transaction recovery method.How to

[MySQL] Innodb parameter optimization, mysqlinnodb Innodb_buffer_pool_size The innodb_buffer_pool_size parameter is used to set the Innodb primary Buffer (Innodb_Buffer_Pool), that is, the primary cache space for caching user tables and index data,

Chapter 1 Securing Your Server and Network (3): Use the managed service account, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

Abmr: test the automatic block Recovery feature and abmr test feature Abmr: test the automatic block Recovery feature Reference Original:ABMR: How to test Automatic Block Recover Feature (Doc ID 1266059.1) Applicable:Oracle Server-Enterprise Edition-

After running utlpwdmg. SQL, ORA-28003, ORA-20001, ORA-20002, ORA-20003 error, ora20002 ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 error reported after running utlpwdmg. SQL. Applicable:Oracle Server-Enterprise Edition-Version 8.1.7.0 and

Oracle GoldenGate (hereinafter referred to as ogg) synchronizes data between databases of the same type on Heterogeneous OS ., Goldengateogg Oracle GoldenGate (hereinafter referred to as ogg) synchronizes data between databases of the same type on