Re: Upgrade from 8.1.6 to 8.1.7

Thanx Howard. I ought to reading this tomorrow.

Brian

On Tue, 12 Nov 2002 09:51:24 +1100, "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:

>Try reading
>http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a86632/toc.
>htm
>
>It's an entire manual all about upgrading or migrating a database.
>
>Regards
>HJR
>
>"Brian Tkatch" <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> wrote in
>message news:eub0tu0kbv9lmtd6aukdomigor7ofjaiur_at_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
>>
>> 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
>> <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 - 22:22:45 CST