How do I get a value from the windows registry to set a variable 2005-10-12 - By Niall Litchfield
I'm guessing you don't have 10g and 9i installed with 10g as the home.
oh.bat is your script.
C:\Scripts>oh
Oracle home is C:\oracle\ora92
C:\Scripts>sqlplus /
SQL*Plus: Release 10.1.0.4.0 - Production on Wed Oct 12 09:54:16 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
On 10/12/05, Dimitar Radoulov <cichomitiko@(protected)> wrote:
>
> Works on my PC, may be with copy/paste the delims are changing, try to
> adjust the value to TAB followed by a space.
> Regards,
> Dimitre
>
> On 10/11/05, Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected)>
> wrote:
> >
> > Thanks a lot Dimitre, copying and pasting directly from the email
> > don't work precisely, but the solution is there :)
> > On 10/11/05, Radoulov, Dimitre <cichomitiko@(protected)> wrote:
> > > Excuse me, the correct syntax is with tokens=3*(by using the asterisk
> > we
> > > make sure that not only the third word is used but everything
> > following it
> > > as well) and you have to set %%A (not %%B).
> > >
> > >
> > > @(protected) OFF
> > > :: delims is a TAB followed by a space
> > > FOR /F "tokens=3* delims= " %%A IN ('reg query HKLM\SOFTWARE\ORACLE\
> > /v
> > > ORACLE_HOME') DO SET
> > > CURR_OH=%%A
> > > ECHO Oracle home is %CURR_OH%
> > >
> > >
> > >
> > >
> > > Dimitre Radoulov
> > >
> > >
> >
> >
> > --
> > Oracle Certified Profesional 9i 10g
> > Orace Certified Professional Developer 6i
> >
> > 8 years of experience in Oracle 7,8i,9i,10g and developer 6i
> >
>
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
<div>I'm guessing you don't have 10g and 9i installed with 10g as the home. oh
.bat is your script.</div>
<div> </div>
<div>
<p>C:\Scripts>oh<br>Oracle home is C:\oracle\ora92<br>C:\Scripts>sqlplus
/</p>
<p>SQL*Plus: Release 10.1.0.4.0 - Production on Wed Oct 12 09:54:16 2005</p>
<p>Copyright (c) 1982, 2005, Oracle. All rights reserved.</p>
<p>ERROR:<br>ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error</p>
<p><br>Enter user-name:<br>ERROR:<br>ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error</p>
<p><br>Enter user-name:<br>ERROR:<br>ORA-12560 (See ORA-12560.ora-code.com): TNS:protocol adapter error</p>
<p><br>SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
</p><br><br> </div>
<div><span class="gmail_quote">On 10/12/05, <b class="gmail_sendername">Dimitar
Radoulov</b> <<a href="mailto:cichomitiko@(protected)">cichomitiko@(protected)<
/a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Works on my PC, may be with copy/paste the delims are changing, try
to adjust the value to TAB followed by a space.</div>
<div> </div>
<div> </div>
<div>Regards,</div><span class="sg">
<div>Dimitre<br><br> </div></span>
<div><span class="q"><span class="gmail_quote">On 10/11/05, <b class="gmail
_sendername">Juan Carlos Reyes Pacheco</b> <<a onclick="return top.js
.OpenExtLink(window,event,this)" href="mailto:juancarlosreyesp@(protected)" target
="_blank">
juancarlosreyesp@(protected)</a>> wrote:</span> </span>
<div><span class="e" id="q_106e37b3219cc4bc_4">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">Thanks a lot Dimitre, copying and pasting
directly from the email<br>don't work precisely, but the solution is there :)
<br>On 10/11/05, Radoulov, Dimitre <<a onclick="return top.js.OpenExtLink
(window,event,this)" href="mailto:cichomitiko@(protected)" target="_blank"
>cichomitiko@(protected)</a>> wrote:<br>> Excuse me, the correct syntax is
with tokens=3*(by using the asterisk we
<br>> make sure that not only the third word is used but everything
following it <br>> as well) and you have to set %%A (not %%B).<br>><br>
><br>> @(protected) OFF<br>> :: delims is a TAB followed by a space<br>
> FOR /F "tokens=3* delims= " %%A IN ('reg query HKLM
\SOFTWARE\ORACLE\ /v <br>> ORACLE_HOME') DO SET<br>> CURR_OH=%%A<br>>
ECHO Oracle home is %CURR_OH%<br>><br>><br>><br>><br>> Dimitre
Radoulov
<br>><br>><br><br><br>--<br>Oracle Certified Profesional 9i 10g<br>Orace
Certified Professional Developer 6i <br><br>8 years of experience in Oracle 7
,8i,9i,10g and developer 6i<br></blockquote></span></div></div><br>
</blockquote></div><br><br clear="all"><br>-- <br>Niall Litchfield<br>Oracle
DBA<br><a href="http://www.niall.litchfield.dial.pipex.com">http://www.niall
.litchfield.dial.pipex.com</a>
|
|
