ITEC NEWSLETTER
Vol. 5, No. 10
November 14, 1997

Table of Contents

1. Wizard Seminar
2. Oracle 7.1.5Supported ThroughJune 30, 1998
3. Oracle Patch forDBMS PIPESon Alpha Under 7.1.5
4. Installing Products inShared Memory


1.WizardSeminar

The Wizard Seminar will be held December 3 and 4, 1997 at the Four Points HotelinSyracuse. There will be a Track A: System and Technical; and Track B:Oracle/Banner. OnDecember 3 at 7 p.m. there will be "Birds of a Feather" discussiongroups. Todate the topics are "Banner Technical FAUG" and "WindowsNT/BackOffice."

Please contact me if you would like to register for Wizard and if you have anyadditional"Birds of a Feather" discussion topics. I can be reached at716-878-4832 orboquarba@itec.suny.edu. Hotel arrangements can be made by contacting the FourPointsdirectly at 314-457-1122.

Submitted by Barbara Boquard


2. Oracle 7.1.5 SupportedThrough June30, 1998

ORACLE WORLDWIDE CUSTOMER SUPPORT SERVICES ANNOUNCEMENT

Oracle formally announces the extension of Oraclemetals Support, formerly knownasCustomer Care Support, for Oracle7 Release 7.1.5 for Alpha and VAX OpenVMS toJune 30,1998.

ANNOUNCEMENT DETAIL

In June 1996, Oracle announced the end of Oraclemetals Support for Oracle7,Releases7.1.x, effective October 31, 1997 for all platforms. Due to the architecture ofDIGITAL'sAlpha and VAX OpenVMS operating systems and changes in OpenVMS Version 7,Oracle7 Release7.3 for OpenVMS required a longer porting period. Oracle recognizes thatcustomers onthese platforms were not able to start their upgrades due to the delayedavailability ofOracle 7.3 on these platforms. As a result, Oracle has extended theOraclemetals supportperiod for Oracle 7.1.5 for Alpha and VAX OpenVMS to June 30, 1998. Thisextension isbeing provided at no additional cost to Oracle supported Alpha and VAX OpenVMScustomers.

The terminal release of Oracle 7.1 for Alpha and VAX OpenVMS is 7.1.5. All OpenVMScustomers must be on this release of 7.1 for continued Oraclemetals supportthrough June30, 1998. Extended Assistance Support will be provided for 3 years afterOraclemetalsSupport ends to those customers who are unable to migrate before June 30, 1998.ExtendedAssistance Support provides for telephone and electronic support only,consisting of thefollowing:

* Answering customer questions
* Providing workarounds and fixes that may be available for known problems, ifpossible
* Providing customers with migration path information

Extended Assistance Support does not provide for the following:

* Software error correction support
* Backporting of fixes
* Certification with supported products or newer operating system releases
* Escalation Support or guaranteed response times or skill availability

Due to these limitations, Oracle strongly recommends that customers upgrade toOracle 7.3as soon as possible to maintain the highest level of support for their productsandsystems.

The following table illustrates the product lifecycle for Oracle7 for Alpha andVAXOpenVMS platforms:

Product OS Certif. Oracle RDBMS/Tools Oracle Worldwide Certification CustomerSupportServices
______________________________________________________________________
Oracle 7.3 Open VMS V7 Developer/2000 1.3.2 Oraclemetals Support For AlphaDeveloper/2000R1.0
(rel 9/19/96) Version 6 Tools

Oracle 7.1.5 Open VMS V6 & Developer/2000 R1.0 Oraclemetals Support For VAXOpen VMSV5.5 CDE1/FORMS4.0.X/ And Alpha (VAX only) Reports 2.0.X (thru 6/30/98) Version6 Tools

ORACLE WORLDWIDE CUSTOMER SUPPORT SERVICES ANNOUNCEMENT ORACLE7 FOR OPENVMS,RELEASE 7.1.5

SUPPORT NOTES

1) Oracle 7.3.2.3.2, the current Oracle7 Server release on the Alpha platform,supportsOpenVMS 7.1 and provides 64-bit Very Large Memory (VLM) support. The Oracle7Serverlicense includes the
following product components: Oracle Distributed Database Option, OracleParallel QueryOption, Oracle Advanced Replication Option, Oracle Server Manager, SQL*Net(TCP/IP andDECnet), and Oracle Intelligent Agent. The following components are licensableseparately:Oracle Parallel Server Option, Oracle Spatial Data Option, SQL*Plus, andProgrammer/2000(Oracle precompilers for Ada, C/C++, COBOL, FORTRAN, Pascal, PL/I, andSQL*Module for C).

