Home » RDBMS Server » Backup & Recovery » DBMS SCHEDULER (Oracle DB 11gR2 RHEL 5.5)
DBMS SCHEDULER [message #632698] Wed, 04 February 2015 11:40 Go to next message
smunir362
Messages: 305
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...
Re: DBMS SCHEDULER [message #632699 is a reply to message #632698] Wed, 04 February 2015 11:44 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
You'll need to re-create your credentials, see dbms_scheduler.create_credential.
Re: DBMS SCHEDULER [message #632702 is a reply to message #632699] Wed, 04 February 2015 12:38 Go to previous messageGo to next message
smunir362
Messages: 305
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
Re: DBMS SCHEDULER [message #632703 is a reply to message #632702] Wed, 04 February 2015 12:44 Go to previous messageGo to next message
John Watson
Messages: 7619
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.
Re: DBMS SCHEDULER [message #632706 is a reply to message #632703] Wed, 04 February 2015 12:59 Go to previous messageGo to next message
smunir362
Messages: 305
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..
Re: DBMS SCHEDULER [message #632711 is a reply to message #632706] Wed, 04 February 2015 13:29 Go to previous message
John Watson
Messages: 7619
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.
Previous Topic: RMAN restoring archivelogs before given PIT
Next Topic: how to migrate data from database A to database B
Goto Forum:
  


Current Time: Fri Oct 19 16:34:35 CDT 2018