远程数据库作业（Oracle世界的ansible）

botang

管理端：

1. grant create job to hr;
   
2. 
   
3. --grant create external job to hr;
   
4. 
   
5. select  * from dba_scheduler_credentials;
   
6. 
   
7. begin
   
8.    dbms_scheduler.create_credential('credential13','HR','oracle_4U');
   
9. end;
   
10. /
    
11. 
    
12. grant execute on  credential13 to hr;
    
13. 
    
14. 
    
15. select * from dba_scheduler_external_dests;
    
16. 
    
17. 
    
18. set serveroutput on
    
19. 
    
20. DECLARE
    
21. versionnum VARCHAR2(30);
    
22. BEGIN
    
23. versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('CLASSROOM');
    
24. DBMS_OUTPUT.PUT_LINE(versionnum);
    
25. END;
    
26. /
    
27. 
    
28. 
    
29. 
    
30. begin
    
31.    dbms_scheduler.create_database_destination(
    
32.    destination_name => 'orcl2',
    
33.    agent => 'CLASSROOM',tns_name => 'orcl2');
    
34. end;
    
35. /
    
36. 
    
37. select * from dba_scheduler_db_dests;
    
38. 
    
39. grant all on orcl2 to  hr;
    
40. 
    
41. 
    
42. BEGIN
    
43. sys.dbms_scheduler.create_job(
    
44. job_name => '"HR"."JOB13"',
    
45. program_name => '"HR"."PROGRAM13"',
    
46. schedule_name => '"HR"."SCHEDULE13"',
    
47. job_class => '"DEFAULT_JOB_CLASS"',
    
48. auto_drop => FALSE,
    
49. enabled => true,
    
50. credential_name =>'SYS.CREDENTIAL13' ,
    
51. destination_name =>'SYS.ORCL2'
    
52. );
    
53. END;
    
54. /
    
55. 
    
56. 
    

复制代码

受控端：

1. [oracle@classroom bin]$ ./schagent  -stop

复制代码

1. [oracle@classroom bin]$ ./schagent  -registerdatabase 192.168.0.254 8888

复制代码

1. [oracle@classroom bin]$ ./schagent  -start

复制代码

1. [oracle@classroom bin]$ netstat -lntp | grep :1025

复制代码