the sub-patch of the data dictionary, such as performing the above operation, and the patch_id PSU 21948354 below will remain and take effect. Sql> select * from Dba_registry_sqlpatch;patch_id VERSION STATUS---------- ---------- ----------------------21948354 19553095 1 SUCCESS 3. When rollback does not update the binary of the database dictionary, you do not need to run $oracle_home/opatch/datapatch-verbose When rollback has updated the PSU for the
://download.oracle.com/docs/cd/e11882_01/server.112/e17022/rman.htm#cihiaadcPostScriptIf you want to enable the real-time application, you need to add standby redo log in the standby, the size should be the same as the main library, and more than the main library group;ALTER DATABASE Add standby LOGFILE GROUP 6 size 500M;ALTER DATABASE Add standby LOGFILE GROUP 7 size 500M;ALTER DATABASE Add standby LOGFILE GROUP 8 size 500M;ALTER DATABASE Add standby LOGFILE GROUP 9 size 500M;Enable command:ALT
:--------------------------------------------------------------------------------------------qq:251097186Email: [email protected]Blog:http://blog.csdn.net/tianlesoftwareWeibo:http://weibo.com/tianlesoftwareTwitter:http://twitter.com/tianlesoftwareFacebook:http://www.facebook.com/tianlesoftwareLinkedin:http://cn.linkedin.com/in/tianlesoftwareDave's QQ Group:--------------------------------------------------------------------------------------------Note: Add group must indicate tablespace and
Eight Important Notes for Data Guard to deploy the physical standby database. These eight points are mainly for DG deployment after 10g R2.
① Set the master database to force logging Mode
Idle> select force_logging from v $ database;
Idle> alter database force logging;
② Set the master database to archive Mode
Idle> archive log list;Idle> shutdown immediate;Idle> startup mount;Idle> alter database archivelo
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 single container cdb. The PDB does not include the Scott user by default.To do 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 ex
]Blog:http://blog.csdn.net/tianlesoftwareWeibo:http://weibo.com/tianlesoftwareTwitter:http://twitter.com/tianlesoftwareFacebook:http://www.facebook.com/tianlesoftwareLinkedin:http://cn.linkedin.com/in/tianlesoftwareDave's QQ Group:--------------------------------------------------------------------------------------------Note: Add group must indicate tablespace and data file relationship | Do not repeat the addition groupcndba_1:104207940 (Full) cndba
Explore Oracle The database upgrade seven11gR2 to 12c Insert after upgrade complete PDBObjective: fromOracle 12cat the beginning, the concept of container database is introduced, which can implement database plug-in operation, such as:now let's take a look at how to11.2.0.4the database is inserted into the12cof theCDPgo inside and let it be aPDBDatabase.First, View database Information :sql> Col BANNER for
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 tansnames value within the UserID parameter, such as Userid=user/[email protected]
autoextend on next 50m maxsize 2048m extent management local; creating temporary tablespace create temporary tablespace my_space_tem Ptempfile'/usr/local/yrm/oracle_data/my_space_temp.dbf'size 32mautoextend on next 32m maxsize 1024mextent management local; Creating user create Users C # #my_user_1 identified by123456 defaulttablespace my_spacetemporary tablespace my_space_temp; authorize Grant Connect,resource to C # #my_user_1; Grant DBA to C # #my_ user_1; Switch User conn my_user_1/123456 a
starts, the PDB for all is the Mount state, and there is no default mechanism to start the PDB automatically when CDB starts.However, the automatic open of the PDB can be implemented by a trigger:Createor REPLACE TRIGGER Open_pdbsAfter STARTUP on DATABASEBEGINEXECUTE IMMEDIATE ' alterpluggable DATABASE all OPEN ';END Open_pdbs;/Example:Sql>show Con_nameCon_name------------------------------PdbcndbaSql>alter session Set Container=cdb$root;Sessionaltered.Sql>create OR REPLACE TRIGGER Open_pdbs2 a
startedSqlplus Sde/[email protected]Oracle Multi-InstanceCreate a second instanceExport ORACLE_SID=TORCLDBCA Creating a DatabaseDbcaNETCA Creating a listenerCreate User and table spacescreate tablespace TSDE_TBS datafile ‘/data/oracle/app/oradata/TORCL/datafile/TSED1.dbf‘ size 1g autoextend on;
create user tsde identified by tsde default tablespace TSDE_TBS;
gr
Deep understanding of Oracle RAC 12cJump to: Navigation, search
Directory
1 Overview
2 Cluster parts management and fault diagnosis
3 Operational Practices
4 new Features
5 Storage and ASM
6 problems in application design
7 managing and tuning a complex RAC environment
8 Backup and Recovery
9 Network Practice
Ten Optimizing the RAC database
One Lock and deadlock
] ~]$ 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--- ---------------------------empcon_id----------
Tags: class java int C data usage1. The Oracle Universal Installer is now available, with a graphical interface installed, and the Java Runtime Environment installed automatically, although the ZIP installation package is a handy and easy-to-use operation.2. For integrated capture (Integrated capture), there is a further improvement in performance and no additional configuration is required for the user;3.
This article mainly introduces the basic management of CDB and PDB, the source Oracle official.
Basic concepts:
Multitenant Environment: Multi-tenant environment
CDB (Container db): Database Container
PD (Pluggable database): pluggable databases
CDB and PDB diagram
COMMON users (ordinary users): often built on the CDB layer, the user name in C # #或c # #开头;
Local Users: Only the PDB layer is established and the container is specified.
In
) Delete data sheetI don't have it, so I've been reporting it.(6) Create a data table (note that there is a space between the parentheses, there is no space to write the error, between the brackets to have a space)(7), inserting data into the table test(8) Transaction submissionNote: Do not commit before the knock is obsolete, be sure to submit(9) Effect after su
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.