RE: Oracle Installation on Windows

Thanks for the suggestion but this is not the source of the problems I encountered. Our situation did not involve shelling out.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

-----Original Message-----

From: Bill Ferguson [mailto:wbfergus_at_gmail.com] Sent: Tuesday, February 10, 2009 10:18 AM To: William Wagman
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Installation on Windows

Bill -

I don't have documentation available, but starting with 10G, I ran into some Oracle problems with permissions when shelling out.

Starting with 10G, Oracle changed the security model when executing programs, so they don't know what the ENV settings are. The solution from Oracle Support was to create a new Windows account with all the permissions Oracle itself needed, then define the ENV settings, PATH, directory permissions, etc., then install Oracle.

Once I did this, then everything worked as it used to under 9i. All this came about since I use the routine at http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php to execute a 'Move' command in a couple of my PL/SQL statements for my application.

You may be having a similar situation as I did, if your applications attempt to execute a Windows command.

Not sure if this helps or not.

--

• Bill Ferguson
  --
  http://www.freelists.org/webpage/oracle-l