测试oracle 11.2.0.4 + goldengate 11.2,需要两台LINUX测试环境都将安装oracle,目前RAC1已经安装好ORACLE 11.2.0.4 SOFTAWRE,节
测试Oracle 11.2.0.4 + goldengate 11.2,需要两台LINUX测试环境都将安装oracle,
测试环境节点1机器名:RAC1 源端
使用clone.pl脚本克隆:
[oracle@rac2 ~]$ cd /u01/oracle/product/11.2/db_1/clone/bin
[oracle@rac2 bin]$ ls
clone.pl prepare_clone.pl
[oracle@rac2 bin]$ perl clone.pl ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/product/11.2/db_1 ORACLE_HOME_NAME=OraDb11g_home1
./runInstaller -clone -waitForCompletion "ORACLE_BASE=/u01/oracle" "ORACLE_HOME=/u01/oracle/product/11.2/db_1" "ORACLE_HOME_NAME=OraDb11g_home1" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1023 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-10-28_02-45-44PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/oracle/oraInventory/logs/cloneActions2013-10-28_02-45-44PM.log
................................................................................... 100% Done.
Installation in progress (Monday, October 28, 2013 2:46:23 PM CST)
.............................................................................. 78% Done.
Install successful
Linking in progress (Monday, October 28, 2013 2:46:42 PM CST)
Link successful
Setup in progress (Monday, October 28, 2013 2:49:39 PM CST)
Setup successful
End of install phases.(Monday, October 28, 2013 2:50:08 PM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
/u01/oracle/product/11.2/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. 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.
使用root用户执行root.sh
[root@rac2 tmp]# sh /u01/oracle/product/11.2/db_1/root.sh
Check /u01/oracle/product/11.2/db_1/install/root_rac2_2013-10-28_14-50-29.log for the output of root script
到此位置克隆完成。
以前这台机器安装过ORACLE 10GR2 RAC,现在检查ORACLE 11G ORACLE_HOME_NAME是否添加到inventory.xml [root@rac2 ~]# cd /u01/oracle/oraInventory/ContentsXML [root@rac2 ContentsXML]# ls comps.xml inventory.xml libs.xml [root@rac2 ContentsXML]# more inventory.xml
推荐阅读:
Linux操作系统中Oracle 11g数据库安装过程图文详解
CentOS 5.6 上安装 Oracle 11g R2 单实例数据库详解
Oracle VM虚拟机中安装Oracle Clusterware 11g步骤
VM虚拟机下在Linux上安装Oracle 11G单实例数据库

TodropaviewinMySQL,use"DROPVIEWIFEXISTSview_name;"andtomodifyaview,use"CREATEORREPLACEVIEWview_nameASSELECT...".Whendroppingaview,considerdependenciesanduse"SHOWCREATEVIEWview_name;"tounderstanditsstructure.Whenmodifying

MySQLViewscaneffectivelyutilizedesignpatternslikeAdapter,Decorator,Factory,andObserver.1)AdapterPatternadaptsdatafromdifferenttablesintoaunifiedview.2)DecoratorPatternenhancesdatawithcalculatedfields.3)FactoryPatterncreatesviewsthatproducedifferentda

ViewsinMySQLarebeneficialforsimplifyingcomplexqueries,enhancingsecurity,ensuringdataconsistency,andoptimizingperformance.1)Theysimplifycomplexqueriesbyencapsulatingthemintoreusableviews.2)Viewsenhancesecuritybycontrollingdataaccess.3)Theyensuredataco

TocreateasimpleviewinMySQL,usetheCREATEVIEWstatement.1)DefinetheviewwithCREATEVIEWview_nameAS.2)SpecifytheSELECTstatementtoretrievedesireddata.3)Usetheviewlikeatableforqueries.Viewssimplifydataaccessandenhancesecurity,butconsiderperformance,updatabil

TocreateusersinMySQL,usetheCREATEUSERstatement.1)Foralocaluser:CREATEUSER'localuser'@'localhost'IDENTIFIEDBY'securepassword';2)Foraremoteuser:CREATEUSER'remoteuser'@'%'IDENTIFIEDBY'strongpassword';3)Forauserwithaspecifichost:CREATEUSER'specificuser'@

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Atom editor mac version download
The most popular open source editor

Dreamweaver Mac version
Visual web development tools

SublimeText3 Chinese version
Chinese version, very easy to use

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 English version
Recommended: Win version, supports code prompts!
