Re: That crazy CBO.....

On HP UNIX going from 8.1.6 to 8.1.7 is easy.

Make sure you have 20 megs of free space in the SYSTEM tablespace.

Create a link under the new $ORACLE_HOME/dbs that points to your pfile.

Make sure you variables are pointed to your new Oracle executables.

Start Server Manager and run the following commands:

connect internal

startup restrict

spool migrate.log

set echo on

@$ORACLE_HOME/rdbms/admin/u0801060.sql

If you did not get any errors - congratulations!

On Wed, 27 Oct 2004 16:46:56 -0400, Spears, Brian <bspears_at_limitedbrands.com> wrote:
>
> I am migrating a database from 8.1.6 to 8.1.7. Should be simple right. The
> docs and my server don't match. Does anyone have a document of the
> migration process they put together?
> This is for hp unix but unix may suffice.. The 8.1.7 Binaries are installed
> on the machine already. I just have to upgrade an existing 8.1.6 database
> instance.
>
> Brian
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l