Re: How do I get a value from the windows registry to set a variable
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Wed, 12 Oct 2005 09:55:42 +0100
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@xxxxxxxxx> 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@xxxxxxxxx>
> 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@xxxxxxxxx> 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
Other related posts:
