Thanks & follow up information
Andy Sims, June 10, 2009 - 11:45 am UTC
Thanks Tom,
The solution you pointed me to works fine, thanks for taking the time to look at my problem. A couple of points for others who may end up looking at this solution:
The Windows service OracleJobSchedulerXE needs to be started.
As system user:
grant create external job to <USERNAME>;
grant create job to <USERNAME>;
Then once logged in as <USERNAME>
dbms_scheduler.create_job(
job_name=>'TEST_OS_EXEC_111',
job_type=>'executable',
job_action=>'C:\WINDOWS\system32\cmd.exe /c D:\20_OS\test1.bat',
enabled=>TRUE
);
Runs the batch file.
Ready to move on to "Standard Edition 1"
Andy Sims, May 27, 2010 - 2:49 pm UTC
Hi Tom, I understand you may delete this if you do not think its relevant! The customer who was using Oracle Express had it installed on a machine with 4 processors (Oracle Express would only use one of these of course). They are now ready to move up to a real licence, the next step being Standard Edition One. However, as far as I can tell, they would not be allowed to install Standard Edition One on this 4 processor machine as it has more than two sockets, have I got this right? To me it makes sense to me that you should be able to upgrade through the Oracle DB product stack without having to change hardware for each upgrade, but this does not seem to be the case. Any thoughts much appreciated.
May 27, 2010 - 3:30 pm UTC
Andy,
sorry, I cannot answer that one - it is more of a license question than a technology question all in all. I'm not sure what the restriction there is.