This is utterly simple and mostly you did it with the mouse.
To do it with command line and powershell, proceed this way.
Open a powershell window
powershell
or if you have no right to edit the machine-wide environment, runas admin
runas /user:yourdomain\youruserplusadmin powershell
then access the environment assembly
[environment]::setEnvironmentVariable("PATH","c:\oracle\product\11.2.0\client_1\bin;C:\WINDOWS\;C:\WINDOWS\system32;C:\Program Files\Putty;C:\Program Files\Perforce;C:\Program Files\TortoiseSVN\bin;C:\WINDOWS\system32\WindowsPowerShell\v1.0","MACHINE")
MACHINE is a for a Machine-wide setting and USER is for a USER-wide setting.
I hope it will be of some use
Completly unrelated, Enterprise Manager 12c for AIX is out. Do not wait it for HPUX, it is not planned. For Windows 64bit, it will come “between March and May 2012″ according to note 793512.1 on metalink
I have never been a Microsoft fanatic nor an anti-microsoft terrorist, but today I could not believe that large compressed folders got corrupted in Windows !
I have send a relatively small zip file (5gb, peanuts) from AIX to Windows per sftp and in Windows Explorer, some files in the compressed folder (read zip) were just pointing to the wrong content.
I had some issues with large zip files on unix, but this was last century! Howcome could a modern filesystem/operating system have such issues?
I have found a few bugs on support.microsoft.com.
Ex: Compressed folder becomes corrupted when larger than 2 gigabytes
Workaround : make sure that you limit the size of a compressed folder to 2 GB or less
Amazing!
I just learnt a neat trick from Oracle Support.
How do you see the current value of NLS_LANG in SQLPLUS ?
HOST is not the right answer.
E.g.:
Unix:
SQL> host echo $NLS_LANG
AMERICAN_SWITZERLAND
Windows:
SQL> HOST ECHO %NLS_LANG%
%NLS_LANG%
The correct setting is revealed by @.[%NLS_LANG%]
E.g.:
Unix:
SQL> @.[$NLS_LANG]
SP2-0310: unable to open file ".[AMERICAN_AMERICA.WE8ISO8859P1]"
Windows:
SQL> @.[%NLS_LANG%]
SP2-0310: unable to open file ".[AMERICAN_AMERICA.WE8ISO8859P1]"
It could well be that both return the same answer, but not necessarly, as shown above.
The unix discrepancy is related to the subshell created by HOST. The subshell may read some .profile and overwrite the value of NLS_LANG
In Windows, the NLS_LANG setting may be set by sqlplus according to some registry entries
I just wrote one of my first powershell script yesterday, it has a pretty nice syntax actually, and no need to download anything like cygwin or other unix-like shell to your PC.
PS> $stmt = "set hea off`n"
PS> $stmt += "select 'hello world' from dual;"
PS> $res = ($stmt | sqlplus -s scott/tiger)
PS> $res
hello world
Pretty cool 
I have been using Vista for about 3 months and finally found a way to start my databases with a single click
The method I used until yesterday was a .BAT file that starts the services, I had then to right click on the shortcut, run as administrator, confirm the UAC warning. 3 Clicks. Way to much…
I have googled quite a lot and found Vista setuid – How to elevate without prompting
Ok, here we go :
1) run mmc
2) file – add snapin
3) Task Scheduler Library – Create Task
4) Name: startoracle
Run with highest privileges
Actions – New – Start a program – Program:net – Arguments: start OracleOraDb11g_home1TNSListener
Actions – New – Start a program – Program:net – Arguments: start OracleServiceLSC01
Actions – New – Start a program – Program:net – Arguments: start OracleServiceLSC02
…
5) create a batch file that runs : schtasks /run /tn startoracle
Same for stoporacle
It seems to work fine. Do not play too much with mmc if you do not know it. It is a powerful tool 
Tags:
It is quite a while I have not posted about Linux. The reason is I have bought in new notebook three months ago with Vista and did not have a program to resize the partition…
Do I need a program?
NO, I do not !!!
Vista has disk management that can resize my online partition.
Run: compmgmt.msc /s
Or go to control panel.
And shrink/extend your volumes!
Tags: