ITEC Newsletter
Vol. 11, No. 6
September 18, 2003

Table of Contents

  1. Oracle 9.2 x on Alpha OpenVMS Issues
  2. OracleWorld
  3. ITEC Support and Services Survey 2003

 

1.    Oracle 9.2 x on Alpha OpenVMS Issues

The following issues have been discovered by ITEC with Oracle 9.2.x on Alpha OpenVMS: 

· Stage installation CD's on ODS-5 format disk

The CD's should get sent out on Thursday. They must be copied to an ODS-5 format disk. Please use the following procedure to copy the CD's to disk:

- set process/parse_style=extended
- Mount CD 1
- Create disk$device:[9iR2install.disk1]
- set default disk$device:[9iR2install.disk1]
- copy cd$device:[000000...]*.*;* [...]*.*
- Mount CD 2
- Create disk$device:[9iR2install.disk2]
- set default disk$device:[9iR2install.disk2]
- copy cd$device:[000000...]*.*;* [...]*.*

Now when you do the install it will automatically look in the [.disk2] directory and it won’t even prompt you to change CD's.

· Pre-create top level directory for Oracle code tree

Although the installation guide does not mention it as a required step, it is a good idea to pre-create the top level directory used for the Oracle code tree:

$ CREATE/DIR/OWNER=ORACLE DISK$APPCODE:[9iR2]

Without this it is possible that you may see one or more of the following errors when installing, linking, or re-linking after applying patches:

Error in invoking target ikerberos of makefile /disk$dra78/9iR2/9iR2Home/network/lib/ins_nau.mk
An error occurred during runtime
 

· BUG 2760856: CAN'T LINK OCI PROGRAMS. LNOCI AND LNOCIC ARE MISSING

LNOCI is needed to link SQR 4.3.5 against the Oracle 9.2 code tree.  There is a patch for this on the ITEC FTP server:

ftp://ftp.itec.suny.edu/vms_oracle9.2.0.2patches/p2760856_9202_AXP.zip


· BUG 2956829 AFTER APPLYING 9.2.0.3.0 PATCHSET, DBCA CRASHES

No patch available as of yet, but the workaround is to remove the space(s) at the beginning of the line in the first line AFTER LISTENER = in listener.ora.
 

· Patch conflict for Alerts 57 and 58

When installing the patch for security alert 58 after the patch for security alert 57, the following warning message is displayed:

$ @install_patch
WARNING !!
It appears that one or more objects in this patch are part of an earlier
installed patch. Installing this patch may overwrite the earlier patch(es)
and is strongly discouraged.
The following patch contains the conflicting object(s):
2990327
Do you wish to proceed nevertheless? [N]

According to Oracle support it is safe to apply the patch and ignore the conflict message. Patch 2990334 is related to Secuity Alert 57, which is included in the patch for Security Alert 58. The patch for Security Alert 58 is replacing the same files that Security Alert 57 fixed. This caused the conflict warning to be displayed.
So do the @install_patch again and say Y for the question "Do you wish to proceed nevertheless? [N] "
 

· Set ORACLE_BASE logical before invoking the DBCA

According to the documentation, setting ORACLE_BASE is not required, however I have encountered several problems and recommend that it be set before invoking the DBCA.  For the installation of the 9.2 code, I used DISK$APPCODE:[9iR2.9iR2Home] as the ORACLE_HOME in the Oracle Universal installer. To invoke the DBCA I then do the following:

$ @DISK$APPCODE:[9iR2.9iR2Home]orauser.com
$ show log oracle_home
   "ORACLE_HOME" = "DISK$APPCODE:[9IR2.9IR2HOME]" (SERVER_2921593951)
