Oracle

With the popularization of computers and the development of networks, databases are no longer just the proprietary topics of programmers. Oracle databases, however, have a place in the database market thanks to their superior performance and

Voting disk ):Voting disk records the node member information, such as the node members and Node Deletion records. The size is 20 MB.View voting disk location: crsctl query css votedisk$ Crsctl query css votedisk0. 0/dev/rhdisk3If the CRS

Using rman to create standby is quite simple and the master database does not need to be stopped. This experiment demonstrates the process of using Rman for Hot Backup and then restore to create the standby database. 1. Demo Environment[Oracle @

First, we do not recommend that you run your production system Oracle database on the VMware vSphere4 platform, because the database running on VMware vSphere4 is certainly slower than the database running on the physical machine. If you really want

In Oracle database operations, there is a ORA-01940: Unable to delete the current connected user error, how to solve? This article introduces the solution, hoping to help you.SQL> drop user a cascade;Drop user a cascade*ERROR is located in row

Abstract This article mainly analyzes the ORACLE system structure and working mechanism from four different levels of Adjustment Analysis in the ORACLE environment of a large database, the optimization and adjustment schemes for ORACLE databases are

1: first, restore the spfile parameter file information in the backup of the control file. RMAN> set dbid = 1133434343Executing command: SET DBID   RMAN> startup nomount;Startup failure: ORA-01078: failure in processing system parametersLRM-00109:

ORA-01659 could not allocate MINEXTENTS over 5 (XXX) solved yesterday's problem with Database Import table: Error: ORA-01659 could not allocate MINEXTENTS 1 over 5 (XXX), try to delete tablespace recreate Delete tablespace: drop tablespace BPM2

The GoldenGate Data Pump Process report the WARNING OGG-01223 Cannot find executable file '. /Server' cannot be started to solve a strange problem today. The na server's buddy called to say that our data pump process was not started, and the data

The client cannot connect to oracle normally, and the listening status is "Not All Endpoints Registered" solution 1. symptom Description: The application response is Not normal. [grid@sdcmpdb1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 -

Tips for using functions in Oracle (2)-The NULLIF function provides the abbreviated CASE expression through a comparison expression. Syntax NULLIF (expression-1, expression-2) the expression to be compared with expression-1. Expression-2: The

ORA-21561: OID generation failed solution [Oracle @ adg ~] $ Sqlplus scott/tiger @ rac11gSQL * Plus: Release 11.2.0.3.0 Production on Fri Jul 19 04:16:59 2013 Copyright (c) 1982,201 1, Oracle. All rights reserved. ERROR: ORA-21561: OID generation

NULL in subquery the subquery returns a single row, multiple rows, and null value. It is applicable to the comparison operators of single-row subqueries: =, >,=, SQL> select last_name,department_id from employees where department_id is

[Oracle] Data Pump detailed tutorial (3)-impdp [Oracle] Data Pump detailed tutorial (2)-expdp http://www.bkjia.com/database/201307/230731.html The import mode is the same as the export mode. The following five modes are also mutually exclusive. Set

Oracle-full recovery of User Management (1) I. categories can be divided into full recovery in non-archive mode and archive mode. full recovery is mainly for archive mode, and it is difficult to achieve full recovery in non-archive mode, unless

Oracle synonym loop chain problem solution [SQL] 1. First check whether there is a loop synonym: select * from dba_synonyms where table_owner = 'test' and synonym_name <> table_name; no record 2. Then query the database objects with no synonym

All databases of the Oracle physical backup server, whether physical or logical, must be created as physical backup databases first. Tools used to create backup databases include RMAN, data guard proxy, and Oracle grid control. The operation must be

RMAN backup scheme RMAN backup archive mode damages (loss) multiple data files, restores the entire database 1. connects to the database, creates a test table, and inserts records SQL * Plus: Release 8.1.6.0.0-Production on Tue May 6 13:46:32 2003

Partition index note (4) -- when the partition index will expire and process the partition index note (3) -- global partition Index http://www.bkjia.com/database/201308/238740.html Local indexes in partitioned tables are automatically maintained

ORACLE-related syntax-subprograms and packages (package, function, procedure) Summary: subprograms are named PL/SQL blocks that can contain parameters and can be called as needed at any time. PL/SQL has two types of subprograms: process and function.