|
哪位大老有LSNRCTL使用的详细资料？？？
经常遭遇nolintener的报错。。。
简直受够了。。
在linux运行lsnrctl命令行窗口一闪而过。
连一个报错都没有。。
还有，修改主机的IP地址，相应要改哪些数据库参数文件啊？？
testtest111 回复于：2003-08-21 22:52:26
lsnrctlstart
abc-123 回复于：2003-08-21 23:01:54
看看listener.ora和tnsnames.ora文件中“Host=”用的是IP还是主机名。
rollingpig 回复于：2003-08-22 09:17:44
$ORACLE_HOME/network/admin/
text2002 回复于：2003-08-22 11:24:19
谢谢各位老大了。
lsnrctl命令其实就有那么几个。
很想详细的学一下，不然被nolintener给整晕了。。
airlily 回复于：2003-08-22 13:24:49
1. LISTENER=
2. (ADDRESS_LIST=
3. (ADDRESS=(PROTOCOL=TCP)(Host=stc-sun02)(Port=1521))
 
4. SID_LIST_LISTENER=
5.(SID_LIST=
6. (SID_DESC=
7.(ORACLE_HOME=/home/oracle)
(GLOBAL_DBNAME=ORCL.us.oracle.com)
9. (SID_NAME=ORCL)
)
10. ...sampleadditionalSIDdescription...
 
listener.oraFileContents
Thedefaultlistener.orafilecontainsthefollowingparameters:
1.Thenameofthelistener.ThedefaultnameisLISTENER.
2.TheADDRESS_LISTparametercontainsablockofaddressesatwhichthelistenerlistensforincomingconnections.Eachoftheaddressesdefinedinthisblockrepresentsadifferentwaybywhichalistenerreceivesaconnection.
3.TheTCPaddressidentifiesincomingTCPconnectionsfromclientsonthenetworkattemptingtoconnecttoport1521.Theclientsusetheportdefinedintheirtnsnames.orafiletoconnecttothislistener.BasedontheSID_LISTdefinedforthislistener,thelistenerspecifiesthedatabasetowhichtoconnect.Pleasenotethatispossibletoconfiguremultiplelistenershereaslongastheyhaveuniquenamesanduniqueportsonthenodewheretheyareconfigured.EachlistenerconfiguredwillhaveitsownSID_LISTbutasingledatabasecanbeservicedbymultiplelisteners.
4.Alistenercanlistenformorethanonedatabaseonamachine.TheSID_LIST_LISTENER_NAMEblockorparameteriswheretheseSIDsaredefined.
5.TheSID_LISTparameterisdefinedifmorethanoneSIDisdefined.
6.TheSID_DESCparametermustexistforeachdefinedSID.
7.TheORACLE_HOMEiswherethehomedirectoryofthedatabaseisdefined.Thisenablesthelistenertoidentifythelocationofadatabaseexecutablefile.
8.TheparameterGLOBAL_DBNAMEidentifiestheglobaldatabasenameofthedatabase,anamecomprisedofthedatabasenameanddatabasedomain.Theglobaldatabasenameisoftheformdatabase_name.database_domain.Consider,forexample,orcl.us.acme.comwherethedatabasenameportion,orcl,isasimplenameyouwishtocallyourdatabase.Thedatabasedomainportion,us.oracle.com,specifiesthedatabasedomaininwhichthedatabaseislocated,makingtheglobaldatabasenameuniqueYoucanobtaintheGLOBAL_DBNAMEvaluefromtheSERVICE_NAMESparameterintheinitializationparameterfile.ThisparametermustbeembeddedunderSID_DESCandshouldmatchthevalueoftheSERVICE_NAMESparameter.
9.TheSID_NAMEparameterdefinesthenameoftheSIDonbehalfofwhichthelisteneracceptsconnections.
10.Bydefault,anexampleSIDisdefinedhere.
airlily 回复于：2003-08-22 13:27:48
LSNRCTLCommands
StartingtheListener
YoucanusetheSTARTcommandtostartthelistenerfromtheListenerControlutility.Anymanualchangestothelistener.orafilemustbemadewhenthelistenerisshutdown.TheargumentfortheSTARTcommandisthenameofthelistener,andifnoargumentisspecified,thecurrentlistenerisstarted.Ifacurrentlistenerisnotdefined,LISTENERisstarted.
LSNRCTL>START[listener_name]
or
$lsnrctlstart[listener_name]
StoppingtheListener
TheSTOPcommandstopsthelistener.Thelistenermustberunningtostopitproperly.Ifapasswordisconfigured,theSETPASSWORDcommandmustbeusedbeforetheSTOPcommandcanbeused.ThepasswordmustbesetfromwithintheLSNRCTLprompt;itcannotbesetfromtheoperatingsystemcommandline.Itisgoodpracticetosendawarningmessagetoallnetworkusersbeforestoppingalistener.
LSNRCTL>STOP[listener_name]
or
$lsnrctlstop[listener_name]
TheSETmodifierisusedtochangelistenerparametersintheListenerControlutility
environment.
LSNRCTL>SETtrc_levelADMIN
TheSHOWmodifierisusedtodisplaythevaluesoftheparameterssetforthelistener.
LSNRCTL>SHOWconnect_timeout
text2002 回复于：2003-08-22 13:33:50
谢谢airlily！
查看上一页
返回分类首页 返回96PC首页
查看下一页 |
