imp fails after upgrade - 10-11-2003 , 03:27 PM
I manage an application that uses an Oracle DB. That DB resides on a host
running 220.127.116.11 on HP-UX 11.00. Since I don't have access to that system
and I am not confident that it is being backed up reliably, I have been
doing a nightly export from another system, run from a cron (my local Oracle
server). That has been working fine for some time.
Yesterday I upgraded my local server to 18.104.22.168. Now I can longer do a full
export. I get this error
.. exporting sequence numbers
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
It seems to work OK until it begins exporting the sequence numbers. I was
able to confirm that a "exp full=yes" can be done successfully on the
22.214.171.124 system. What is the cause of this and what, if anything, can I do
to correct it?
Re: imp fails after upgrade - 10-11-2003 , 03:48 PM
Randy Harris wrote:
compatible with a 126.96.36.199 export dictionary? What's metalink/support
say? (or perhaps the upgrade docco that comes with the upgraded s/w?)
One possibility - install a baseline 188.8.131.52 (no need to install a
database -just the s/w) in a separate Oracle Home on your local
machine. Use that instead of the new s/w to continue your exports.
A second possibility - shake some trees to ensure the backups on the HP
are done properly so you don't end up being responsible for things you
really can't control. (What happens when 'they' upgrade the HP-UX?)
A third - there's a reason for upgrading to 184.108.40.206 .... have the DB on
the HP-UX machine upgraded.
A fourth - get all the databases moved up to 9i
A fifth - investigate RMAN for backup.
(etc., etc., etc.)
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]
Re: imp fails after upgrade - 10-11-2003 , 03:51 PM
Randy Harris wrote:
WHERE status = 'INVALID';
I expect you'll find some. Then check the log file from the upgrade.
Then repeat the upgrade.
Make sure you perform any STARTUP MIGRATE or other recommendations that
are in the documentation
and be sure to run utlrp.sql in the /rdbms/admin directory.
(replace 'x' with a 'u' to reply)
Re: imp fails after upgrade - 10-11-2003 , 07:58 PM
"Daniel Morgan" <email@example.com> wrote
I don't think that can be a good thing. There was no upgrade of the
database, it was originally created with 220.127.116.11 and still is. When I
encountered the problem was attempting to do an export from a client running
18.104.22.168. It might be a matter of the 22.214.171.124 export utility simply not
being compatible with the 126.96.36.199 database (as suggested by Mr. Forbrich).
So far, I can't find any documentation indicating one way or the other.
I've already submitted a request to have the server and the database
upgraded to 188.8.131.52. Aside from that, can you suggest what steps I should
take to address this problem?
Re: imp fails after upgrade - 10-11-2003 , 08:11 PM
"Hans Forbrich" <forbrich (AT) yahoo (DOT) net> wrote
fiind anything in the documentation to suggest one way or the other.
server. We got merged with another company, SAP got moved from our
headquarters to theirs. Both our DBAs left. The system is now "managed" by
systems people with little Oracle knowledge.
have that done. (or let me do it).
the bookstore is in order.
Re: imp fails after upgrade - 10-12-2003 , 12:07 AM
On Sat, 11 Oct 2003 20:27:40 GMT, "Randy Harris" <randy (AT) SpamFree (DOT) com>
The usual issue of not running
after every upgrade
though these steps are documented.
Sybrand Bakker, Senior Oracle DBA
Re: imp fails after upgrade - 10-12-2003 , 01:07 AM
"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote
upgrading a databse? I ran them on all of my local databases (after
upgrading the server to 184.108.40.206), but the databse I'm having a problem with
is still at 220.127.116.11.