Home » RDBMS Server » Server Administration » 10g upgrade questions (Oracle DB 10.2.0.3)
10g upgrade questions [message #339818] Fri, 08 August 2008 14:31 Go to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
Hi,

I am planning to upgrade a 9i database to 10g.
I have the 10g software installed and CPU is also applied.
After the upgrade do i need to run the catcpu.sql or is it automatically run when catupgrd.sql is run?
Re: 10g upgrade questions [message #339819 is a reply to message #339818] Fri, 08 August 2008 14:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Get all the details in 10g Upgrade Guide.
Re: 10g upgrade questions [message #339820 is a reply to message #339818] Fri, 08 August 2008 14:49 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
If you are planning on using the Database Upgrade Assisstant DBUA then this will take care of everything for you

regards

Alan
Re: 10g upgrade questions [message #339822 is a reply to message #339819] Fri, 08 August 2008 14:57 Go to previous messageGo to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
I have gone through that but could not find what I am looking for.
Re: 10g upgrade questions [message #339823 is a reply to message #339820] Fri, 08 August 2008 14:59 Go to previous messageGo to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
Alan,

thanks for the reply..
I am planning to run the scripts manually.
Catupgrd.sql
Re: 10g upgrade questions [message #339825 is a reply to message #339823] Fri, 08 August 2008 15:08 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
I would recommend DBUA it takes away any heart ache from the manual process.

regards

Alan
Re: 10g upgrade questions [message #339826 is a reply to message #339818] Fri, 08 August 2008 15:10 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Perhaps my eyesight is failing me, but what OS is under the DB?

On RH Linux V10.2.0.3 system, I don't have any catcpu.sql file.
Re: 10g upgrade questions [message #339828 is a reply to message #339826] Fri, 08 August 2008 15:17 Go to previous messageGo to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
Hi anacedent,

10.2.0.3 on SunOS 5.9...
By catcpu.sql i mean to say the script that we run to appply the critical patch.

Do we need to run this script after upgrading the database from 9i to 10g as the CPU is only applied to 10g software?
Re: 10g upgrade questions [message #339830 is a reply to message #339825] Fri, 08 August 2008 15:23 Go to previous messageGo to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
I actually did an upgrade before and after the upgrade if i run

select * from registry$history; it doesn't show me anything.
whereas in other 10g db's it gives the patch name.
Re: 10g upgrade questions [message #339832 is a reply to message #339818] Fri, 08 August 2008 15:27 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Forgive me for NOT being a mind reader.

>By catcpu.sql i mean to say the script that we run to appply the critical patch.

>"the script"?
>"critical patch"?


>Do we need to run this script after upgrading the database from 9i to 10g as the CPU is only applied to 10g software?

>"this script"?

To take a V9 database to V10.2.0.3, you need to follow the steps in the V10.2.0.1 Installation Guide
and then follow the installation instructions which come with V10.2.0.3 patchset.

I suggest you do not try going in a single step as that it not supported.
In any case, I hope you have good backups & a documented & tested restoration procedure.

[Updated on: Fri, 08 August 2008 15:28] by Moderator

Report message to a moderator

Re: 10g upgrade questions [message #339835 is a reply to message #339818] Fri, 08 August 2008 15:54 Go to previous messageGo to next message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
thanks all..

i got the solution from Metalink..here's what it says

Since the CPU patch software was already installed before upgrading the database, do you still need to run the CPU post-install steps, like catcpu.sql?


Solution
Yes, you must still run the CPU post-install steps like catcpu.sql, even though the CPU software was already installed before you upgraded the database. The CPU post-install steps, like catcpu.sql, ensure the database objects are updated for the CPU.

For all Oracle Database releases, you must run the post-installation steps (that is, the catcpu.sql script) for any new database you create or database upgraded to this release since the CPUApr2008 patch was applied.

Want to read more..Note:461082.1
Re: 10g upgrade questions [message #339838 is a reply to message #339835] Fri, 08 August 2008 16:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Since you are doing a manual upgrade, you should also read over Note: 316889.1 that reiterates running the catcpu.sql after upgrade.
Re: 10g upgrade questions [message #339886 is a reply to message #339825] Sat, 09 August 2008 07:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>>I would recommend DBUA it takes away any heart ache from the >>manual process.

Even Oracle Corp. also recommended to DBUA. but it is always best to use MANUAL UPGRADE procedure becuase we have full control on upgrade what is going on.


Re: 10g upgrade questions [message #340125 is a reply to message #339818] Mon, 11 August 2008 09:43 Go to previous message
dba.admin2008
Messages: 9
Registered: January 2008
Junior Member
thanks all...

My upgrade was successfull...
i did a manual upgrade... CPU also applied..
so far it looks good...
Previous Topic: database creattion error
Next Topic: Table size doen not reduce
Goto Forum:
  


Current Time: Tue Dec 06 06:47:32 CST 2016

Total time taken to generate the page: 0.06012 seconds