Wednesday, March 31, 2010

How to find Sunrise & Sunset times in US?

To find sunrise and sunset times in US check this website.http://www.sunrisesunset.com/usa/ The website also displays twilight times. 

Sunday, March 28, 2010

List of commands I frequently use in Oracle

Listed below commands I fequently use on Oracle in Linux OS environment.
(I will keep updating as I come across more)...
Oracle Commands:
  • .How to find whether listener is running or not? 
    • lsnrctl status
    • to start listener 
      • lsnrctl start
    • to stop listener
      • lsnrctl stop 
    • to list services
      • lsnrctl services
  • To Configure Listener
    • from command prompt type netca
  • to start dbconsole (Enterprise Manager Console)
    • emctl start dbconsole
  • to stop dbconsole
    • emctl stop dbconsole
  • to access Enterprise Manager
    • https://<service_name>:1158/
      • for example if your service name is my.example.com then access url will be https://my.example.com:1158/
  • How to start Oracle dB?
    • sqlplus /nolog
    • sql> connect / as sysdba
    • startup
  • How to shutdown Oracle dB?
    • shutdown immediate
  • How to lock a user account & of course to unlock?  
    • SQL> ALTER USER <username>  ACCOUNT LOCK;
    • SQL> ALTER USER <username> ACCOUNT UNLOCK;
    • If you want to change the password while you unlock, use the following command: 
      • SQL> ALTER  USER <username> IDENTIFIED BY <password> ACCOUNT UNLOCK;

How to make SQLDeveloper work on Linux

SQLDeveloper ver 1.1.is a Java Product, much like JDeveloper. Unfortunately it does not seem to update java path automatically.
After Installing JDK in linux, open the file sqldeveloper.conf (path: $ORACLE_HOME/opt/sqldeveloper/sqldeveloper/bin) and modify the parameter SetJavaHome to point to the actual path where jdk resides.
Ex: I had installed JDK in /usr/java directory. So my entry for SetJavaHome is /usr/java/jdk1.6.0_18

List of Commands I use frequently in Linux/Unix

