oracle 11g tutorial

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4 I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R

ASM file allocation in a disk group Oracle ASM striping Oracle ASM strip has the following two purposes: Distribute the Server Load balancer across all disks in the disk group. Reduces I/O latency ASM strip is divided into coarse-grained strip and fine-grained strip. Coarse-grained strip is used as a disk group to provide load balancing, while fine-grained strip can reduce the I/O latency of a specif

export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database character set:SELECT * from V$nls_parameters WHERE PARAMETER in (' Nls_characterset ',

Oracle Easy Interface ToolBackground: I work on a remote machine, I need to call data to the Oracle 11g server, the Oracle client is already installed on the remote machine, but neither SQL Plus nor SQL developer and PL SQL developer are available (DBAs don't fix it for a few days). I have the server IP,

Tags: oracle-11g navicat win7-64bitNavicat for Oracle Connect Oracle 11G operation Flow 1 Changing the Oracle configuration file After you install Oracle

"rolling upgrade" for ORACLE11g and later versions. In other words, you cannot use this function to upgrade ORACLE10g databases to 11G. Before performing a rolling upgrade, make sure your environment is ready. For example, if you use the ORACLE Clusterware software, you must complete the upgrade to the next version that meets the requirements before rolling the upgrade. Of course, you should also use the r

Write in front: In the work, the general installation of Oracle oneG client, configure Net Manager (installed client or server), remote connection to the Oracle database to meet the needs of connecting the database. If you want the machine to operate Oracle, you need to install Oracle one-to-oneG server.

This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not worry about the kids shoes. I

This paper is compiled from Oracle documentation Warehouse Builder 11g Architecture and components Oracle Warehouse Builder is an information integration tool that can transform data into high-quality information using an Oracle database. The Oracle database is the central

Oracle study-oracle 11g OCM Exam (1)System environment: RedHat EL64Oracle:oracle 11gR2Oracle 11g OCM Exam First, manual build library, reference document 650) this.width=650; "Src=" http://img.blog.csdn.net/20160408214710987?watermark/2/ Text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dis

Navicat for Oracle connection to Oracle 11G operation process, navicat11g Procedure for connecting Navicat for Oracle to Oracle at 11 GB 1. Change the Oracle configuration file After installing

Oracle lab environment setup (Windows + Oracle 11g) I. systems and software Windows 7 + Oracle 11g 2. Prepare the installation environment Prepare for ORACLE Installation 1. Delete Environment Variables D: \

Install Oracle 11g in Oracle Enterprise Linux. Prepare the server and operating system. 2. Check the redhat kernel version. [root @ redhat ~] # Uname-r 2.6.32-131.0.15.el6.i686 installation package check [root @ redhat sysconfig] # rpm-qa | grep binutils binutils-2.20.51.0.2-5.20.el6.i686 www.2cto.com binutils-devel-2.20.51.0.2-5.20.el6.i686 [root @ redhat syscon

install11. Use the Startup ScriptYou need to make some changes before using the startup script, mainly to configure the ORACLE_HOME_LISTNER variable.Vi $ ORACLE_HOME/bin/dbstartPut 79 rowsORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleModifyORACLE_HOME_LISTNER = $ ORACLE_HOMEOtherwise, an error is returned:[Oracle @ gtlions bin] $./dbstartFailed to auto-start Oracle Net Listene using/ade/vikrkuma_new/

Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem) Method 1: Export imports all use 11g clients --11G Cli

Lab environment: Oracle 11g R2 RAC (11.2.0.3.5) Oracle Enterprise Linux 5.6x86 1. Create an ASM disk group and mount the disk on two nodes. Then, partition the disk on the first node. [root @ Rac1 ~] # Fdisk-ldisk/dev/SDE: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersunits = cylinders of 16065*512 = 8225280 bytes Device boot start end blocks

unknown keyNote: The value of kernel. shmmax's is half of the physical memory. My memory is 2 GB, so it is 1073741824Step 2: VI/etc/security/limits. conf, add:Oracle soft nproc 2047Hard nproc 16384Oracle soft nofile 1024Oracle hard nofile 65536Step 3: VI/etc/PAM. d/login. Add the following parameters:Session required pam_limits.so step4: VI/etc/profile:If [$ user = "oracle"]; thenIf [$ shell = "/bin/KSh"]; thenUlimit-P 16384Ulimit-N 65536ElseUlimit-u

information between Oracle processesAbout connected session information, including all current active and inactive sessionsDatabase information is stored in the SGAORACLE.DATABASE.11G InstallationThis trial CentOS6.5 system, before installing Oracle to pay attention to hardware requirements, memory minimum of 4GB, virtual memory is twice times the physical memor

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive. SQL> alter system set cluster_database = false scope = spfile sid = '*'; 2. Shut down all instances (shutdown on both sides) SQL> shutdown imm

://img1.51cto.com/attachment/201405/16/665690_ 14002507119ka6.jpg "" 725 "height=" 544 "/> 14) as shown, select IgnoreAll (make sure the package that is ignored has all been successfully installed), click Next. 650) this.width=650; "title=" 05-014 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" 05-014 "src=" http://img1.51cto.com/attachment/201405/16/665690_ 1400250713x1w