Mixing 8.1.7.7 and 9.2.0.6 on HP-UX with memory windows

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Mon, 4 Apr 2005 14:09:11 -0400
Message-ID: <52C70FF150F49E479DAF59C68A27149D010A5ED4@va016a0e2.corp.suntrust.com>

Inherited a test box that has four 8.1.7.4 databases on an HP-UX box running memwindows so they will all fit. This also incorporated a "strange" set up with the listener in that it appeared, as best as they can recollect that a listener could only talk to one memory window, so there are 4 "listeners" so to speak.

We want to convert them, one at a time to 9.2.0.6. Giving the strangeness of the setup, has any one had any problems with memory windows, going from 32 bit to 64 bit all on HP-UX?

The "sister" box went fine, but it only had one database, thus was an "all or nothing" conversion.

I'm assuming that I'll only be able to convert one listener at a time, but as the databases come over to 9, they can all be handled by one listener.(normal again)

PFDEV:/home/oracle> lsnrctl status

LSNRCTL for HPUX: Version 8.1.7.4.0 - Production on 04-APR-2005 13:57:54

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

STATUS of the LISTENER

Alias                     listener

Version                   TNSLSNR for HPUX: Version 8.1.7.4.0 -

Production

Start Date                25-FEB-2005 15:13:17

Uptime                    37 days 21 hr. 44 min. 37 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File
/u001/app/oracle/product/8.1.7/network/admin/listener.ora

Listener Log File
/u001/app/oracle/product/8.1.7/network/log/listener.log

Services Summary...

PFBAK has 2 service handler(s)

PFDEV has 2 service handler(s)

PFITE has 2 service handler(s)

PFTST has 1 service handler(s)

The command completed successfully

PFDEV:/home/oracle> ps -eaf|grep tnsl

oracle 5914 1 0 Feb 25 ? 0:22
/u001/app/oracle/product/8.1.7/bin/tnslsnr listener7 -inherit

oracle 5477 1 0 Feb 25 ? 0:10
/u001/app/oracle/product/8.1.7/bin/tnslsnr listener5 -inherit

oracle 5053 1 0 Feb 25 ? 3:29
/u001/app/oracle/product/8.1.7/bin/tnslsnr listener2 -inherit

oracle 5719 1 0 Feb 25 ? 0:00
/u001/app/oracle/product/8.1.7/bin/tnslsnr listener6 -inherit

oracle 4853 1 0 Feb 25 ? 4:59
/u001/app/oracle/product/8.1.7/bin/tnslsnr listener -inherit

oracle 27264 27117 1 13:58:18 pts/tf 0:00 grep tnsl

PFDEV:/home/oracle>

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. [ST:A234]

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

Received on Mon Apr 04 2005 - 14:23:28 CDT