Показаны сообщения с ярлыком Oracle Scheduler. Показать все сообщения
Показаны сообщения с ярлыком Oracle Scheduler. Показать все сообщения
,

Register scheduler agent

четверг, 22 октября 2015 г. 0 коммент.

I have error:


D:\oracle\client112040\BIN>schagent -registerdatabase dwh.prod.local 8080
Agent Registration Password ? ***********

ERROR: Connecting to: http://dwh.prod.local:8080/remote_scheduler_agent/register_agent. java.io.IOException: Server returned HTTP response code: 401 for URL: http://dwh.prod.local:8080/remote_scheduler_agent/register_agent2

Cause:
Agent DAD is not installed.


Action:
Run the script prvtrsch.plb with following command:



SQL> @?/rdbms/admin/prvtrsch.plb


Set a registration password for the Scheduler agents using the SET_AGENT_REGISTRATION_PASS procedure.


The following example sets the agent registration password to mypassword.



BEGIN
DBMS_SCHEDULER.SET_AGENT_REGISTRATION_PASS('mypassword');
END;


D:\oracle\client112040\BIN>schagent -registerdatabase dwh.prod.local 8080
Agent Registration Password ? ***********

Oracle Scheduler Agent Registration for 11.2 Agent
Agent Registration Successful!

D:\oracle\client112040\BIN>

<\br>
Читать полностью

,

Error during launch external job

пятница, 2 октября 2015 г. 0 коммент.

I got the error:

EXTERNAL_LOG_ID="job_173118_9",
USERNAME="DB_HOST\user_agent",
STANDARD_ERROR="Launching external job failed: Invalid username or password"

Cause: On Windows, the host user that runs the external executable must be assigned the Log on as a batch job logon right.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse002.htm#ADMIN12397


Action:  In the Control Panel, open Administrative Tools, then Local Security Policy.  Beneath Security Settings, open Local Policies and highlight User Rights Assignment.  Locate Log on as a batch job. Open the properties and add any users that need this right.  When finished, save your changes and close the Local Security Settings window.

Читать полностью

, ,

Error During Remove Agent Service

среда, 12 марта 2014 г. 0 коммент.

I got an error:OpenService failed - The specified service does not exist as an installed service.


C:\app\product\11.2.0\client_2\bin>schagent.exe -registerdatabase dbag 8080
Agent Registration Password ? *******************
*
Oracle Scheduler Agent Registration for 11.2 Agent
Agent Registration Successful!

C:\app\product\11.2.0\client_2\bin>schagent.exe -unregisterdatabase dbag 8080

1] dbag

Enter the number of the database being unregistered or 0 to cancel:
1
Oracle Scheduler Agent Unregistration for 11.1 Agent
Agent Unregistration Failed!
Error: ORA-27452: 192 is an invalid name for a database object.

C:\app\product\11.2.0\client_2\bin>schagent.exe -unregisterdatabase dbag 8080
No registered database v11.2 or higher to be unregistered.

C:\app\product\11.2.0\client_2\bin>schagent.exe -removeagentservice
OpenService failed - The specified service does not exist as an installed service. (0x424)


SQL> select * from all_scheduler_external_dests;

DESTINATION_NAME HOSTNAME PORT IP_ADDRESS ENABLED COMMENTS
----------------- ---------------- ------ ---------------- ------- ---------------------------------------------------------
AGENT_1 192.168.100.102 65001 192.168.100.102 TRUE Registered on 30-JAN-14 11.06.31.426000 AM EUROPE/MOSCOW

SQL>

begin
dbms_scheduler.drop_agent_destination(destination_name => 'AGENT_1');
end;

SQL>

Remove windows service:


C:\app\product\11.2.0\client_2\bin>sc delete OraClient11g_home2_OracleSchedulerExecutionAgent
[SC] DeleteService SUCCESS
Читать полностью

,

How to know the password for the scheduler credential

вторник, 11 марта 2014 г. 0 коммент.

Use function dbms_isched.get_credential_password:


SQL>
SQL> begin
2 dbms_scheduler.create_credential(credential_name => 'credential4test',
3 username => 'user4test',
4 password => 'pass4test');
5 end;
6 /

PL/SQL procedure successfully completed

SQL>
SQL> select user$.name as credential_owner,
2 obj$.name as credential_name,
3 scheduler$_credential.username,
4 scheduler$_credential.password,
5 dbms_isched.get_credential_password(obj$.name, user$.name) enc_password
6 from scheduler$_credential,
7 obj$,
8 user$
9 where user$.user# = obj$.owner# and
10 scheduler$_credential.obj# = obj$.obj#;

CREDENTIAL_OWNER CREDENTIAL_NAME USERNAME PASSWORD ENC_PASSWORD
------------------ ---------------- ------------ --------------------------------------- --------------
SYS CREDENTIAL4TEST user4test BUG19SWE76fBKqdqgKsZu/fTpM8wOfSQXg== pass4test

SQL>
Читать полностью