Re: Upgrade from 8.1.6 to 8.1.7

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 - 16:51:24 CST