Oracle

Recently helped a customer recover 6 sets of Oracle RAC, both ASM and version 10.2.0.4. Stay up for several days, almost vomiting blood.Here is a brief description of the recovery of one of the libraries, to share with you.Several of these have

Database starts error The code is as follows Copy Code sql> startup Mount Pfile= ' C:\pfile.txt ' The ORACLE routine has started. The code is as follows Copy Code Total System

1, what is a cursor? ① retrieves a result set from a table from which the mechanism for interacting with each record is pointed.Operations in the ② relational database are performed on a complete rowset.The rowset returned by the SELECT statement

Here a simple note, the National Day overtime recovery of a customer's 2 sets of Oracle RAC database, the entire recovery process, 2 sets of RAC similar, so here is a set of database recovery process as an example of simple analysis. Because the

The concept of a temporary table There is also a type of table in the Oracle database, called a temporary table. The biggest difference between this temporary table and the permanent table is that the data in the table doesn't exist forever. When

First get to know the ln and update-alternatvies commands.LN LinkFirst, let's talk about the Linux link, which is divided into two kinds: symbolic link (symbolic link) and hard link (hard link).We know that files have file names and data, which are

1. Execute a SQL script file Copy Code code as follows: Sqlplus User/pass@servicename Or Copy Code code as follows: Sql>start File_names Or Copy Code code as follows: sql>@

Row to Columna table Query results are --row column Select years, (select amount from Tb_amount as A where Month=1 and A.years=tb_amount.years) as M1, (select amount from T B_amount as a where month=2 and a.years=tb_amount.years) as M2,

Today encountered a problem, there is a table can not operate, it is likely to be locked, the first thought is kill session, so executed the following script to find out which session has a problem: To see if a table is locked SELECT/*+

This example describes the use of Oracle Cross Library query Dblink. Share to everyone for your reference, specific as follows: 1. Before you create a job Before you create a dblink, first check to see if the user has appropriate permissions. For

The Oracle tutorial you are looking at is a common database system that compares Oracle databases. To bring up the database, the first company to think of, is usually oracle. The company was founded in 1977 and was originally a company specializing

The Oracle tutorial you are looking at is: Oracle SQL Performance Tuning Series Learning Ii. 4. Select the most efficient table name order (valid only in the Rule-based optimizer) The Oracle parser processes the table names in the FROM clause in

Oracle database is often encountered in the use of such or such a problem, and these problems often confuse us, we summarized the Oracle database in the use of some of the problems, and the solution, we begin to analyze these issues. First, after

1 "in 12-hour system display Sql>select to_char (sysdate, ' yyyy-mm-dd HH12:MI:SS AM ') from dual;To_char (sysdate, ' YYYY-MM-DDHH1------------------------------2007-06-29 02:50:06 pm 2 "in 24-hour system display Sql> Select To_char (sysdate, '

(i) in the process of using Oracle, we often encounter a number of Oracle errors, for beginners, these errors may be a little vague, and may not know how to handle the resulting errors, I use the more frequent error code one by one to make analysis,

The advantages of this method: 1, the integration of Oracle client within the program, no need to configure users themselvesThe disadvantage of this method: 2, increase the volume of the package (Oracle Instant client itself has a few 10 megabytes

The kill session is one of the things that DBAs often encounter. If you kill a session that should not kill, it is destructive, so avoid this error as much as possible. It should also be noted thatIf the session of Kill is part of an Oracle

Exadata backup recovery is the same as that of a single machine or RAC database, but there are some optimization best practices for multiple nodes. Today, we will briefly talk about the backup and recovery of Exadata.To fully utilize the I/O

Install the Oracle 11.2.0.4 database software and execute root. sh. This is nothing special.Then, we need to modify the ORACLE binary file permissions of oracle RDBMS so that the oracle database process can obtain the ASM disk group.[Root @ lunar5 ~]