Re: DBA role missing and 8.0 to 8i upgrade problems

Toomas,

All of your problems stem from the fact that you have an older version of the data dictionary and a newer version of the binaries. Your programs are looking for views or fields that don't exist.

You should have a script in \oracle\rdbms\admin called u0800030.sql. This is the dictionary upgrade script for 8.0.3 to 8.1.5 (at least for NT). It calls several other scripts to perform the upgrade.

Before you start the upgrade, BACKUP YOUR DATABASE! Shut the oracle instance down and take copies of all data files, control files, redo logs, and archive logs used by Oracle. The file headers should be stamped with 8.1.5 by now, but if you have problems with the upgrade you may be able to back out with Oracle corp's help.

After the backup, start the database, connect internal through server manager, and run u0800030.sql. This will update your data dictionary. When finished, it is not a bad idea to take another cold backup, but that is your choice.

If you run into problems, let me know.

Brent Tucker
www.servman.com

Toomas Aas wrote in message <37F1EFE2.2AA4353B_at_mail.ee>...
>Hello!
>
>I am a NetWare administrator with practically no experience on
>managing Oracle server. However, I succeeded in getting Oracle 8.0.3
>installed on NetWare 5 ca 6 months ago and it has run with no visible
>problems since then.
>
>Now I want to upgrade the server to Oracle8i (8.1.5) and have some
>problems & questions (after much RTFMing), if you don't mind.
>
>First:
>I noticed that in Security Manager I no longer see the 'DBA' role. I
>am quite sure that it was there after installing the server (I
>installed the server with default database). God knows what has
>happened to it. Maybe this is the root of all my other problems. Is
>there a way to re-create the DBA role? Can you give me (or point me
>to) the guidelines for doing so?
>
>Second:
>The 8.1.5 installation process prompts for the oracle home directory
>on server, defaulting to \ORANW815. I had 8.0.3 installed in \ORACLE,
>so I specified \ORACLE as home for 8.1.5. Is this allowed or should I
>have installed 8.1.5 to new home instead?
>
>Third:
>After the software is upgraded, several operations result in following
>error messages:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-00942: table or view does not exist
>
>One example of when such error occurs is when I try to delete user in
>Security Manager. In this particular case there is also the message
>"VBO-5530: user cannot be dropped". But the ORA-00942 message seems to
>be the root of the evil here. I was connected as INTERNAL when I tried
>to do this and it has been tried with various user IDs (which worked
>before the upgrade).
>
>I upgraded only the software and left the original 8.0 database intact.
>
>Fourth:
>The Oracle8i 'Getting Started for NetWare' guide says that to upgrade
>the database to new 8i format I need to run the script
>RDBMS\ADMIN\CAT8004.SQL. I cannot find this script anywhere on my
>server.
>
>Thank you for reading this long message and I appreciate the feedback
>(if any).
>
Received on Wed Sep 29 1999 - 11:37:48 CDT