Oracle-L: RE: 8i databases under 9i listener?

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Wed, 05 Mar 2003 09:34:44 -0800
Message-ID: <F001.00560E93.20030305093444@fatcity.com>

We had something similar, but only when attempting a server SQL+ connection, which I found was
due to someone messing up the ORA_NLS33 setting.

As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: jeff.thomas_at_thomson.net

Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain
-----Original Message-----

Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L

We are also finding difficulties with a mixed Oracle environment.

We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener, and then start to upgrade our instances, one by one. This go around, after upgrading our listener to 9.2.0.2, when PeopleSoft tries to connect to a 8.1.7.3 database using the 9.2.0.2 listener, the process fails with the message "ORA-01890 NLS error detected". This is happening both when a PS App Server is connecting to Oracle and when the PS client program connects in 2-tier mode. We didn't see this type of behavior with other tools (SQL+, Toad, etc.) connecting to Oracle, so we thought it was a PS problem and reported it to their support center without much progress. In the mean time, we have reconfigured so that we are now running 2 listeners on the box, one for Oracle 8i and one for Oracle 9iR2. So far, we have not found a problem with Oracle 9iR2 databases interacting with like listeners, but our testing continues.

If anyone else on this list can shine some light on this problem, please do.

*---------------------------------------------------------------------------

*
  Stephen T. Murphy
  Manager, Database and Technical Support   ITS - University Applications Development   MSC-100
  The University at Albany, S.U.N.Y

  Albany,  New York    12222            
  Phone: (518) 437-4523     Fax: (518) 437-4540

<mailto: SMurphy_at_UAMail.Albany.EDU> MailTo: SMurphy_at_UAMail.Albany.EDU AIM: SMurphy199

-----Original Message-----

Sent: Wednesday, March 05, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L

RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener.

PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file.
Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases.

We've checked, and double-check, all environment variables, O/S permissions,

and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something
that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue.

The sequence of events went like this:

Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there

are eight 8.1.7.4 instances running.

Feb 14th -- We startup the 9i listener and shutdown the 8i listener.

Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was

successful.

The funny thing is that none of the 8.1.7.4 databases had any problems with the
9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links.

But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was
bounced for the first time since it's inception, and then all the problems started.

We are back to running both an 8i and 9i listener for the time being, but I have
a lurking suspicion that something is not right somewhere, and could come back
and bite us in the future.

Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: jeff.thomas_at_thomson.net

Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba> Select 'Indy DBA' then 'DBA Web Pages'

As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: jeff.thomas_at_thomson.net

Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON.

More about Thomson: http://www.thomson.net/videochain <http://www.thomson.net/videochain>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Jeff
INET: jeff.thomas_at_thomson.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 05 2003 - 11:34:44 CST