MSSQL网站制作之利用Opatch东西使用过渡性Patch

提供用于管理、检查、优化数据库操作的管理工具。
LastUpdated:Saturday,2004-12-0410:04Eygle






良多时分，在推出一个完全的补钉集之前，Oracle会根据Bug的严峻水平公布一些过渡性或一时性Patch，修改一些Bug。
这些Patch一般没有setup安装程序，必要利用Oracle的opatch工具安装，本文就opatch的利用举行树模申明。

1.下载

Opatch的最新版本能够从Metalink下载，参考Note:224346.1

2.利用

在NT/UNIX，Opatch都必要perl撑持，以是，利用之前确认你安装了perl情况撑持。

把下载的patch解压后，可使用opatch挪用安装，树模以下：



$opatchapply2990321PERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules;exportPERL5LIB/opt/oracle/product/9.2.0/Apache/perl/bin/perl./opatch.plapply2990321OPatchVersion1.0.0.0.43PerlVersion5.00503Performingpre-patchinstallationchecks.general_optionsissetto0UsingoraInst.loctolookupouilibs...Parsing/opt/oracle/oraInventory/ContentsXML/comps.xmlFound"oracle.swd.oui"version"2.2.0.12.0"on"/opt/oracle/oui"FoundJREversion"1.3.1.0.0a"on"/opt/oracle/jre/1.3.1/bin/java"OracleHome=/opt/oracle/product/9.2.0inventory_location=/opt/oracle/oraInventoryliboraInstaller_lib=/opt/oracle/oui/bin/solaris/liboraInstaller.sopath_to_java=/opt/oracle/jre/1.3.1/bin/javapath_to_oI_loc=/var/opt/oracle/oraInst.locoui_component_loc=/opt/oracle/ouirequired_jar_fileunderoui=lib/OraInstaller.jarCheckingifthisisaRACsystem...ThisisnotaRACsystemComponentName:oracle.rdbmsComponentVer.:9.2.0.3.0InterimPatchID:2990321Bugsfixedbythispatch:27167642988114---Patch号，及修改的bug申明PleaseshutdownOracleinstancesonthissystem(OracleHome=/opt/oracle/product/9.2.0)Isthissystemreadyforupdating(aretheinstancesdown)?PleaserespondY|N>YBacking-upfilesbeforepatching.Applyingpatch2990321.Patching/opt/oracle/product/9.2.0/lib/libagent9.awithhodmp.o.Patching/opt/oracle/product/9.2.0/lib/libagent9.awithhomt.o.Patching/opt/oracle/product/9.2.0/lib/libagent9.awithhorcr.o.Runningmakeforclient_sharedlib.ar:creating/opt/oracle/product/9.2.0/lib/libclntst9.aar:creating/opt/oracle/product/9.2.0/lib32/libclntst9.aRunningmakeforiextproc.Performingpost-patchinventoryupdateandremovingworkingfiles.Patch2990321hasbeenappliedsuccessfully.Updatinginventory...OPatchsuccedded.

3.经由过程opatch检察数据库各组件版本





