首页 文章

Win 2008 Server上的Oracle Remote Scheduler Agent 11.2.0.1

提问于
浏览
0

好的,这是一个奇怪的 . 只将远程调度程序代理(11.2.0.1)安装到Win2008服务器上,将其注册到数据库,测试了一个只运行一个简单的DOS .bat文件的远程作业,该文件只执行“嘿我跑”到本地文件 . 一切都很好 . 反复测试它 - 一切都很好 .

在同一服务器上添加了Oracle 11.2.0.1客户端的安装,以便我的远程作业可以回调数据库,并且现在调度代理程序不会运行任何DOS命令 - 它在启动cmd.exe时失败,并且始终返回错误号255 .

来自DB的工作(与工作时相同):

BEGIN
  DBMS_SCHEDULER.create_job(
    job_name             => 'test_win_job2',
    job_type             => 'EXECUTABLE',
    number_of_arguments  => 2,
    job_action           => 'C:\Windows\System32\cmd.exe',
    auto_drop            => TRUE,
    enabled              => FALSE);
  DBMS_SCHEDULER.set_job_argument_value('test_win_job2',1,'/c');
  DBMS_SCHEDULER.set_job_argument_value('test_win_job2',2,'c:\oracleagent\test_script.bat');
--
  DBMS_SCHEDULER.set_attribute('test_win_job2', 'credential_name', 'NEW_WIN_CREDENTIAL');
  DBMS_SCHEDULER.set_attribute('test_win_job2', 'destination', '142.00.00.26:9000');
  DBMS_SCHEDULER.enable('test_win_job2');
END;
/

摘自Win框中的agent.log文件:

