RE: Listener issue

From: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 27 Apr 2012 00:52:32 +0000

Thanks to those who emailed me.  Here are some of my responses

Lsnrctl services for the 10205 listener shows the following

Service "<ORACLE_SID>" has 1 instance(s).
  Instance "<ORACLE_SID>", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:141
         LOCAL SERVER

The LOCAL_LISTENER PARAMETER is empty in the 10203 database

I removed the sqlnet.ora in both the 10205 and 10203 directories to remove that 
as an option.

In the 10205 listener.ora I am also setting the ORACLE_HOME directory

Thanks,
Mike

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Michael Schmitt
Sent: Thursday, April 26, 2012 3:59 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Listener issue

Hello,

I have a couple databases running 10205 in a development environment.  The 
production environment had not been upgraded yet, and was running 10203.  The 
Application team wanted us to restore a couple of the databases from production 
onto development and keep it 10203.  I still had the binaries on development so 
removed the 10205 databases and then recreated them as 10203 from the backup.

The listener was running out of the 10205 binaries, so I just updated the 
oracle home there.  For some reason, the connection to the databases running 
10203 is dropping with "ORA-12537: TNS:connection closed".  I am pretty sure I 
have done this plenty of times in the past on different servers, so can't 
figure out what the problem is.  I thought as long as the listener is running a 
higher version (10205), I should be fine.  The listener still hands off the 
connection to the databases that remain 10205 without a problem.  If I shutdown 
the 10205 listener, and startup the old 10203 listener, it hands off the 
connection to the newly refreshed 10203 databases without a problem.

The error showing up in the listener.log is

26-APR-2012 15:35:10 * 
(CONNECT_DATA=(SID=<DB_NAME>)(CID=(PROGRAM=sqlplus@<machine>)(HOST=machine)(USER=oracle)))
 * (ADDRESS=(PROTOCOL=t
cp)(HOST=machine)(PORT=54980)) * establish * SID * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Solaris Error: 32: Broken pipe    

I know I must be missing something, but can't think of what it is.  Any ideas?

Thanks is advance
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

References:
- Database Licensing question
  - From: Jeffrey Beckstrom
- Re: Database Licensing question
  - From: Hans Forbrich
- Listener issue
  - From: Michael Schmitt

RE: Listener issue

Other related posts: