Sorry, I cup of coffe was nescessary to wake up... ;o) I got it.. And worked well... Thanks a lot Stefan and David..! Creating a link in the $SQLPATH was the trick! ;O) On Sun, Oct 24, 2010 at 5:45 AM, Guilherme Raymo Longo < grlongo.ireland@xxxxxxxxx> wrote: > Hi, and thanks fir the reply! > I was afraid that I wouldn't be able to solve this problem without asking > the development team to rewrite a unix solution before trying this one. > > But, Stefan. I don't really get what you are trying to say... > > 'oracle@central:~/temp/ [M2] cat > real_script.sql´ > select * from v$instance; > - Here I presume you populated your script > > oracle@central:~/temp/ [M2] ln -s real_script.sql F:TESTfoo.sql > - And than you created a link to the real script here: F:TEST\foo.sql > > Now, this command: > @F:\TEST\foo.sql > > You are executing the simbolic link in F:\ > F:\ is a mapped directory in wine... how sqlplus is able to find F:\ still > not clear to me as there is no real F:\ to sqlplus. > > this is the part where it goes wrong, and remember that I am in a linux > box... this is a installation through wine.. ;O) > > C:\Setup>C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\BIN\SQLPLUS.EXE > /NOLOG @F:\INTEGRADO\LINNER\SETUP\ARQUIVOS\USUARIOS.SQL <------- This > file really exist, and it is there.... > > SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 24 05:42:27 2010 > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > SP2-0310: unable to open file "F:INTEGRADOLINNERSETUPARQUIVOSUSUARIOS.SQL" > > Could you plz gimme one more little hint... and thanks for the effort! > > > > > On Sat, Oct 23, 2010 at 5:38 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>wrote: > >> Try this: >> >> oracle@central:~/temp/ [M2] cat > real_script.sql >> select * from v$instance; >> oracle@central:~/temp/ [M2] ln -s real_script.sql F:TESTfoo.sql >> oracle@central:~/temp/ [M2] sqh >> >> SQL*Plus: Release 11.2.0.1.0 Production on Sat Oct 23 21:36:43 2010 >> >> Copyright (c) 1982, 2009, Oracle. All rights reserved. >> >> >> Connected to: >> Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit >> Production >> With the Partitioning, Automatic Storage Management, OLAP, Data Mining >> and Real Application Testing options >> >> SQL> @F:\TEST\foo.sql >> >> >> >> >> INSTANCE_NUMBER INSTANCE_NAME >> --------------- ---------------- >> HOST_NAME >> ---------------------------------------------------------------- >> VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE >> LOG_SWITCH_WAIT >> ----------------- --------- ------------ --- ---------- ------- >> --------------- >> LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO >> ---------- --- ----------------- ------------------ --------- --- >> 1 M2 >> central >> 11.2.0.1.0 21-SEP-10 OPEN NO 1 STARTED >> ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO >> >> >> Stefan >> >> >> >> ========================= >> >> Stefan P Knecht >> CEO & Founder >> s@xxxxxxxx >> >> 10046 Consulting GmbH >> Schwarzackerstrasse 29 >> CH-8304 Wallisellen >> Switzerland >> >> Phone +41-(0)8400-10046 >> Cell +41 (0) 79 571 36 27 >> info@xxxxxxxx >> http://www.10046.ch >> >> ========================= >> >> >> >> On Sat, Oct 23, 2010 at 11:44 AM, Guilherme Raymo Longo < >> grlongo.ireland@xxxxxxxxx> wrote: >> >>> Good morning.... >>> >>> I trying to accomplish a task that is killing me... seriously! >>> I am trying to adapt an application that runs on windows to work on an >>> Ubuntu Server box. >>> The thing is that during the installation at certain point it >>> is necessary that some sql script gets opened and executed by sqlplus. >>> I am doing everything I can with wine but after the sqlplus is opened the >>> problem begins. This is the line that the executable runs to open the sql >>> script: >>> >>> C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\BIN\SQLPLUS.EXE /NOLOG >>> @F:\INTEGRADO\LINNER\SETUP\ARQUIVOS\USUARIOS.SQL >>> >>> The sqlplus file has been mapped correctly, but this >>> path: @F:\INTEGRADO\LINNER\SETUP\ARQUIVOS\USUARIOS.SQL cannot be found >>> because sqlplus does not have F: >>> mapped. Wine does! >>> >>> So, my question is: >>> Is there any way to map (by using environment variables or by any other >>> way) a path to a device for example F: -> /my/path so sqlplus is able to >>> find files when a statement like the one above is executed? >>> >>> Thanks in advance! >>> Guilherme Longo >>> >>> >>> >>> >>> >> >