DBA Tips Archive for Oracle
Running MTS on Oracle8i Database with Oracle9i Listener
by Jeff Hunter, Sr. Database Administrator
Consider the following database server configuration with two Oracle product sets installed (Oracle 8.1.7 and Oracle 9.2.0):
- Oracle8i (8.1.7)
- Database called ORA817 running in MTS
- Oracle9i (9.2.0)
- Database called ORA920 (Doesn't matter if running in MTS or not)
- Oracle9i TNS Listener services both ORA81 and ORA920 databases
In short, I have two databases (one is 8.1.7 and the other is 9.2.0) on the same database server. The ORA817 database is running in Multi-Threaded Server mode while ORA920 can either be in MTS mode or not. The key fact here is that a 9.2.0 listener is listening for an 8.1.7 databases that is running in MTS.
This configuration will not make connections to the Oracle8i (ORA817) using MTS. Dedicated server worked fine for ORA817. When trying to connect through MTS, (using SQL*Plus or from the Web), the session just hangs.
I then shutdown all 18.104.22.168.0 databases and moved the Oracle9i listener to the 8.1.7 ORACLE_HOME, setup ORA817 with MTS and it worked fine. It seems like the 9.2.0 listener cannot work with MTS on the ORA817 database?!?
This is documented in BUG: 2421734
Workaround - Changes to the listener.ora File
I really don't want to run two listeners (one for Oracle8i and another for Oracle9i). The workaround is to turn off direct handoff by adding the following to your listener.ora file:DIRECT_HANDOFF_TTC_<listener name> = OFF
Copyright (c) 1998-2018 Jeffrey M. Hunter. All rights reserved.
All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at firstname.lastname@example.org.
I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.