Hi all,
we are running Oracle 19 EE on a Windows Server 2019 und want to use Oracle-Scheduler for external Jobs in a multitenant environment with one CDB and one PDB.
We have configured (on CDB) :
XDB
dispatcheers/shared_server_sessions/job_queu_processes ...
scheduler-timezone
agent registration-password
http/ftp-ports
<ORACLE_HOME>\scheduler\execution_agent\schagent.conf
At the step :
schagent -registerdatabase <Host-Name> <Port>
we get the Exception :
--------------------------------------------------
Warning:
The JKS keystore uses a proprietary format. It is recommended to migrate to PKCS12 which is an industry standard format using "keytool -importkeystore -srckeystore <ORACLE_HOME>\scheduler\execution_agent\data\wallet\agent.key -destkeystore <ORACLE_HOME>\scheduler\execution_agent\data\wallet\agent.key -deststoretype pkcs12".
Agent Registration Password ? *XXXXX*
*
Oracle Scheduler Agent Registration for 19.15.0.0.0 Agent
Agent Registration Failed!
Error: ORA-29283: invalid file operation while registerdatabase
The data is invalid.
--------------------------------------------------
We do not find any other hints what may be the cause of that problem.
The message above is also written to <ORACLE_HOME>\scheduler\execution_agent\data\agent.log
The error lets assume a read/write problem in the operating system, but the user calling the statement has admin privileges.
Following :
https://community.oracle.com/tech/apps-infra/discussion/943308/error-ora-29283-invalid-file-operation-while-registerdatabase
we found that we had no directory SCHEDULER$_WALLET_DIR yet (which is also missing on our UNIX environments where using Oracle-Scheduler with external jobs has no problem).
After creating a directory for a test with :
create or replace directory SCHEDULER$_WALLET_DIR as <ORACLE_HOME>\scheduler\WALLET';
the error message changes to :
--------------------------------------------------
Agent Registration Failed!
Error: ORA-28759: failure to open file
--------------------------------------------------
When "schagent -registerdatabase <Host-Name> <Port>" is called and raises the exception the
directory <ORACLE_HOME>\scheduler\WALLET\1 is created with the file ewallet.p12
and in <ORACLE_HOME>\scheduler\execution_agent\data\wallet the files
agent.key, authdbs.dat, authdbs.lock, keystore.bin
are created.
We suspect something may be wrong with their privileges ....
Does anyone has a suggestion ?