Notes on daily happenings around me, while I work hard - or hardly, depending on the viewpoint - in the Oracle World
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:
(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
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/
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/
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/
Thursday, March 18, 2010
» IE8 - What you need to know :: CSS, JavaScript and XHTML Explained
» IE8 - What you need to know :: CSS, JavaScript and XHTML Explained
Interesting article by Estelle on CSS/JavaScript & XHTML
Interesting article by Estelle on CSS/JavaScript & XHTML
Tuesday, March 16, 2010
OPN PartnerCast - Download free podcast episodes by Oracle Corporation on iTunes.
OPN PartnerCast - Download free podcast episodes by Oracle Corporation on iTunes.
Watch/Listen Oracle Partner Podcasts using the above Link.
Watch/Listen Oracle Partner Podcasts using the above Link.
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)
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.
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."
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.
Labels:
cool apps,
openware,
processing software,
twitter,
venn diagram
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!
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.
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)
Subscribe to:
Posts (Atom)