Re: mapping devices on sqlplus! - Oracle 10g XE
- From: Guilherme Raymo Longo <grlongo.ireland@xxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 24 Oct 2010 05:45:21 -0200
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
>>
>>
>>
>>
>>
>
Other related posts:
