oracle database 12c training

Prerequisite: The Oracle 12c database is installed, there is already a DB instance XE, login user/password: system/oralceI'm using a Docker-installed instance of Oracle 12c:8080:80801521:1521 -v/home/Specific reference https://hub.docker.com/r/sath89/

Attention:This document is an operational document for production, omitting the need for ip,oracle users to server,agent at least Sudo,ping,ssh, creating directory permissions.First, installation requirements 1.1. Overview of the System IP Database oem Operating system Database version XX1

Label:12c 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 PDB 2, import and export need to specify its tansnames value wit

Method/Step1 download version of Oracle 12c R2 forwindows：Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html includes two compressed packages: winx64_12c_ Database_1of2.zip,winx64_12c_database_2of2.zipUnzip the version of Oracle 12c R2 for Win

Directory:First, prefaceSecond, the use of ordinary usersThird, automatically start the PDBFirst, prefaceA recent Oracle 12c database has been installed on your computer to experience the new features. After installation, like the 11g in the DOS window to do the following:Sql*Plus:release12.1.0.2.0Production onSunday August9 -: .: - -Copyright (c)1982, the,

Oracle DB In-memory is pre-installed in Oracle database 12c (12.1.0.2 version) without the need to install additional software or recompile existing database software. This is because the in-memory option is seamlessly integrated into the

Application is to Wbbank, so name is Wbbank Application DB is running in a individual PDB Application DB have its own tablespace There is both users for this DB, one was to administrate objects of the db (Schema), which was used by DBA and other one is To operate the data, which was used by application Following is details:1. Create PDB and its DBA userSqlplus sys as sysdbacreate pluggable DATABASE pdbwbbank ADMIN USER wbbank_dba ide

The problem is as follows:In 12c, we tested two cases:The first is to add hint, so that the 12c execution plan is similar to 10 GB, but because of the 12c nlj_batching, a nestloop is added. However, the execution plan is essentially the same, and the index S_CONTACT_X_U1 returns the table query.The second is to use 10g outline hint, OFE = 10g, and the execution p

Tags: cold backup Oracle Database Migration 12cExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way. The path of the target machine is inconsistent with the source library and needs to be rebuilt controlfile.Migration step

Brief introductionSAP claims that Hana is the fastest database, so SAP's new ERP system S4 no longer supports OracleA new feature of Oracle 12c is the ability to convert between rows and columns for the same tableSAP wants users to think of Hana as a unique technology, but in this article you can see that both memory and Columnstore are not proprietary technologi

, there will be a problem. SQL> select * from v $ version; BANNER CON_ID------------------------------------------------------------------------------------------Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production 0PL/SQL Release 12.1.0.1.0-Production 0CORE 12.1.0.1.0Production 0TNS for Linux: Version 12.1.0.1.0-Production 0NLSRTL Version 1

compatibility, you can also use the Alterdatabase command to modify:CONN [email protected]ALTER DATABASE DEFAULT tablespace users;ALTER DATABASE DEFAULT Temporary tablespacetemp;Attention:Regardless of which method you use, it is important to ensure that container is correct before you modify it.--------------------------------------------------------------------------------------------All rights reserved,

Tags: Oracle 12c change archive mode1.shutdown Normal or shutdown immediate close the databaseSql*plus:release 12.1.0.1.0 Production on Monday December 15 15:49:47 2014Copyright (c) 1982, Oracle. All rights reserved.Connect to:Oracle Database 12c Enterprise Edition Release 1

Tags: img Install Oracle Advanced database Mode Gen Tag alias MCTHere, I am introducing the installation of the cloud Control 12c. The previous version is called Grid Control, which is also known as 11g. When I write this blog, the Cloud Control 13c has come out, this version follow me to introduce. Before installing, let's take a look at the overall architectur

area storage, default path, then click Next23 Here I choose to use the same password for all accounts Wangfeiyu123, can also be for different usersSet a different password, then click Next24. Set DBA, Database Operations Group Oinstall, then click Next25, if the error is prompted, because the version of the installation package is different or the kernel parameters have a problem or less dependentSoftware, you need to resolve the error, and then clic

1. Prepare for 1.1 download Oracle 12c InstallerRefer to: http://www.wxzzz.com/1231.html articles can be downloaded smoothly.1.2 Unzip the downloaded two compressed filesUnzip the two compressed packets into the same directory, "database" and click on the "setup.exe" file under the extracted directory:2, installation process 2.1, double-click "setup.exe" to insta

Complete uninstall of Oracle 12c operation steps on Windows71. Close all Oracle Services and press "Win+r" to Run "services.msc" to find all services beginning with Oracle (oraclevsswriterorcl+oracleserviceorcl+ ORACLEORADB12HOME1TNSLISTENER+ORACLEORADB12HOME1MTSRECOVERYSERVICE+ORACLEJOBSCHEDULERORCL), click Stop.2. Un

-vip.localdomain NTRAC1-VIP10.1.32.94 Ntrac2-vip.localdomain NTRAC2-VIP10.1.32.96 Ntrac3-vip.localdomain NTRAC3-VIP#SCAN10.1.32.99 Rac-scan.localdomain Rac-scan#Database和Grid安装#创建ccdb数据库Configure CCDBRedo Log Modify Size 100M then create 4 groups of redo log* * Follow the prompts to modify the OKALTER SYSTEM setprocesses=500 Scope=spfile;The system has changed.ALTER SYSTEM setsession_cached_cursors=500 Scope=spfile;System has changedALTER SYSTEM setsg

Tags: containe name open rand JSON begin data ONS RACThe requirements of the test environment for the first two days will be on-line production environment, demand orA. Data source: SSP library ssp.m_system_user,oracle DB 12.1.0.2.0,ogg Version 12.2.0.1.1 oggcore_12.2.0.1.0_platforms_151211.1401_ FBOB. Data target: MySQL DLS library Dls_system_userC.kafka cluster: 10.1.1.247, Ogg Version 12.3.0.1.0 oggcore_oggadp.12.3.0.1.0ga_platforms_170828.1608 Sin

Label:Reprint Please specify source: http://blog.csdn.net/anxpp/article/details/51345074, thank you! This article is for the most basic operations of students who have not used Oracle (whether they have used other databases or not).1. DownloadAddress: http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html Download links with various platforms supported by the Enterprise and St