Read about oracle 12c database new features for dba, The latest news, videos, and discussion topics about oracle 12c database new features for dba from alibabacloud.com
Tags: database backup solution Oracle
Course lecturer: Xiao Liu Teacher
Course Category: Oracle
Suitable for people: advanced
Number of lessons: 15 hours
Update level: Complete
Type of Service: Class C (General Service class course)
Using the technology: Oracle
Projects involved:
ORACLE11G is a more generic version, trying to install Oracle 12c unfortunately failed, there is no wayThe following is the collation of information
1. Attached to the installation file
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip? authparam=1407205871_4259949f8bacf912168631692563a693Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip?
How to automatically start PDB Pluggable Database in Oracle 12c
PDB Pluggable Database is an important new feature of 12c, but for PDB in CDB, all PDB is not brought when CDB is started by default, in this way, we need to manually
Tags: database backup Oracle Solution
Need more information to contact Q2748165793
First Lecture: Introduction to Backup and recovery-related operationsBackup and Recovery SolutionsSecond: Starting the Rman operation and the Rman architectureRMAN ChannelsRman Backup and recovery related operationsConfiguring the Rman Backup EnvironmentConfigure Backup retention PoliciesClient Tools useAbo
Oracle has been releasing Oracle for 12C for some time and Oracle has only 64-bit releases and no 32-bit version. Our system installation environment is CentOS 6.5 x86_64. 1. Install Oracle Dependency PackModify the Yum configuration and install 32-bit and 64-bit RPM by defa
1. The PDB to be used for cloning as read-only status: Startup Open Read OnlySelect from V$pdbs; con_id NAME open_mode-------------------------------------------------- 2 pdb$seed READ only 3 PDB1 Mounted 4 P4 mountedsqlset container=pdb1; SQL> ALTER DATABASE open Read only;2. Login CDBSql> Connect/ asSysdbasql> Create p
/gaoERROR:Ora-01045:user C # #ERIC lacks CREATE SESSION privilege; Logon denied----have no permissions, we can give it permission individually, or we can assign a role to it.Warning:you is no longer connected to ORACLE.Sql> Conn/as SYSDBAConnected.Sql> Grant DBA to C # #eric Container=all; ---to its DBA role, with a role scope covering all containersGrant succeeded.Sql> Conn C # #eric/gaoConnected. ---conne
powerful tool 36Learn more from data dictionary 38DBA work Note of yangtingkun (by Yang Tingting) 45Use SQL to explain a magic 46
. ORA-600 (17069) Error solving process 47V $ diagnosis of exceptions in the SQL view Result 51Error parsing for Stored Procedure ORA-4068 54Diagnosis of a network connection error 57Talking about the features of job and database link 58One ORA-01041 error diagnosis 60Analysis o
space recoveryRecovering tables with Rman backup sets12th: Optimizing Rman PerformancePurpose of Rman performance optimizationBasic concepts of Rman performance optimizationUsing views to diagnose Rman performance issuesTuning Rman Backup Performance13th: Handling Rman-related operational issuesInterpreting messages for Rman outputDiagnosing Rman problems with the v$ viewInterrupt Rman Operation method14th: Using Rman for data migrationOverview of Rman data
In addition to using DBCA to delete the Oracle 12C database, we can also use the drop database Command to delete it.This deletion method is very simple, but must meet the following two requirements:1. The database must be in the mount State and cannot be in the open state;2.
insert the PDB and then complete a post-insertion step.? the first step, the 12.1 before the library upgrade to 12c version;? The second step is to connect to the non-CDB library in order to produce a presentation file, as shown in the removal of a PDB section:ShutdownimmediateStartupmountAlterdatabase Open Read only;BeginDbms_pdb. Describe (pdb_descr_file=> '/home/oracle/oradata/noncdb/noncdb.xml ');End/S
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
In the 11g cluster, we often use the initialization file (pfile) under DBS to specify the actual spfile in the ASM
[Oracle@ol6-112-rac1 dbs]$ Cd/u01/app/oracle/product/11.2.0.4/db_1/dbs[Oracle@ol6-112-rac1 dbs]$ lsHc_acfsdb.dat hc_cdbrac_1.dat hc_cdbrac_2.dat initcdbrac_1.ora initcdbrac_1.ora.orig init.ora orapwacfsdb SPFILEACF Sdb.ora[
Installation of Oracle Database 12C in Linux
Install Oracle Database 12C in Linux. After the installation, Oracle Configuration Manager fails to be properly installed, which does not ma
Server A installs the Oracle 12c 64-bit database, and Machine B accesses the Oracle database.Get ready:1. Download Instantclient-basic-nt-12.1.0.2.0.zip,:http://pan.baidu.com/s/1c04lzso2. Download Plsql,:http://pan.baidu.com/s/1bnhkdojInstallation steps1. Installing the Orcle ClientUnzip the downloaded instantclient-ba
Description of Oracle 12c CDB and PDB database startup and shutdown, 12 cpdb
In Oracle 12c, it is divided into CDB and PDB. Their startup and shutdown operations are as follows.
1 Container Database (CDB)
For CDB, the startup
Label:Installing Oracle Database 12c Release 1 (12.1.0.2.0) under WindowsRecently, Oracle database 12c Release 1 (12.1.0.2.0)-Enterprise Edition needs to be installed due to the need to establish an ODI repository on
(i) Launch of the databaseStarting (startup) a database requires three steps.1. Launch the Oralce instance2. Loading the database by instance3. Open the Database·1) STARTUP NomountThe Nomount option launches only one Oracle instance·2) STARTUP MOUNTThe Startup Mount command launches the instance and mounts the
;Rman Target/Run{Allocate channel C1 type disk;Allocate channel C2 type disk;Allocate channel C3 type disk;Backup Filesperset 3 as compressed backupset database format '/home/oracle/0705/fulldata%d%T%s%p ‘;Backup Archivelog all format '/home/oracle/0705/arch%d%T%s%p ' delete input;Backup current controlfile format '/home/orac
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.