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

Links

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-19 - By JayMiller@(protected)

Reply: 1 2 3 4 5 6 7 8 9 10 >>

Is anyone else out there running both a 10.2 and a 9.2 listener on the same
port? Now that I've successfully upgraded my dev database from 10.1 to 10.2
I'm having listener issues (Solaris 2.9).

Previously I was running 3 listeners on the same port with no problems (2 of
them 9.2 one of them 10.1). When I try to start the listener for the 10.2
database it complains that there is already a listener running on that port:

$ lsnrctl start listener_mds

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 19-SEP-2005 20:37:49

Copyright (c) 1991, 2005, Oracle. All rights reserved.

TNS-01106: Listener using listener name listener_rtb has already been
started

I'm using the same host and key settings that worked on the 10.1 instance:

LISTENER_MDS =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = mdsdev)(PORT = 1526))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCMDS))

)

)

)

SID_LIST_LISTENER_MDS =

(SID_LIST =

(SID_DESC =

(ORACLE_HOME = /oracle/mds/product/10.2.0)

(SID_NAME = mdsdb)

)

)

Thanks,
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>
<BODY>
<html>

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

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

<style>

</style>

</head>

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

<div class=Section1>

<div>

<div>

<div>

Is anyone else out there running both a
10.2 and a 9.2 listener on the same port?  Now that I've
successfully upgraded my dev database from 10.1 to 10.2 I'm having
listener issues (Solaris 2.9).

 

Previously I was running 3 listeners on
the same port with no problems (2 of them 9.2 one of them 10.1).  When I
try to start the listener for the 10.2 database it complains that there is
already a listener running on that port:

 

$ lsnrctl start listener_mds


LSNRCTL for Solaris: Version 10.2.0.1.0 -
Production on 19-SEP-2005 20:37:49

Copyright (c) 1991, 2005, Oracle. 
All rights reserved.

TNS-01106: Listener using listener name
listener_rtb
has already been started

 

I'm using the same host and key
settings that worked on the 10.1 instance:

 

LISTENER_MDS =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

     
(ADDRESS_LIST =

       
(ADDRESS = (PROTOCOL = TCP)(HOST = mdsdev)(PORT = 1526))

      )

     
(ADDRESS_LIST =

       
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCMDS))

      )

    )

  )

 

SID_LIST_LISTENER_MDS =

  (SID_LIST =

    (SID_DESC =

     
(ORACLE_HOME = /oracle/mds/product/10.2.0)

      (SID_NAME =
mdsdb)

    )

  )

 

 

 

 

Thanks, 
Jay Miller

</div>

</div>

</div>

</div>

</body>

</html>

<hr size=1>

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.

</BODY>
</HTML>