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

2005-09-21       - By Goulet, Dick

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

Humm,  Did that too, but without problems.

 __ __  

From: Richard Ji [mailto:richard.c.ji@(protected)]
Sent: Wednesday, September 21, 2005 1:34 PM
To: Goulet, Dick
Cc: MGogala@(protected); JayMiller@(protected);
oracle-l@(protected)
Subject: Re: 10.2 listener won't start on same port as 9.2 listener


It's backward compatible but not without problems some times.  I ran
into
a problem using 9i listener for a 8.1.7.4 DB where it start to run out
of file
descriptors.  Revert back to 8i listener solved the problem.  So I had
to
run two listeners.

Regards

Richard


On 9/21/05, Goulet, Dick <DGoulet@(protected)> wrote:

  The advice I got from OTS some years ago, like with the release
of 8.0, was to use one listener for all databases on a single server,
just use the latest listener installed as they were backwards
compatible.  That advice has been working extremely well ever since.  So
my question would be why do you want a separate listener, unless you've
got two or more IP addresses, and consequently NIC's, for one server?
 
 
 __ __  

  From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Gogala, Mladen
  Sent: Wednesday, September 21, 2005 11:20 AM
  To: 'JayMiller@(protected)'; oracle-l@(protected)
  Subject: RE: 10.2 listener won't start on same port as 9.2
listener
 
 

  Oracle is, quite obviously, listening to my advice, even if some
listers are not.

 

  --

  Mladen Gogala

  Ext. 121

 
 __ __  


  From: JayMiller@(protected) [mailto:
JayMiller@(protected) <mailto:JayMiller@(protected)> ]
  Sent: Tuesday, September 20, 2005 6:07 PM
  To: oracle-l@(protected)
  Subject: RE: 10.2 listener won't start on same port as 9.2
listener

 

  Well, I just got the answer from Oracle and apparently 10.2 is
purposely not allowing you to do this any more.  It was done as a fix
for another bug and this behavior will be backported to earlier versions
in future releases.

 

  Looks like we're going to have to go with a single listener,
like it or not.

 

  Sigh.

 



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=558243617-21092005><FONT face=Arial
color=#0000ff size=2>Humm,&nbsp; Did that too, but without
problems.</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> Richard Ji [mailto:richard.c.ji@(protected)
]
<BR><B>Sent:</B> Wednesday, September 21, 2005 1:34 PM<BR><B>To:</B> Goulet,
Dick<BR><B>Cc:</B> MGogala@(protected); JayMiller@(protected);
oracle-l@(protected)<BR><B>Subject:</B> Re: 10.2 listener won't start on same
port as 9.2 listener<BR></FONT><BR></DIV>
<DIV></DIV>It's backward compatible but not without problems some times.&nbsp;
I
ran into<BR>a problem using 9i listener for a <A
href="http://8.1.7.4">8.1.7.4</A> DB where it start to run out of
file<BR>descriptors.&nbsp; Revert back to 8i listener solved the problem.&nbsp;
So I had to<BR>run two listeners.<BR><BR>Regards<BR><BR>Richard<BR><BR>
<DIV><SPAN class=gmail_quote>On 9/21/05, <B class=gmail_sendername>Goulet,
Dick</B> &lt;<A href="mailto:DGoulet@(protected)">DGoulet@(protected)</A>&gt;
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204
,204) 1px solid">
 <DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff size=2>The
advice
 I got from OTS some years ago, like with the release of 8.0, was to use one
 listener for all databases on a single server, just use the latest listener
 installed as they were backwards compatible.&nbsp; That advice has been
 working extremely well ever since.&nbsp; So my question would be why do you
 want a separate listener, unless you've got two or more IP addresses, and
 consequently NIC's, for one server?</FONT></SPAN></DIV>
 <DIV><SPAN class=e id=q_106794e2173fd994_1><BR>
 <DIV lang=en-us dir=ltr align=left>
 <HR>
 <FONT face=Tahoma size=2><B>From:</B> <A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:oracle-l-bounce@(protected)"
 target=_blank>oracle-l-bounce@(protected)</A> [mailto:<A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:oracle-l-bounce@(protected)"
 target=_blank>oracle-l-bounce@(protected)</A>] <B>On Behalf Of </B>Gogala,
 Mladen<BR><B>Sent:</B> Wednesday, September 21, 2005 11:20 AM<BR><B>To:</B>
 '<A onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:JayMiller@(protected)"
 target=_blank>JayMiller@(protected)</A>'; <A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:oracle-l@(protected)"
 target=_blank>oracle-l@(protected)</A><BR><B>Subject:</B> RE: 10.2 listener
 won't start on same port as 9.2 listener<BR></FONT><BR></DIV>
 <DIV></DIV>
 <DIV>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Oracle is, quite
 obviously, listening to my advice, even if some listers are
 not.</SPAN></FONT></P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT>&nbsp;
</P>
 <DIV>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">--</SPAN></FONT>
<FONT
 color=navy><SPAN style="COLOR: navy"></SPAN></FONT></P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mladen
 Gogala</SPAN></FONT><FONT color=navy><SPAN
 style="COLOR: navy"></SPAN></FONT></P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Ext.
 121</SPAN></FONT></P></DIV>
 <DIV>
 <DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
 size=3><SPAN style="FONT-SIZE: 12pt">
 <HR align=center width="100%" SIZE=2>
 </SPAN></FONT></DIV>
 <P><B><FONT face=Tahoma size=2><SPAN
 style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN><
/FONT></B><FONT
 face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:JayMiller@(protected)"
 target=_blank>JayMiller@(protected)</A> [mailto:<A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:JayMiller@(protected)" target=_blank>
 JayMiller@(protected)</A>] <BR><B><SPAN
 style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, September 20, 2005 6:07
 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <A
 onclick="return top.js.OpenExtLink(window,event,this)"
 href="mailto:oracle-l@(protected)"
 target=_blank>oracle-l@(protected)</A><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></DIV>
 <P><FONT face="Times New Roman" size=3><SPAN
 style="FONT-SIZE: 12pt"></SPAN></FONT>&nbsp;</P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Well, I just got the
 answer from Oracle and apparently 10.2 is purposely not allowing you to do
 this any more.&nbsp; It was done as a fix for another bug and this behavior
 will be backported to earlier versions in future releases.</SPAN></FONT></P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT>&nbsp;
</P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Looks like we're
 going to have to go with a single listener, like it or not.</SPAN></FONT></P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT>&nbsp;
</P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Sigh.</SPAN></FONT><
/P>
 <P><FONT face=Arial color=navy size=2><SPAN
 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT>&nbsp;
</P></DIV></SPAN></DIV></BLOCKQUOTE></DIV><BR></BODY></HTML>