Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!usenet From: Brian Tkatch Newsgroups: comp.databases.oracle.server Subject: Upgrade from 8.1.6 to 8.1.7 Date: Mon, 11 Nov 2002 17:38:38 -0500 Organization: Altopia Corp. - Usenet Access - http://www.altopia.com Lines: 59 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Newsreader: Forte Free Agent 1.92/32.572 Xref: newsfeed1.easynews.com comp.databases.oracle.server:166586 X-Received-Date: Mon, 11 Nov 2002 15:38:07 MST (news.easynews.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 Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. 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 (c) Copyright 2000 Oracle Corporation. All rights reserved. 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 . I don't even see the standard edition! Brian