MSSQL网站制作之Is iSQL Plus running

对于update操作，只需要把event中的旧行和新行值对调即可。iSQL*PlusPage
iSQL*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
操作被同步到从库上后，则主从都“回天无力”。