<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2enclosuresfull.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>AreJae.Com</title>
	
	<link>http://www.arejae.com/blog</link>
	<description>me,myself,english and programming…</description>
	<pubDate>Sat, 24 Oct 2009 08:28:12 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.7.1</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/Arejaecom" type="application/rss+xml" /><feedburner:emailServiceId>Arejaecom</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><feedburner:feedFlare href="http://add.my.yahoo.com/rss?url=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://us.i1.yimg.com/us.yimg.com/i/us/my/addtomyyahoo4.gif">Subscribe with My Yahoo!</feedburner:feedFlare><feedburner:feedFlare href="http://www.newsgator.com/ngs/subscriber/subext.aspx?url=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://www.newsgator.com/images/ngsub1.gif">Subscribe with NewsGator</feedburner:feedFlare><feedburner:feedFlare href="http://feeds.my.aol.com/add.jsp?url=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://o.aolcdn.com/favorites.my.aol.com/webmaster/ffclient/webroot/locale/en-US/images/myAOLButtonSmall.gif">Subscribe with My AOL</feedburner:feedFlare><feedburner:feedFlare href="http://www.bloglines.com/sub/http://feeds.feedburner.com/Arejaecom" src="http://www.bloglines.com/images/sub_modern11.gif">Subscribe with Bloglines</feedburner:feedFlare><feedburner:feedFlare href="http://www.netvibes.com/subscribe.php?url=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://www.netvibes.com/img/add2netvibes.gif">Subscribe with Netvibes</feedburner:feedFlare><feedburner:feedFlare href="http://fusion.google.com/add?feedurl=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://buttons.googlesyndication.com/fusion/add.gif">Subscribe with Google</feedburner:feedFlare><feedburner:feedFlare href="http://www.pageflakes.com/subscribe.aspx?url=http%3A%2F%2Ffeeds.feedburner.com%2FArejaecom" src="http://www.pageflakes.com/ImageFile.ashx?instanceId=Static_4&amp;fileName=ATP_blu_91x17.gif">Subscribe with Pageflakes</feedburner:feedFlare><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item>
		<title>Using JConsole to Monitor Tomcat Applications</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/I6j2ZiubolE/using-jconsole-to-monitor-tomcat-applications.html</link>
		<comments>http://www.arejae.com/blog/using-jconsole-to-monitor-tomcat-applications.html#comments</comments>
		<pubDate>Sat, 24 Oct 2009 08:28:12 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[Tips & Tricks]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/using-jconsole-to-monitor-tomcat-applications.html</guid>
		<description><![CDATA[JConsole is a graphical tool which allows the user to monitor and manage the behavior of Java applications.


In order to enable jconsole to monitor Tomcat Application, just add the additional line in catalina.bat or catalina.sh

set JAVA_OPTS=%JAVA_OPTS% -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port="9001" -Dcom.sun.management.jmxremote.authenticate="false" -Dcom.sun.management.jmxremote.ssl="false"

Now you can open jconsole using below command.

jconsole localhost:9001
&#160;
Till then&#8230;happy monitoring..  
]]></description>
			<content:encoded><![CDATA[<p>JConsole is a graphical tool which allows the user to monitor and manage the behavior of Java applications.</p>
<p><img alt="jConsole" src="http://www.arejae.com/blog/wp-content/uploads/2009/10/jconsole.png" width="450" height="264" /></p>
<p><span id="more-628"></span>
<p>In order to enable jconsole to monitor Tomcat Application, just add the additional line in catalina.bat or catalina.sh</p>
<pre class="sql" name="code">
set JAVA_OPTS=%JAVA_OPTS% -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port="9001" -Dcom.sun.management.jmxremote.authenticate="false" -Dcom.sun.management.jmxremote.ssl="false"
</pre>
<p>Now you can open jconsole using below command.</p>
<p>
jconsole localhost:9001</p>
<p>&nbsp;</p>
<p>Till then&#8230;happy monitoring.. <img src='http://www.arejae.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/I6j2ZiubolE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/using-jconsole-to-monitor-tomcat-applications.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/using-jconsole-to-monitor-tomcat-applications.html</feedburner:origLink></item>
		<item>
		<title>How to connect Huawei E220 Celcom Broadband in Ubuntu 9.04</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/bapYBFTRDDM/how-to-connect-huawei-e220-celcom-broadband-in-ubuntu-904.html</link>
		<comments>http://www.arejae.com/blog/how-to-connect-huawei-e220-celcom-broadband-in-ubuntu-904.html#comments</comments>
		<pubDate>Sun, 27 Sep 2009 00:22:26 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[*nix]]></category>

		<category><![CDATA[Tips & Tricks]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/how-to-connect-huawei-e220-celcom-broadband-in-ubuntu-904.html</guid>
		<description><![CDATA[Without installing any additional software, connecting Huawei E220 device to Celcom broadband in Ubuntu 9.04 is very easy. Just follow the connection assistant and you will be good.  
Edit Connections..

Add new Mobile Broadband

Assistant


Select service provider

Give a nice name to the connection

Edit the connection properties. APN celcom.net.my is auto by the assistant. I Just leave [...]]]></description>
			<content:encoded><![CDATA[<p>Without installing any additional software, connecting Huawei E220 device to Celcom broadband in Ubuntu 9.04 is very easy. Just follow the connection assistant and you will be good. <img src='http://www.arejae.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<p><strong>Edit Connections..</strong></p>
<p><img alt="step1" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step1.png" width="219" height="171" /></p>
<p><strong>Add new Mobile Broadband</strong></p>
<p><img alt="step2" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step2.png" width="374" height="260" /></p>
<p><strong>Assistant</strong></p>
<p><img alt="step3" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step3.png" width="409" height="386" /></p>
<p><span id="more-626"></span>
<p><strong>Select service provider</strong></p>
<p><img alt="step4" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step4.png" width="407" height="361" /></p>
<p><strong>Give a nice name to the connection</strong></p>
<p><img alt="step5" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step5.png" width="406" height="362" /></p>
<p>Edit the connection properties. APN <strong>celcom.net.my</strong> is auto by the assistant. I Just leave it like that and it works.</p>
<p><img alt="step6" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step6.png" width="332" height="411" /></p>
<p><strong>Choose your connection.</strong></p>
<p><img alt="step7" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step7.png" width="249" height="197" /></p>
<p>.. and you are connected.</p>
<p><img alt="step8" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/step8.png" width="272" height="41" /></p>
<p>Previously I&#8217;m using <strong>wvdial</strong> as suggested in <a href="http://melayubuntu.blogspot.com/2008/07/akses-ke-celcom-broadband-menggunakan.html" target="_blank">this blog</a> and it is also works. The problem is that, it is not in ubuntu default installation,you need to install it first before you can use it. Well, it&#8217;s not really a problem since you still can install it in offline mode. (<a href="http://acomelectronics.com/GeorgeVita/restore_wvdial.html" target="_blank">here</a> is the way how to do it)</p>
<p>Till then..Happy surfing !</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/bapYBFTRDDM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/how-to-connect-huawei-e220-celcom-broadband-in-ubuntu-904.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/how-to-connect-huawei-e220-celcom-broadband-in-ubuntu-904.html</feedburner:origLink></item>
		<item>
		<title>Offline blogging editor in Ubuntu - Bilbo</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/uIj9g0Je5_Q/offline-blogging-editor-in-ubuntu-bilbo.html</link>
		<comments>http://www.arejae.com/blog/offline-blogging-editor-in-ubuntu-bilbo.html#comments</comments>
		<pubDate>Mon, 21 Sep 2009 03:43:14 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[My Life]]></category>

		<category><![CDATA[Tips & Tricks]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/offline-blogging-editor-in-ubuntu-bilbo.html</guid>
		<description><![CDATA[I have been searching for the best offline blogging editor in ubuntu for a quite sometimes. Now I think I found the right one. ;).
Bilbo
(testing uploading picture)
3 Steps to intall.

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com  0xfe0272d55c41c17774052e575646f8b10331274d
echo deb http://ppa.launchpad.net/neversfelde/ppa/ubuntu `lsb_release --short --codename` main &#124; sudo tee -a /etc/apt/sources.list
sudo apt-get update ; sudo apt-get install bilbo


Thanks [...]]]></description>
			<content:encoded><![CDATA[<p>I have been searching for the best offline blogging editor in ubuntu for a quite sometimes. Now I think I found the right one. ;).</p>
<p><a href="http://bilbo.gnufolks.org/" target="_blank">Bilbo</a></p>
<p><img src="http://www.arejae.com/blog/wp-content/uploads/2009/09/etapp-logo.png" />(testing uploading picture)</p>
<p>3 Steps to intall.</p>
<pre class="sql" name="code">
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com  0xfe0272d55c41c17774052e575646f8b10331274d
echo deb http://ppa.launchpad.net/neversfelde/ppa/ubuntu `lsb_release --short --codename` main | sudo tee -a /etc/apt/sources.list
sudo apt-get update ; sudo apt-get install bilbo
</pre>
<p>
Thanks to this <a href="http://bigbrovar.wordpress.com/2009/09/06/the-ultimate-blogging-client-for-linux" target="_blank">blog</a></p>
<p><span id="more-608"></span>
<p>Testing next page</p>
<p>Hmm&#8230;it&#8217;s fail to make this content appear in next page with Bilbo or is it me that can&#8217;t figure it out yet. anyway&#8230;It&#8217;s ok.</p>
<p>
p/s: Selamat Hari Raya Aidilfitri. Maaf zahir dan batin.</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/uIj9g0Je5_Q" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/offline-blogging-editor-in-ubuntu-bilbo.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/offline-blogging-editor-in-ubuntu-bilbo.html</feedburner:origLink></item>
		<item>
		<title>My solution for ORA-12560: TNS:protocol adapter error</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/-1cYcMowf90/my-solution-for-ora-12560-tnsprotocol-adapter-error.html</link>
		<comments>http://www.arejae.com/blog/my-solution-for-ora-12560-tnsprotocol-adapter-error.html#comments</comments>
		<pubDate>Sat, 19 Sep 2009 05:13:08 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[Database]]></category>

		<category><![CDATA[Programming]]></category>

		<category><![CDATA[Tips & Tricks]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/my-solution-for-ora-12560-tnsprotocol-adapter-error.html</guid>
		<description><![CDATA[Everything goes fine with my Oracle 11G but out of the sudden it give me this error. ORA-12560: TNS:protocol adapter error.
I then look at the Event Viewer logs and give me another error message.
ACTION : &#8216;CONNECT&#8217; DATABASE USER: &#8216;/&#8217; PRIVILEGE : SYSDBA CLIENT USER: NT AUTHORITY\SYSTEM CLIENT TERMINAL: MYAREJAE STATUS: 0 .
Googling around give me [...]]]></description>
			<content:encoded><![CDATA[<p>Everything goes fine with my Oracle 11G but out of the sudden it give me this error. <strong>ORA-12560: TNS:protocol adapter error.</strong></p>
<p>I then look at the Event Viewer logs and give me another error message.</p>
<p>ACTION : &#8216;CONNECT&#8217; DATABASE USER: &#8216;/&#8217; PRIVILEGE : SYSDBA CLIENT USER: NT AUTHORITY\SYSTEM CLIENT TERMINAL: MYAREJAE STATUS: 0 .</p>
<p>Googling around give me below solution. Just run the command and everything goes back to normal.</p>
<p><strong>oradim -edit -sid orcl -startmode auto</strong></p>
<p>Depending on the situation, I think maybe this solution is not necessary true for everyone but at least it works for me. <img src='http://www.arejae.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<p>Till then&#8230;</p>
<p>Happy Coding&#8230;</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/-1cYcMowf90" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/my-solution-for-ora-12560-tnsprotocol-adapter-error.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/my-solution-for-ora-12560-tnsprotocol-adapter-error.html</feedburner:origLink></item>
		<item>
		<title>Eclipse Tips -  Generate Getter and Setters</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/cKWwXWPJONo/eclipse-tips-generate-getter-and-setters.html</link>
		<comments>http://www.arejae.com/blog/eclipse-tips-generate-getter-and-setters.html#comments</comments>
		<pubDate>Sun, 13 Sep 2009 02:44:17 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[Programming]]></category>

		<category><![CDATA[Tips & Tricks]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/eclipse-tips-generate-getter-and-setters.html</guid>
		<description><![CDATA[Below are the way how you can generate getters and setters in eclipse.

&#160;
To get more tips for eclipse, you can happily go to this and this site.
Till then&#8230;happy coding.

]]></description>
			<content:encoded><![CDATA[<p>Below are the way how you can generate getters and setters in eclipse.</p>
<p><img alt="2009-06-30 094307" src="http://www.arejae.com/blog/wp-content/uploads/2009/09/2009-06-30-0943071.jpg" width="450" height="198" /></p>
<p>&nbsp;</p>
<p>To get more tips for eclipse, you can happily go to <a href="http://www.laliluna.de/eclipse-myeclipse-tips-and-tricks.html" target="_blank">this</a> and <a href="http://www.javaworld.com/javaworld/jw-08-2005/jw-0829-eclipse.html" target="_blank">this</a> site.</p>
<p>Till then&#8230;happy coding.</p>
<p><a href="http://www.laliluna.de/eclipse-myeclipse-tips-and-tricks.html"></a></p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/cKWwXWPJONo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/eclipse-tips-generate-getter-and-setters.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/eclipse-tips-generate-getter-and-setters.html</feedburner:origLink></item>
		<item>
		<title>Happy 09.09.09</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/mPgOsS67XRs/happy-090909.html</link>
		<comments>http://www.arejae.com/blog/happy-090909.html#comments</comments>
		<pubDate>Wed, 09 Sep 2009 05:36:11 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[My Life]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/happy-090909.html</guid>
		<description><![CDATA[my dear blog..it has been a long time since my last post.
I&#8217;m getting so busy with my job. So many things to update in my blog but I can&#8217;t figure out how to write.
Perhaps I can write a litte bit after finish off some of my major task.
Anyway..happy Ramadhan and Happy 09.09.09
&#160;
p/s: anyone got married [...]]]></description>
			<content:encoded><![CDATA[<p>my dear blog..it has been a long time since my last post.</p>
<p>I&#8217;m getting so busy with my job. So many things to update in my blog but I can&#8217;t figure out how to write.</p>
<p>Perhaps I can write a litte bit after finish off some of my major task.</p>
<p>Anyway..happy Ramadhan and Happy 09.09.09</p>
<p>&nbsp;</p>
<p>p/s: anyone got married today ?</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/mPgOsS67XRs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/happy-090909.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/happy-090909.html</feedburner:origLink></item>
		<item>
		<title>Selamat Berpuasa</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/CFZy6mkGiHY/selamat-berpuasa.html</link>
		<comments>http://www.arejae.com/blog/selamat-berpuasa.html#comments</comments>
		<pubDate>Fri, 21 Aug 2009 11:05:02 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[My Life]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/selamat-berpuasa.html</guid>
		<description><![CDATA[Di kesempatan ini, saya mengambil kesempatan untuk mengucapkan Selamat menyambut Ramadhan &#38; Selamat menjalani ibadah puasa.

&#160;
p/s : Ku mengharapkan Ramadhan kali ini penuh makna&#8230;agar dapat kulalui dengan sempurna..
]]></description>
			<content:encoded><![CDATA[<p>Di kesempatan ini, saya mengambil kesempatan untuk mengucapkan Selamat menyambut Ramadhan &amp; Selamat menjalani ibadah puasa.</p>
<p><img style="WIDTH: 379px; HEIGHT: 400px" alt="bonus ramadhan" src="http://www.arejae.com/blog/wp-content/uploads/2009/08/bonus-ramadhan.jpg" width="325" height="400" /></p>
<p>&nbsp;</p>
<p>p/s : Ku mengharapkan Ramadhan kali ini penuh makna&#8230;agar dapat kulalui dengan sempurna..</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/CFZy6mkGiHY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/selamat-berpuasa.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/selamat-berpuasa.html</feedburner:origLink></item>
		<item>
		<title>Something to ponder</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/eC_CKkqzVdc/something-to-ponder.html</link>
		<comments>http://www.arejae.com/blog/something-to-ponder.html#comments</comments>
		<pubDate>Fri, 10 Jul 2009 03:17:29 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[My Life]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/something-to-ponder.html</guid>
		<description><![CDATA[Never regret.
If it&#8217;s good, it&#8217;s wonderful
If it&#8217;s bad, it&#8217;s experience

&#160;
p/s : who feel time is running too fast&#8230;?
]]></description>
			<content:encoded><![CDATA[<p>Never regret.</p>
<p>If it&#8217;s good, it&#8217;s wonderful</p>
<p>If it&#8217;s bad, it&#8217;s experience</p>
<p><img height="337" alt="have a wonderful journey" src="http://www.arejae.com/blog/wp-content/uploads/2009/07/have-a-wonderful-journey.jpg" width="450" /></p>
<p>&nbsp;</p>
<p>p/s : who feel time is running too fast&#8230;?</p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/eC_CKkqzVdc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/something-to-ponder.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/something-to-ponder.html</feedburner:origLink></item>
		<item>
		<title>HR2000 Telekom 8 Digit Converter.</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/WEkjRf7bX10/hr2000-telekom-8-digit-converter.html</link>
		<comments>http://www.arejae.com/blog/hr2000-telekom-8-digit-converter.html#comments</comments>
		<pubDate>Fri, 08 May 2009 02:47:21 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[:Else:]]></category>

		<category><![CDATA[AutoIt]]></category>

		<category><![CDATA[My Life]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/hr2000-telekom-8-digit-converter.html</guid>
		<description><![CDATA[Previously, I wrote about Automate 7 to 8 digit phone number conversion using AutoIT. Since then, I&#8217;m not using it anymore until I get a request regarding phone number conversion from my reader.
Searching that software online bring me no luck, so I ask my friend to email it to me. Now, im here to share [...]]]></description>
			<content:encoded><![CDATA[<p>Previously, I wrote about <a href="http://www.arejae.com/blog/automate-7-to-8-digit-phone-number-conversion-using-autoit.html">Automate 7 to 8 digit phone number conversion using AutoIT</a>. Since then, I&#8217;m not using it anymore until I get a request regarding phone number conversion from my reader.</p>
<p>Searching that software online bring me no luck, so I ask my friend to email it to me. Now, im here to share the software in case someone need it.</p>
<p><img height="230" alt="HR Telekom" src="http://www.arejae.com/blog/wp-content/uploads/2009/05/hr-telekom.jpg" width="333" /></p>
<p>You can download it <a href="http://www.arejae.com/download/hrtelekom8.zip">here</a>.</p>
<p>p/s: I&#8217;m very very busy nowdays&#8230;.sorry if my response is so slow. <img src='http://www.arejae.com/blog/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/WEkjRf7bX10" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/hr2000-telekom-8-digit-converter.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/hr2000-telekom-8-digit-converter.html</feedburner:origLink></item>
		<item>
		<title>Automate your oracle import and export using AutoIt</title>
		<link>http://feedproxy.google.com/~r/Arejaecom/~3/XZ2BwJaq5u0/automate-your-oracle-import-and-export-using-autoit.html</link>
		<comments>http://www.arejae.com/blog/automate-your-oracle-import-and-export-using-autoit.html#comments</comments>
		<pubDate>Wed, 25 Mar 2009 11:50:43 +0000</pubDate>
		<dc:creator>arejae</dc:creator>
		
		<category><![CDATA[AutoIt]]></category>

		<category><![CDATA[Programming]]></category>

		<guid isPermaLink="false">http://www.arejae.com/blog/automate-your-oracle-import-and-export-using-autoit.html</guid>
		<description><![CDATA[I always believe that I can do almost everything using AutoIt. Well, since I need to do a lot of import and export job manually, I just wondering why not I just automagically do it using AutoIt.
There are a few steps involve in this process :
1. export data from server to my local pc
2. connect [...]]]></description>
			<content:encoded><![CDATA[<p>I always believe that I can do <strong><em>almost</em></strong> everything using AutoIt. Well, since I need to do a lot of import and export job manually, I just wondering why not I just automagically do it using AutoIt.</p>
<p>There are a few steps involve in this process :</p>
<p>1. export data from server to my local pc</p>
<p>2. connect to sqlplus and drop user</p>
<p>3. create user and grant permission</p>
<p>4. import back using dump file created in step 1</p>
<p>Now, here how I convert those steps into AutoIt.</p>
<p><span id="more-587"></span>
<pre class="sql" name="code">
Opt("WinTitleMatchMode",2)
$cmdPID = Run("cmd", "", @SW_SHOWNORMAL)
WinWaitActive("cmd.exe")
$hDos = WingetHandle("cmd.exe")
SendKeepActive($hDos)

Send("d:")
Send("{ENTER}")
Send("cd\backup")
Send("{ENTER}")

$filename = @YEAR &amp; @MON &amp; @MDAY &amp; ".dmp"
;First part
$parameter = "arejae/arejae@mydevelopmentserver file=" &amp; $filename
Send('exp.exe ' &amp; $parameter)
Send ("{ENTER}") 

;Second part
Send('sqlplus "/as sysdba"')
Send ("{ENTER}")
Send('drop user arejae cascade;')
Send ("{ENTER}")
;assuming no errors..well..just to let you know that assuming is killing...

;3rd part
Send('create user arejae identified by arejae;')
Send ("{ENTER}")
Send('grant DBA to arejae;')
Send ("{ENTER}") 

;exit SQLPlus and proceed to import file
Send("exit")
Send("{ENTER}")

;4th part
Send('imp arejae/arejae file='&amp; $filename &amp; ' full=y ')
Send ("{ENTER}") 

;done..exit from command prompt
Send("exit")
Send("{ENTER}")
</pre>
<p></p>
<p>That&#8217;s all.. now i can combine all those steps with only one single click or..i can schedule it to run at anytime. <img src='http://www.arejae.com/blog/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
<img src="http://feeds.feedburner.com/~r/Arejaecom/~4/XZ2BwJaq5u0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.arejae.com/blog/automate-your-oracle-import-and-export-using-autoit.html/feed</wfw:commentRss>
		<feedburner:origLink>http://www.arejae.com/blog/automate-your-oracle-import-and-export-using-autoit.html</feedburner:origLink></item>
	</channel>
</rss>
