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,
available RAM and swap space, enter the following command: FreeAutomatic Memory Management Starting with Oracle Database 11g, the Automatic memory Management featurerequires more shared Memory (/DEV/SHM) A nd file descriptors. The size of the sharedmemory must is at least the greater of the Memory_max_target and Memory_targetparameters For each Oracle instance o
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
SetWholeKingdeeEAS DatabaseMove to another environment for development and testing:
BackupOracle Database: (you can also PL-SQL through external tools)
[Oracle @ rcno8 ~] $Sqlplus
SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Enter user-name:Conn/as sysdba
Enter password:
Connected:
Oracle
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
means that your sys password has been changed to admin, you can sql>conn sys/admin as sysdba after you know the password of sys, you are the boss, you can change the password of system and Scott, In fact, Scott's default password is Tiger, can be used directly, but the first login will prompt you to modify, if you are turned into a test with this is also very good. The summary process is as follows: Sql*plus:release 11.2.0.1.0 Production on Monday January 10 22:25:16 2011 Copyright (c) 1982,
Two test samples were made in the art of simulating Oracle performance diagnostics. The book says not to bear relies_on. Cache (Result_cache relies_on (test1,test2)). The test proved incorrect, and the function F1 () did not use relies_on, but the changes on the table affected the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 19:46:44 2014Copyright (c) 1982, 20
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
Have always wanted to learn Oracle, but is the installation of Oracle has not been successful, people are very distressed, especially what listener what, has not understood, got a whole day did not get out, the Internet to find information on most of the information is uneven, not too detailed, and after the attempt has not been successful, Now through my careful modulation, finally installed successfully,
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
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
Tags: Manager 11.2 lin ERP Change write img for actions1, ready to installView the current version of Oracle and make sure it is older 11.2.0.1[[Email protected]_test_121_90 ~]$ rlwrap sqlplus/as sysdba
sql*plus:release 11.2.0.1.0 Production on Fri Mar 17 15 :
Copyright (c) 1982, 20:45, Oracle. All rights reserved.
Connected to:
Oracle Database
" 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
password. Default interface: Our default connection name is to use the ORCL User name: System Password: just set the Host Name: Default to local (localhost) Port number: 1521 Sid:xe Note that we need to modify xe for ORCL. You can click Test to test and connect. After the test is successful, you can fill in the Save password. Convenient for later login users. Save the information: Executes a statement with the following effect: Transferred from: http://www.cnblogs.com/liuhongfeng/
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
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.