Oracle

11.2.0.3 the database crashed due to damage to the ASM disk header block and encountered an incorrect ORA-15196.More detailed error: ORA-15196: Invalid ASM block header [KFC. C: 26076] [endian_kfbh] [256] [0! = 1]Further checks have found that the

The Oracle tutorial is as follows: Oracle 8x monitors the logon status of sysdba users. Before Oracle 8i, internal users were used to start and shut down databases and create databases. Since the 8i version, Oracle has gradually eliminated internal

The Oracle tutorial is: how to directly run the OS command (on) in Oracle ). In Oracle 8i, operating system commands are often run during the storage process. Generally, Oracle Enterprise Manager can be used to set jobs. However, due to the lack of

First, add the Oracle 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears: Figure 1 Click "Start installation" to install Oracle 10 Gb. Generally, check whether the system configuration meets

I have read a document called "penetration: from application down to OS (Oracle)" over the past few days. It is very interesting. The general meaning of this document is, if the Oracle service is started with the Administrator account, you only need

1. What is the difference between Oracle and SQL Server 2005?MACRO:1 ). the biggest difference is that oracle can run on different platforms, and SQL server can only run on windows platforms. The stability and security of windows platforms affect

Document directory Read Committed Isolation Serializable Isolation Isoation eve) The isolation level defines the degree of isolation between transactions. Isolation level and concurrency are mutually contradictory: the higher the degree of

Here is a simple record.: Record 1: N was installed with Oracle 10 a long time ago. I logged on again two days ago and found that the login failed. I always reported an error such as the host does not exist. As a result, the database was reinstalled,

We usually use a 32-bit PC, So we installed Oracle32-bit clients. However, the servers are usually 64-bit and the 64-bit Oracle client is installed. If you want to deploy an application that uses Oracle. DataAccess to connect to Oracle, you may

Oracle stores data through corresponding algorithm conversion in the database. This article briefly introduces the Number-type data storage and conversion of Oracle. This article aims to answer question No. 2119 on the message board. We can use the

The password of scott is incorrect. Go to the Administrator and modify the password of scott. Or change the password as follows: In the running column, press sqlplus (Space)/nolog and press Enter. In the pop-up box, press "conn sys/password as

The ORACLE tutorial is: FAQs about ORACLE database application development and troubleshooting. Hardware Platform: SUN Ultra Enterprise 3000 Operating System: Solaris 2.5 (Simplified Chinese) Disk: 4.2 GB Memory: 256 MB Oracle B version:

The ORACLE tutorial is: automatic backup of the Oracle database. I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be

The ORACLE tutorial is: how to directly run the OS command (below) in Oracle ). Exec SQL WHENEVER SQLERROR CONTINUE; Sqlglm (msg_buffer, & buffer_size, & msg_length ); Printf ("Daemon error while connecting: \ n "); Printf ("%. * s \ n", msg_length,

The ora 12154 error is reported when plsql is connected to the oracle database. Today I encountered a problem that sqlplus can be used to connect to a remote database, but plsql cannot be used to connect, error "ORA-12154: TNS: Unable to parse the

To sum up the basic knowledge of oracle, oracle is composed of instances and databases. The structure is as follows: Oracle databases consist of instances and databases: * A database consists of data files (including oracle Data, indexes, table

Show parameter processes; Then Change System connections Alter system set processses = 1000 scope = spfile; The procedure and description are as follows: Problem description: an error is reported when the client connects to the database. ORA-12516:

Today, we have a statistical result for all days of a month. If the result of a day is 0, it must be displayed, that is:Date transaction count transaction amount2009-4-01 1 102009-4-02 2 202009-4-03 0 0.... At first, I used the left join, on as the

1. nested loop Join)Nested connection divides the dataset to be processed into an External Loop (driving data source) and an internal loop (Driven Data Source). An External Loop is executed only once (first ), the number of inner loop executions

Copy codeThe Code is as follows:-- Get the start time of the last dayCreate or replace function fd_lastxunstart (rq in date) return string isRefstr varchar2 (50 );V_rq date;Begin-- Get the date of the last ten daysV_rq: = trunc (rq );Select case