While doing some testing of Oracle on a Windows 7 computer I stopped the TNS Listener service also known as OracleOraDb11g_home1TNSListener. The problem is when I attempted to restart the service it would not start. While testing various other things I had made numerous changes so I started looking into what might cause the issue and was pretty confident that the $ORACLE_HOME variable I set within the Windows Environment Variables was probably the culprit. Below I describe more details about the error as well as how I resolved the TNS Listener not being able to start.
Again I am fairly new to Oracle so it has been quite a learning process and typically I have been running into errors that are easy to resolve but being able to locate the answers easy has been challenging. While attempting to use sqlplus.exe from the Windows 7 command line I continued to receive a TNS protocol adapter error and it turns out it was simply from using the incorrect syntax. Below I describe the error in more detail as well as the correct syntax to use for sqlplus on Windows 7.
I recently installed Oracle on a Windows 7 computer to test some tools that are available in Backtrack. I am very new to Oracle so it has been a bit of a learning process including the fact that I had no idea you can install Oracle without having to pay any money to download it so I also plan on writing an article on how to do this. Anyhow after the initial Oracle install we were testing oscanner from Backtrack and locked all of the Oracle accounts which was a bummer because I wasn’t sure there was a way to correct the issue. Turns out it is really easy to unlock the Oracle accounts if you have access to the Oracle server so below I describe how to unlock Oracle accounts when it appears they have all been locked.
This is really easy to do but it will be different for Windows OS’s configured in Windows Virtual PC and Linux/Unix OS’s configured in Windows Virtual PC. For instance Windows XP Mode run from Windows Virtual PC will allow you to easily move the mouse between your desktop and the Windows XP Mode Virtual PC without skipping a beat. When you try to do the same thing within a Linux Windows Virtual PC or a Unix Windows Virtual PC this will not be the case because the Windows Virtual PC integration features are not available to anything but Windows Operating Systems at this time. Below are the instructions for breaking your mouse out of the Linux or Unix Windows Virtual PC.
Earlier today I needed to lookup the origin of some IP’s and I typically use whois but it wasn’t installed on the CentOS server I was working on. Attempting to install whois failed so below there is information on installing whois using the yum package manager on CentOS.