<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Tahoma;
color:teal;
font-weight:bold;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Tahoma;
color:teal;
font-weight:bold;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 76.3pt 1.0in 76.25pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:teal;font-weight:bold'>Ha! I
know what you mean. My son is a programmer for a government agency.<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:teal;font-weight:bold'><o:p> </o:p></span></font></b></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Everett, Vernon
[mailto:Vernon.Everett@dpi.wa.gov.au] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, August 01, 2006
9:16 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">hobbit@hswn.dk</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [hobbit] Oratns</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Thanks Jim</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Henrik could probably check the code and
tell us - and he should be up in just a few hours.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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!!!!!!</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>(The senior DBA is a mate of mine, so
he would help, but isn't back for 2 weeks)</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Amazing how easily politics can
prevent you having a good day. :-(</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Cheers</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'> <st1:City w:st="on"><st1:place
w:st="on">Vernon</st1:place></st1:City></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Smith,
Jim [mailto:JMSmith@stvincenthealth.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, 2 August 2006
9:42 AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">hobbit@hswn.dk</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [hobbit] Oratns</span></font><o:p></o:p></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>Jim Smith<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>-----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 tabIndex="0"
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
w:st="on">hobbit@hswn.dk</st1:PersonName><br>
Subject: [hobbit] Oratns<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>Hi all<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>Some assistance with bb-hosts please.<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>1.2.3.4 name.domain.com # oratns:1545<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>This will check for an Oracle listener on port 1545<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>ports on a server.<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>1.2.3.4 name.domain.com # oratns:1545 oratns 1546<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>Or can we do it like this<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>1.2.3.4 name.domain.com # oratns:1545:1546<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>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 size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>CLM.<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>Regards<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'> <st1:place w:st="on"><st1:City w:st="on">Vernon</st1:City></st1:place><o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>To unsubscribe from the hobbit list, send an e-mail to<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'>hobbit-unsubscribe@hswn.dk<o:p></o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoPlainText><b><font size=2 color=teal face=Tahoma><span
style='font-size:10.0pt'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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. <o:p></o:p></span></font></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>