cbash-2.03$cdOPatch/bash-2.03$ls2990321README.txtopatchopatch.plDocumentationjlibopatch.batopatch_modulesbash-2.03$opatchPERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules;exportPERL5LIB/opt/oracle/product/9.2.0/Apache/perl/bin/perl./opatch.plUsage:opatch[-h[elp]][-r[eport]][command]command:=applyattachlsinventoryqueryrollbackversion:=-helpDisplaysthehelpmessageforthecommand.-reportPrinttheactionswithoutexecuting(deprecated).ERROR:OPatchfailedbecauseofcmd.args.problem.bash-2.03$opatchlsinventoryPERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules;exportPERL5LIB/opt/oracle/product/9.2.0/Apache/perl/bin/perl./opatch.pllsinventoryUsingoraInst.loctolookupouilibs...Parsing/opt/oracle/oraInventory/ContentsXML/comps.xmlFound"oracle.swd.oui"version"2.2.0.18.0"on"/opt/oracle/oui"FoundJREversion"1.3.1.0.0a"on"/opt/oracle/jre/1.3.1/bin/java"OracleHome=/opt/oracle/product/9.2.0inventory_location=/opt/oracle/oraInventoryliboraInstaller_lib=/opt/oracle/oui/bin/solaris/liboraInstaller.sopath_to_java=/opt/oracle/jre/1.3.1/bin/javapath_to_oI_loc=/var/opt/oracle/oraInst.locoui_component_loc=/opt/oracle/ouirequired_jar_fileunderoui=lib/OraInstaller.jarRetrievinginventory.PRODUCTNAMEVERSION===================AdvancedQueueing(AQ)APIPatch9.2.0.4.0AdvancedQueueing(AQ)API9.2.0.1.0AdvancedReplicationPatch9.2.0.4.0AdvancedReplication9.2.0.1.0AgentRequiredSupportFilesPatch9.2.0.4.0AgentRequiredSupportFiles9.2.0.1.0ApacheConfigurationforOracleJavaServerPages1.1.2.3.0ApacheConfigurationforOracleXMLDevelopersKit9.2.0.1.0ApacheJServ1.1.0.0.0gApacheWebServerfiles1.3.22.0.0aAssistantCommonFilesPatch9.2.0.4.0AssistantCommonFiles9.2.0.1.0AuthenticationandEncryption32-bit9.2.0.1.0AuthenticationandEncryption32-bit9.2.0.4.0AuthenticationandEncryptionPatch9.2.0.4.0AuthenticationandEncryption9.2.0.1.0BaliShare1.1.17.0.0BC4JRuntimeforDatabase9.0.2.692.1CapacityPlanner9.2.0.1.0ChangeManagementCommonFiles9.2.0.1.0CharacterSetMigrationUtility9.2.0.1.0CharacterSetMigrationUtility9.2.0.4.0DataManagementServicesCommonFilesPatch9.2.0.4.0DataManagementServicesCommonFiles9.2.0.1.0DatabaseConfigurationAssistant9.2.0.1.0DatabaseSQLScriptsPatch9.2.0.4.0DatabaseSQLScripts9.2.0.1.0DatabaseUpgradeAssistant9.2.0.1.0DatabaseVerifyUtilityPatch9.2.0.4.0DatabaseVerifyUtility9.2.0.1.0DatabaseWorkspaceManager9.2.0.1.0DBJAVARequiredSupportFilesPatch9.2.0.4.0DBJAVARequiredSupportFiles9.2.0.1.0DocumentaionRequiredSupportFiles9.2.0.1.0EnterpriseEditionOptions9.2.0.1.0EnterpriseLoginAssistant9.2.0.1.0EnterpriseManageWebsiteTranslatedFiles9.2.0.1.0EnterpriseManagerBaseClasses9.2.0.1.0EnterpriseManagerClient9.2.0.1.0EnterpriseManagerCommonFiles9.2.0.1.0EnterpriseManagerConsole9.2.0.1.0EnterpriseManagerDatabaseApplications9.2.0.1.0EnterpriseManagerEvents9.2.0.1.0EnterpriseManagerInstallationPrerequisiteChecks9.2.0.1.0EnterpriseManagerIntegratedApplications9.2.0.1.0EnterpriseManagerMinimalIntegration9.2.0.1.0EnterpriseManagerPagingandOMSCommonFiles9.2.0.1.0EnterpriseManagerQuickTours9.2.0.1.0EnterpriseManagerTranslatedFiles9.2.0.1.0EnterpriseManagerWebSite9.2.0.1.0EnterpriseManagerWebserverIntegration9.2.0.1.0Export/ImportPatch9.2.0.4.0Export/Import9.2.0.1.0ExternalNaming:NISPatch9.2.0.4.0ExternalNaming:NIS9.2.0.1.0GenericConnectivityCommonFilesPatch9.2.0.4.0GenericConnectivityCommonFiles9.2.0.1.0GenericConnectivityUsingODBCPatch9.2.0.4.0GenericConnectivityUsingODBC9.2.0.1.0InstallationCommonFilesPatch9.2.0.4.0InstallationCommonFiles9.2.0.1.0iSQL*PlusPatch9.2.0.4.0iSQL*Plus9.2.0.1.0JDBCCommonFilesPatch9.2.0.4.0JDBCCommonFiles9.2.0.1.0JDBC/OCICommonFilesPatch9.2.0.4.0JDBC/OCICommonFiles9.2.0.1.0JSDK2.0.0.0.0dLDAPRequiredSupportFilesPatch9.2.0.4.0LDAPRequiredSupportFiles9.2.0.1.0LegatoNetworkerSingleServer6.1.0.0.0MigrationUtilityPatch9.2.0.4.0MigrationUtility9.2.0.1.0NewDatabaseIDPatch9.2.0.4.0NewDatabaseID9.2.0.1.0ObjectTypeTranslatorPatch9.2.0.4.0ObjectTypeTranslator9.2.0.1.0Oracle9iR2Patchset9.2.0.4.0OracleAdvancedSecurity9.2.0.1.0OracleApplicationsExtensionsPatch9.2.0.4.0OracleApplicationsExtensions9.2.0.1.0OracleC++CallInterfacePatch9.2.0.4.0OracleC++CallInterface9.2.0.1.0OracleCachingServiceforJava2.1.0.0.0aOracleCallInterface(OCI)Patch9.2.0.4.0OracleCallInterface(OCI)9.2.0.1.0OracleChangeManagementPack9.2.0.1.0OracleClientRequiredSupportFilesPatch9.2.0.4.0OracleClientRequiredSupportFiles9.2.0.1.0OracleCodeEditor1.2.1.0.0AOracleCommonSchemaDemosPatch9.2.0.4.0OracleCommonSchemaDemos9.2.0.1.0OracleCompleteDSSStarterDatabase9.2.0.1.0OracleCompleteOLTPStarterDatabase9.2.0.1.0OracleCoreRequiredSupportFilesPatch9.2.0.4.0OracleCoreRequiredSupportFiles9.2.0.1.0OracleDataMiningPatch9.2.0.4.0OracleDataMining9.2.0.1.0OracleDatabaseDemosPatch9.2.0.4.0OracleDatabaseDemos9.2.0.1.0OracleDatabaseUserInterface2.2.11.0.0OracleDatabaseUtilitiesPatch9.2.0.4.0OracleDatabaseUtilities9.2.0.1.0OracleDeveloperServerFormsManager9.2.0.1.0OracleDiagnosticsPack9.2.0.1.0OracleDisplayFonts9.0.2.0.0OracleDynamicServicesServer9.2.0.1.0OracleeBusinessManagementExtensionsPatch9.2.0.4.0OracleeBusinessManagementExtensions9.2.0.1.0OracleEMDAgentExtensionsPatch9.2.0.4.0OracleEMDAgentExtensions9.2.0.1.0OracleEnterpriseManagerProducts9.2.0.1.0OracleExtendedWindowingToolkit3.4.13.0.0OracleFormsExtensions9.2.0.1.0OracleHelpForJava3.2.13.0.0OracleHelpForJava4.1.13.0.0OracleHelpfortheWeb1.0.7.0.0OracleHTTPServerExtensions9.2.0.1.0OracleHTTPServer9.2.0.1.0OracleIceBrowser5.06.8.0.0OracleIntelligentAgentBaseComponentFilesPatch9.2.0.4.0OracleIntelligentAgentBaseComponentFiles9.2.0.1.0OracleIntelligentAgentConfigTool9.2.0.1.0OracleIntelligentAgentExtensions9.2.0.1.0OracleIntelligentAgent9.2.0.1.0OracleinterMediaAnnotator9.2.0.1.0OracleinterMediaAudio9.2.0.1.0OracleinterMediaAudio9.2.0.4.0OracleinterMediaClientCompatibilityFilesPatch9.2.0.4.0OracleinterMediaClientCompatibilityFiles9.2.0.1.0OracleinterMediaClientDemosPatch9.2.0.4.0OracleinterMediaClientDemos9.2.0.1.0OracleinterMediaClientOption9.2.0.1.0OracleinterMediaCommonFilesPatch9.2.0.4.0OracleinterMediaCommonFiles9.2.0.1.0OracleinterMediaImage9.2.0.1.0OracleinterMediaImage9.2.0.4.0OracleinterMediaJavaAdvancedImagingPatch9.2.0.4.0OracleinterMediaJavaAdvancedImaging9.2.0.1.0OracleinterMediaJavaClient9.2.0.1.0OracleinterMediaJavaMediaFrameworkClient9.2.0.1.0OracleinterMediaLocatorPatch9.2.0.4.0OracleinterMediaLocator9.2.0.1.0OracleinterMediaVideo9.2.0.1.0OracleinterMediaVideo9.2.0.4.0OracleinterMediaWebClient9.2.0.1.0OracleinterMedia9.2.0.1.0OracleInternetDirectoryClientCommonFilesPatch9.2.0.4.0OracleInternetDirectoryClientCommonFiles9.2.0.1.0OracleInternetDirectoryClientPatch9.2.0.4.0OracleInternetDirectoryClient9.2.0.1.0OracleInternetDirectoryTools9.2.0.1.0OracleJavaCorePatch9.2.0.4.0OracleJavaLayoutEngine2.0.1.0.0OracleJavaServerPages1.1.3.1.0OracleJavaToolsPatch9.2.0.4.0OracleJavaTools9.2.0.1.0OracleJDBCThinDriverforJDK1.1Patch9.2.0.4.0OracleJDBCThinDriverforJDK1.19.2.0.1.0OracleJDBCThinDriverforJDK1.2Patch9.2.0.4.0OracleJDBCThinDriverforJDK1.29.2.0.1.0OracleJDBCThinDriverforJDK1.4Patch9.2.0.4.0OracleJDBCThinDriverforJDK1.49.2.0.1.0OracleJDBC/OCIDriverforJDK1.19.2.0.1.0OracleJDBC/OCIDriverforJDK1.29.2.0.1.0OracleJFCExtendedWindowingToolkit4.1.10.0.0OracleJVMPatch9.2.0.4.0OracleJVM9.2.0.1.0OracleManagementPackforOracleApplications9.2.0.1.0OracleManagementServer9.2.0.1.0OracleMessageGatewayCommonFiles9.2.0.1.0OracleModPL/SQLGateway3.0.9.8.3bOracleNetConfigurationAssistantPatch9.2.0.4.0OracleNetConfigurationAssistant9.2.0.1.0OracleNetListenerPatch9.2.0.4.0OracleNetListener9.2.0.1.0OracleNetManagerPatch9.2.0.4.0OracleNetManager9.2.0.1.0OracleNetPatch9.2.0.4.0OracleNetRequiredSupportFilesPatch9.2.0.4.0OracleNetRequiredSupportFiles9.2.0.1.0OracleNetServices9.2.0.1.0OracleNet9.2.0.1.0OracleOLAPAPIPatch9.2.0.4.0OracleOLAPAPI9.2.0.1.0OracleOLAPCubeViewer9.2.0.1.0OracleOLAPCWMLitePatch9.2.0.4.0OracleOLAPCWMLite9.2.0.1.0OracleOLAPPatch9.2.0.4.0OracleOLAPWorksheet9.2.0.1.0OracleOLAP9.2.0.1.0OraclePartitioningPatch9.2.0.4.0OraclePartitioning9.2.0.1.0OraclePerlInterpreter5.00503.0.0.0cOracleProgrammer9.2.0.1.0OracleRequiredSupportFiles32bit9.2.0.1.0OracleRequiredSupportFiles64bitPatch9.2.0.4.0OracleSOAPClient2.0.0.0.0aOracleSOAPforJServ2.0.0.0.0aOracleSOAPServer2.0.0.0.0aOracleSpatialPatch9.2.0.4.0OracleSpatial9.2.0.1.0OracleSQLJPatch9.2.0.4.0OracleSQLJ9.2.0.1.0OracleStarterDatabase9.2.0.1.0OracleTextPatch9.2.0.4.0OracleText9.2.0.1.0OracleTracePatch9.2.0.4.0OracleTraceRequiredSupportFilesPatch9.2.0.4.0OracleTraceRequiredSupportFiles9.2.0.1.0OracleTrace9.2.0.1.0OracleTransparentGateways9.2.0.1.0OracleTuningPack9.2.0.1.0OracleUIX2.0.20.0.0OracleUltraSearchCommonFilesPatch9.2.0.4.0OracleUltraSearchCommonFiles9.2.0.1.0OracleUltraSearchMiddle-TierPatch9.2.0.4.0OracleUltraSearchMiddle-Tier9.2.0.1.0OracleUltraSearchServerPatch9.2.0.4.0OracleUltraSearchServer9.2.0.1.0OracleWalletManagerPatch9.2.0.4.0OracleWalletManager9.2.0.1.0OracleWorkflowManager9.2.0.1.0OracleXMLDevelopersKitPatch9.2.0.4.0OracleXMLDevelopersKit9.2.0.1.0OracleXMLRuntimeComponents9.2.0.1.0OracleXMLSQLUtilityPatch9.2.0.4.0OracleXMLSQLUtility9.2.0.1.0Oracle9iDatabase9.2.0.1.0Oracle9iDevelopmentKit9.2.0.1.0Oracle9iforUNIXDocumentation9.2.0.1.0Oracle9iGlobalizationSupportPatch9.2.0.4.0Oracle9iGlobalizationSupport9.2.0.1.0Oracle9iPatch9.2.0.4.0Oracle9iServer32bit9.2.0.1.0Oracle9iServer64bitPatch9.2.0.4.0Oracle9iSyndicationServer9.2.0.1.0Oracle9i9.2.0.1.0ParserGeneratorRequiredSupportFiles9.2.0.1.0PerformanceManager9.2.0.1.0PL/SQLEmbeddedGateway9.2.0.1.0PL/SQLPatch9.2.0.4.0PL/SQLRequiredSupportFilesPatch9.2.0.4.0PL/SQLRequiredSupportFiles9.2.0.1.0PL/SQL9.2.0.1.0PlatformRequiredSupportFiles9.2.0.1.0PrecompilerCommonFilesPatch9.2.0.4.0PrecompilerCommonFiles9.2.0.1.0PrecompilerRequiredSupportFilesPatch9.2.0.4.0PrecompilerRequiredSupportFiles9.2.0.1.0Pro*C/C++Patch9.2.0.4.0Pro*C/C++9.2.0.1.0Pro*COBOLPatch1.8.77.4.0Pro*COBOLPatch9.2.0.4.0Pro*COBOL1.8.77.0.0Pro*COBOL9.2.0.1.0Pro*FORTRANPatch1.8.77.4.0Pro*FORTRAN1.8.77.0.0RDBMSRequiredSupportFilesPatch9.2.0.4.0RDBMSRequiredSupportFiles9.2.0.1.0RecoveryManagerPatch9.2.0.4.0RecoveryManager9.2.0.1.0regexp2.0.20.0.0ReportingFramework9.2.0.1.0RequiredSupportFiles9.2.0.1.0SecureSocketLayerPatch9.2.0.4.0SecureSocketLayer9.2.0.1.0SQL*LoaderPatch9.2.0.4.0SQL*Loader9.2.0.1.0SQL*PlusPatch9.2.0.4.0SQL*PlusRequiredSupportFilesPatch9.2.0.4.0SQL*PlusRequiredSupportFiles9.2.0.1.0SQL*Plus9.2.0.1.0SQLJRuntimePatch9.2.0.4.0SQLJRuntime9.2.0.1.0SQLJTranslator9.2.0.1.0SQLServerMonitoringOption9.2.0.1.0SSLRequiredSupportFilesPatch9.2.0.4.0SSLRequiredSupportFiles9.2.0.1.0SunJDKextensions9.2.0.1.0SunJDK1.3.1.0.1aUtilitiesCommonFilesPatch9.2.0.4.0UtilitiesCommonFiles9.2.0.1.0VisigenicsORB3.4.0.0.0XDKRequiredSupportFilesPatch9.2.0.4.0XDKRequiredSupportFiles9.2.0.1.0XMLClassGeneratorforC++9.2.0.1.0XMLClassGeneratorforC++9.2.0.4.0XMLClassGeneratorforJava9.2.0.1.0XMLClassGeneratorforJava9.2.0.4.0XMLParserforCPatch9.2.0.4.0XMLParserforC++Patch9.2.0.4.0XMLParserforC++9.2.0.1.0XMLParserforC9.2.0.1.0XMLParserforJavaPatch9.2.0.4.0XMLParserforJava9.2.0.1.0XMLParserforOracleJVMPatch9.2.0.4.0XMLParserforOracleJVM9.2.0.1.0XMLParserforPL/SQLPatch9.2.0.4.0XMLParserforPL/SQL9.2.0.1.0XMLTransviewerBeans9.2.0.1.0XMLTransviewerBeans9.2.0.4.0XMLTransx9.2.0.1.0XMLTransx9.2.0.4.0XML9.2.0.1.0XML9.2.0.4.0XSQLServlet9.2.0.1.0XSQLServlet9.2.0.4.0OPatchsuccedded.

