List Info

Thread: RE: upgrade 10.2.0.3 to 10.2.0.4 on windows -




RE: upgrade 10.2.0.3 to 10.2.0.4 on windows -
country flaguser name
United States
2008-09-20 11:50:38
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".

The problem does not appear to be documented.

Oracle Tech Support was barking up the wrong b-tree for a
while until a
Windows DBA that happened to be on-site noticed the old
oracle registry
setting pointed at the PFile. 

have a great weekend!
-- 
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: <epiercesurewest.net
  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).

-- 
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: Amin Adatia
  INET: amin_adatiahotmail.com

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).

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )