Re: How do I get a value from the windows registry to set a variable

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 12 Oct 2005 16:45:17 -0500 (EST)
Message-ID: <008c01c5cf0b$e5670110$1a03310a@IBME1D11967173>

:o) I choose this variable name (CURR_OH) to demonstrate that this is new variable, not the ORALCLE_HOME that you already have in your environment. If you want to use it with the ORACLE_HOME you have to change it(script test.bat)

@ECHO OFF
set ORACLE_HOME=
echo The current ORACLE_HOME is %ORACLE_HOME% :: 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 ORACLE_HOME=%%A ECHO The NEW Oracle Home is %ORACLE_HOME%

D:\Downloads>test
The current ORACLE_HOME is
The NEW Oracle Home is C:\oracle\ora92
D:\Downloads>sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Wed Oct 12 11:03:16 2005

SQL> Regards,
Dimitre

Original Message ----- From: Niall Litchfield To: cichomitiko_at_gmail.com Cc: Juan Carlos Reyes Pacheco ; oracle-l_at_freelists.org Sent: Wednesday, October 12, 2005 10:55 AM Subject: 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

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-l

Received on Wed Oct 12 2005 - 16:46:14 CDT