session set CONTAINER=EHRPDB;--Switch back to the root containerAlter session set Container=cdb$root;--2 Creating pluggable Databases--2.1 Cloning seed ContainerCreate pluggable Database cpcdbAdmin user Cpcadm identified by Cpcadmfile_name_convert= ('/oracle/app/oracle/oradata/edw/pdbseed ', '/oradata/edw/cpcdb/datafile/');--2.2 Creating a database directlyCREATE Pluggable DATABASE HrdbADMIN USER HRDBA ide
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,
\hosts file 127.0.0.1 is blocked.2. Also IP address do not use DHCP to obtain IP automatically, you need to specify an IP address. This problem occurs as long as you find the cause, and then let the monitoring start normally can solve the problem.3. Firewall does not shut down caused4. Check that the other network configuration is correct.The installation is complete, according to the prompt browser access (The browser may be reported missing flash plugin to install one on the line)User name is
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
Oracle 12c R1 physical standby uard physical standby database enable real-time apply
The physical standby database is always in the mount state, which is inconvenient for Data Synchronization verification.
Enabling real-time apply enables real-time query.
In the standby database mount status:
SQL> select open_mode from v $ database;
OPEN_MODE------------------------------------------------------------MOUNTE
/view" Warning window!Workaround:Log in to Oracle Sql*plusC:\users\administrator>C:\users\administrator>sqlplus/nologSql*plus:release 10.2.0.1.0-production on Tuesday January 29 10:54:36 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.Sql> Connect Sys/sys as SysdbaThis section is to find out the error when opening the databaseSql> select Open_mode from V$database;Open_mode----------Mountedsql> ALT
object:dbms_jms_plsql privilege:execute grantee:system
- GRANT EXECUTE onSys. Dbms_job toSYSTEM with Grant option
+ /
A --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system
at GRANT EXECUTE onSys. Dbms_random toSYSTEM with Grant option
- /
- --METADATA type:grant object:v_$transaction privilege:execute grantee:system
- GRANT SELECT onSys. v_$TRANSACTION toSYSTEM with Grant option
- /
- --METADATA type:grant object:gv_$transaction privilege:execute grantee:s
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
explicitly inserted; METADATA-ONLY default value refers to the default value specified when a new column is added, and the difference in 11g is that, the default value of 11g must be not null.
3. extend the length limit of multiple data types: Increase the VARCHAR2, NVARCHAR2, and RAW types to 32 K, set compatibility to 12.0.0.0 or above, and set the initialization parameter MAX_ SQL _STRING_SIZE to EXTENDED, this function does not support CLUSTER tables and index organization tables. In the en
Label:1. Backing Up the NON-CDB database2. Close the NON-CDB database sql> shutdown immediate; 3. non-cdb to read-only status sql> Startup Open Read Only 4. Create an XML file (created in non-cdb) sql> begin
Dbms_pdb.describe (pdb_descr_file='/tmp/test.xml') ;
End;
/ The XML file created here and the original library's data file make up a unplugged PDB 5. Close the NON-CDB database6. Login CDB using ' /tmp/orcl.xml ' copy;
SQLSet container=P6;
SQL> $
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?
Tags: share roo agent list specific main tar ber ATI Install Agent Agent When em11g, agent installation is through the host side of the producer Download agent and install, on the EM12C version number, can be on the EM12C server. The agent proxy is installed remotely to the monitored host side by means of "push", and the agent agent can be installed for multiple hosts at the same time. Official documents: Http://www.gokhanatil.com/2011/10/how-to-deploy-oracl
Tags: RAC nts ges ASE host Technology One height issue1. Visit Oracle Website: https://www.oracle.com/index.html, download Oracle Database 12c Release 1(Note: File1 and File2 are to be downloaded!!) Otherwise post-installation will report a bunch of errors, refer to: http://www.2cto.com/database/201503/386272.html)2. Unzip the file and copy all the folders in the
Installing Oracle 12c on Windows 7 64-bit does not have a set character set, using the operating system default character set: we8mswin1252, modify the character set to: ZHS16GBK. Because the process is irreversible, you first need to back up the database.1. Fully prepared database2. Querying the current character setSQL>Select*fromwhere parameter='nls_ CHARACTERSET'; PARAMETER
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.