RE: upgrade 10.2.0.3 to 10.2.0.4 on windows -

as-salaamu 'alaykum 

Amin, thanks for your interest in this issue.

> What setting in the Registry?

(now deleted)

HKEY_LOCAL_MACHINESOFTWAREORACLEKEY_OraDb10g_home1ORA
_INST_PFILE = 
D:oracleproduct10.2.0db_1databaseinitINST.ora

(warning - line wrapping)
fwiw - "INST" is not the real database name

> In which directory was the PFile and the SPFile?

D:oracleproduct10.2.0db_1database[PFile].ora
D:oracleproduct10.2.0db_1database[SPFile].ora

---

To reiterate, the problem did not exist in 10.2.0.3, it only

occurred after upgrading to 10.2.0.4 (CPU July 15, 2008).

I guess the days of installing Oracle CPUs (critical patch
updates -  
"security patches) on a production windows server
without testing 
them first are over.

As an aside, the contract DBA that solved the problem said
that he 
concluded a while ago that that staying with a
("static") PFile 
instead of using a ("dynamic") SPFile is usually
better.

Regards,
Eric

On 20 Sep 2008 at 8:50, Amin Adatia wrote:

> In which directory was the PFile and the SPFile?
> 
> What setting in the Registry?
> 
> 
> Regards
> Amin Adatia( aminknowtech.ca )
> KnowTech Solutions Inc. ( www.knowtech.ca )
> +1.613.226.8378  Mobile +1.613.864.8378
> 
> 
> -----Original Message-----
> epiercesurewest.net
> Sent: Fri September-19-2008 19:46
> To: Multiple recipients of list ODTUG-SQLPLUS-L
> 
> re: oracle 10 on windows 2003
> 
> fyi
> 
> for some reason, using a SPFile ("init.ora"
parameters) we had a glitch
> upgrading from 10.2.0.3 to 10.2.0.4 ("15-July-2008
CPU") where ORADIM was
> looking at an old PFile instead of the SPFile. (the
PFile was left over from
> an Oracle8 upgrade.)
> 
> ORADIM had startup errors because the SPFile had
"compatible=10.0" and PFile
> had "compatible=9.2".
 . . .

-- 
For more information on this topic or to become a member,
visit our Web site at http://www.ODTUG.com  

Join ODTUG for The PL/SQL and The APEX Expert Gathering of
the Year! OPP2008 and APEXposed! 2008 will be held on
October 29-30, 2008 at the Wyndham O'Hare, Chicago. Visit
www.odtugopp.com or www.odtugapextraining.com for more
details.


-- 
Author: 
  INET: epiercesurewest.net

Fat City Hosting, San Diego, California -- http://www.fatcity.com
------------------------------------------------------------
---------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGurufatcity.com (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from). 
You may
also send the HELP command for other information (like
subscribing).