Technology Errors

OracleOraDb11g_home1TNSListener Service On Local Computer Started And Then Stopped

Errors2 Comments

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.

Technology Errors

sqlplus Error: ORA-12560: TNS:protocol adapter error

Errors9 Comments

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.

Information Security

How To Login To Oracle On Windows 7 When All Oracle Accounts Are Locked

SecurityLeave a comment

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.

Technology Insights

Get Mouse Control Back In Windows Virtual PC On Windows 7

InsightsLeave a comment

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.