OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » DBMS SCHEDULER (Oracle DB 11gR2 RHEL 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS SCHEDULER [message #632698]

Wed, 04 February 2015 11:40

smunir362
Messages: 306
Registered: September 2007

Senior Member

Hi,
I was running rman (shell scripts) jobs using DBMS_SCHEDULER. Now I change sys and oracle user(OS) password. Now jobs are failed.
Complaining invalid username password. Where I have to change to solve this issue...

Report message to a moderator

Re: DBMS SCHEDULER [message #632699 is a reply to message #632698]

Wed, 04 February 2015 11:44

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

You'll need to re-create your credentials, see dbms_scheduler.create_credential.

Report message to a moderator

Re: DBMS SCHEDULER [message #632702 is a reply to message #632699]

Wed, 04 February 2015 12:38

smunir362
Messages: 306
Registered: September 2007

Senior Member

ok
You mean credential OS oracle user/password....
But I was also using user=sys pass=abc123 as an argument for backup jobs....
What about that

Report message to a moderator

Re: DBMS SCHEDULER [message #632703 is a reply to message #632702]

Wed, 04 February 2015 12:44

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

You don't understand Scheduler credentials at all, do you? Better read up on them. I've already pointed you towards one of the relevant procedures.

Report message to a moderator

Re: DBMS SCHEDULER [message #632706 is a reply to message #632703]

Wed, 04 February 2015 12:59

smunir362
Messages: 306
Registered: September 2007

Senior Member

Sir,
I understand it. I explain it
I create credential using dbms_scheduler.
I create job rman using dbms_scheduler and pass sys/abc123 as argument to this jtob.
I create rman shell script and put $/$2 instead of hardcoding user/password.....This setup was running fine.

Now I change OS user passwor and sys password due to policy requirement..After this my jobs were fail.
I update credential using dbms_scheduler and also update job argument but my jobs still failed...
How to investigate/solve this problem..

Report message to a moderator

Re: DBMS SCHEDULER [message #632711 is a reply to message #632706]

Wed, 04 February 2015 13:29

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

You haven't read up on credentials at all, have you? There is plenty of information in the Administrator's Guide. Then you need to look at dba_scheduler_jobs to see what credential is being used and dba_scheduler_credentials to see what credentials exist. Then you need to drop and re-create the credentials with the new password. You might also want to show the code you are running.

But I've had enough for today. Goodbye.

Report message to a moderator

Previous Topic:	RMAN restoring archivelogs before given PIT
Next Topic:	how to migrate data from database A to database B

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 21 13:30:39 CDT 2023