oracle 11g certification

Label:Oracle 051 for several topics (Oracle 11g) 1. Usage of interval SELECT INTERVAL ' month,interval ' 54-2 ' year to Month,interval ' 11:12:10.1234567 ' HOUR-SECOND from dual; The query results are: INTERVAL ' ' MONTH---------------------------------------------------------------------------INTERVAL ' 54-2 ' yeartomonth----------------------------------------

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386

Tags: system sys AST download data BSP Enterprise Database large Web siteOracle Database 11g Release 2 standard Edition and Enterprise Edition software DownloadsOracle Database 11g 2nd Edition Standard Edition,Software download for Enterprise EditionMicrosoft Windows (32-bit) Disc 1, Disc 2 (2GB) 1Microsoft Windows (x64) CD 1, Disc 2 (2GB) 2Linux x86 Disc 1, Disc 2 (2GB) 3Linux x86-64 Disc 1, Disc 2 (2GB) 3

Routine maintenance and troubleshooting of Oracle 11G R2 slave uard 1. About the Forced Logging ModeSome DDL statements can avoid writing redo logs by specifying the NOLOGGING clause (the purpose is to increase the speed, which is indeed valid in some cases). After specifying the database as the force logging mode, the database records all operations except the temporary tablespace or temporary rollback seg

As we all know, it is not easy to migrate a database from a higher version of Oracle to a lower version of oracle. If you directly use the SQL developer tool, you may not be able to complete the migration successfully (errors may occur more or less in the middle ). Exp and IMP are applicable to Oracle data copy and backup of the same version. If

The key reason for upgrading a large object (Large object, LOB) storage capability is the increasing demand for data security in Oracle 11g, which focuses on expanding transparent data encryption for LOB and tablespace (transparent data encryption, TDE) features to improve data security and explain how these features protect complex, unstructured data, such as medical Digital Image communication (Digital Im

CentOS6.5x64 install 64-bit Oracle 11g in silent mode 1. Download the 64-bit Oracle11g source file and upload it to the Linux server. 2. Package installation check and installation: Install the tool using yum: Yum-y install binutils compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaliblibgcc gcc stdc + + libstdc ++-devel make sysstat unixODBC-devel pdksh numactl-d

Oracle 11g New Features 09-10-10Oracle 11g new feature: Rman backup skips the free interval 09-10-10Oracle 11g new feature: Server Result Cache Test 09-10-10Oracle 11g new feature: One of Result Cache 09-10-10Oracle 11g new f

Oracle upgrades from 10g to 11g detailed stepsold Database version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation:Complete Checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2 software Here to Software 'sinstallationIt is not explained in detail, you can refer to the appropriate documentation. Here is the note: If you want to 11gr2 on the late

The learning progress is a little slow. I finally succeeded in installing the Oracle 11g R2 database on the Red Hat Enterprise Linux 5.5 system on the Virtual Machine. Here I will share my installation experience with you! Of course, the level is limited. Please forgive me for your suggestions !! The software version I used is linux_11gR2_database_32bit. You can download it from the

Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database, rmanduplicationIf the production-based duplicate replication is not manually configured with pfile (set memory, process, dg-related configuration parameters, database-related path parameters), various parameters cannot be converted;Because duplicate will automatically copy pfile, control file,

This article uses the interface installation method, applies to the LAN Remote Installation Oracle and installs directly on the Linux server. Through the Internet environment installation has not been tested, the Internet environment by silent installation is better. This article is installed through the red Hat Enterprise Linux 6 64-bit system, Centos 6.6 system. The tools used in this article: Xshell 4, Xftp 4, VMware 10.0.3 The

Install Oracle 11g in CentOS 6.5 I recently started to learn how to use CentOS and make some records. References: Install Oracle 11g in Cent OS 6_5 (x86_64) I. Hardware requirements 1. Memory swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory[Plain] view plaincopy # GrepMemTotal/proc/meminfo

+ ---------------- Install and configure Oracle 11g R2 on centos 5.5 ----------------- ++ -------------------------------- By kerryhu ------------------------------------ + I. Runtime EnvironmentSystem Environment: centos 5.5 32-bit (graphical installation)Hard Disk Partition:/Boot 150 mSwap 4096 M (at least 3 GB)/10g/Home 5g/Tmp 5g/Usr 10g/Usr/local 10g/Var 10g/OPT 10g/Data all remaining DF-H # S

Tags: Oracle1. Download Oracle 11g R2 for Windows version:Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.htmlThese include two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip2, unzip two compressed packets into the same directory, namely "database" directory, and then click the "setup.exe" file under the extracted directory:De

file; CP: Copy files; MV: renaming, moving files; RM: Delete files; mkdir: Create directory; RmDir: Delete directory; Stat: View file statistics; File: View files type; Cat/more/less/head/tail: View the contents of the file; 2 absolute Path relative path Absolute file path: Defines the exact location of the directory in the virtual file structure, starting with the root of the virtual directory; Relative file path: Specifies the destination fil

default yum source speed of the system is often unsatisfactory and all components are connected overseas. In order to achieve quick installation in China, you must modify the yum source. Http://mirrors.163.com/http://mirrors.sohu.com these two domestic sources. Run the following command. Cd/etc/yum. repos. d Mv CentOS-Base.repo CentOS-Base.repo.bak Wget http://mirrors.163.com/.help/centos-base-163.repoor wget http://mirrors.sohu.com/help/CentOS-Base-sohu.repo Run yum makecache to generate Cach

BKJIA featured translations] Oracle 11g R2 extends many new feature suites for backup and recovery, including recovery manager RMAN, many of which are extensions for earlier features. BKJIA editing recommendations: New features and application details of Oracle 11g Automated block recovery. In my opinion, the block-lev

Dataguard is an important solution officially recommended by Oracle for the MongoDB architecture. Currently, RAC + Local federation uard + Remote Federation uard has become a common HA architecture in the industry. Switchover and failover are the most common operation scenarios for RAC and replica uard.Failover is an unplanned switchover action. Generally, the Primary database Primary has a hardware and software fault. If you cannot continue to provid

Oracle 11g Installation Prior to installation to determine their own computer configuration, in Windows, for example, if it is Win7 the following systems such as XP, you can choose Oracle 10g. Because the 10g program files only 200 trillion, and 11g and reached 2G, the official download path to the file can not be fou