测试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,使用“ dropviewifexistsview_name;” andTomodifyAview,使用“ createOrreplaceViewViewViewview_nameAsSelect ...”。 whendroppingaview,asew dectivectenciesanduse和showcreateateviewViewview_name;“ tounderStanditSsstructure.whenModifying

mySqlViewScaneFectectialized unizedesignpatternslikeadapter,Decorator,Factory,andObserver.1)adapterPatternadaptSdataForomDifferentTablesIntoAunifiendView.2)decoratorPatternenhancateDataWithCalcalcualdCalcalculenfields.3)fieldfields.3)

查看InMysqlareBeneForsImplifyingComplexqueries,增強安全性,確保dataConsistency,andOptimizingPerformance.1)他們simimplifycomplexqueriesbleiesbyEncapsbyEnculatingThemintoreusableviews.2)viewsEnenenhancesecuritybyControllityByControllingDataAcces.3)

toCreateAsimpleViewInmySQL,USEthecReateaTeviewStatement.1)defitEtheetEtheTeViewWithCreatEaTeviewView_nameas.2)指定usethectstatementTorivedesireddata.3)usethectStatementTorivedesireddata.3)usetheviewlikeatlikeatlikeatlikeatlikeatlikeatable.views.viewssimplplifefifydataaccessandenenanceberity but consisterfort,butconserfort,consoncontorfinft

1)foralocaluser:createUser'localuser'@'@'localhost'Indidendify'securepassword'; 2)foraremoteuser:creationuser's creationuser'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Rocaluser'@'localhost'Indidendify'seceledify'Securepassword'; 2)

mysqlviewshavelimitations:1)他們不使用Supportallsqloperations,限制DatamanipulationThroughViewSwithJoinsOrsubqueries.2)他們canimpactperformance,尤其是withcomplexcomplexclexeriesorlargedatasets.3)

porthusermanagementinmysqliscialforenhancingsEcurityAndsingsmenting效率databaseoperation.1)usecReateusertoAddusers,指定connectionsourcewith@'localhost'or@'%'。

mysqldoes notimposeahardlimitontriggers,butacticalfactorsdeterminetheireffactective:1)serverConfiguration impactactStriggerGermanagement; 2)複雜的TriggerSincreaseSySystemsystem load; 3)largertablesslowtriggerperfermance; 4)highConconcConcrencerCancancancancanceTigrignecentign; 5); 5)


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

Video Face Swap
使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

EditPlus 中文破解版
體積小,語法高亮,不支援程式碼提示功能

SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)

SublimeText3 英文版
推薦:為Win版本,支援程式碼提示!

禪工作室 13.0.1
強大的PHP整合開發環境

SublimeText3漢化版
中文版,非常好用