首页  电脑故障排除  病毒安全 电脑基础知识  硬件知识  软件应用知识  操作系统知识  编程程序

美国编程网址 日本编程网址 法国编程网址 德国编程网址 韩国编程网址 香港编程网址 台湾编程网址

您的位置:首页>>编程程序>>Oracle

alert_SID.log文件中的问题,请各位大虾赐教!

 
alert_SID.log文件中的问题,请各位大虾赐教!
  
  这是在alert_SID.log文件中看到的:
StartingORACLEinstance(normal)
MonAug2514:59:392003
Runningwith1strandforNon-EnterpriseEdition
LICENSE_MAX_SESSION=0
LICENSE_SESSIONS_WARNING=0
SCNscheme1
Usinglog_archive_destparameterdefaultvalue
Runningwith1strandforNon-EnterpriseEdition
LICENSE_MAX_USERS=0
哪位能帮我解释一下'Non-EnterpriseEdition'和几个‘LICENSE‘参数,多谢了!
  
  
  
  airlily 回复于:2003-08-26 11:27:37
up
airlily 回复于:2003-08-27 11:46:35
难道真的没有人帮忙吗?
rollingpig 回复于:2003-08-27 12:37:24
就是oracle的licence管理
http://www.wangz.net/sessionl.php
Limitthenumberofsessionsconcurrentlyconnectedtoadatabase
OraclehelpsyouensurethatyoursitecomplieswithitsOracleServerlicenseagreement.Ifyoursiteislicensedbyconcurrentusage,youcantrackandlimitthenumberofsessionsconcurrentlyconnectedtoadatabase.Ifyoursiteislicensebynamedusers,youcanlimitthenumberofnameduserscreatedinadatabase.Ineithercase,youcontrolthelicensingfacilites,andmustenablethefacilitiesandsettheappropriatelimits.
Tousethelicensingfacility,youneedtoknowwhichtypeoflicensingagreementyoursitehas,andwhatthemaximumnumberofsessionsornamedusersis.Yoursitemayuseeithertypeoflicensing,butnotboth.
However,mostsiteleavethelicensingmechanismdisabledbyomitting
LICENSE_MAX_SESSION
LICENSE_SESSIONS_WARNING
LICENSE_MAX_USERS
fromtheparameterfile,orsetthevalueofallthreeto0.
youcancheckituseOracleSessionManager(Database->Info,intheLICENSEsection)
orusethefollowingstatement:
selectsessions_max,sessons_warning,session_current,session_highwater,users_max
fromv$license;
Limitthenumberofsessionsthatcanbeconnectedsimultaneouslytothedatabaseonthespecifiedcomputerbyusingconcurrentusagelicensingmaybeusefulwhenaproductiondatabaseistoobusytodealwithmanysessions.Althoughitisnotreasonableusage.
Youcansetalimitonthenumberofconcurrentsessionsbeforeyoustartaninstance,orchangethemaximumnumberofconcurrentsessionswhilethedatabaseisrunning.(Oraclesessionmanagercanhelpyoudothisonthefly).
Afteryourinstance'ssessionlimitisreached,onlyuserswithRESTIRCTEDSESSIONprivilege(usuallyDBAs)canconnecttothedatabase.WhenauserwithRESTIRCTEDSESSIONprivilegeconnects,OraclewritesamessagetotheALERTfile.
UsethefollowingstatementtochangeLICENSE_MAX_SESSION
AltersystemsetLICENSE_MAX_SESSION=64//whatevervalueyoulike
Inadditiontoenforcingtheconcurrentusagelimits,Oracletracksthehighestnumberofconcurrentsessionsforeachinstancewhichnames"highwatermark".
NOTE:Oracleasksyouconnectonlytoterminateunneededprocess.DonotraisethelicensinglimitsunlessyouhaveupgradedyouOraclelicenseagreement.
airlily 回复于:2003-08-27 13:34:53
多谢!
  

查看上一页  返回分类首页 返回96PC首页  查看下一页

  版权所有:电脑知识大全 网站备案:粤ICP备07031496号  联系我们

友情链接:母婴知识  外贸商务网  娱乐频道  汽车维修知识  股票入门知识  游戏攻略秘籍  本站空间由安信网络提供