Being a developer, I hardly ever use Unix/Linux. However,every now and then I need to do work on Linux. Instead of keep searching internet or bug my friendly colleagues, I think it is a better idea to list out Linux commands below. So here goes (I will keep updating as I come across more)...


  • remove directory /files.
    • rm -fr *.*
    • f flag will force remove (and not interactively ask whether you need to remove or not)
    • r flag will allows for recursively deleting all files and directories
    • note: if there is a need to ask before deleting any file, then use i flag
  • How to find ip address in Linux?
    • ifconfig will print the ip address
    • note: if the above command returns "not found", then, use /sbin/ifconfig
  • How to find Disk Usage: Link to baobob: Linux Disk usage analysis and cleanup tools
  • How to find out where "java" or any other file installed (its complete path)?
    • the command whereis java will list the complete path
  • How to execute .bash_profile after changes?
    • . ./.bash_profile (there should be a space between the first dot and the second one)
  • create alias for commands
    • alias cls=`clear tput`
  • How to count number of files in a directory?
    • file . -type f wc -l
  • How to display present working directory in the prompt?
    • In bash shell, set PS1=`\w` (I also add a colon ":" and a greater than symbol ">" at the end like this: PS1=`\w :>` for further references goto everything.com
  • Vi Commands
    • How to display filename while working inside vi?
      Type Ctrl+G
    • How to display line numbers?
      Press ':' and type set number
    • How to display mode we are working on (APPEND or OPEN...)?
      Press ':' and type set showmode

Thursday, March 25, 2010

photo of the first bug





Actual photo of the first Bug - thanks to Prof. Mehran Sahami of Standford University & Smithsonian.
A short apocryphal story as told by Prof: In 1945, there was a lady by name Grace Murray Hopper ( click here to learn about Adm.Hopper ). She first woman admiral and was stationed at Harvard University.  who was from the Navy, working on Mark II Computer (it was those of Huge Vacum Tubes and relays). One day, they noticed that the Computer was working on fits and starts . So they opened the Computer and actually walked inside the Computer, to find a moth shorted-out between two relays. So she removed the moth and preserved the moth in her log book. The above photo is from the logbook kept at Smithsonian ( Smithsonian photo of first Bug) .

Tuesday, March 23, 2010

Excellent Free JavaScript/XML /XSLT/FO editors

Found Excellent editors to edit XML/XSLT/FO editors
All the editors mentioned below are free (some editors do do not make available all the features in the freebie version).
XMLSpear: http://www.donkeydevelopment.com/#features
XMLFox: http://www.xmlfox.com/ Another free XML Editor. Some of the features are not available in the freebie version.
Editx: Excellent Free XML Editor, cool Features http://free.editix.com/ Requires you to buy, in order to use do FO Translations, XML and other features

For FO Translations:
RenderX: http://www.renderx.com/download/personal.html

Microsoft:
Any mention without Microsoft XML Editors is incomplete (Not that it has any cool features). You can also use MS Word to create /Edit XML documents.
XML Notepad: Microsoft XML Editor

JavaScript
Yaldex: http://www.yaldex.com/Free_JavaScript_Editor.htm

Last but not the least,is Oracle JDeveloper - although I am yet to go through it completely and one which I intend to make my favorite - to download goto:
http://www.oracle.com/technology/software/products/jdev/index.html

"Paid" Editor:
Of course, there are other "paid" version of XML Editor, which have superior features, some offering fully functional "trial" versions. I have listed below a couple of them:
XMLSPY http://www.altova.com/simpledownload2c.html?gclid=CMrz8q37zqACFYd-5QodfEqp5Q
oXygen: http://www.oxygenxml.com/

XSLT, FO & Others

FOP: Other Resources
I stumbled upon this excellent collection on XSLT, FO and other resources including Java (thanks to Rodolfo Raya of IBM - to visit his page click here )
Of course, I should thank Michael Morrison too, since he had mentioned about about apache.org in his book.
This website too has excellent tutorials on XSL-FO as well as other web technologies: http://www.learn-xsl-fo-tutorial.com/

Monday, March 15, 2010

Overview \ Processing 1.0

Overview \ Processing 1.0

Interesting to learn to about Processing software. (it is a software that can be used to produce Visual Arts).
Enclosed below a short synopsis about Processing (lifted it from about page)

"Processing is a programming language, development environment, and online community that since 2001 has promoted software literacy within the visual arts. Initially created to serve as a software sketchbook and to teach fundamentals of computer programming within a visual context, Processing quickly developed into a tool for creating finished professional work as well."
For example the following apps was developed using Processing Software.


Cool apps, it displays on the bottom the data points in the Venn Diagram. Clicking on any of the venn diagram changes the data displayed in the bottom.You can get more information about the above twitter app at Jeff Clark'sTwitterVenn apps and about Processing here.

Sunday, March 14, 2010

Tamil transliteration by Google - cool

I saw this cool feature -tranliterater - in google which types in Tamil (or any other language), simply thrilled! ஒன்லி ப்à®°ோப்லேà®®் இஸ் தட் கூகிள் சீà®®்ஸ் டு திà®°ுன்ச்ளிடேரடே எவெà®°ி வோà®°்ட். பீல்ஸ் லைக், சிà®™்கிà®™் ஓனே ஒப் ரஹ்à®®ான்'s சாà®™்.
wonder how many would be able to read the above sentence!

Wednesday, March 10, 2010

New Product from Oracle


Oracle® has finally entered the food world! After drinking Gatorade and other energy drinks for years, Larry Ellison, CEO of Oracle®, got this idea while racing for the America cup, in the Mediterranean. Viola! Oracle ® Organic drink. Studies were conducted on two groups, one which drank 3 bottles of Oracle ® Juice and the other drank plain apple/orange/lime juice. Those who drank 3 bottles a day of Oracle ® juice, learnt Oracle ® products at least 2 times faster. The savings in terms of spending on learning at Oracle ® University, software, and books is estimated to be, 52.75%. Learn Oracle®! Drink Oracle ®! Earn more!

This is a spoof on Oracle. Link to original article I read is here. I have no knowledge whether this is an Oracle product or not.None of statistics presented are true. I have written this article with tonge-firmly-in-the-cheek.

Sunday, March 7, 2010

Oracle wins America Cup

And Oracle wins America's Cup Again (Second year in a row). Congrats, guys, keep it up!

The Challenge is all the more difficult, since the winning team sets the rules for the next cup, making it all the more difficult for challenger teams to take it away.

Wednesday, March 3, 2010

CGI-BIN

Found an interesting site which teaches CGI-BIN - check it out

in reference to: CGI Scripts - Learning to Publish (view on Google Sidewiki)