oracle 12c books

Basic Introduction to Oracle 12C PDB Maintenance Basic usage: Run the command before 11G. Conn/as sysdba; Create user test identifed by test; ORA-65096: The public user name or role name is invalid. Check the official document and find that "to create a general-purpose user, you must start with C # Or c #." At this time, I have some questions. What is a common user? No matter whether it is created first Cre

Summary of new features in Oracle 12C SQL Multiple indexes on the same field Before Oracle 12c R1, a field cannot have multiple indexes in any form. Some may wonder why a field usually requires multiple indexes. In fact, there are many fields or field sets that require multiple indexes. In

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 within the UserID parameter, such as Userid=user/[email protected] Data Pump Import and export example1. View the current SID, view the P

Tags: images virtual is the database management TOC various Sysstat graphical interface homeOracle database is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational database management system, System portability, easy to use, strong function, applicable to all kinds of large, medium, small, microcomputer environment. It is a highly efficient and reliable database solution tha

Tags: vertical details system performance which fast SAP database combined bottleneck This article comes from reading notes on which is Faster HANA or Oracle 12C, and outlines the key points. Does not represent my point of view.Brief introductionSAP claims that Hana is the fastest database, so SAP's new ERP system S4 no longer supports Oracle A new feature of

Previously wrote an article by modifying the control file to modify the path of the problem, now use method two through rename to modify the path of the problemExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way.Migration stepsFirst turn off monitoring, and kill the connected appPs-ef | grep Local=no | awk ' {

Turn RAC off (Oracle 12C note) Turn RAC off (Oracle 12C note) Check RAC status [Grid @ rac01 ~] $ Crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533:

Label:installed a Oracle 12c is not able to connect to Oracle 12c after using PL/SQL developer. Look online, according to Fcflying said the operation succeeded, so make a note: 1) Install Oracle 12c 64-bit : HTTP://WWW.ORACLE.COM/

Dangdang page Link: Http://product.dangdang.com/23625712.html The 1th chapter Oracle Database Basic knowledge1.1 What is a relational database1.1.1 Relational Database modelFounder of 1.1.2 Relational data model1.2 Oracle Database Development historyThe beginning of 1.2.1 Company1.2.2 Oracle Database development process1.3 Database RDBMS1.4 SQL Language Introduct

The installation of Oracle Enterprise Cloud Control 12c is a complex process because he needs to rely on Oracel database and Oracle Weblogic. Now that Oracle has integrated the WebLogic into the Cloud control installation package, this article is based on Oracle Linux 6.3 in

PL/SQL Developer log on to Oracle 12c After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note: 1) install

SQL Server played for some years and recently wanted to play Oracle, so I thought of playing with an Oracle server. The first time you install Oracle under Linux, the entire process references an article: http://blog.csdn.net/huangyanlong/article/details/45021171Environment: VMWare workstatrion 8.0.3Operating system: CentOS 7 x64Database:

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 architecture. First, it needs a database (that is, repo

Explore Oracle Database Upgrade 7 11gR2 to 12c after the upgrade is complete, insert PDB, 11gr2pdb Explore Oracle Database Upgrade 7Insert PDB after 11gR2 to 12c upgrade is complete Preface: Since Oracle 12c, the concept of contai

Complete uninstall of Oracle 12c operation steps on Windows7 1. Turn off all Oracle Services and press "Win+r" to Run "services.msc" to find all services that begin with Oracle (oraclevsswriterorcl+oracleserviceorcl+ ORACLEORADB12HOME1TNSLISTENER+ORACLEORADB12HOME1MTSRECOVERYSERVICE+ORACLEJOBSCHEDULERORCL), click S

On April 9, June 2013, Oracle officially released Oracle Database 12C release 1. It is as follows: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html According to Sina Weibo, a well-known Chinese DBA, guobiao, Oracle 12c has new features su

The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _ Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a secondary encapsulation of crs_stat to make the results look more fresh. For example: In the