2) Developer/2000 Release 1.3.2, the current tools release on both Alpha andVAX OpenVMS,supports Oracle 7.3 and OpenVMS 7.x. The Developer/2000 Release 1.3.2 licenseincludes thefollowing product
components: Oracle Forms 4.5.7, Oracle Reports 2.5.5, and Oracle Graphics2.5.7. OracleProcedure Builder 1.5.6 may be licensed separately.

3) Oracle supports running Developer/2000 Release 1.0 against Oracle 7.3 in aclient/server configuration only. On OpenVMS, the only supported configurationofDeveloper/2000 Release 1.0 with Oracle 7.3 is to run the tools on a separatehardwareclient connecting to Oracle 7.3 on an OpenVMS 7.x system via SQL*Net V2.

4) These products are only available in Oracle 7.1.x bundles on OpenVMS. Theseproductsare not included in the Oracle 7.3.x bundles, but are certified and supportedin aclient/server installation for Oracle 7.3, using SQL*Net V2, through release7.3.4. OnOpenVMS, the only supported configuration of these
products with Oracle 7.3 is to run the tools on a separate hardware clientconnecting toOracle 7.3 on an OpenVMS 7.x system via SQL*Net V2. SQL*Net V1 is not supportedagainstOracle 7.3.

5) The end of Oraclemetals support for Oracle 7.3 on all Oracle platforms willbedetermined after the release of Oracle8. The end of Oraclemetals support forOracle 7.3will occur no earlier than December 31,1999, and Oracle will provide 24 monthsadvancednotification prior to the end of Oraclemetals support.

6) Oracle 7.3.2.3.1, the current Oracle7 Server release on the VAX platform,supportsOpenVMS 7.0 and 7.1. The Oracle7 Server license includes the following productcomponents:Oracle Distributed Database Option, Oracle Parallel Query Option, OracleAdvancedReplication Option, Oracle Server Manager, SQL*Net (TCP/IP and DECnet), andOracleIntelligent Agent. The following components are licensable separately: OracleParallelServer Option, Oracle Spatial Data Option, SQL*Plus, and Programmer/2000(Oracleprocompilers for Ada, C/C++, COBOL, FORTRAN, Pascal, PL/I, and SQL*Module forC).

7) Oracle 7.1.5 is the terminal release of Oracle 7.1 for OpenVMS customers. OnVAX,Oracle 7.1.5 supports OpenVMS 5.5-2 through 6.2. On Alpha, Oracle 7.1.5supports OpenVMS6.1 through 6.2. OpenVMS customers must be on Oracle 7.1.5 for continuedOraclemetalssupport through June 30, 1998. Error correction support for any other Oracle7.1.x releasewill be limited and is subject to priority 1 severity problems and technicalfeasibility.

Submitted by Mike Notarius


3. Oracle patch forDBMS_PIPES onAlpha under 7.1.5

Hello Everyone!

I would like to Thank Kathy Paranya for pointing this required patch on AlphaOpenVMSOracle 7.1.5.2.3. I will include the e-mail from the Banner Oracle listservethat Kathyforwarded to me. Please note as the "itec_readme.txt" file in theGETSOFTWAREsaveset explains, you only need the patch for Bug #381331.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Hi Mike....

I just got this e-mail message and don't know if you are aware of the problemsthat Bannercampuses have been having with Oracle pipes. There will be more and more Bannercampusesusing this piping system as they move to Banner 2.1.x, so if you caninvestigate thesepatches it would be great.

Thanks,
Kathy Paranya

Database Administrator
SICAS Center     Internet:PARANYKW@ONEONTA.EDU   
SUNY at Oneonta    Phone: 607-436-2032
Oneonta, NY 13820-4015    FAX:   607-436-2038
*******************************************************************************



From:    IN%"boracle@sctcorp.com" 29-OCT-199718:17:36.78
To:       IN%"boracle@sctcorp.com""TCPNET: BANNER Oracle Discussion List"
CC:   
Subj:    Gurjobs Problems & Solutions

Hi All,

This is to let everyone know that we think we have a solution to the G Gurjobsproblemthat people have experienced with Oracle 7.1.5 (mostly VMS Shops). The problembeing theGURJOBS pipe & all of Job submission freezes and you need to bring down thedatabaseto clear the problem -- thanks to all the hard work of Don Gaarder at theAction Line forfinding this patch. According to the BUG Reports, this is a pipe & timingproblem andrequired a backport. We've been since last Friday now without GURJOBS stopping(knock onfake wood product.) I think this is the solution we've been looking for!

