Home » RDBMS Server » Server Administration » Migration of Oracle Jobs (10g Linux)
Migration of Oracle Jobs [message #483441] Mon, 22 November 2010 03:32 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
Recently we are planning to migrate oracle 10g to 11g.
We are migrating PHASEWISE (Schema wise) as this is a 50TB of Production instance.
We are using Oracle Golden gate for this purpose.

Is there is any way that we can migrate oracle jobs from 10g to 11g?

Please advice...

Regards
P

Report message to a moderator

Re: Migration of Oracle Jobs [message #483454 is a reply to message #483441] Mon, 22 November 2010 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
s there is any way that we can migrate oracle jobs from 10g to 11g?

What do you mean by Oracle job?
What do you mean by migrate them?
As far as I know, there is no difference between 10 gand 11g jobs (in the standard meaning of Oracle job object).

Regards
Michel

Report message to a moderator

Re: Migration of Oracle Jobs [message #483471 is a reply to message #483454] Mon, 22 November 2010 06:13 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
The below is my actual situation:-

I have some scheduled jobs running at 10g.
I quired from dba_scheduler_jobs and got the below jobs:-

1. CREATE_AUDIT_TABLE_PARTITION
2. GATHER_STATS_JOB
3. PURGE_LOG

I want to migrate those above jobs from 10g to 11g.

What will be the procedure.

Thanks -
P

Report message to a moderator

Re: Migration of Oracle Jobs [message #483475 is a reply to message #483471] Mon, 22 November 2010 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If they are your cutom jobs, I think there is nothing to do unless you do something specific to 10g version.

Regards
Michel

Report message to a moderator

Re: Migration of Oracle Jobs [message #483485 is a reply to message #483475] Mon, 22 November 2010 07:36 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
thanks for your valuable response.
Is there is any package or utility that I can use to fulfill the requirements?

Thanks-
P

Report message to a moderator

Re: Migration of Oracle Jobs [message #483511 is a reply to message #483485] Mon, 22 November 2010 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is there is any package or utility that I can use to fulfill the requirements?

There is no package to do nothing.

Regards
Michel

Report message to a moderator

Re: Migration of Oracle Jobs [message #483518 is a reply to message #483511] Mon, 22 November 2010 11:15 Go to previous message
cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
If they're your own jobs you should have scripts to create them.
Export and Expdp should export them.
No idea what goldengate does.

Gather_stats_job and purge_log are oracle created jobs that should already be present on the new db (or equivalent jobs).

Report message to a moderator

Previous Topic: Sniped process
Next Topic: Error Creating Database using DBCA Oracle 11 g r2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 08:47:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.