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_at_fatcity.com"
title=ORACLE-L_at_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_at_perceptron.com">ineyman_at_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_at_havelsan.com.tr"
title=bunyamink_at_havelsan.com.tr>Bunyamin K. Karadeniz
To: <A
href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_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 ???
Received on Thu Jan 10 2002 - 09:36:30 CST
