oracle database 12c training

Tags: 01:23:06 [emailprotected]> Select name, decode (CDB, ' YES ', ' multitenant Option enabled ', ' Regular 12c Database: ' ) "Multitenant Option", Open_mode, con_id from V$database; NAME multitenant Option open_mode con_id--------------------------------------------------------------------ORCL Regular 12c database:

move datafile '/u01/app/oracle/oradata/cdb/pdb/pdb_users01.dbf ' to '/u01/app/pdb_user01.dbf ';Database altered.Sql> Select Name,status from V$datafile where file#=10;NAME STATUS-------------------------------------------------------------------------------- -------/U01/APP/PDB_USER01.DBF ONLINESuccess!Summary: Although Oracle

Tags: Oracle 12c Three-node RAC installation error [ins-32025]Test installs three node Oracle 12C RAC, notebook configuration dual core I5 16g memory, each VM allocates 4G memory.During the installation of the database software, the primary instance restarts unexpectedly and

First, the environmentService side: Oracle 12.2.0.1 RACClient: Less than Oracle 11.2.0.3Second, the phenomenonWhen using a less than Oracle 11.2.0.3 client version connection to the Oracle 12.2.0.1 RAC database "Ora-28040:no matching authentication protocol"Third, solve the

Tags: NET error online update HTTP upgrade error GES debugYesterday afternoon, the implementation reported an Oracle error ora-03137said that the database in 11g no problem, upgrade to 12c, the error.Local debugging, see after executing SQL, reported exception, as follows:Execute SQL in a 12c

Oracle transaction-based temporal tables, under 11g and 12C, can be seen when statistics on temporary tables are collected, the former records are emptied, the latter is not, which is an important distinction. In the company environment with 12C, in the field with 11g, using temporary table will cause the time is slow, before I have a post http://blog.csdn.net/st

The company installs an Oracle 12c test environment, is ready to export the online library to test performance, the results of the test library of the character set selected Al32utf8, a look at the line is ZHS16GBK, or to maintain the same, and then record Al32utf8 ZHS16GBK character Set process: first, the most important thing: backup. Back up your data. Don't forget to back up your data. C:\windows\syst

ArticleDirectory New Features Database architecture On July 6, June 26, 2013, Oracle Database 12C was officially released. The first version was 12.1.0.1.0. The first download platforms were Linux and Solaris: Oracle official: Http://www.oracle.com

Label:Oracle DB 12c new feature: Raw device is no longer supported. Reference from:Announcement of De-support of using RAW devices in Oracle Database Version 12.1 (Doc ID 578455.1) Details:De-support of RawThe directory for this article is a notification that the raw device is no longer supported in the Oracle

The entire installation of Oracle cloud control 12c is more complex, just the choice of installation path, login password, port number and many other configurations are confusing, dizzying. This article describes how to get installed after the installation of the various types of port number, URL and how to start, close the cloud control and so on for your reference.For the installation configuration of clo

Tags:control1.0targedbf table spaces archappend backup strategy home Oracle 12c Backup and recovery strategy (Rman Backup [Open Archive/control file/data File/Archive log]): Backup strategy: * Make a full backup of the database (including all data and read-only tablespace) every six months * once a week level 0 backup * One level backup per day * Pre-backup set

The problem originates from a 12c database of the customer and needs to be booted to a non-real time apply mode, but the discovery is performed:ALTER DATABASE recover managed standby database cancel;ALTER DATABASE recover managed standby

Tags: window8 64-bit + Oracle1) Install Oracle 12c 64-bit2) Installing the 32-bit Oracle Client (INSTANTCLIENT-BASIC-NT-12.1.0.1.0.ZIP)Download Instantclient-basic-win32-11.2.0.1.0.zip, must be the Win32 version, the Oracle official website downloads, unzip it to the Oracle

Tags: Oracle windows "[INS-30131] the Initial Setup that's Required to Run the installation program Validation were not successful" Error Wh Ile installing Oracle Database (Doc ID 1569962.1) To Bottom In this Document Symptoms Cause

#!/bin/bash# #oracle: Start/stop Oracle Database 11g r2/12c## chkconfig:345 - Ten# description:the Oracle Database Server is a RDBMS created by Oracle corporation## processname:oracle.