Home » RDBMS Server » Server Administration » Migrate Job Library to a New Server?
icon9.gif  Migrate Job Library to a New Server? [message #281635] Sun, 18 November 2007 21:59 Go to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Hi all..

1st of all, I really don't know where should I put this topic coz it seems everything is related all at once.

Currently I am using Oracle Management Server (OMS) to submit my data loading job which resides in the OEM Job Library. The OMS & Database is on the same server, same instance - Oracle 9i. The Job involved some OWB background scripts.

And now we want to migrate to a new server - database Oracle 10g. But the OMS is under another instance on the same server.

Last time, after the DBA migrated all the schema.. I got the error as in the attached file.

So, my question is...
1. What does the error actually means? How could the job reinsert the same value again when submitting the job?
2. Is it OK to copy all the jobs just like that? In other words, the Job Library will only refer to the value inside the relevant tables


Thank you very much.
  • Attachment: oms01.bmp
    (Size: 696.15KB, Downloaded 152 times)
Re: Migrate Job Library to a New Server? [message #281638 is a reply to message #281635] Sun, 18 November 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORA-00001:	unique constraint (string.string) violated
Cause:	An UPDATE or INSERT statement attempted to insert a 
duplicate key. For Trusted Oracle configured in DBMS MAC mode, you
may see this message if a duplicate entry exists at a different 
level.
Action:	Either remove the unique restriction or do not insert the key.

[Updated on: Sun, 18 November 2007 22:19]

Report message to a moderator

Re: Migrate Job Library to a New Server? [message #281650 is a reply to message #281638] Sun, 18 November 2007 22:57 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Arju wrote on Mon, 19 November 2007 12:19

ORA-00001:	unique constraint (string.string) violated
Cause:	An UPDATE or INSERT statement attempted to insert a 
duplicate key. For Trusted Oracle configured in DBMS MAC mode, you
may see this message if a duplicate entry exists at a different 
level.
Action:	Either remove the unique restriction or do not insert the key.


thanks..

but that's the problem.. how could i resolve the problem?? coz i don't know which entry that caused it..

and by logic, it shouldn't hsppen coz i am submitting a new job to ther server..

[Updated on: Sun, 18 November 2007 22:58]

Report message to a moderator

icon9.gif  Re: Migrate Job Library to a New Server? [message #281893 is a reply to message #281635] Mon, 19 November 2007 18:43 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
I'm wondering why is that this topic disappear from the main page?? Shocked

Is there anything wrong? Confused
Re: Migrate Job Library to a New Server? [message #281894 is a reply to message #281635] Mon, 19 November 2007 19:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I'm wondering why is that this topic disappear from the main page??
If it did in fact disappear, how & where did you find it to post this follow up question?
Re: Migrate Job Library to a New Server? [message #281897 is a reply to message #281894] Mon, 19 November 2007 21:17 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
anacedent wrote on Tue, 20 November 2007 09:17

>I'm wondering why is that this topic disappear from the main page??
If it did in fact disappear, how & where did you find it to post this follow up question?


By following the link that I've got in my e-mail - Reply Notification..

I'm not sure what have gone wrong but this is not the 1st time I noticed my topic is not listed in the 1st page of the board though my topic is still new and has the latest reply.

Anyway ana, don't you want to say something about my problem?

I've no more idea what to do.. I've tried importing some values from this 15 tables from the old database.. But still to no avail. Sad

SMP_VDJ_JOB_LOG_COMMENT
SMP_VDJ_JOB_LOG_INTERMED
SMP_VDJ_JOB_PER_TARGET
SMP_VDJ_JOB_TARGET
EPC_CLI_JOB
SMP_VDJ_JOB_LOG
SMP_VIEW_AGENT_JOBS
SMP_VDJ_JOB
SMP_VIEW_JOBS
SMP_VIEW_JOB_EXECUTIONS
SMP_VIEW_JOB_HISTORY
SMP_VIEW_JOB_LIBRARY
SMP_VIEW_JOB_NOTIFICATIONS
SMP_VIEW_JOB_STATUS
SMP_VIEW_VDJ_PRIV_JOB
Re: Migrate Job Library to a New Server? [message #281900 is a reply to message #281635] Mon, 19 November 2007 21:52 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please step back & try to view what you've posted from MY perspective.

You say you have a problem which I accept as a true statement.

I have no idea EXACTLY what you are doing when you get the error.
I have no idea what fields or indexes are exists for either table
I have no idea what data exists in either the source or destination tables.

You are getting a UNIQUE INDEX violation; it so appears.

The solution is to NOT INSERT duplicate key values into the table.
Re: Migrate Job Library to a New Server? [message #282480 is a reply to message #281900] Thu, 22 November 2007 02:14 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
anacedent wrote on Tue, 20 November 2007 11:52

Please step back & try to view what you've posted from MY perspective.

You say you have a problem which I accept as a true statement.

I have no idea EXACTLY what you are doing when you get the error.
I have no idea what fields or indexes are exists for either table
I have no idea what data exists in either the source or destination tables.

You are getting a UNIQUE INDEX violation; it so appears.

The solution is to NOT INSERT duplicate key values into the table.

but the problem is.. the violated constraint is the system generated value inside the ORACLE package..

Again, I want to know whether the Job Library can be simply copied from one database to another just like that?

This is because I have no idea on how to create the Job Library from scratch.

The application is being developed by a vendor and now they are no longer supporting the system.

By right I should only maintain the application as is. But recently, there is a request to migrate the current system to a new server.

So, that's why I'm asking what should I do to copy all the jobs.

Thank you.
Re: Migrate Job Library to a New Server? [message #282984 is a reply to message #281635] Sun, 25 November 2007 21:16 Go to previous message
aimy
Messages: 209
Registered: June 2006
Senior Member
Now I've tried creating the job from scratch by following exactly the parameter as shown in the screenshot below:

http://www.hotlinkfiles.com/files/673500_tfqz9/OLDJOB.gif

As I've finished, when I want to add it to the Job Library (new server), the following error occured:

http://www.hotlinkfiles.com/files/673505_nagrc/capture_26.11.2007_10-56-21.gif

The content of the table SMP_VDJ_JOB on the new server is as follows:

http://www.hotlinkfiles.com/files/673512_7xzjm/capture_26.11.2007_10-55-41.gif

And finally the script (which I could hardly understand) for the PARAMETERS part is as found in the attachment.

So, can somebody please help me identify the cause of this problem.. Sad

Thank you so much for cooperation.
  • Attachment: VOIP.sql
    (Size: 10.96KB, Downloaded 327 times)

[Updated on: Sun, 25 November 2007 21:19]

Report message to a moderator

Previous Topic: Problem relating NLS parameter setting[Topic:Merged]
Next Topic: Shrink Tablespace
Goto Forum:
  


Current Time: Fri Dec 09 21:43:51 CST 2016

Total time taken to generate the page: 0.08283 seconds