ITEC NEWSLETTER

Vol. 6, No. 4
May 22, 1998



Table of Contents
1. Oracle EnterpriseManager Performance Pack 1.5.0
2. Oracle 7.3.3.4 andpatch to bring it up to 7.3.3.5 for Alpha OpenVMS and
    Developer 2000 1.3.2 for Alpha OpenVMS are available inGETSOFTWARE.
3. Oracle Backups
4. Oracle on Open VMS


1. Oracle EnterpriseManagerPerformance Pack 1.5.0

Oracle Enterprise Manager Performance Pack 1.5.0 is now available for
download by your site license managers from the ITEC Web Getsoftwae site.

Submitted by Joe Lofft, SCADM


2. Oracle 7.3.3.4 andpatchto bring it up to 7.3.3.5 for Alpha OpenVMS and
Developer 2000 1.3.2 for Alpha OpenVMS are now available in GETSOFTWARE

This is to let you know that Oracle 7.3.3.4 along with the patch to bring itup
to 7.3.3.5 for Alpha OpenVMS and Developer 2000 1.3.2 for Alpha OpenVMS arenow
available in GETSOFTWARE.

I will include the readme files (that are included in the savesets) belowfor
your convenience. There are URL's that point to the HTML IUG for Oracle
7.3.3.4, 7.3.3.5 and Developer 2000 1.3.2. Please see below:

ORACLE 7.3.3.4 / 7.3.3.5 README.TXT:

This is the readme from ITEC for Oracle 7.3.3.4 and the patch set thatbrings
it up to 7.3.3.5. This release is for Alpha OpenVMS 7.1. You CAN NOT runthis
on an earlier version of Alpha OpenVMS.

Starting with 7.3.x, Oracle has included their IUG (installation User Guide)in
HTML format for your convenience. I have put this HTML up on my machine foryou
to access and aid in the installation.

The link for the 7334 IUG is:

http://mikec.itec.suny.edu/oracle7334alphaovms/ig/ig.html

The Administrator's User Guide can be found at:

http://mikec.itec.suny.edu/oracle7334alphaovms/stag/stag.html

The INSTRUCTIONS FOR THE 7.3.3.5 PATCH SET can be found at:

http://mikec.itec.suny.edu/oracle7334alphaovms/patch_note_7335.htm

As of today 04-30-98, there are no other patches available for 7.3.3.4
/7.3.3.5, the only later release of Oracle for Alpha OpenVMS is 8.0.3.2.

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


ORACLE DEVELOPER 2000 1.3.2 README.TXT:

This is the readme from ITEC for Developer 2000 1.3.2 on Alpha OpenVMS.
This release is for Alpha OpenVMS 7.1.

Starting with 7.3.x, Oracle has included their IUG (installation User Guide)in
HTML format for your convenience. I have put this HTML up on my machine foryou
to access and aid in the installation.

The link for the Developer 2000 IUG is:

http://mikec.itec.suny.edu/dev2k132alphaovms/d2kA/d2k.html

IT IS VERY IMPORTANT THAT YOU INSTALL THIS IN A DIFFERENT ORACLE HOME, THANTHE
ORACLE RDBMS.

PLEASE USE THE FOLLOWING LINK FOR INFO ON DOING THE ACTUAL INSTALL:

http://mikec.itec.suny.edu/dev2k132alphaovms/d2kA/apc.html#C

