Hi Nick ,
What I came through while reading the errors which you were getting is that there are some parameters in init.ora which are not supported in 9i ,
Recently we have done migration from 8.1.7.4 to 9.2.0.5 so some parameter in init.ora we have to be changed.
Could you please send me your init.ora file ,so that I could help you out with the problem which you are facing.
Rohit
-----Original Message-----
From: Cox Nick [mailto:oracledba-ezmlmshield-x52651680.[Email address protected]
Sent: Saturday, July 31, 2004 4:14 AM
To: LazyDBA Discussion
Subject: 8.1.7.0 to 9.2.0.4 upgrade failure
Hi folks,
I've got a tar open for this as well, but I'm getting to the stage of having
to abandon this upgrade, so any help appreciated.
Been through all the prelim stuff and get to
startup migrate
... which fails with the following error. Can anyone offer any advice ?
many thanks,
Nick
/ora1/users/oracle >sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jul 30 23:20:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup migrate
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 292161720 bytes
Fixed Size 731320 bytes
Variable Size 167772160 bytes
Database Buffers 102400000 bytes
Redo Buffers 21258240 bytes
Database mounted.
ORA-00402: database changes by release 8.1.7.0.0 cannot be used by release
8.1.0.0.0
ORA-00405: compatibility type "Faster segment drop"
SQL> exit
**********************************************************************
This is a commercial communication from Commerzbank AG.
This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email address protected] immediately that you have
received it and then destroy the copy in your possession.
Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.
This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.
**********************************************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
=================================================
Disclaimer : The information contained in this Message is confidential and intended only for the use of the individual or entity identified. If the reader of this message is not the intended recipient, any dissemination, distribution or copying of the information contained in this message is strictly prohibited. If you received this message in error, please notify the sender immediately.
Oracle LazyDBA home page