Error in Upgrade of Oracle 8.1.7

[Arlindo Ferreira_1]

Hi,
We perform a Upgrade of oracle 8.0.5 (64bit) to 8.1.7 (64bit) on HP-UX 11.00 64-bit, and an error occur in the ODMA : "ORA-19502: write error on file /oracle/LI1/817_64/assistants/dbma/odma/rbs.dbf blockno 6785.
The Oracle file system is full(before upgrade ORACLE_HOME we have 1800Mb free) but when the error occur we see the /oracle is full...
When we restart ODMA we get error ORA-0600.
What can we do???
Regards
Arlindo Ferreira

[Andreas D. Skjervold]

Hi

Looks like you'll have to extend the /oracle filesystem / lvolume.

I'm a little puzzled by the positioning of the rbs.dbf file in the odma directory...
If this belings to a database it should be placed under a different mount point.

But I'm not to familiar with the migration assistant.

You're better of doing this manually. This means more work, but you have the full control of things.

Refer to Oracle Metalink
Note:133920.1
Subject: Complete upgrade checklist for manual upgrades from 8.x to 8.x
(attached)

Andreas

[Alexander M. Ermes]

Hi there.
Did you try a typical install or complete install ? You can customize the installation, means you select the products you want to run.
The Installer then checks the dependencies and gives you the minimum space required for your installation.
Did you upgrade your database or did you just install the software ?

Rgds
Alexander M. Ermes

[John Palmer]

I can only think of the obvious...

- talk to Oracle Support, ORA-00600 errors are Oracle program exceptions.

- restore the database from you pre-upgrade backup, make more space available and upgrade again.

Regards,
John

[Ian Dennison_1]

Check the install/upgrade instructions,... Did you miss any additional File Systems (like /oracle/stage) that were instead included in /oracle?

Sounds like a restart of the upgrade.

Cheers, Ian Dennison

[Volker Borowski]

Arlindo,

is this SAP environment (Path conventions look like).
If this is the case, I suspect, that somehow you included the creation of a starter database, because in a SAP environment with an upgrade to oracle 8.1.7, /oracle/SID/817_64 will be a brand new directory, which could definately not have any database files (and rollback tablespaces) in it. So the space calculation for ORACLE_HOME is done without a starter database, and this might be the problem now.

Get rid of this starter database and just upgrade the real one according to the SAP/Oracle upgrade manual. Be sure to download the most recent one from SAPNET and take a look of additional OSS notes in addition.

Hope this helps
Volker

[Arlindo Ferreira_1]

Our option was to make a restore of the backup, increase the size of the filesystem and then start all over.But we have a question, should we also restore the /oracle, or restore only the data files?

Thanks in advance
Arlindo Ferreira

[Arlindo Ferreira_1]

We made a typical installation, The software is installed, the problem is in the upgrade phase.
Why "/oracle" need more than 1800Mb free ? (manual refer 1800Mb).After the installation why /oracle continue increasing?

[Wodisch]

Hello Arlindo,

Oracle save a lot of log files below $ORACLE_HOME - if you have NOT changed that in yout "init*ora" files, those logs grow and grow :-(

Search all the "log" directories below, like
$ORACLE_HOME/rdbms/log
$ORACLE_HOME/network/log
and such...

HTH,
Wodisch

[Arlindo Ferreira_1]

Thanks gentlemen for all your help.
We have increase /oracle (more than 2500Mb free),restored the database and started all over, and now we have the database upgraded :-)

Wodisch, we had modified the oracle initialization parameters in ORACLE_HOME (oracle_home 8.0.5) :
background_dump_dest,user_dump_dest,core_dump_dest,log_archive_dest into others files-systems.
There are any more parameters to modify?
Best regards,
Arlindo Ferreira.