Oracle

Look at me today this single node 12C RAC, suddenly feel that the disk group of OCR is called +dg_sys a little uncomfortable, want to change to +SYS_DG. The approach is to migrate the Ocr/votedisk/asm SPFile to an existing ASM, and then modify the

Because of the reasons for the project need to use the Oracle database, due to time constraints can not learn from the foundation, and the Oracle operation of the command interface is too unfriendly, so I found Pl/sql developer this very useful

The first step: network connection, in my last blog has introduced, no longer said. Purpose of network connection: In order to be able to use the yum command, download files directly on the Internet. Step two: Go to Oracle website to download 12c

By exp, the data is unloaded to the file system, a. dmp file is generated, and then, when necessary, the data is loaded into the database by Imp. For the general small and medium-sized databases, the full database of exp produced by the DMP file may

I. Oracle built-in role connect and resource permissions Grant Connect,resource to user; Connect role:--is the typical right to give end users, the most basic Alter session--modifying sessions Create CLUSTER--Create a cluster Create DATABASE

Oracle RAC also has ha (high availiablity) and lb (loadbalance). And its high availability is based on failover (failover). It means that the failure of any node in the cluster will not affect the user's use, the user connected to the failed node

Original: Oracle job procedure Stored procedure timed taskThe Oracle job has timed execution and can perform its own tasks at a specified point in time or at some point in the day.First, query the system job, you can query the view --related

1.where cannot be placed behind group by 2. Having is used together with group by, placed behind group by, at this time the function is equivalent to the where3.where behind the condition can not have aggregation function, such as SUM (), AVG (),

1 descriptionIn 11g, view the log of the grid and enter $oracle_hom/log.[[email protected] ~]$ cd  $ORACLE _home/log/[[email protected] log]$ lscrs   diag  rac1[[email protected] log]$ cd rac1[[email protected]

1 IntroductionIn the process of programming, you will often encounter two sets of records compared. such as the East China power grid PMS interface to implement the transfer of changes (new, modified, deleted) in the day of data. There are many ways

First, the overall analysisThe implementation of this system is not difficult, but how to better design the implementation method or need more in-depth analysis, such as: If you add additional functionality, is not required to changeThe code is very

The time for all nodes must be synchronized, which is usually achieved by configuring the NTP server. If the user already has a time server in the network, then all nodes can point to it, otherwise you can pick a node from the cluster as the time

In the previous article, we introduced the most important file in Sql*loader-control file, and this article to introduce the most important part of the control file-the field list, the role of the field list is to the data file records and tables in

5.1 Case Statement1. The case statement has the following structureCase SELECTORWhen EXPRESSION 1 then STATEMENT 1;When Expresssion 2 then STATEMENT 2;........When EXPRESSION n then STATEMENT N;ELSE STATEMENT n+1;END case;The reserved word case

1. Row to column:First, the initial data:Data after conversion:Second, the conversion of the statement:--statistics on the number of staff in various positions in various departments:SELECT T.job, SUM (DECODE (t.job, ' clerk ', 1, NULL)) as COUNT1,

After listening to nearly 20 speeches in the last two days, I felt a lot of harvest, and the deepest feeling was that I still had a long way to go. There are several points to note:Listening to the old cat yesterday, it is a common problem that

oracle11g Start Error, startup Nomount failed, background alert error log as follows:[[email protected] dbs]$ more/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.logwed Feb 03 20:56:28 2016Starting ORACLE instance (normal) ...

installed a Oracle 12c is not able to connect to Oracle 12c after using PL/SQL developer. Look online, according to Fcflying said the operation succeeded, so make a note:1) Install Oracle 12c 64-bit:

The following is the DB2 connection database1) Use IBM.Data.DB2 link DB2 database2) DB2 client must be installed, IBM. DATA.DB2 can be found in the installed bin.3) Note The DB2 client version problem, my is WIN7 need V10 version, server win2008 use

A customer told me today that the logs of the slave database of a core database are increasing rapidly. Through checking, alert logs continuously report errors, as shown below: The code is as follows:Copy code Fri Dec 11 20:48:37 2015Incomplete