oracle database 12c

Many friends feedback on the win 64-bit operating system can not use bbed (including the 9I,10G,11G,12C database version), previously wrote an article, the perfect implementation of the win platform versions of the database version on top of the implementation of the use of bbed (in win run the Bbed program), Unfortunately, I did not mention the platform informat

Oracle 12C r2-new features-pdb disk I/O (iops,mbps) resource managementIn previous versions, there was no easy way to control the amount of disk I/O used by a single PDB. As a result, a PDB may run out of disk I/O and affect the performance of other PDB in the same instance. The Oracle 12c R2 can control the amount of

Tags: io using ar for SP on EF BS SQL--Confirm Current CDB Sql> select name,cdb from V$database; NAME CDB------------------------ORCL YES --Query the current PDB basic information Col pdb_name for A30select Pdb_id,pdb_name,dbid,status,creation_scn from Dba_pdbs;select con_id,dbid,name,open_mode From V$pdbs; Create a consumer sql> Create User C # #test identified by test; Sql> alter session set CONTAINER=PDB1;Sql> show Con_name; Sql> show Con_name; Con

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,

patiently. 10 after the inspection passed, will give you this information, you can save, you may use later. Click Install. 11, after the patience to wait for the installation, I installed for half an hour. 12, then will pop up the following box out, click Password Management. To set the password. 13,sys system is the user you want to use. You can fill in the password, but be sure to remember. After the Oracle link is the user with the password to

Prior to the Oracle 12c version, the VARCHAR2 and NVARCHAR2 data types had a maximum length of 4000, with the extended maximum of 12c versions supported to 32767, or 32KB, and parameter Max_string_ The size is the maximum length of the extended data type that controls the extended datatype: Standard: Represents the length limit before

/asm-diskechmod 660/DEV/ASM-DISKFchmod 660/dev/asm-diskgForgot to edit the kernel parameters vi/etc/sysctl.confFs.file-max = 6815744Kernel.sem = 250 32000 100 128Kernel.shmmni = 4096Kernel.shmall = 4294967296Kernel.shmmax = 4398046511104Kernel.panic_on_oops = 1Net.core.rmem_default = 262144Net.core.rmem_max = 4194304Net.core.wmem_default = 262144Net.core.wmem_max = 1048576FS.AIO-MAX-NR = 1048576Net.ipv4.ip_local_port_range = 9000 65500This article is from the "vmware/

Create a user in 12c--avoid ORA-65096 or ORA-65049 errors From:Creating users in 12c-avoiding ORA-65096 or ORA-65049. (Document ID 1572404.1) Apply to:Oracle database-enterprise edition-version 12.1.0.1 and laterInformation in this document applies to any platform.When you use the previous version of SQL syntax to create user in

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

= Tag20180112t205525channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00 : 01Finished restore at 12-jan-2018 21:54:48rman> restore SPFile validate; Starting restore at 12-jan-2018 21:54:57using channel Ora_disk_1channel ora_disk_1:starting validation of datafile backup Setchannel ora_disk_1:reading from backup piece +datadg/orcl/autobackup/2018_01_12/s_965249725.381.965249727channel Ora_disk_1:piece handle=+datadg/orcl/autobackup/2018_01_12/s_9652

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

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

Tags: his database using guide 12c and this one OracleWhat kind of audit trail is supported in a 12c database?From: What Audit Trail Types is supported for A 12c Database?(Document ID 1986609.1)Suitable for:Oracle Audit Vault and

] ~]# ID griduid=54322 (GRID) gid=54321 (Oinstall) groups=54321 (Oinstall), 54322 (DBA), 54327 (ASMDBA), 54328 (Asmoper), 54329 ( Asmadmin)[[email protected] ~]# ID Oracleuid=54321 (Oracle) gid=54321 (oinstall) groups=54321 (Oinstall), 54322 (DBA), 54324 (BACKUPDBA), 54325 (DGDBA), 54326 ( KMDBA), 54327 (ASMDBA), 54328 (Asmoper), 54330 (RACDBA)[Email protected] ~]# usermod-u 54321-g oinstall-g dba,asmdba,backupdba,dgdba,kmdba,racdba,asmoper,asmadmin,o

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