<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR><o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PersonName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 76.3pt 1.0in 76.25pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoPlainText {
FONT-WEIGHT: bold; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; COLOR: teal; FONT-FAMILY: Tahoma
}
LI.MsoPlainText {
FONT-WEIGHT: bold; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; COLOR: teal; FONT-FAMILY: Tahoma
}
DIV.MsoPlainText {
FONT-WEIGHT: bold; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; COLOR: teal; FONT-FAMILY: Tahoma
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>Thanks Jim</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>Sounds like an idea. If you have time I would apreciate it.
But let's give it some time, somebody may still have the
answer.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>Henrik could probably check the code and tell us - and he
should be up in just a few hours.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>The irony is, I am a DBA as well as a SysAdmin, and could
do exactly as you suggest easily enough, but I work for a government department,
hired as a contract SysAdmin!!!!!!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>The outcry it would cause if a SysAdmin did any DBA work is
just not worth it. The senior DBA is on leave, and the junior one can't/won't
help.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>(The senior DBA is a mate of mine, so he would help,
but isn't back for 2 weeks)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2>A<SPAN
class=814350602-02082006>mazing how easily politics can prevent you having
a</SPAN><SPAN class=814350602-02082006> good day.
:-(</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2>Cheers</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2> Vernon</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=814350602-02082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Smith, Jim
[mailto:JMSmith@stvincenthealth.com] <BR><B>Sent:</B> Wednesday, 2 August 2006
9:42 AM<BR><B>To:</B> hobbit@hswn.dk<BR><B>Subject:</B> RE: [hobbit]
Oratns<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Yes, I'm sure it WOULD be a CLM! Unfortunately, I
don't have multiple listeners running on any of my servers so I can't be of much
help. Do you have a test server running Oracle that you can play
with? I do and am willing to give this a try if I can get my DBA to assist
with setting up some dummy listeners.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Jim Smith<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----<BR>From: Everett, Vernon
[mailto:Vernon.Everett@dpi.wa.gov.au] <BR>Sent: Tuesday, August 01, 2006 8:36
PM<BR>To: <st1:PersonName
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex=0 w:st="on">hobbit@hswn.dk</st1:PersonName><BR>Subject: [hobbit]
Oratns</SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Hi all<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Some assistance with bb-hosts
please.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">If I want to check for an oracle listener, my line looks
like this<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">1.2.3.4 name.domain.com #
oratns:1545<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">This will check for an Oracle listener on port
1545<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">How do I make it check for more than one Oracle
listener?<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">For reasons unknown to me, we are running multiple
listeners on separate<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">ports on a server.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Should I have multiple oratns entries (so my line looks
like this)<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">1.2.3.4 name.domain.com # oratns:1545 oratns
1546<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Or can we do it like
this<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">1.2.3.4 name.domain.com #
oratns:1545:1546<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Ordinarily, I would just run a few tests, but bring down
one of the<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">listeners on a production server as a test could prove
to be a serious<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">CLM.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">Regards<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"> <st1:City w:st="on"><st1:place
w:st="on">Vernon</st1:place></st1:City><o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">To unsubscribe from the hobbit list, send an e-mail
to<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt">hobbit-unsubscribe@hswn.dk<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P>
<P class=MsoPlainText><B><FONT face=Tahoma color=teal size=2><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></B></P></DIV>NOTICE:
This email contains confidential or proprietary information which may be legally
privileged. It is intended only for the named recipient(s). If an addressing
error has misdirected the email, please notify the author by replying to this
message. If you are not the named recipient, you are not authorized to use,
disclose, distribute, copy, print or rely on this email, and should immediately
delete it from your computer system. </BODY></HTML>