filewatcher
Linux Shell下面的文件观察家：# until [ -f f.png ]; do sleep 1 ;done ;echo "File exists"
filewatcher在64上一定要libpam链接：
REDHAT 6默认的样子:
# cd /lib64/
# ls -l *libpam*
lrwxrwxrwx. 1 root root 177月 17 04:41 libpamc.so.0 -> libpamc.so.0.82.1
-rwxr-xr-x. 1 root root 116807月 10 2017 libpamc.so.0.82.1
lrwxrwxrwx. 1 root root 217月 17 04:41 libpam_misc.so.0 -> libpam_misc.so.0.82.0
-rwxr-xr-x. 1 root root 137607月 10 2017 libpam_misc.so.0.82.0
lrwxrwxrwx. 1 root root 167月 17 04:41 libpam.so.0 -> libpam.so.0.82.2
-rwxr-xr-x. 1 root root 552807月 10 2017 libpam.so.0.82.2
一定要做：
# ln -s libpam.so.0.82.2 libpam.so
请注意观察默认有一个不起动的file watcher作业的总的“代表”:
靠上面这张图中的file_watcher_schedule基于时间来观察，我们做实验就把这个间隔10分钟改为2分钟。
begin
dbms_scheduler.create_file_watcher(
file_watcher_name => 'filewatcher1',
directory_path => '/home/oracle/myfile',
file_name => 'botang*.txt',
credential_name => 'credential1');
end;
select* from dba_scheduler_file_watchers;
grant execute on filewatcher1 to hr;
grant execute on SYS.SCHEDULER_FILEWATCHER_RESULT to hr;
grant create external job to hr;
grant create job to hr;
create table hr.tfilewatcher1 ( avarchar2(200)) ;
create or replace procedure hr.procfilewatcher ( p_1 SYS.SCHEDULER_FILEWATCHER_RESULT)
is
begin
insert into hr.tfilewatcher1values ( to_char( p_1.file_timestamp,'YYYY-MM-DD:HH24:MI:SS') ||' '
||p_1.directory_path||' '
||p_1.actual_file_name||' '
||p_1.file_size) ;
commit;
end;
begin
dbms_scheduler.create_program(
program_name => 'HR.program10',
program_type => 'STORED_PROCEDURE',
program_action => 'HR.procfilewatcher',
number_of_arguments => 1,
enabled => false);
end;
begin
dbms_scheduler.define_metadata_argument(
program_name => 'HR.program10',
metadata_attribute => 'event_message',argument_position => 1 ) ;
end;
begin
dbms_scheduler.enable('HR.program10');
end;
当定义了第一个file watcher之后，默认的file watcher“代表”活了：
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
jOB_NAME=> 'hr.job10',
PROGRAM_NAME=> 'hr.program10',
EVENT_CONDITION => 'tab.user_data.file_size > 10',
QUEUE_SPEC=> 'filewatcher1',
AUTO_DROP=> FALSE,
ENABLED=> true);
END;
使能并行文件到达观察，不要错过文件：
begin
dbms_scheduler.set_attribute('hr.job10','parallel_instances',true);
end;
select* from hr.tfilewatcher1;
A
12018-08-04:08:11:24 /home/oracle/myfile botang1.txt 11
22018-08-04:08:17:17 /home/oracle/myfile botang3.txt 551920
32018-08-04:08:17:42 /home/oracle/myfile botang1.txt 22
-------------------------------------------远程外部作业
12c这一头：
alter system set dispatchers='(PROTOCOL=TCP) (dispatchers=6)';
alter system set shared_servers=6;
select* from dba_usersorder by 1;
USERNAMEUSER_IDPASSWORDACCOUNT_STATUSLOCK_DATEEXPIRY_DATEDEFAULT_TABLESPACETEMPORARY_TABLESPACECREATEDPROFILEINITIAL_RSRC_CONSUMER_GROUPEXTERNAL_NAMEPASSWORD_VERSIONSEDITIONS_ENABLEDAUTHENTICATION_TYPEPROXY_ONLY_CONNECTCOMMONLAST_LOGINORACLE_MAINTAINED
1ANONYMOUS51 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMSYSAUXTEMP7/7/2014 5:53:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G NPASSWORDNYES Y
2APEX_04020098 EXPIRED & LOCKED7/7/2014 6:31:11 AM7/7/2014 6:31:11 AMSYSAUXTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
3APEX_PUBLIC_USER95 EXPIRED & LOCKED7/7/2014 6:29:17 AM7/7/2014 6:29:17 AMUSERSTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
4APPQOSSYS49 EXPIRED & LOCKED7/7/2014 5:53:07 AM7/7/2014 5:53:07 AMSYSAUXTEMP7/7/2014 5:53:07 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
5AUDSYS7 EXPIRED & LOCKED7/7/2014 5:39:13 AM7/7/2014 5:39:13 AMUSERSTEMP7/7/2014 5:39:13 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
6BI107 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
7CTXSYS73 EXPIRED & LOCKED7/7/2014 6:12:03 AM7/7/2014 6:12:03 AMSYSAUXTEMP7/7/2014 6:11:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
8DBSNMP48 OPEN 1/4/2019 10:26:08 PMSYSAUXTEMP7/7/2014 5:53:06 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES04-AUG-18 04.46.51.000000000 PM +08:00Y
9DIP23 EXPIRED & LOCKED7/7/2014 5:43:05 AM7/7/2014 5:43:05 AMUSERSTEMP7/7/2014 5:43:05 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
10DVF99 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMSYSAUXTEMP7/7/2014 6:51:55 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
11DVSYS1279990 EXPIRED & LOCKED7/7/2014 6:52:07 AM7/7/2014 6:52:07 AMSYSAUXTEMP7/7/2014 6:51:55 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
12FLOWS_FILES94 EXPIRED & LOCKED7/7/2014 6:31:11 AM7/7/2014 6:31:11 AMSYSAUXTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
13GSMADMIN_INTERNAL21 EXPIRED & LOCKED7/7/2014 5:42:58 AM7/7/2014 5:42:58 AMSYSAUXTEMP7/7/2014 5:42:58 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
14GSMCATUSER61 EXPIRED & LOCKED7/7/2014 5:56:36 AM7/7/2014 5:56:36 AMUSERSTEMP7/7/2014 5:56:36 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
15GSMUSER22 EXPIRED & LOCKED7/7/2014 5:42:58 AM7/7/2014 5:42:58 AMUSERSTEMP7/7/2014 5:42:58 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
16HR102 OPEN 1/10/2019 5:50:13 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTGROUP1 10G 11G 12C NPASSWORDNNO04-AUG-18 02.49.16.000000000 PM +08:00N
17IX104 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
18LBACSYS92 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMSYSTEMTEMP7/7/2014 6:29:01 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
19MDDATA85 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMUSERSTEMP7/7/2014 6:20:54 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
20MDSYS79 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
21OE109 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMEXAMPLETEMP7/8/2018 10:05:46 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
22OJVMSYS70 EXPIRED & LOCKED7/7/2014 6:07:27 AM7/7/2014 6:07:27 AMUSERSTEMP7/7/2014 6:07:27 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
23OLAPSYS82 EXPIRED & LOCKED7/7/2014 6:20:30 AM7/7/2014 6:20:30 AMSYSAUXTEMP7/7/2014 6:20:30 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
24OPS$ORACLE111EXTERNALOPEN USERSTEMP7/18/2018 8:30:39 PMDEFAULTDEFAULT_CONSUMER_GROUP NEXTERNALNNO28-JUL-18 11.36.44.000000000 AM +08:00N
25ORACLE_OCM36 EXPIRED & LOCKED7/7/2014 5:44:37 AM7/7/2014 5:44:37 AMUSERSTEMP7/7/2014 5:44:37 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
26ORDDATA76 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
27ORDPLUGINS77 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
28ORDSYS75 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
29OUTLN13 EXPIRED & LOCKED7/7/2014 5:39:15 AM7/7/2014 5:39:15 AMSYSTEMTEMP7/7/2014 5:39:15 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
30PM106 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
31SCOTT110 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:10:54 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
32SH105 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
33SI_INFORMTN_SCHEMA78 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
34SPATIAL_CSW_ADMIN_USR90 EXPIRED & LOCKED7/7/2014 6:25:01 AM7/7/2014 6:25:01 AMUSERSTEMP7/7/2014 6:25:01 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
35SPATIAL_WFS_ADMIN_USR87 EXPIRED & LOCKED7/7/2014 6:24:57 AM7/7/2014 6:24:57 AMUSERSTEMP7/7/2014 6:24:57 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
36SYS0 OPEN 1/17/2019 11:00:04 AMSYSTEMTEMP7/7/2014 5:39:13 AMDEFAULTSYS_GROUP 10G 11G 12C NPASSWORDNYES21-JUL-18 11.00.04.000000000 AM +08:00Y
37SYSBACKUP2147483617 EXPIRED & LOCKED7/7/2014 5:39:13 AM7/7/2014 5:39:13 AMUSERSTEMP7/7/2014 5:39:13 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
38SYSDG2147483618 EXPIRED & LOCKED7/7/2014 5:39:14 AM7/7/2014 5:39:14 AMUSERSTEMP7/7/2014 5:39:14 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
39SYSKM2147483619 EXPIRED & LOCKED7/7/2014 5:39:14 AM7/7/2014 5:39:14 AMUSERSTEMP7/7/2014 5:39:14 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
40SYSTEM8 OPEN 1/4/2019 10:04:24 PMSYSTEMTEMP7/7/2014 5:39:13 AMDEFAULTSYS_GROUP 10G 11G 12C NPASSWORDNYES28-JUL-18 03.11.38.000000000 PM +08:00Y
41USER1112 OPEN 1/14/2019 9:01:20 PMUSERSTEMP7/18/2018 9:01:20 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO28-JUL-18 03.39.15.000000000 PM +08:00N
42USER2113 EXPIRED 7/28/2018 3:22:46 PMUSERSTEMP7/18/2018 9:01:51 PMPROFILE1DEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO28-JUL-18 03.21.46.000000000 PM +08:00N
43WMSYS62 EXPIRED & LOCKED7/7/2014 6:05:43 AM7/7/2014 6:05:43 AMSYSAUXTEMP7/7/2014 6:05:43 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
44XDB50 EXPIRED & LOCKED7/7/2014 5:53:17 AM7/7/2014 5:53:17 AMSYSAUXTEMP7/7/2014 5:53:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
45XS$NULL2147483638 EXPIRED & LOCKED7/7/2014 5:44:03 AM7/7/2014 5:44:03 AMUSERSTEMP7/7/2014 5:44:03 AMDEFAULTDEFAULT_CONSUMER_GROUP 11G NPASSWORDNYES Y
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Aug 4 16:48:21 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @?/rdbms/admin/prvtrsch.plb
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
no rows selected
Package created.
Package body created.
No errors.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
User altered.
User altered.
1 row updated.
Commit complete.
Grant succeeded.
Procedure created.
No errors.
Audit policy altered.
Function created.
Procedure created.
Procedure created.
Procedure created.
Procedure created.
Procedure created.
Procedure created.
No errors.
Procedure created.
No errors.
Procedure created.
No errors.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
Commit complete.
SQL>
select * from dba_users order by 1;
USERNAMEUSER_IDPASSWORDACCOUNT_STATUSLOCK_DATEEXPIRY_DATEDEFAULT_TABLESPACETEMPORARY_TABLESPACECREATEDPROFILEINITIAL_RSRC_CONSUMER_GROUPEXTERNAL_NAMEPASSWORD_VERSIONSEDITIONS_ENABLEDAUTHENTICATION_TYPEPROXY_ONLY_CONNECTCOMMONLAST_LOGINORACLE_MAINTAINED
1ANONYMOUS51 EXPIRED 7/7/2014 6:52:34 AMSYSAUXTEMP7/7/2014 5:53:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G NPASSWORDNYES Y
2APEX_04020098 EXPIRED & LOCKED7/7/2014 6:31:11 AM7/7/2014 6:31:11 AMSYSAUXTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
3APEX_PUBLIC_USER95 EXPIRED & LOCKED7/7/2014 6:29:17 AM7/7/2014 6:29:17 AMUSERSTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
4APPQOSSYS49 EXPIRED & LOCKED7/7/2014 5:53:07 AM7/7/2014 5:53:07 AMSYSAUXTEMP7/7/2014 5:53:07 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
5AUDSYS7 EXPIRED & LOCKED7/7/2014 5:39:13 AM7/7/2014 5:39:13 AMUSERSTEMP7/7/2014 5:39:13 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
6BI107 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
7CTXSYS73 EXPIRED & LOCKED7/7/2014 6:12:03 AM7/7/2014 6:12:03 AMSYSAUXTEMP7/7/2014 6:11:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
8DBSNMP48 OPEN 1/4/2019 10:26:08 PMSYSAUXTEMP7/7/2014 5:53:06 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES04-AUG-18 04.49.51.000000000 PM +08:00Y
9DIP23 EXPIRED & LOCKED7/7/2014 5:43:05 AM7/7/2014 5:43:05 AMUSERSTEMP7/7/2014 5:43:05 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
10DVF99 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMSYSAUXTEMP7/7/2014 6:51:55 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
11DVSYS1279990 EXPIRED & LOCKED7/7/2014 6:52:07 AM7/7/2014 6:52:07 AMSYSAUXTEMP7/7/2014 6:51:55 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
12FLOWS_FILES94 EXPIRED & LOCKED7/7/2014 6:31:11 AM7/7/2014 6:31:11 AMSYSAUXTEMP7/7/2014 6:29:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
13GSMADMIN_INTERNAL21 EXPIRED & LOCKED7/7/2014 5:42:58 AM7/7/2014 5:42:58 AMSYSAUXTEMP7/7/2014 5:42:58 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
14GSMCATUSER61 EXPIRED & LOCKED7/7/2014 5:56:36 AM7/7/2014 5:56:36 AMUSERSTEMP7/7/2014 5:56:36 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
15GSMUSER22 EXPIRED & LOCKED7/7/2014 5:42:58 AM7/7/2014 5:42:58 AMUSERSTEMP7/7/2014 5:42:58 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
16HR102 OPEN 1/10/2019 5:50:13 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTGROUP1 10G 11G 12C NPASSWORDNNO04-AUG-18 02.49.16.000000000 PM +08:00N
17IX104 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
18LBACSYS92 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMSYSTEMTEMP7/7/2014 6:29:01 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
19MDDATA85 EXPIRED & LOCKED7/7/2014 6:52:34 AM7/7/2014 6:52:34 AMUSERSTEMP7/7/2014 6:20:54 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
20MDSYS79 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
21OE109 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMEXAMPLETEMP7/8/2018 10:05:46 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
22OJVMSYS70 EXPIRED & LOCKED7/7/2014 6:07:27 AM7/7/2014 6:07:27 AMUSERSTEMP7/7/2014 6:07:27 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
23OLAPSYS82 EXPIRED & LOCKED7/7/2014 6:20:30 AM7/7/2014 6:20:30 AMSYSAUXTEMP7/7/2014 6:20:30 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
24OPS$ORACLE111EXTERNALOPEN USERSTEMP7/18/2018 8:30:39 PMDEFAULTDEFAULT_CONSUMER_GROUP NEXTERNALNNO28-JUL-18 11.36.44.000000000 AM +08:00N
25ORACLE_OCM36 EXPIRED & LOCKED7/7/2014 5:44:37 AM7/7/2014 5:44:37 AMUSERSTEMP7/7/2014 5:44:37 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
26ORDDATA76 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
27ORDPLUGINS77 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
28ORDSYS75 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
29OUTLN13 EXPIRED & LOCKED7/7/2014 5:39:15 AM7/7/2014 5:39:15 AMSYSTEMTEMP7/7/2014 5:39:15 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
30PM106 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
31REMOTE_SCHEDULER_AGENT115
EXPIRED & LOCKED8/4/2018 4:48:28 PM8/4/2018 4:48:28 PMUSERSTEMP8/4/2018 4:48:28 PMDEFAULTDEFAULT_CONSUMER_GROUP NPASSWORDNNO N
32SCOTT110 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:10:54 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
33SH105 EXPIRED & LOCKED7/8/2018 10:11:03 PM7/8/2018 10:11:03 PMUSERSTEMP7/8/2018 10:04:24 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO N
34SI_INFORMTN_SCHEMA78 EXPIRED & LOCKED7/7/2014 6:12:11 AM7/7/2014 6:12:11 AMSYSAUXTEMP7/7/2014 6:12:11 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
35SPATIAL_CSW_ADMIN_USR90 EXPIRED & LOCKED7/7/2014 6:25:01 AM7/7/2014 6:25:01 AMUSERSTEMP7/7/2014 6:25:01 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
36SPATIAL_WFS_ADMIN_USR87 EXPIRED & LOCKED7/7/2014 6:24:57 AM7/7/2014 6:24:57 AMUSERSTEMP7/7/2014 6:24:57 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
37SYS0 OPEN 1/17/2019 11:00:04 AMSYSTEMTEMP7/7/2014 5:39:13 AMDEFAULTSYS_GROUP 10G 11G 12C NPASSWORDNYES21-JUL-18 11.00.04.000000000 AM +08:00Y
38SYSBACKUP2147483617 EXPIRED & LOCKED7/7/2014 5:39:13 AM7/7/2014 5:39:13 AMUSERSTEMP7/7/2014 5:39:13 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
39SYSDG2147483618 EXPIRED & LOCKED7/7/2014 5:39:14 AM7/7/2014 5:39:14 AMUSERSTEMP7/7/2014 5:39:14 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
40SYSKM2147483619 EXPIRED & LOCKED7/7/2014 5:39:14 AM7/7/2014 5:39:14 AMUSERSTEMP7/7/2014 5:39:14 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
41SYSTEM8 OPEN 1/4/2019 10:04:24 PMSYSTEMTEMP7/7/2014 5:39:13 AMDEFAULTSYS_GROUP 10G 11G 12C NPASSWORDNYES28-JUL-18 03.11.38.000000000 PM +08:00Y
42USER1112 OPEN 1/14/2019 9:01:20 PMUSERSTEMP7/18/2018 9:01:20 PMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO28-JUL-18 03.39.15.000000000 PM +08:00N
43USER2113 EXPIRED 7/28/2018 3:22:46 PMUSERSTEMP7/18/2018 9:01:51 PMPROFILE1DEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNNO28-JUL-18 03.21.46.000000000 PM +08:00N
44WMSYS62 EXPIRED & LOCKED7/7/2014 6:05:43 AM7/7/2014 6:05:43 AMSYSAUXTEMP7/7/2014 6:05:43 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
45XDB50 EXPIRED & LOCKED7/7/2014 5:53:17 AM7/7/2014 5:53:17 AMSYSAUXTEMP7/7/2014 5:53:17 AMDEFAULTDEFAULT_CONSUMER_GROUP 10G 11G 12C NPASSWORDNYES Y
46XS$NULL2147483638 EXPIRED & LOCKED7/7/2014 5:44:03 AM7/7/2014 5:44:03 AMUSERSTEMP7/7/2014 5:44:03 AMDEFAULTDEFAULT_CONSUMER_GROUP 11G NPASSWORDNYES Y
$ netstat -lntp | grep :8888
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
BEGIN
DBMS_XDB.SETHTTPPORT(8888);
END;
$ netstat -lntp | grep :8888
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::8888 :::* LISTEN 22259/tnslsnr
SELECT DBMS_XDB.GETHTTPPORT() FROM DUAL;
BEGIN
DBMS_SCHEDULER.SET_AGENT_REGISTRATION_PASS('mypassword');
END;
远程这一头：
-客户机器安装client中的定制---scheduleragent组件（一般填客户机主机名，端口1500）
->
->
->
客户机需要用schagent -registerdatabase 192.168.0.90 8888
$ ./schagent-registerdatabase192.168.0.908888
Agent Registration Password ? ***********
Oracle Scheduler Agent Registration for 12.1 Agent
Agent Registration Successful!
$ ./schagent -start
Scheduler agent started
在12c这一头：
--服务器验证：
DECLARE
versionnum VARCHAR2(30);
BEGIN
versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('station86');
DBMS_OUTPUT.PUT_LINE(versionnum);
END;12.1.0.1.1
select* from dba_scheduler_external_dests;
OWNERDESTINATION_NAMEHOSTNAMEPORTIP_ADDRESSENABLEDCOMMENTS
1SYSSTATION86station86.example.com1025192.168.0.86TRUERegistered on 04-AUG-18 05.08.44.539215 PM PRC
grant all on station86 to hr;
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"HR"."JOB11"',
job_type => 'EXECUTABLE',
job_action => '/home/oracle/helloworld.sh',
repeat_interval => 'FREQ=SECONDLY;INTERVAL=30',
start_date => systimestamp at time zone 'Asia/Shanghai',
end_date => to_timestamp_tz('2018-08-04 17:30:00 Asia/Shanghai', 'YYYY-MM-DD HH24:MI:SS TZR'),
job_class => '"DEFAULT_JOB_CLASS"',
comments => 'job11',
auto_drop => TRUE,
enabled => FALSE);
DBMS_SCHEDULER.SET_ATTRIBUTE(name => '"HR"."JOB11"', attribute => 'destination', value => 'station86' );
DBMS_SCHEDULER.SET_ATTRIBUTE(name => '"HR"."JOB11"', attribute => 'credential_name', value => '"SYS"."CREDENTIAL1"' );
sys.dbms_scheduler.enable( '"HR"."JOB11"' );
END;
在windows上外部作业（包含远程外部作业）容易报以下错误：
Host Credentials报错"Connection to host as user oracle failed: ERROR: Wrong password for user"的解决一例
我成功安装了Oracle 10g，可以登录到企业管理器，但无法执行一些操作，如数据库的备份调度，
执行恢复等，由于操作系统登录全权证书的问题。我被要求提供操作系统登录凭证才可以执行这些操作。
我在Host Credentials那里输入的是用户administrator,并且administrator已经加入到了ORA_DBA组
但执行操作是报错如下：
Error: Connection to host as user oracle failed:
ERROR: Wrong password for user
如何解决这个问题呢？
我查阅了Oracle的官方文档，发现如下解决办法：
1. 打开组策略,用gpedit.msc命令。
2. 逐步找到compute configuration -- windows setting -- security setting -- local policy
-- user rights assignment -- log on as a batch job
3.双击"log on as a batch job"，在这里加入你需要的操作系统user
4.再次在OEM的Host Credentials输入那些user和password，一切ok。
页:
[1]