This content has been marked as final. Show 4 replies
user9077620 wrote:& which environment do you have?
Un-set ORACLE_HOSTNAME in the environment.
How we unset this variable ORACLE_HOSTNAME?
what is OS name & version?
Windows 7 Ultimate
Service Pack 1
- 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
Senior Oracle DBA
Open a CMD prompt
type the following:
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:
and press Enter.
BTW, I based this on my WinXP.... Don't have a Windows 7 Ult. machine.
Edited by: dcentgye on May 8, 2012 7:08 PM