oracle 11g book

+ ---------------- 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

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

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

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

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

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

We have provided an overview of the unique features of Oracle 11g R2. At the same time, we also describe the enhancement of the data warehouse performance related to Oracle 11g R2. The following describes the enhanced features of Data guard in Oracle

" user./U01/oracle/product/11.2/db_1/root. shTo execute the configuration scripts:1. Open a terminal window2. Log in as "root"3. Run the scripts The cloning of OraDb11g_home1 was successful.Please check '/u01/oracle/oraInventory/logs/cloneActions2013-10-28_02-45-44PM.log' for more details.Run root. sh as the root user.[Root @ rac2 tmp] # sh/u01/oracle/product/11.

Label:1. Download Oracle 11g R2 for Windows version: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.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", and then click the "setup.exe" file under the extracted directory:3. In the Configure Security Update

Some ASP. NET + Oracle 11g learning and writing essays. This seriesArticleIt can help. net that is unfamiliar with Oracle and is not even used at all.ProgramStaff, can get started and develop applications in the shortest time, to avoid having to spend as much time as I did for the support team to flip books, Query files, create code for implementation and test, a

Label:Selection:32-bit memory is a bottleneck, already 64-bit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In virtual machine installation, the network is set up by hostonly modeNote: Network adapter to set up ICS (Internet Connection Sharing) to the VMware network Adapter VMnet1So for virtual machines, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24 segmentHDD 40G, Memory 2G1

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

Tags: des c tar ext color http1. Build Oracle RAC 11g cluster on Oracle Enterprise Linux and ISCSI2. All shared disk storage for Oracle RAC will be based on ISCSI,ISCSI using Openfiler version 2.3, which runs on the third node, which is referred to as the networked storage server in this article x86_643. Each Linux nod

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary 1. Preparations before installation: Operating System: RHEL6.5 Storage: Huawei, multi-path configured Bind the business network card and heartbeat network card and pass the redundancy test. YUM source configuration BASH/SSL vulnerability patches 2. Check System Requirements A. LINUX version Cat/etc/issue B. Memory (at least 1 GB) Grep

The following problems are frequently encountered during data migration: 1. If the exported file is not valid, the header verification fails; 2. EXP-00056: Oracle error 6550ORA-06550: Line 1, column 41:PLS-00302: component 'set _ no_outlines 'must be declaredORA-06550: Line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export termination failed About import and export: 1. The exp command on the client must be consistent with the

One, install the Ubuntu 13.04 Server 64-bit version (the simplest to install), and then install all the following accessories #apt-get update #apt-get Dist-upgrade # Apt-get Install Automake autotools-dev binutils bzip2 doxygen elfutils expat gawk unzip #apt-get install gcc gcc-multil IB g++-multilib ia32-libs ksh less lesstif2 lesstif2-dev #apt-get install lib32z1 libaio1 libaio-dev Libc6-dev libc6-de v-i386 libc6-i386 #apt-get install Libelf-dev libltdl-dev libmotif4 libodbcinstq4-1 lib

The ORA-00845 is prompted when the database is started: MEMORY_TARGETnotsupportedonthissystem (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle11g The ORA-00845 is prompted when you start the database: MEMORY_TARGET not supported on this system (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle 11g 1. The ORA-00845: MEMORY_TARGET not supported on this