An important part of the installation is to NOTE:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Unlike a server-based installation of Developer/2000, ORACLEINS cannot beused
to initialize or upgrade the system database tables, or load the demodatabase
tables from a client-only installation. Please refer to your
ORA_ROOT:[<product>]ORA_<product>_DATA.COM file for the
SQL scripts you need to execute manually.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I verified with Oracle that you should just be able to run the com fileslisted
below:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
$! DISK$ORACLE1:[ORACLE.DEV2K.SQLPLUS]ORA_SQLPLUS_DATA.COM;1
$! DISK$ORACLE1:[ORACLE.DEV2K.GUICORE23]ORA_GUICORE23_DATA.COM;1
$! DISK$ORACLE1:[ORACLE.DEV2K.PROCBUILDER]ORA_PROCBUILDER_DATA.COM;1
$! DISK$ORACLE1:[ORACLE.DEV2K.GRAPHICS25]ORA_GRAPHICS25_DATA.COM;1
$! DISK$ORACLE1:[ORACLE.DEV2K.REPORTS25]ORA_REPORTS25_DATA.COM;1
$! DISK$ORACLE1:[ORACLE.DEV2K.FORMS45]ORA_FORMS45_DATA.COM;1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

NOTE: the above example assumes an ORACLE HOME ofDISK$ORACLE1:[ORACLE.DEV2K].

Submitted by Mike Notarius


3. Oracle Backups

ITEC would like to remind the people running Oracle to be sure that youhave
good backups. Please consider doing backups on a regular basis. Whenever
possible, it is recommended that you do cold backups. This involves takingthe
database down and backing up all of the physical files that make up the
database. It is also recommended to backup the instance directory(ORA_INSTANCE
on VMS) as well as all of the init files (including ones referenced with
ifile). The following three queries will allow you to identify the physical
files that actually make up your Oracle database:

select * from v$controlfile

select * from v$logfile;

select * from v$datafile;

As an added safety measure, you can also perform exports. A full exportwill
allow you to rebuild your database should that become necessary.

Besides doing the cold backups, you should be running your productiondatabase
in Archive Log mode. This allows you to recover from your last cold backup
right up to a specific point in time, including just before your database
crashed (if that is the case).

So, if you haven't already, please make sure you have a good backupmechanism
in place. Also remember that just because you have a backup on tape, it
doesn't mean the backup is good. You should take the precaution of testing
your backups so you know they will be dependable and work when you reallyneed
them.

If you have any questions or concerns regarding this subject, please feelfree
to contact ITEC Oracle support by sending e-mail to SCADM@itec.suny.edu.

Submitted by Mike Notarius


4. Oracle on OpenVMS

I just received a letter from Oracle addressing peoples concerns of Oracleon
OpenVMS. Oracle is going to be having "Teleseminars" directed totheir OpenVMS
customers. I thought I would pass this along so whoever would like tolisten
in can. I will retype the letter I received for your convenience below:

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

* Trying to decide on your future IS strategy, but wondering what thefuture
holds for OpenVMS?

* Looking for more information on Oracle's OpenVMS direction?

* Need to know how to integrate your Oracle OpenVMS environment with other
Oracle technologies?

If you are looking for answers to these questions, join us from the comfortof
your office for the Oracle / Digital OpenVMS update and DirectionsTeleseminar
on June 3rd or 4th.

Oracle and Digital invite you to discuss with product companies the exiting
future for Oracle OpenVMS customers. We will articulate our jointcommitment
to OpenVMS, and provide you with information you need to make key ITdecisions.

During this 60 minute interactive session, Oracle and Digital executiveswill
describe the investments both companies are making to protect yourinvestment
in Oracle solutions on OpenVMS. In addition to the Oracle and Digital
directions and product plan presentations, there will be an opportunity toget
answers to specific questions directly from the product management teams.

We are offering two identical one-hour sessions to fit your schedule:

Wednesday June 3rd at 10:00AM EST
or
Thursday June 4th at 2:00PM EST

TO REGISTER CALL 1-800-811-1623

OR

REGISTER ON-LINE AT http://www.digital-yes.com/oracle

This Teleseminar is the first in a series of teleseminars directed to our
OpenVMS customers. We look forward to hearing from you on the 3rd or 4th.

Sincerely,

Laurent Sandrolini
Director, Product Management
Digital Strategic Business Unit
Oracle Corporation

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

Even though COA is going on through the 3rd, you should still be able tocatch
the teleseminar on the 4th.

Please participate and bring up your concerns.

Please let me know if you have any questions or concerns regarding this.

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