From bunyamink@havelsan.com.tr Thu, 10 Jan 2002 07:36:30 -0800
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Date: Thu, 10 Jan 2002 07:36:30 -0800
Subject: Re: RUNNING .BAT FILE FROM PROCEDURE ?
Message-ID: <F001.003EC52F.20020110070529@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Thanks Igor ,
I am trying it but when I want to log on to db , it 
gives 
ORA-12500: TNS:listener failed to start a dedicated 
server process            
error.
Will I do another change ? For example the startup 
account of TNSLISTENER Service .?
Bunyamin
<BLOCKQUOTE dir=ltr 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Igor 
  Neyman 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Thursday, January 10, 2002 3:30 
  PM
  Subject: Re: RUNNING .BAT FILE FROM 
  PROCEDURE ?
  
  The fact, that it works under 9i, is really 
  interesting.  I didn't have chance to play with it yet.
  As for 8.1.7, Oracle runs under NT 'SYSTEM' 
  account (just look at startup options of Oracle service in 
  ControlPanel/Services).
  Hence, your .bat file, called from 
  Oracle, is executed under 'SYSTEM' account, which does not have 
  privileges to access 'mapped' network drives, and it is not possible to grant 
  those privileges to 'SYSTEM' account.
  What you can try, is to create NT account, grant 
  it appropriate privileges to access network drive, and change startup 
  options for Oracle service to 'Log on'  as this new account, 
  should work.
   
  Again, it's interesting, what's been changed in 
  9i.  Check the account used to run Oracle service.
   
  Igor Neyman, OCP DBA<A 
  href="mailto:ineyman@perceptron.com">ineyman@perceptron.com  
  
  <BLOCKQUOTE dir=ltr 
  style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
    ----- Original Message ----- 
    <DIV 
    style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
    <A href="mailto:bunyamink@havelsan.com.tr" 
    title=bunyamink@havelsan.com.tr>Bunyamin K. Karadeniz 
    To: <A 
    href="mailto:ORACLE-L@fatcity.com" title=ORACLE-L@fatcity.com>Multiple 
    recipients of list ORACLE-L 
    Sent: Thursday, January 10, 2002 7:40 
    AM
    Subject: RUNNING .BAT FILE FROM 
    PROCEDURE ?
    
    OS : WINNT , DB :  8.1.7
    I have a java class embedded in database and I 
    am calling it with a procedure. 
    The procedere executes a bat file . 
    
    In the bat file there 2 copy commands . First 
    of them copying a file from  a local directory to another local 
    directory. 
    Second command copy's a file in a shared 
    directory of another computer to another shared directory of that computer. 
    
    BAT file and permissions are all set correctly 
    in all directories..(everyone ,full access).Also gave javasyspriv role and 
    other privileges to the user .
     When I double click on the bat file . 
    Both two commands run correctly. 
    But When I run the bat file via the procedure . 
    The first command runs correctly (local copy command) , but the second one 
    (copying a file in a shared directory of another computer to another shared 
    directory of that computer)  does not run . 
     
    What is the problem ? I gave all permissions 
    but still does not work for remote computer shared files.
    I tried it on 9i database and it worked 
    ..(INTERESTING)
    Any ideas please ???