课程第43/44次（2017-10-14星期六上下午）

botang

cloud control安装完的端口总结：


job1准备：

1. select   * from v$version;
   
2. select * from dba_sys_privs sp where sp.GRANTEE='HR';
   
3. grant create job to hr;
   
4. select * from dba_sys_privs sp where sp.GRANTEE='HR';
   
5. alter user hr identified by oracle_4U account unlock;

复制代码

job1的program1：


job1的schedule1：


job1的状态：


job2是一个操作系统的外部作业：

job2的准备：

1. grant create external job to hr;
   
2. select * from dba_sys_privs sp where sp.GRANTEE='HR';
   
3. select  * from dba_scheduler_credentials;
   
4. begin
   
5. dbms_scheduler.create_credential('CRED1','oracle','oracle');
   
6. end;
   
7. select  * from dba_scheduler_credentials;
   
8. select  * from dba_tab_privs tp where tp.GRANTEE='HR';
   
9. grant execute on sys.cred1 to hr;
   
10. select  * from dba_tab_privs tp where tp.GRANTEE='HR';

复制代码

shell程序文本：

1. #!/bin/sh
   
2. 
   
3. export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2
   
4. export ORACLE_SID=orcl
   
5. export ORACLE_BASE=/u01/app/oracle
   
6. 
   
7. /u01/app/oracle/product/12.1.0/dbhome_2/bin/sqlplus /nolog >> /home/oracle/job2a.log <<EOF
   
8. conn hr/oracle_4U
   
9. alter session set nls_date_format='yyyy-mm-dd:hh24:mi:ss';
   
10. select  sysdate from dual;
    
11. exit
    
12. EOF
    
13. 
    
14. date +%Y%m%d-%H%M%S >> /home/oracle/job2b.log

复制代码