Links
Home
Oracle DBA Forum
Frequent Oracle Errors
TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found'>ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated
10.2 listener won 't start on same port as 9.2 listener

10.2 listener won 't start on same port as 9.2 listener

2006-04-03       - By JayMiller@(protected)

Reply:     <<     21     22     23     24     25     26     27     28  

One more update.  Our sales rep connected me to the Oracle development
group and apparently they are working on restoring the ability to run
mulitiple listeners on the same port if you use different virtual IPs.



No ETA on when they will restore that functionality however.



Jay Miller





-- --Original Message-- --
From: Miller, Jay
Sent: Thursday, September 22, 2005 5:13 PM
To: oracle-l@(protected)
Subject: RE: 10.2 listener won't start on same port as 9.2 listener



Just a follow up.



I could get all three listeners to run *if* I start the 10.2 listener
first.  This works since the reason it won't start otherwise is that
they've added code which checks if anything is listening on that port
and returns an error message if there is.  This is obviously not a real
solution though.



Oracle added this to resolve a bug where the wrong error message was
being given if you tried to start a listener when it was already
running.  So to fix a bad error message the entire functionality was
removed.



I'm going to file an enhancement request but the analyst warned me it
probably won't be granted.



Ah, well.  The company is merging soon so I probably won't have to deal
with these systems by this time next year...







Thanks for the help,

Jay Miller





 __ __  

This message is confidential and sent by TD Waterhouse solely for use
by the intended recipient. If you are not the intended recipient, you
are hereby notified that any use, distribution or copying of this
communication is strictly prohibited. This should not be deemed as an
offer or solicitation, to buy or sell any product. Any 3rd party
information contained herein was prepared by sources deemed reliable,
but is not guaranteed. TD Waterhouse does not accept electronic
instructions that would require an original signature. Information
received by or sent from TD Waterhouse is stored, subject to review,
and may be produced to regulatory authorities or others with a legal
right to such.


<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">


<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>
<!--
/* Font Definitions */
@(protected)
  {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.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
p
  {margin-right:0in;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.emailstyle17
  {font-family:Arial;
  color:navy;}
span.EmailStyle21
  {font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>One more update.&nbsp; Our sales rep
connected
me to the Oracle development group and apparently they are working on restoring
the ability to run mulitiple listeners on the same port if you use different
virtual IPs.</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>No ETA on when they will restore that
functionality however.</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<div>

<p class=MsoAutoSig><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Jay Miller</span></font></p>

</div>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-- --Original Message-- --<br>
<b><span style='font-weight:bold'>From:</span></b> Miller, Jay <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, September 22, 2005
5:13 PM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: 10.2 listener won't
start on same port as 9.2 listener</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"
><span
style='font-size:12.0pt'>&nbsp;</span></font></p>

<div>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>Just a follow up.</span><
/font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>I could get all three
listeners to run *<b><span style='font-weight:bold'>if</span></b>* I start the
10.2 listener first.&nbsp; This works since the reason it won't start otherwise
is that they've added code which checks if anything is listening on that port
and returns an error message if there is.&nbsp; This is obviously not a real
solution though.</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>Oracle added this to
resolve a bug where the wrong error message was being given if you tried to
start a listener when it was already running.&nbsp; So to fix a bad error
message the entire functionality was removed.</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>I'm going to file an
enhancement request but the analyst warned me it probably won't be granted.<
/span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>Ah, well.&nbsp; The
company is merging soon so I probably won't have to deal with these systems by
this time next year...</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<div>

<p class=MsoAutoSig style='margin-left:.5in'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Thanks
for the help,</span></font></p>

<p class=MsoAutoSig style='margin-left:.5in'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Jay
Miller</span></font></p>

</div>

<p class=MsoNormal style='margin-left:1.0in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>&nbsp;</span><
/font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

</div>

<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'>
<font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=1 width="100%" align=center>

</span></font></div>

<p style='margin-left:.5in'><strong><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>This message is confidential and sent by TD Waterhouse
solely for use</span></font></b></strong><b><span style='font-weight:bold'><br>
<strong><b><font face="Times New Roman">by the intended recipient. If you are
not the intended recipient, you</font></b></strong><br>
<strong><b><font face="Times New Roman">are hereby notified that any use,
distribution or copying of this</font></b></strong><br>
<strong><b><font face="Times New Roman">communication is strictly prohibited.
This should not be deemed as an</font></b></strong><br>
<strong><b><font face="Times New Roman">offer or solicitation, to buy or sell
any product. Any 3rd party</font></b></strong><br>
<strong><b><font face="Times New Roman">information contained herein was
prepared by sources deemed reliable,</font></b></strong><br>
<strong><b><font face="Times New Roman">but is not guaranteed. TD Waterhouse
does not accept electronic</font></b></strong><br>
<strong><b><font face="Times New Roman">instructions that would require an
original signature. Information</font></b></strong><br>
<strong><b><font face="Times New Roman">received by or sent from TD Waterhouse
is stored, subject to review,</font></b></strong><br>
<strong><b><font face="Times New Roman">and may be produced to regulatory
authorities or others with a legal</font></b></strong><br>
<strong><b><font face="Times New Roman">right to such. </font></b></strong><
/span></b></p>

</div>

</body>

</html>