Re: Adventures of a Designer 2000 installer on Netware

That's quite a tale. Thanks for including so much detail.

Recently, we upgraded from Oracle 7.0.16 to 7.1 on our Netware 3.12 server and ran into what might be a similar problem. When running the CATPROC.sql routines (the one that creates all of the support for stored procedure/packages and server routines like PUT_LINE), some of the packages failed to create.

The first solution from Oracle was to get more memory in our server, but we are running at 32 megabytes right now. In the end, I found out by my own experimentation that when a package is created using the OR REPLACE clause, it would fail. However, if I did a DROP PACKAGE package_name; and then a separate CREATE PACKAGE package_name; things worked just fine.

Everything installed OK once I modified some of the script files. Oracle is still looking into the problem.

Another hint Oracle has given me is that some versions of SQL*Plus may not run scripts correctly. Also, when running SQL*DBA on the server in Full Screen mode, scripts might not execute properly. They made it a point to ask me to run the scripts from the server console using only SQL*DBA in LINE mode.

I think these two examples are indications that not everyone out there has 128 MB of RAM to spare. Oracle should do more testing in low memory situations where things start to get real flaky. Not all DBAs are brave enough or have the spare time to muck about with install scripts. Hopefully things will improve over time as they typically do with Oracle.

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Fri Aug 04 1995 - 00:00:00 CEST