Oracle

A friend came to me and said they had switched the previously stored to AIX direct-attached storage to a storage network with a fibre switch, and the RAC failed to start, allowing me to support it. The analysis was due to the incorrect start of the

The database alert log appears ORA-20011 KUP-11024 errorsThu Sep 22 18:00:31 2016Dbms_stats:gather_stats_job encountered errors. Check the trace file.Errors in

Prior to 11.1, many people might have known that Oracle database history passwords could be restored through alter user identified by values password, but several problems occurred in 11g:1. Dba_users no password record (null value), this problem

Oracle 11g Installation Prior to installation to determine their own computer configuration, in Windows, for example, if it is Win7 the following systems such as XP, you can choose Oracle 10g. Because the 10g program files only 200 trillion, and

For SQL languages, there are two components: DML (Data Manipulation language): They are select, UPDATE, INSERT, DELETE, just like its name, these 4 commands are the languages used to manipulate the data in the database. DDL (data Definition Language)

Single-record functions in SQL 1.ASCII returns the decimal number corresponding to the specified character; Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual; A A ZERO space --------- --------- --------- ---

A customer's 11.2 RAC for Linux x86-64 environment fails after a power outage and the RAC environment does not start automatically. After you log on to the database server, you discover that the cluster process exists and then try to start the

[Oracle] [Standby] [PDB] Modify parameters in PDB, set range to SPFILE, report ORA-65099 errorIn the data gaurd Standby (or CDB is Read only), under the PDB, the following SQL error is executed:sql> ALTER SYSTEM SET sga_target = M SCOPE =

Configuring the EnvironmentOracle Service SideOracle_winx64_12c_database.isoOracle ClientInstantclient-basiclite-nt-12.1.0.1.0.zipIntegrated development EnvironmentPL/SQL Developer 10.0.5.1710Configuration stepsMake sure that Oracle has completed

First, the advanced level of PL/SQL-control structureIn any computer language (c,java,pascal) there are various control statements (conditional statements, loop structures, sequential control structures ...), and there are also such control

Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7)This article presents what to install the Oracle 11G on Oracle Enterprise Linux 7 (OEL7).read following article How to install Oracle Enterprise Linux 7: install Oracle Linux 7 (OEL7)  

Excerpt from the VLDB and partitioning guide1. Introduction to the ViewV$px_buffer_adviceProvides historical usage of buffer for all parallel queries, as well as related proposal planning. For problems such as insufficient memory during parallel

Application Scenarios:this week in the SIT, I help one of the only Test sisters. Data quality verification for some tables, the first step is to compare the table definition of the source and stage tables with the Consistency of data content. This

In Oracle, the WM_CONCAT function is an aggregate function similar to the GROUP_CONCAT function in MySQL, but the Group_concat function is powerful and can define delimiters and sorts, and of course the so-called strong is relative, If we don't know

? Use SQL Optimization guidance for:– Identify the SQL statements that use the most resources – optimize the SQL statements that use the most resources? Optimize workloads with SQL access guidance SQL optimization SQL optimization

For the needs of market and enterprise Development, Oracle provides a relatively unified solution for enterprise-class real-time data solutions, Oracle data integration. The following article is mainly about the specific description of its solution,

First install ha-instant Client-v11.2.0.3.0-x86.rar：Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x86.rarFtp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x64.rarThen perform the installation of ODBC a

ORACLE stored procedure details, oracle Stored ProcedureORACLE Stored Procedure explanation 1. Definition A Stored Procedure is a set of SQL statements used to complete specific database functions. The SQL statement set is compiled and Stored in the

With the rapid development of cloud computing, mobile and social technology, the role of enterprise data centers is constantly changing. Enterprises need stronger computing capabilities, simpler IT architecture, and more controllable O & M costs.

Database Name, database instance name and database domain name I. Database Name what is database name? The database name is the ID of a database, just like the ID card number of a person. He uses the DB_NAME parameter to indicate that if multiple