oracle ocp

Tags: DBA RAM read-write management art SSE buffer temp tablespace UNIXReprinted from: http://blog.csdn.net/robinson_0612/article/details/5529239 An Oracle server consists of an Oracle instance and an Oracle database. That is: Oracle Server = Oracle Instance +

the Balance2. Using RACWhat happens with RACCluster-related concepts: Brain fissure, amnesia, votingDeploying a two-node clustered environment using ASM as a storage installationInstalling the grid software on multiple nodesInstalling Oracle database software on multiple nodesCreate and manage a multi-node db instanceRAC Daily Command SummaryCommon Troubleshooting for RACHow RAC environments are optimized3. Using DGDG PrincipleWhat is a logical libra

recommended to intensive reading. Oracle upgraded? How to quickly read Oracle's new features Oracle Database New Features Guide After each new version of Oracle release, look at Oracle Database New Features Guide for the latest feature, which can be read roughly without intensive reading.

First, recover via file descriptor (descriptor) (RM delete data file not backed up) Scene: misoperation Delete data file tp10.dbf Rm-rf/u01/app/oracle/oradata/bxdb/tp10.dbf Select Ts#,file#,name,bytes,status from V$datafile; Ps-ef |grep dBW |grep-v grep Cd/proc/12308/fd 1. Method One: Online recoveryCp/proc/13979/fd/264/u01/app/oracle/oradata/ocp/newtp12.db

Tags: OracleSet power on (Linux) auto-start Oracle shutdown automatically shuts down Oracle1, switch to the root user, confirm that the startup file and the shutdown file is present[Email protected] bin]$ pwd/u01/oracle/product/10.2.0/db_1/bin[[email protected] bin]$ ls DbstartDbstart--sqlplus script to invoke when executing startup[[email protected] bin]$ ls DbshutDbshut--sqlplus the script to invoke when

Oracle redo complexity-oracle Core Technology Reading Note 3, redo-oracle I. Overview We know that in oracle, Every modification to a piece of data generates a redo (that is, redo, which records the modified content ). The purpose is to back up the modified data for future redo. Now there is a problem. Redo logs are ge

Because of the installation of Oracle 10G when there was a problem, and then asked roommates to send a copy of the Oralce 10g client installation package came up. It was possible to use Pl/sql, and then, in the case of a job need, to import an Oracle database backup from a colleague at a time, making IMP statement to import a 6550 error, the internet to check the reason is because the server and the clien

Study of oracle lesson one, oraclelesson Oracle learning Part 1 1. oracle Introduction 1.1 common database categories Small databases: SQL server, access (Microsoft) Medium-sized databases: mysql (from Sweden) and sybase (sybase from the United States) Large Databases: informix (IBM), oracle (

1. View database Information Show parameter instance_name Show parameter Db_name Show Parameter Service_Name Select dbid from V$database; 2. Normal Shutdown database Sqlplus/as SYSDBA Sql>shutdown Immediate 3. Start database to mount mode Sql>startup Mount 4. Confirm that the listener is activated. Lsnrctl status 5. Modify Database name Host nid Target=sys/password DBNAME=OCP setname=y # Change Database ID and database name Oratest to TE

Based on my practical experience, this forum article (CCID technical community) provides some insights for Oracle learners. For details, see the following: Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of

Oracle learning suggestions Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of Oracle, such as Unix, such as network and storage. Therefore, you must be interested in

test the OCP certificate, a system for Oracle to learn, and then see Oracle Concepts, Oracle online document, the principle of Oracle will have a deeper understanding of the principles, and can begin to do some research topics such as: RMAN, RAS, Statspact, DATAGUARD, TUNIN

Tags: Oracle server notebook CopyrightPrepare to start learning Oracle from scratch.I said 2016 years to write a weekly technical blog. So from now on.Today we have a problem with a weak explosion:A notebook was replaced a few days ago, and the Oracle 11g R2 is installed on the new notebook. Use DBCA installed database without error, shut down the computer to sle

Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of Oracle, such as Unix, such as network and storage. Therefore, you must be interested in learning Oracle well. If yo

Some time ago I started to learn some basic knowledge about oracle. To facilitate exercises and operations, I installed an Oracle 10 Gb. After the installation is complete, the current database is directly deprecated. The card is terrible. The card can only be used for surfing the Internet. At that time, I was too busy to do anything else, so I never care about it. Together with the last Internet cafe. Thes

About Oracle ASM instances About Oracle ASM disk groups About grouping and failure groups About Oracle ASM Disks About Oracle ASM files About Oracle ASM instances The Oracle ASM instance is built based on the same technology a

Method 1: As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client? In fact, I always wanted to do this, because this client is so annoying !!! Not only will JDK be installed,

Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as

Oracle learning notes first knowledge Oracle, oracle learning notes first KnowledgeDatabase Introduction A Database is a warehouse that organizes, stores, and manages data according to the data structure. SQL is the acronym of Structured Query Language (Structured Query Language.Definition 　　DatabaseTo put it simply, it can be regarded as an electronic file cabin

Tags: file path off SQ server has a lock creat evo combo1.Oracle Default UserAccess to Oracle database only with a legitimate user accountOracle has several default database usersAll data dictionary tables and views in the database are stored in the SYS pattern. SYS users are primarily used to maintain system information and manage instances.Systems is the default system administrator who owns the internal