利用opatch的rollback选项，还能够回滚某个一时补钉，不再详细申明。



本文作者:
eygle,Oracle手艺存眷者,来自中国最年夜的Oracle手艺论坛itpub.
www.eygle.com是作者的团体站点.你可经由过程Guoqiang.Gai@gmail.com来接洽作者.接待手艺切磋交换和链接互换.

原文出处:

http://www.eygle.com/internal/Use.Opatch.apply.Interim.Patch.htm


操作被同步到从库上后，则主从都“回天无力”。

我们学到了什么？思考问题的时候从表的角度来思考问

Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。

如果我们从集合论（关系代数）的角度来看，一张数据库的表就是一组数据元的关系，而每个SQL语句会改变一种或数种关系，从而产生出新的数据元的关系（即产生新的表）。

可能有的朋友会抱怨集成的orderby，其实如果使用ranking函数,Orderby是少不了的。如果担心Orderby会影响效率，可以为orderby的字段建立聚集索引，查询计划会忽略orderby操作（因为本来就是排序的嘛）。

索引视图2k就有。但是2005对其效率作了一些改进但是schema.viewname的作用域真是太限制了它的应用面。还有一大堆的环境参数和种种限制都让人对它有点却步。

如安全管理、备份恢复、性能监控和调优等，SQL只要熟悉基本操作就可以，只要程序设计部分只要稍加了解即可（如存储过程、触发器等）。