Tags: MoS unique oracl product Memory server app not strEnvironment is 12.2.0.1 version, Oracle Data guard Main Library patrol found alert with abnormal error: 2018-07-10t13:24:04.710366+08:00Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/DWDB/DWDB1/TRACE/DWDB1_M000_4455.TRC:Ora-00245:control file backup failed; In Oracle RAC, Target might not is on shared storageRemov
Oracle 12c In-Memory
Oracle introduced the In-Memory and columnar compression option In 12c, which greatly improves query performance.
Here, we can see how much performance can be improved in the same query through a comparison.
1. allocate Memory to In-Memory firstSQL> show parameter inmemory;NAME TYPE VALUE----------
The new features of In-database archiving are introduced in Oracle Database 12c, which allows users to archive data by marking data rows on the table as inactive inactive. These inactive data rows can be compressed into one optimization and are not visible to the app by default. This feature enables the functionality and requirements of this "tag delete" in the case of minimal changes to existing code.Befor
Label:Oracle Data Integrator 12c installation (ODI installation)Enterprise Edition installation steps (including standalone installation steps)Download Oracle Data Integrator 12CR2 (12.2.1.0.0) address on official website For example, when installing ODI, there are two options, the first is a standalone installation, just install the Oracle Data Integrator 12cr2,
Tag:tabreadossmanage copy optionsonslinebase $ Sqlplus '/as sysdba ' sql*plus:release 12.1.0.1.0 Production on Tue June 13:03:06 2015Copyright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit productionwith The partitioning, OLAP, Adva nced Analytics and Real application testing optionssql> show Con_name; Con_name---------------------------
Simple CDC, the simplest CDC. Here, each CDC table change is captured independently, and there is no need to consider the consistency of data between tables that have primary foreign key reference relationships.1 Environment PreparationSOURCE table: Odi_src. DEPT Target table: Odi_tag. DEPT Configuration topology See the creation and configuration of the ODI studio topology (Oracle) Model Reverse engineering See:
) (host=oracle12c) (port=5500)) (Security= (my_wallet_directory=/u01/app/ Oracle/admin/orcl/xdb_wallet)) (presentation=http) (Session=raw))Services Summary ...Service "7351E8AE5372218EE0539B6BA8C08D05" has 1 instance (s).Instance "ORCL", status ready, have 1 handler (s) for the This service ...Service "ORCL" has 1 instance (s).Instance "ORCL", status ready, have 1 handler (s) for the This service ...Service "Orclxdb" has 1 instance (s).Instance "ORCL"
In addition to using DBCA to delete the Oracle 12C database, we can also use the drop database Command to delete it.This deletion method is very simple, but must meet the following two requirements:1. The database must be in the mount State and cannot be in the open state;2. The database must be inRestricted mode.[Oracle @ rhel6u4 ~] $Sqlplus/as sysdbaSQL * Plus:
Label: In oracle12c, the concept of pluggable databases, the PDB, is added to allow a database container (CDB) to host multiple pluggable databases (PDB). CDB is all called Containerdatabase, the Chinese translation is a database container, the PDB is all called pluggabledatabase, you can plug and unplug the database. The following is an official document about the CDB vs. pdb diagram. In CDB, you can only create a C # #或C # #开头的用户, and if you do not add c##, you will be prompted with the error
SOURCE end: 12C RAC primay backup fileTarget side: 12C Single InstancePartial Summary:1 Pfile Modification2 Disable Redo Thread N3 Drop logfile Group N4 Rename LogFile5 Cancel Log Remote transferIf primary is in Maximum availablity mode, the control file will detect log_archive_dest_n in case the log transfer is normal? So without processing will be an error:LGWR (ora-16072): Minimum of 1 LGWR standby datab
Environment: WIN7 64-bit + Oracle 12c (12.1.0.2.0)Mode: Graphical InstallationLog on to the system as an administrator:1 Double-click the setup.exe in the database directoryRemove the check for "Receive security updates" and click Next.2 Wait for some time to appearI have an error INS-30131 here:For example, after starting the Server service, normal:3.
5.6.7.8.9. Note that the password set he
The problem originates from a 12c database of the customer and needs to be booted to a non-real time apply mode, but the discovery is performed:ALTER DATABASE recover managed standby database cancel;ALTER DATABASE recover managed standby database disconnect from session;
After that, the database is still working in the real time apply mode.
Went to the alertlog for a while, found the answer:
Thu June 09 12:16:03 2016Errors in FILE/CUST/MYDB/RDBMS/
Label:In previous versions, the parent table could not be truncate directly when there was a foreign key constraint. In 12C, a cascade operation attribute was added to the truncate operation. If you create a FOREIGN key constraint, use "on Delete Casacde". Test script: Sql>drop table child; SQL>drop table parent; SQL>CREATE TABLE parent (ID number primary key); SQL>CREATE TABLE Child (CID number primary key,pid number); SQL>ALTER TABLE child add cons
Create an Oracle 12c user
Oracle 12c accounts can be divided into public accounts and local users. A common account is created under CDB and can be used by all PDB users. A local account can only be created in PDB.
Create a public userAlter session set container = CDB $ ROOT;Create user c # u02 identified by
The concept of change sets is introduced in conformance CDC. A change set can include several tables that have relationships with each other, such as a primary foreign key reference relationship. The CDC can guarantee data consistency when capturing and releasing changes in a change set. This exercise describes how to use a CDC that guarantees consistency.1 Environment PreparationSOURCE table: Odi_src. Dept,odi_src. Emp Target table: Odi_tag. DEPT, Odi_tag. Emp Configuration topology See the cre
Install Agent AgentIn the em11g, agent installation is through the host side of the producer to download Agent agent and installation, on the EM12C version, on the EM12C server, through the "push" way the agent agent in the remote installation to the monitored host side, You can also install agent agents for multiple hosts at the same time.Official documents:Http://www.gokhanatil.com/2011/10/how-to-deploy-oracle-management-agent.htmlInstallation metho
This article mainly introduces the basic management of CDB and PDB, data source Oracle official.Basic concepts:Multitenant Environment: Multi-tenant environmentCDB (Container database): DB containerPD (Pluggable database): pluggable databasesCDB vs. pdb diagramCOMMON users (ordinary users): often built on the CDB layer, user name in C # #或c # #开头;Local Users: Only the PDB layer is established, and container is specified when it is established.In
Because you want to switch servers, re-install Oracle, you want to use the latest 12c. It took a whole day to record the process and problems as follows.First, download Oracle 12c:Half of the 12.1.0.2.0 on the official web site is really down, with the hundred-gigabit fiber is also to half of the failure. So you can only download 12.1.0.1.0.II. installation?
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.