$ define ORACLE_BASE DISK$APPCODE:[9IR2]
$ show log oracle_base
   "ORACLE_BASE" = "DISK$APCODE:[9IR2]" (LNM$PROCESS_TABLE
$ DBCA

This will allow you to modify the default file locations within the DBCA.  Without it the file locations may not get set correctly if you modify the default values.
 

· BUG 456600 OUI AND DBCA ARE USING PHYSICAL DEVICE NAMES INSTEAD OF LOGICAL NAMES

I used all logical device names when installing the code and creating databases, Oracle has translated some of these into physical device names.  Although a bug has not been opened as of yet on this issue, I do have an open TAR (3382002.999) for it and expect a bug to be filed in the near future.  The workaround in the DBCA is to select a new database for the template and generate scripts without creating a db from within dbca. You can then edit the scripts and change the diskname back to the logical before manually running the scripts.


· BUG 3145539 ORA_DUMP is being set incorrectly

The VMS logical ORA_DUMP is being set incorrectly, regardless of whether ORACLE_BASE was set or not prior to invoking DBCA.  Although a bug has not been opened as of yet on this issue, I do have an open TAR (3381993.999) for it and expect a bug to be filed in the near future.  ORA_DUMP is defined in the file ORA_ROOT:[dbs]sid_{SID}.properties.  I have heard conflicting reports from Oracle as to whether this file can be modified, so at this point there is no workaround.
 

· BUG 1134891 ORA-03113 ON STARTUP AFTER SHUTDOWN ABORT

For backups many people do a SHUTDOWN ABORT, STARTUP RESTRICT, SHUTDOWN NORMAL to kick any users off the database who may still be connected.  While this works fine in previous versions of Oracle, there is a bug in 9.2 in which the following errors will show up when attempting to restart the database after a SHUTDOWN ABORT:

SQL> startup
ORA-03113: end-of-file on communication channel
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

If you exit out of SQL*Plus and wait a while you can eventually start the database again, but there seems to be no rhyme or reason as to the sequence of events that allow this to happen.  There is no patch as of yet and the only workaround is to kill all user sessions with the ALTER SYSTEM KILL SESSION... command and then do a SHUTDOWN IMMEDIATE.

Submitted by Joe Lofft (scadm@itec.mail.suny.edu)

 

2.    OracleWorld

A few of us at ITEC were fortunate enough to be able to attend the OracleWorld conference this month and as expected the emphasis was on the upcoming release of Oracle 10g (database and application server). Attached are a couple of the many presentations we attended. You can also find a considerable amount of information on TECHNET http://otn.oracle.com/index.html as well as in the September Issue of Oracle magazine - also available online at http://otn.oracle.com/oramag/oracle/03-sep/content.html. In particular you may want to look at the cover story http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover.html

Details on availability were sketchy with Oracle promising that the database will be available by the end of this year and the common consensus being that the application server would be available a month or so before that.

OTN also is providing an ‘availability notification signup’ at
http://otn.oracle.com/iwant10g although it is unclear if this notification is for availability for download from OTN only or notification of product availability to order.

Attachments:  40090.ppt      40090.doc     40116_george_10g.ppt

Submitted by Dan Brint (scadm@itec.mail.suny.edu)
 

3. ITEC Support and Services Survey 2003

Please help the ITEC Executive Board in mapping the future of ITEC by completing the ITEC Support and Services Survey 2003 available on our web page:   http://ias.itec.suny.edu/pls/itec_survey/survey.default_page

The survey is divided into areas of support and an overall general evaluation of ITEC. We encourage you to complete the portions that are applicable to your campus. We encourage multiple responses, or a collaboration of effort, for each member campus.

Your responses will be analyzed and reviewed by the ITEC Executive Board. It is the intent of the Executive Board to direct the future of ITEC support and services based on your responses to this survey.

We understand the workload you are all facing and very much appreciate your time in completing this survey.

Submitted by Barbara Boquard (Barb.Boquard@itec.mail.suny.edu)

 

Editor:  Barbara A. Boquard

Barb.Boquard@itec.mail.suny.edu

ITEC's General Office

716/878-ITEC (4832)

Operations

716/878-5122

FAX

716/878-3485

Web Page

http://www.itec.suny.edu

 


ITEC Home