Upgrade from 8.1.6 to 8.1.7

From: Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK>
Date: Mon, 11 Nov 2002 17:38:38 -0500
Message-ID: <eub0tu0kbv9lmtd6aukdomigor7ofjaiur@4ax.com>

We have an 8.1.6 database, and with a new server, we'd like to start using 8.1.7. We installed 8.1.7 on the new server, put the database in place and did a recover. After starting up the database, I tried logging in via SQL*PLUS. It was succesful but it reported errors in some modules,

$ dbstart

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production JServer Release 8.1.7.0.1 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                        114839712 bytes
Fixed Size                                          73888 bytes
Variable Size                                    87494656 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                     10493952 bytes

Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Database "ORCL" warm started.
$ sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Nov 11 19:31:45 2002

Enter user-name: xxxxxxxx
Enter password: xxxxxxxx
ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]

Error accessing package DBMS_APPLICATION_INFO ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production JServer Release 8.1.7.0.1 - Production

After a quick search on google groups, I found that PLS 707 can appear after a upgrade is started but not finished.

What is the appropriate way to upgrade? Also, where do I find upgrade scripts? I only see 8.1.7 EE listed at
<URL:http://otn.oracle.com/software/products/oracle8i/content.html>. I don't even see the standard edition!

Brian Received on Mon Nov 11 2002 - 16:38:38 CST