Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Upgrade of Oracle 8.1.7

Arlindo Ferreira_1
Occasional Contributor

Error in Upgrade of Oracle 8.1.7

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
9 REPLIES
Andreas D. Skjervold
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Alexander M. Ermes
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
John Palmer
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Building a dumber user
Volker Borowski
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Occasional Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Occasional Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Honored Contributor

Re: Error in Upgrade of Oracle 8.1.7

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
Occasional Contributor

Re: Error in Upgrade of Oracle 8.1.7

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.