oracle database 12c training

Reprint: http://www.cnblogs.com/xqzt/p/5034375.htmlFor those who are familiar with Oracle or who have contacted Oracle, Scott, the user, must be quite familiar with it. 12c has launched a pluggable database with multiple database PDB in the form of multiple tenants in a sing

Tags: style blog http io ar color OS using SPIn Oracle 12c, the CDB and PDB, their startup and shutdown operations are organized as follows.1 Container Database (CDB)For CDB, startup and shutdown are the same as in previous traditional ways, with the following syntax:Startup[nomount | MOUNT | RESTRICT | UPGRADE | Force | READ only]Shutdown[immediate | ABORT]Note

=oracle.install.db.config.asm.asmsnmppassword=Myoraclesupport_username=myoraclesupport_password=Security_updates_via_myoraclesupport=falseDecline_security_updates=trueOracle.installer.autoupdates.option=skip_updatesproxy_host=proxy_port=Proxy_user=Proxy_pwd=Collector_supporthub_url=Installing Oracle Software[Email protected] response]$ pwd/home/software/database[Email protected] response]$ chmod 700/HOME/SO

Label:A bit of Oracle 12c. Some of the experiences are written down first. 12c engage in new meaning, get a CDB (container database, not business center CBD yo) and PDB (pluggable database). The PDB is inserted into the CDB. In simple terms, CDB is a

Oracle Cloud Control 12c the entire installation is more complex, light installation path selection, login password, port number and many other configurations are confusing, dizzying. This article describes how to obtain installation after installation of the various port number, URL and how to start, close cloud control and so on, for your reference. The installation configuration for Cloud control can re

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

Tags: Log release 1.3 nec Rman created Min object operation1.1. Rman Connection DatabaseRman can connect to a target database through operating system authentication and password file two ways, users who use the Rman Backup Recovery tool need to have SYSDBA or sysbackup system permissions, if the user needs to connect to the recovery directory, need to be granted Recovery_catalog_ Owner object permissions.D:\instantclient_12_2>sqlplus sys/password @cl

Download Oracal installation packageEnter https://www.oracle.com/index.html Select-->menu-->downloads and trials-->database-->oracle DatabaseCheck the Accept License agreement.Locate Oracle Database 12c Release 2, select the following file 1 (3.2 GB) See all download (if you

Because Oracle 12c uses the CDB-PDB architecture, similar to Docker, multiple pluggable-db can be loaded within the CONTAINER-DB, so additional configuration is required after installation to be used.First, modify the Listener.ora, Tnsnames.ora# # #listener. ora###LISTENER =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))(Connect_data = (service_name = ORCL)))#sid list enumerates

Tags: 12c impdp expdp12c has launched a pluggable database with multiple database PDB in the form of multiple tenants in a single container cdb. The data pump import and export for the PDB is slightly different from the traditional database.1, need to add tansnames for PDB2, import and export need to specify its tansna

/o1_mf_undotbs1_djszmxkc_.dbfspace_name,b.file_nameSql>drop tablespace UNDOTBS1 including contents and datafiles; (Remember to execute in the PDB)Sql>select name from V$datafile where name is like '%undo% ';NAME-----------------------------------------------------------------------------/HOME/ORACLE/APP/ORACLE/ORADATA/ANDYCDB/DATAFILE/O1_MF_UNDOTBS1_DJSYYJLK_.DBF > is now the Undo datafile in CDB.Ii. shared

] ~]$ sqlplus sys/[emailproteCTED] as Sysdbasql*plus:release 12.1.0.1.0 Production on Sat Jan 14:26:04 2014Copyright (c) 1982, oracle. All rights reserved.connected to:oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit productionwith th E partitioning, OLAP, Advanced Analytics and Real application testing optionssql> show Con_name con_idcon_name--- -

Kernel parameters Net.ipv4.ipfrag_low/high_thresh, Net.ipv4.ipfrag_time GC Lost block problem Gns Optimizing the RAC database grd* RAC Wait Event * GC Current Block 2-way/3-way GC CR Block 2-way/3-way GC CR Grant 2-WAY/GC current Grant 2-way GC CR Block BUSY/GC current block Busy GC CR Block CONGESTED/GC current block congested Placeholder Wait Events

Starting with Oracle 12C allows different types of index to be created on the same column for performance tuning, with different types of index mainly including (B*tree vs bitmap,local vs Global)ORACLE 11G The code is as follows Copy Code Sql> select * from V$version; BANNER ------------------------------------------------------------

.293.874633187 +data/stldb/118073e7a685f068e0536506a8c0a25e/ datafile/users.296.874633293 +data/stldb/118073e7a685f068e0536506a8c0a25e/datafile/kiwi.339.874702947 Elapsed: 00:00:00.08 21:14:45 [emailprotected]> select name from V$tempfile; NAME----------------------------------------------------------------------------------------------------------- -----------------------+data/stldb/118073e7a685f068e0536506a8c0a25e/tempfile/temp.295.8747036272 cross-Library pluggable test 21 : 48:28 [emailprote

Tags: MCT proc Oracle EMC 12c Monit product Time DBA12C configuration OEMs are significantly different from previous versions, without Emctl, and are configured directly using the following methods:Sql*plus:release 12.1.0.2.0 Production on Tue Jul 19 07:19:33 2016Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle