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.
Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…