Home » RDBMS Server » Enterprise Manager » Scheduling backup (Oracle, 10i, Windows xp)
Scheduling backup [message #288438] Mon, 17 December 2007 09:55 Go to next message
bert1977
Messages: 4
Registered: December 2007
Junior Member
Hi All,

I am new on Oracle.

I succeed in doing back-up from RMAN but when I try to schedule back up from EM I got this error:

The JOB Submission has Failed for the following reason
ORA-01722: numero non valido ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1636 ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1716 ORA-06512: a line 1

I have given to the OS user the right to submit batch process and I have changed the international settings of OS to use the AM-PM hour and dd/mm/aaaa date

Any Idea??

Thank you very much!!!
Re: Scheduling backup [message #288440 is a reply to message #288438] Mon, 17 December 2007 10:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. What is your OS platform ?

Just guess your running on windows then grant "logon as batch job" privs to OS user.
Re: Scheduling backup [message #288454 is a reply to message #288440] Mon, 17 December 2007 10:53 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
If on Windows!!!

Go to
"Control Panel" ->
"Admin Tools" ->
"Local Security Policy."
Within "Local Policies", go to user "Right Assignment."
Add the user to "Logon as a Batch Job."
Re: Scheduling backup [message #288615 is a reply to message #288454] Tue, 18 December 2007 03:28 Go to previous messageGo to next message
bert1977
Messages: 4
Registered: December 2007
Junior Member
Hi,

thanks for the answer.

The OS is windows xp.

I have alredy grant to the OS user the rights to logon as batch job.... and I have the error!!!

What can I do????

Thank you

Andrea
Re: Scheduling backup [message #288617 is a reply to message #288438] Tue, 18 December 2007 03:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Which error? If you don't tell about the errors to us then I think no one else has the ability to guess which types of problem you are facing.
Re: Scheduling backup [message #288627 is a reply to message #288438] Tue, 18 December 2007 03:47 Go to previous messageGo to next message
bert1977
Messages: 4
Registered: December 2007
Junior Member
Hi,

As I said before I have the following error:

The JOB Submission has Failed for the following reason
ORA-01722: numero non valido ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1636 ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1716 ORA-06512: a line 1


where have I to look to others log??

Thanks,

Andrea
Re: Scheduling backup [message #288766 is a reply to message #288627] Tue, 18 December 2007 11:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.orafaq.com/forum/t/42548/0/
Re: Scheduling backup [message #289032 is a reply to message #288766] Wed, 19 December 2007 05:33 Go to previous messageGo to next message
bert1977
Messages: 4
Registered: December 2007
Junior Member
Thanks for the answer but in the link you send me the error is:

ORA-20204: User does not exist: TEST ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06512: at "SYSMAN.MGMT_JOBS", line 139 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1

in this case seems that the user doesn't exist

In my case the error is:

Sottomissione del job non riuscita per il seguente motivo
ORA-01722: numero non valido ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1636 ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1716 ORA-06512: a line 1

It is strange...I'm quite shure that the problem is in the interaction of the OS but I grant to the OS user the grant to logon as batch job!! What else can I do??

Thank you

Andrea
Re: Scheduling backup [message #289103 is a reply to message #289032] Wed, 19 December 2007 13:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Can you translate it into English??

Sottomissione del job non riuscita per il seguente motivo
ORA-01722: numero non valido ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1636 ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1716 ORA-06512: a line 1

Re: Scheduling backup [message #289125 is a reply to message #289103] Wed, 19 December 2007 16:38 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
Senior Member
DreamzZ wrote on Wed, 19 December 2007 11:15

Can you translate it into English??

Sottomissione del job non riuscita per il seguente motivo
ORA-01722: numero non valido ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1636 ORA-06512: a "SYSMAN.MGMT_CREDENTIAL", line 1716 ORA-06512: a line 1





The JOB Submission has Failed for the following reason
ORA-01722: invalid number
ORA-06512: "SYSMAN.MGMT_CREDENTIAL" at line 1636
ORA-06512: "SYSMAN.MGMT_CREDENTIAL" at line 1716
ORA-06512: at line 1
Re: Scheduling backup [message #289301 is a reply to message #289125] Thu, 20 December 2007 10:50 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check your timezone status.
Or try with no time zone settings!!
Previous Topic: Reschedule job outside of OEM
Next Topic: EM athentication problem in windows os.
Goto Forum:
  


Current Time: Mon Dec 23 07:39:11 CST 2024