MSSQL网站制作之Is iSQL Plus running
对于update操作，只需要把event中的旧行和新行值对调即可。iSQL*PlusPageiSQL*PlusisaproductindependentofEnterpriseManager.TheiSQL*PlususerinterfacerunsinawebbrowserconnectedtotheInternetoryourintranet.iSQL*PlusenablesyoutouseawebbrowsertoconnecttoanOracledatabaseandperformthesameactionsasyouwouldthroughthecommandlineversionofSQL*Plus(knownasSQL*Plusinthisguide).YoucanuseiSQL*PlustowriteSQL*Plus,SQLandPL/SQLcommandsto:
Enter,edit,runandsaveSQLcommandsandPL/SQLblocks.
Calculate,andprintqueryresults.
YoucanusetheiSQL*PlusWorkspacetowrite,load,saveandexecutescripts.YoucanenterscriptsasyouwouldincommandlineSQL*Plus.ThescriptoutputcanbedisplayedintheWorkspacescreenorsavedtoafileonyourclientmachine.
TheiSQL*Plusapplicationcanbeusedbytwotypesofusers;adatabaseuserwithNORMALroleandaWebDBAuser.Forsecurityreasons,ifyouwanttoconnectasSYSOPERorSYSDBA,youmustcreateandconfigureaWebDBAuserthatisHTTPauthenticated.
ConfiguringiSQL*Plus
IfyoureceiveanerrormessagepageafteryouclicktheiSQL*PluslinkontheDatabaseHomepage,youshouldcheckthefollowing:
IsiSQL*Plusconfiguredproperly?
ForGridControl,iSQL*PluswillnotbeshippedwiththeOMS(OracleManagementServer).SoiSQL*Plusneedstobemanuallyconfiguredtopointtoanyrunning10GiSQL*Plusserver.AllthetargetdatabasesdiscoveredinthisGridControlapplicationwillusethisiSQL*Plusserverfortheirqueries.
ForDatabaseControl,theiSQL*PlusinstallationwillautomaticallyconfiguretousetheiSQL*Plusservershippingwiththistarget.
ToconfigureiSQL*Plus,twoentriesinthe$ORACLE_HOME/sysman/config/emoms.propertiesfileontheOMS(OracleManagementServer)machineneedstobepopulatedbyreplacingthefollowingplaceholders:replace%ISQLPLUS_PROTOCOL%,%ISQLPLUS_HOST%and%ISQLPLUS_PORT%withtheprotocol,thehostandtheportoftheiSql*Plusserveryouwanttouse.
ForadatabaseuserwithNORMALrole:
oracle.sysman.db.isqlplusUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dynamic
ForadatabaseuserwithSYSOPERandSYSDBArole(requiresadditionalsetupforiSQL*PlusDBAaccess):
oracle.sysman.db.isqlplusWebDBAUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dba/dynamic
Forexample:
oracle.sysman.db.isqlplusUrl=http://chablis.au.oracle.com:5560/isqlplus/dynamic
oracle.sysman.db.isqlplusWebDBAUrl=http://chablis.au.oracle.com:5560/isqlplus/dba/dynamic
ForRACapplications,theemoms.propertiesfileforallnodesoftheclustermustalsohavethesetwoentriesconfigured.
Afterconfiguringtheentries,theOMSneedstoberestartedtopickupthechange.
IsiSQL*Plusrunning?
IfiSQL*Plusisnotstarted,youmaystartiSQL*Plususingthecommand:
$ORACLE_HOME/bin/isqlplusctlstart
IsiSQL*PlusDBAAccessSetup?
IfiSQL*Plusisconfiguredproperly,theiSQL*PlusConnectionRolepagepromptsyoutoselecttheroleyouwanttousetoconnecttoiSQL*Plus--Normal,SYSOPER(WebDBA)orSYSDBA(WebDBA).
ToconnectasSYSOPERorSYSDBA,theWebDBAusermustbesetupandauthenticatedusingtheOracleJAASProvider,knownasJAZN(JavaAuthoriZationN).ThisisOraclesimplementationoftheJavaAuthenticationandAuthorizationService(JAAS).WheniSQL*PlusWebDBAURLisinvoked,youmustenteravalidJAZNusernameandpasswordinadialogtogainaccesstotheiSQL*PlusDBAURL.ThisusernameandpasswordmaybedifferenttotheusernameandpasswordforyourOracledatabaseinstance.
ForinstructionsonhowtosetupaccesstoiSQL*PlusDBAURL,seetheSQL*PlusUsersGuideandReference.
Formoreinformationaboutthejaznadminsetup,seetheiSQL*PlusInstallationandConfigurationguideorgoto:
wiggum.ce.columbia.edu:7778/iplus/help/us/toc.htm
操作被同步到从库上后，则主从都“回天无力”。 你觉得我的非分区索引无法对起子分区，你可以提醒我一下呀！没有任何的提醒，直接就变成了非分区表。不知道这算不算一个bug。大家也可以试试。 如果是将来做数据库的开发设计，就应该详细学习T-SQL的各种细节，包括T-SQL的程序设计、存储过程、触发器以及具体使用某个开发语言来访问数据库。 如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。 多走走一此相关论坛，多看一些实例开发，多交流0经验，没什么的，我也是刚学没多久!加油 大侠们有推荐的书籍和学习方法写下吧。 分区表效率问题肯定是大家关心的问题。在我的试验中，如果按照分区字段进行的查询（过滤）效率会高于未分区表的相同语句。但是如果按照非分区字段进行查询，效率会低于未分区表的相同语句。 对递归类的树遍历很有帮助。个人感觉这个真是太棒了！阅读清晰，非常有时代感。 原来公司用过MYSQL自己也只是建个表写个SQL
页:
[1]