For those who get their support from Oracle, the related bug numbers that youshould lookfor are:
Bug #287705, Bug #334693, Bug #381331.  (Our TAR# was 10385917.5)

Once you install the patched files, you need to relink oracle and all theapplications ...Not too bad of a job.

After we implemented the solution, we shipped the tape to SCT to help in itsdistribution.They should have the tape by now.

Also, I notice that from a client perspective, GURJOBS seems to process a bitfaster (nolong wait aor gray screen waiting for the message to be processed).

Thanks for the feedback everyone! I hope this info is helpful to you aswell.

dB
+------------------------------------------------------------------------+
| Darryl 'dB' Balaski -- Database Administrator                                       |
| Board of Trustees of Community-Technical Colleges                             |
| Hartford, CT 06105 tel: (860)-725-6699 Fax: (860)-541-5711             |
|--------------------------------------------------------------------------|
| personal page: http://www.commnet.edu/co/staff/darryl/                          |
| banner release: http://www.commnet.edu/cgi-bin/bannerver                     |
+========================================================================+
| The problem with an Us vs. Them world view is that it is too inclusive.      | 
+-------------------------------------------------------------------------+

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

The patch, if not already, will be in GETSOFTWARE shortly.

According to Oracle (when the TAR was open), there is no patch available forVAX.

As always, if you have any questions please let me know.

Submitted by Mike Notarius


4.InstallingProducts in Shared Memory

If you have more than one concurrent Oracle product user, installing theproduct in sharedmemory can potentially save physical memory and increase performance.

You can also install some or all of the Oracle products in shared memory byrunning theORA_INSUTL.COM file. If a product is installed into shared memory, each productneedsadditional global pages (these numbers are approximate) as indicated by thefollowingtable:

Program Alpha Pagelets VAX Pages
Export 1264 2467
Import 1264 2381
Programmatic Interfaces 11856 5057
SQL*Loader 1552 2693
SQL*Net 65 9
SQL*Plus 6944 3035
Server Manager 8978 2565
Pro*C 7332 5514


Running ORA_INSUTL

The ORA_INSUTL.COM file can be run from the ORA_INSTALL directory any timeafter theproducts have been installed.

Run ORA_INSUTL as often as you want to install different products.

1. To run the ORA_INSUTL file, enter the following command:

$ @ORA_INSTALL:ORA_INSUTL

A list of all the Oracle products installed on your system is displayed,similar to thefollowing:

Installable Utilities --------------------- 1. SQL*Plus
                                                             2. NetConfig
                                                             3. PROGINT
                                                             4. RDBMS

2. Enter the number of the product you want to install and press[RETURN].  Enter ALLto install all products. Enter E or EXIT to leave this menu with the productsyouselected. Enter Q for Quit to leave this menu without installing any product.

ORA_INSUTL creates ORA_UTIL:INSUTILITY.COM and ORA_UTIL:REMUTILITY.COM.

It then runs INSUTILITY to install the selected products in shared memory andexits.
ORA_UTIL:INSUTILITY.COM and ORA_UTIL:REMUTILITY.COM are defined as follows:

INSUTILITY.COM:

Installs Oracle products other than the Server (RDBMS), such as Oracle Formsand SQL*Plus,in shared memory.

REMUTILITY.COM:

Removes the products from shared memory, such as Oracle Forms and SQL*Plus,installed byINSUTILITY.COM. It does not affect the shared global sections of the Oracle7images.

PLEASE NOTE: if you see Oracle programs taking up memory for each user, andthese productsdon't appear in the list mentioned above, then you can add them to the twofiles(ORA_UTIL:INSUTILITY.COM and ORA_UTIL:REMUTILITY.COM) yourself (by using thelines in thefile already as a guide) so the program will run in shared memory.

I would like to Thank Romney Taylor for his guidance in this article.

Submitted by Mike Notarius



                                                      Editor: Barbara A. Boquard
                                                      boquarba@itec.suny.edu


                                                      ITEC's General Office    716/878-4832

                                                      Director's Office             716/878-4832
                                                      Operations                     716/878-5122
                                                      After Hours                    716/878-6642
                                                      FAX                              716/878-4235
                                                      Web Page                      http://www.itec.suny.edu


ITEC Home Page