Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How do I get a value from the windows registry to set a variable
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: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
On 10/12/05, Dimitar Radoulov <cichomitiko_at_gmail.com> 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_at_gmail.com>
> 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_at_gmail.com> 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).
> > >
> > >
> > > @ECHO 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 12 2005 - 03:57:52 CDT
![]() |
![]() |