4 Replies Latest reply: May 8, 2012 6:09 PM by 355883 RSS

    ORACLE_HOSTNAME

    user9077620
      Guys

      Un-set ORACLE_HOSTNAME in the environment.

      How we unset this variable ORACLE_HOSTNAME?

      Thanks
        • 1. Re: ORACLE_HOSTNAME
          sb92075
          user9077620 wrote:
          Guys

          Un-set ORACLE_HOSTNAME in the environment.

          How we unset this variable ORACLE_HOSTNAME?

          Thanks
          & which environment do you have?

          what is OS name & version?
          • 2. Re: ORACLE_HOSTNAME
            user9077620
            ORACLE_HOSTNAME

            Windows 7 Ultimate
            Service Pack 1
            • 3. Re: ORACLE_HOSTNAME
              sybrand_b
              - Learn to work with the shell of your unknown OS
              - do not ask questions for which you easily can find the answer in your (online) resources


              ----------
              Sybrand Bakker
              Senior Oracle DBA
              • 4. Re: ORACLE_HOSTNAME
                355883
                Open a CMD prompt
                type the following:

                set ORACLE_HOSTNAME

                and press Enter

                If the next line shows any value for this env. variable, it means the value is set at the SYSTEM level.
                Find "Computer" or "My Computer", RIGHT-CLICK, properties... Look for "Environment Variable" in the System or Advanced TAB.
                Environment variables window will open.
                Look at the sytem variables in the bottom.

                Click to select ORACLE_HOSTNAME variable and press DELETE.

                If you temporarily want to unset at the shell level, in the command prompt, type the following:

                set ORACLE_HOME=

                and press Enter.

                BTW, I based this on my WinXP.... Don't have a Windows 7 Ult. machine.

                HTH

                Edited by: dcentgye on May 8, 2012 7:08 PM