Oracle

Tuning system time is not a trivial thing for a RAC environment, and Oracle is likely to reboot one of the nodes to ensure consistency between nodes. The test found that if the system time is adjusted forward, no matter how long the adjustment will

This article is the migration of the way to achieve the database 10g to 11g migration upgrades. First, the environment introduction 1. Source Database Environment Operating system version: OEL5.8 x64 Database version: 10.2.0.5 x64 Database SID

Triggers are a technology provided by many relational database systems. In Oracle systems, triggers are similar to processes and functions, with pl/sql blocks for declaration, execution, and exception handling processes. 1 Trigger Type Triggers

This article describes the typical examples that sql*loader often use in the process of actual use. 1. How do I get fewer columns for the larger than data file in the table? Suppose a CSV file is as follows: A1,A2,A3,A4 b1,b2,b3,b4

Oracle Data Guard from the macroscopic point of view, mainly provides the following two services: 1) Log transmission: The main library transmits the generated redo log to the standby library; 2 log application: The redo log, which is transferred

1. View database Information Show parameter instance_name Show parameter Db_name Show Parameter Service_Name Select dbid from V$database; 2. Normal Shutdown database Sqlplus/as SYSDBA Sql>shutdown Immediate 3. Start database to mount mode

L1, L2, L3 block function:--easy to find data blocks. There is a pointer to the L3 in the L1, L2 has a pointer to L3, and a pointer and state for multiple blocks of data in the L3. 1. In each L3, there are multiple L2 addresses (the first L3 is a

Recently in the official document of Oracle Sqlplus, the Sqlplus Security Section introduced the PUP mechanism. To take this, I will use the following: PUP (Product_user_profile) Introduction Product_user_profile is the next table in the system

After the N installation attempt to vomit blood summary, hope to be helpful to everyone, at the same time do record memo: Summary: Pre-installation preparation is the key!!! Check and recheck! Reference: Http://docs.oracle.com/cd/E16655_01/install.

Personal experiments sometimes use large tables, where you can share the dba_objects to create a test large table: First set up the test table Sys@orcl>create table Test nologging as Select RowNum id,a.* from Dba_objects a where 1=2;

Only one DG can be designated for storage during the 11g installation: CRS, voting But Oracle's official recommendation is to configure this: 1, when OCR does not configure the mirror, or redundant storage of at least 3 OCR. If the underlying

First, the concept of the user Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts include schemas,

1. Recover password fileOrapwd file= $ORACLE _HOME/DBS/ORAPWOCP password=oracle force=y ignorecase=y; --Note: whether the common user's password is case-sensitive and Sec_case_sensitive_logon by the initial parameter, and not the password file

Summary: This article describes how to use PHP's database access technology to implement the storage of Oracle LOB data objects. Keywords: php;oracle; LOB; storage; Introduction PHP, or "Php:hypertext preprocessor", is a versatile scripting

In general, Oracle databases operate more efficiently than SQL Server databases in large data environments. From the query optimization alone, the two are quite different. Below, the author of the database query optimization of the difference to do

Today, there are users of the ASM in the disk to do Fdisk, resulting in ASM disc exception, through the manual repair ASM disk HEADER To solve the problem, here through the experiment reproduced, reminding you to operate the ASM hard disk partitions

VFP because of its popularity, ease of use, by the vast number of developers welcome, but its security and stability is not very perfect. The advantages of Oracle in this respect are legendary, the combination of both, can develop efficient, safe

TNS-00510 Internal Limit restriction exceeded Cause Too Many files or sockets open simultaneously (or some other resource has). Action for further details, trace the operation for protocol details. TNS-12500 Tns:listener failed to start a

There is a connection problem with the database you can use the Tnsping service name at the command line to check the cause of the error. Common errors are: Ora-12535:tns: Operation timeout Turn off the firewall first, which is the most common

10g online redefinition solves this problem. If the objects are created using Copy_table_dependents, the associated objects are automatically changed to their original names when the redefinition operation completes. If it is a manually created