2016.07.13 12:52:28 CDT Received connection from 142.53.204.216:45907
2016.07.13 12:52:28 CDT Using existing spare worker thread
2016.07.13 12:52:28 CDT Thread: 12 Assigned connection to 142.53.204.216:45907
2016.07.13 12:52:28 CDT Thread: 12 Incremented connections to 1
2016.07.13 12:52:28 CDT Thread: 12 Ignoring header: Host Value: 142.53.57.26:8090
2016.07.13 12:52:28 CDT Thread: 12 Received: Source Value: p7214.some.agency.ca
2016.07.13 12:52:28 CDT Thread: 12 Received: Source-DB Value: CGNSDEV
2016.07.13 12:52:28 CDT Thread: 12 Received: Date Value:  2016-07-13 13:52:39.165595000America/Toronto EDT
2016.07.13 12:52:28 CDT Thread: 12 Received: Source-Port Value: 8085
2016.07.13 12:52:28 CDT Thread: 12 Received: Nonce Value: OEY7pLrMFbK/hT+evALZsw==
2016.07.13 12:52:28 CDT Thread: 12 Received: Mac Value: 1M8roBa3lRobQGpb7mLL3V+aPvU=
2016.07.13 12:52:28 CDT Thread: 12 Received: Action Value: RUN
2016.07.13 12:52:28 CDT Thread: 12 Received: Command Value: C:\Windows\System32\cmd.exe
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Id Value: 326021
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Name Value: TEST_WIN_JOB2
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Subname Value: 
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Owner Value: JOBMGMT_APP_CODE
2016.07.13 12:52:28 CDT Thread: 12 Received: Username Value: wasadmin
2016.07.13 12:52:28 CDT Thread: 12 Received: Password Value: *
2016.07.13 12:52:28 CDT Thread: 12 Received: Domain Value: 
2016.07.13 12:52:28 CDT Thread: 12 Received: Request-Id Value: 2797301621
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Start Value:  2016-07-13 13:52:38.946324000America/New_York EDT
2016.07.13 12:52:28 CDT Thread: 12 Received: Job-Scheduled-Start Value:  2016-07-13 13:52:38.853560000America/New_York EDT
2016.07.13 12:52:28 CDT Thread: 12 Received: Credential-Owner Value: JOBMGMT_APP_CODE
2016.07.13 12:52:28 CDT Thread: 12 Received: Credential-Name Value: NEW_WIN_CREDENTIAL
2016.07.13 12:52:28 CDT Thread: 12 Ignoring header: Log-ID Value: 81795
2016.07.13 12:52:28 CDT Thread: 12 Received: Argument1 Value: /c
2016.07.13 12:52:28 CDT Thread: 12 Received: Argument2 Value: c:\oracleagent\test_script.bat
2016.07.13 12:52:28 CDT Thread: 12 Ignoring header: Connection Value: close
2016.07.13 12:52:28 CDT Thread: 12 Database authentication check passed
2016.07.13 12:52:28 CDT Thread: 12 Decremented connections to 0
2016.07.13 12:52:28 CDT Thread: 12 Incremented running jobs to 1
2016.07.13 12:52:28 CDT Thread: 12 Log ID: job_326021_18 Name: JOBMGMT_APP_CODE.TEST_WIN_JOB2 Source: p7214.ic.gc.ca : 8085 Source DB: CGNSDEV Command: C:\Windows\System32\cmd.exe
2016.07.13 12:52:28 CDT Thread: 12 Argument 1 : /c
2016.07.13 12:52:28 CDT Thread: 12 Argument 2 : c:\oracleagent\test_script.bat
2016.07.13 12:52:28 CDT Thread: 12 Passed SystemDrive=C:
2016.07.13 12:52:28 CDT Thread: 12 Passed SystemRoot=C:\Windows
2016.07.13 12:52:28 CDT Thread: 12 Passed Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\ibm\gsk8\lib64;C:\Program Files (x86)\ibm\gsk8\lib;C:\IBM\DB2\BIN;C:\IBM\DB2\FUNCTION;C:\IBM\DB2\SAMPLES\REPL;C:\app\oracle\product\11.2.0\client\bin
2016.07.13 12:52:28 CDT Thread: 12 Passed ComSpec=C:\Windows\system32\cmd.exe
2016.07.13 12:52:28 CDT Thread: 12 Passed OS=Windows_NT
2016.07.13 12:52:30 CDT Thread: 12 Job terminated with error number: 255. Duration: 1.435 seconds
2016.07.13 12:52:30 CDT Thread: 12 Results: job_owner=JOBMGMT_APP_CODE&job_name=TEST_WIN_JOB2&job_subname=&start_date=1468432348896&run_duration=1435&cpu_used=&error_number=255&error_text=&output_text=&request_id=2797301621&add_info=EXTERNAL_LOG_ID%3D%22job_326021_18%22%2C%0AUSERNAME%3D%22wasadmin%22&submit=Submit
2016.07.13 12:52:30 CDT Thread: 12 Returning job results to :http://p7214.ic.some.agency:8085/remote_scheduler_agent/submit_job_results2
2016.07.13 12:52:30 CDT Thread: 12 Connected to :p7214.some.agency.ca
2016.07.13 12:52:30 CDT Thread: 12 Sent data to submit_job_results :p7214.some.agency.ca
2016.07.13 12:52:30 CDT Thread: 12 Received: Oracle Scheduler Remote Job Run Completion
2016.07.13 12:52:30 CDT Thread: 12 Received: Job Run Completion Successful!
2016.07.13 12:52:30 CDT Thread: 12 Decremented running jobs to 0
2016.07.13 12:52:30 CDT Thread: 12 Adding thread to spareThreads

如果我检查Windows事件日志,我看到:

jssu.exe
            0.0.0.0
            4bb1e0d1
            ntdll.dll
            6.1.7601.17725
            4ec4aa8e
            c0000374
            00000000000c40f2
            39c
            01d1dd2f52920e10
            C:\app\oracle\product\11.2.0\client\bin\jssu.exe
            C:\Windows\SYSTEM32\ntdll.dll
            90ff6867-4922-11e6-906b-000c29f63d9e

The information attached is:
Fault bucket , type 0
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: jssu.exe
P2: 0.0.0.0
P3: 4bb1e0d1
P4: StackHash_dcf9
P5: 6.1.7601.17725
P6: 4ec4aa8e
P7: c0000374
P8: 00000000000c40f2
P9: 
P10: 

Attached files:

These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_jssu.exe_f02bd96ab90965af7744491b05a8a4b136aedab_1d31148f

Analysis symbol: 
Rechecking for solution: 0
Report Id: ec2e1259-491c-11e6-906b-000c29f63d9e
Report Status: 0

有没有人知道为什么客户端从同一个发行版安装已杀死远程调度程序代理?或者将它们都放在同一台服务器上可能需要什么?我可以查看2008年以外的操作系统选项,但只是想知道是否有人这样远程看过任何东西 .

1 回答

  • 0

    原来这是11.2.0.1可执行文件中的一个错误,从11.2.0.4下载修补jssu.exe解决了它 .

相关问题