Pages

Friday, January 06, 2017

How to install Oracle SQL Developer in Linux Debian family


Currently I am in a team doing a software project on site in a company located on Cengkareng. One of the task needed on this project is access to Oracle Server and i use Oracle SQL Developer which able to download freely on Oracle site (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-ea-42-3211401.html). We will use Debian family (Debian, Ubuntu,Lubuntu, Kbuntu, etc) and in this chance i write the steps as follows :
  1. Get the software from oracle.com site. From this site, unfortunately no debian package available which Debian family use, there is only Linux RPM available for Linux and we will use it.
    For now, when this article wrote, we have file : 
    sqldeveloper-4.2.0.16.356.1154-1.noarch.rpm
  1. For installing RPM file on Debian family, we need to convert RPM file to DEB file first, we use alien package for do that. Run this command to install alien and other necessary packages from our account:
    $ sudo apt-get install alien dpkg-dev debhelper build-essential

  2. To convert a package from rpm to debian format, use this command:
    $ sudo alien packagename.rpm

    For our case, the command will be:
    $ sudo alien sqldeveloper*.rpm
    We use asterisk (*) to represents the rest character.
    The process takes for some moment. It will create: sqldeveloper_4.2.0.16.356.1154-2_all.deb

  3. Install debian file above (sqldeveloper_4.2.0.16.356.1154-2_all.deb) by using dpkg tool, the internal package management tool for debian family.
    $ sudo dpkg -i packagename.deb

    For our case, the command will be:
    $ sudo dpkg -i sqldeveloper*.deb
  4. Hurray, Alhamdulillah …. Oracle SQL Developer installed Succesfully. :-)
    For first running, you will be asked for JDK directory. You can know where JDK directory by using syntax : $ which java
    In my computer, it display /usr/bin/java . I just entry : /usr.
    Oracle SQL Developer also ask for adding command : SetSkipJ2SDKCheck true  in product.conf manually. product.conf is located on /home/username/.sqldeveloper/4.2.0 and other location (You may choose one).


    You also can uncomment SetJavaHome and fill the value with your JDK directory.
     
  5. That's all. You type : sqldeveloper for any location to run SQL Developer.
    $ sqldeveloper. The software doesn't create shortcut manually in GUI, you can create by yourself.



    Reference:


    Install an RPM package on Ubuntu Linux - http://www.howtogeek.com/howto/ubuntu/install-an-rpm-package-on-ubuntu-linux/




Friday, December 16, 2016

Memilih Pemimpin Muslim Yang Peduli Dengan Umat Islam

Dewasa ini, di Indonesia suhu Hukum, Politik dan Sosial kemasyarakatan sedang hangat-hangatnya, karena dipicu dengan kejadian seorang Gubernur yang juga merupakan peserta Pilkada, sedang menjadi tersangka penistaan agama Islam yang sebelumnya di demo oleh jutaan umat Islam yang saat artikel ini ditulis, kasusnya sedang dalam proses persidangan di pengadilan negeri Jakarta Utara.

Situasi  Hukum, politik dan sosial kemasyarakatan yang sedang hangat-hangatnya tersebut, juga mempengaruhi isi perbincangan masyarakat luas di banyak tempat, tidak terkecuali di sosial media dan instant messaging.

Saya sendiri menggunakan Sosial media seperti Facebook dan Twitter serta juga menggunakan Instant Messaging yaitu Whatsapp (WA). Dalam menggunakan Whatsapp, selain untuk berkomunikasi dengan teman, sanak family dan orang lain, saya juga tergabung dalam beberapa group WA, salah satu di antaranya adalah group Doeval '94. Group WA ini adalah group WA yang anggotanya adalah alumni SMP Negeri 245 yang masuk pada tahun 1994. Sudah cukup lama ya …, kami yang dulunya anak-anak, sekarang sudah pada punya anak … :-).

Pernah suatu kali saya mengupload image perkataan seorang mantan perdana menteri Turki, Necmettin Erbakan, seperti yang saya insert juga di artikel ini. Perkataannya adalah : “Muslim yang tidak pedulikan politik, akan dipimpin oleh politikus yang tidak pedulikan orang Islam”. Seorang teman, yang tulisan ini diperuntukkan untuk dia, sebut saja “W”, membantah kepada saya, kurang lebih  :”Itukan di Turki “. Maksudnya adalah, itukan di Turki, bukan di Indonesia. Sebuah pembantahan yang tidak saya duga, namun cukup masuk akal, karena yang mengatakannya adalah, Necmettin Erbakan, mantan perdana menteri Turki, yang juga orang Turki, sehingga pernyataannya khusus pada masalah Turki saja, begitu pikir teman saya itu.

Walau begitu, pernyataan Necmettin adalah pernyataan global, tidak untuk kasus Turki saja, dengan beberapa alasan, yaitu:

1. apa yang disampaikan oleh Necmettin dapat terjadi di semua negara. Dari isi pernyataannya :
 “Muslim yang tidak pedulikan politik, akan dipimpin oleh politikus yang tidak pedulikan orang  Islam”.  Muslim ada di banyak negara, selain di Turki, yang menjadi negara Necmettin, sehingga pernyataannya juga berlaku untuk wilayah lain.

2. Dari pernyataannya, Necmettin tidak menyebut atau bermaksud kepada kasus Turki saja, baik secara eksplisit maupun implisit, sehingga tujuannya adalah global, tidak spesifik.

3. Sangat banyak pernyataan yang disampaikan oleh tokoh dunia dari sebuah negara, namun pernyataannya tidak hanya untuk negaranya saja dan berlaku global, seperti pernyataan John F.Kennedy, presiden Amerika  era dulu, yang berbunyi : “Change is the law of life. And those who look only to the past or present are certain to miss the future”.

Sehingga, dari tujuan dan berlakunya pernyataan Necmettin tersebut, tidak khusus untuk Turki saja, namun juga untuk negara lain, seperti Indonesia.

Sekarang, bagaimana dengan kebenaran pernyataan Necmettin. Saya sendiri meyakini, pernyataannya mengandung kebenaran, terutama untuk negara yang menganut sistem pemilihan demokrasi yang penduduknya mayoritas Muslim seperti Turki dan Indonesia. Dalam demokrasi pada pemilihan pemimpin,  menganut hak pilih satu orang, satu hak pilih, sehingga setiap warga negara sangat menentukan siapa pemimpin yang akan dipilihnya.

Olah karena itu, sebagai seorang Muslim dan warga negara, kita harus peduli terhadap politik, siapapun kita, karena politik adalah cara untuk menguasai negara dan masyarakat, termasuk kehidupan pribadi warga negaranya dan memilih pemimpin daerah dan negara adalah unsur penting dari kehidupan politik. Yang lebih penting dari itu, karena memilih pemimpin Muslim adalah perintah Allah yang tertulis dalam Al-quran yang tertulis pada salah satu surat dan ayatnya yang sedang santer saat ini, yaitu : Al-maidah : 51.
Hai orang-orang yang beriman, janganlah kamu mengambil orang-orang Yahudi dan Nasrani menjadi pemimpin-pemimpin (mu);sebagian mereka adalah pemimpin bagi sebagian yang lain. Barangsiapa di antara kamu mengambil mereka menjadi pemimpin, maka sesungguhnya orang itu termasuk golongan mereka. Sesungguhnya Allah tidak memberi petunjuk kepada orang-orang yang Zalim (QS:Al-Maidah: 51).

Walau begitu, pemimpin yang beragama Islam, belum tentu juga peduli terhadap Umat Islam, sehingga kita memilih tidak hanya pemimpin yang beragama Islam, namun pemimpin beragama Islam yang peduli terhadap kondisi umat Islam, yang dapat dilihat dari track recordnya.


Salam,
Jakarta, Sabtu, 17 Desember 2016, bertepatan dengan 17 Rabiul Awal 1438 H, bertepatan juga dengan jadwal Leg 2 Final Piala AFF, Indonesia vs Thailand.


Akhmad Sofwan
----------------------------

Sumber image:
https://twitter.com/elfianems/status/729534280016101376

Sunday, August 14, 2016

Data Mining - The Opening words

This is the first article about Data Mining. This Data mining topic i create primarily for writing about my experiment in Data mining for my own documentation and for public as well . Hopefully, it is useful for others. Besides documenting my experiment,i also plan to write theory about Data Mining although perhaps not so detail.

I am an Indonesian and English is not my native language and in daily life i don't often use it . This blog is a place for me to practice English, especially in reading and writing with some topics including Data Mining and Spatial Data Mining, so please understand me if there are some writing-error within articles i write. Any suggestions and critics are welcome .


Friday, August 14, 2015

LetoDMS, a good choice in Document Management System

This morning, i and my partner went to a Government institution on central jakarta for made a presentation for our client's need in Document Management System (DMS).

What is DMS ?. DMS is a system (based on computer programs in the case of the management of digital documents) used to track, manage and store documents. There, we explained about LetoDMS, an open source DMS software including its features and its function and discussed about their needs. Alhamdulillah, they saw LetoDMS is a proper software for their needs although we need to modify in some places and i as a man in charge about software technical is responsible to make it work.

I choose an Open source as a first choice is, it is a fast way to explain about DMS rather than make a dummy software first, because we don't have yet a DMS product to present. If the client's need is not so far from what the software offer, i just need to modify it in a small effort but with high income :-). But if client's need is far for what the software offer, developing the software from scratch is considerable which the effort could be less than modify open source software with enormous modification and the price is adjusted, of course.

If you or your client need DMS software, i think LetoDMS is a good choice. Besides open source, it has a lot of features, such as :
- Create folders to group your documents
- Lock and unlock documents
- Set expiration-date for documents
- Download documents or view them online within your browser
- User and group management
- Multi language support

The Modification is not about adding new features or modify it but also need to hide or eliminate some existing unneeded features in LetoDMS for fulfill client's need. Oh ya, LetoDMS is based on PHP and Mysql and run in browser, so you need to familiar with PHP and Mysql to modify it. For further information about LetoDMS and Download the source code, you can visit www.letodms.com

Saturday, December 20, 2014

My dirty creek

I live in Petukangan Utara, Jakarta Selatan, a district area bordered with Jakarta Barat in north side  and Tangerang in west side. When i was a child, i was about 7 - 8 years old, about 28 years ago, i like played at creek with my friends, caught fish. The water is grey-brown indicate it that the water was not so dirty most contain mud and soil. Some kind of fish could still alive in it, such as Sepat (Trichogaster trichopterus), Julung-julung (Hemiramphus brasiliensis)and rice field Crab (Paranthelpusa Convexa) . At that time, trees and empty land is still wide including water absorption area and not so many houses built if comparing today, so that waste water from household still flowed well by creek with keeping it for fish life . The creek's condition quite well in general.

At that time, with the condition is still natural, i and my friends could caught fish,went fishing, played football and other games in space area, played on trees and caught dragonflies where found a lot at that time, because trees are still a lot.

Today, the creek water is very dirty, it is black moreover when in dry season, indicate it that no fish can live there anymore. It caused by more people live here and need more houses so human have to cut trees and space area is decreased also throw waste water more than previous years . In the other hand the creek capacity is still same or maybe less because mud sediment is growing. And it causes the water is black, not a habitat anymore for fish.

Some of surrounding area on the creek especially at the picture i took, is a campus area. Previously it is land owned by people, there are fish pools and garden but today a campus bought it and change fish pools become buildings, parking area,etc.

So, what's people's loss because that change environment including creek water change from low dirty to very dirty ?.
1. Fish are gone. Means food supply is decreased.

2. Clear land water is depleted fastly. When dry season in 3 months, households start difficult  to find it, digging land deeply is a must to find clear water. Clear water from water company has not come to this area.

3. Food supply from trees such as fruits and vegetables has decreased (Especially for land owner). So everything we need must buy.

4. Temperature is higher because trees are decreased.

5. Space area for children to play and human socializing is decreased too. Children have to play in street or rent a field to play futsal for example.

What will we do to overcome that ?
Build more buildings and streets is unavoidable because human number is growing and demanding more infrastructure moreover it is in Jakarta area, center of business and government,as we know, the infrastructure development is growing fastly but there are some steps we can do to make our environment still comfort. Some of them are :

1. Plant trees although in a small land or in plant's pot.
2. Create many reservoirs to absorb more water from rain
3. Create a wide green area per subdistrict / kecamatan . Actually it is a   government task.
4. Save clear water
5. Keep clean our environment including creek and river.

So, the importance to keep our environment green means make our life and our next generation life is sustainable and keep comfort because we are so dependent with our environment. Keeping our environment is keeping life itself.

Image : By myself. My dirty creek .

References :
1. en.wikipedia.org/wiki/sepat
2. id.wikipedia.org/wiki/Julung-julung
3. http://id.wikipedia.org/wiki/Yuyu

Thursday, April 03, 2014

How useful Master Degree in Computer Science for a Web Developer ?


This year, i am starting pursuing a master degree in Magister Ilmu Komputer (Master of Computer Science), Universitas Indonesia. I do it because my superior in IT Academy where i teach was urge me to get Master degree for keeping still eligible to teach in Higher Education institution including in my academy. Although my main job is not a lecturer but i like learning and teaching and i want try to keep interact with academy because academy is one of important source of knowledge and skill, so i try to enter University again to pursue master Degree and Alhamdulillah, this year , it is become reality.
   A master degree for a Lecturer is useful and a necessity regarding on Government provision, demanding lecturer to have Minimum Education is Master Degree.  What about for Web Developer like my main job ? How useful is it ?. Doesn't Web Developer doesn't require master degree for becoming it. An Employer or Client of Project today just need Bachelor Degree and more important thing, the web developer must be knowledgeable, skillful and have good portfolios rather than having master degree. No one require Web Developer must have Master Degree.
   Okay, today no one or almost no one require a web developer to have master degree but later if you have a higher position, like becoming a Project Manager or a Lead Developer, particularly for Big Project which come from big institution, i am sure, a master degree holder is more consider than other candidate, of course, experience, knowledge and skillful is already fulfilled.
   Another usage and the more important thing is knowledge enrichment and networking . In Master Program , like i am pursuing today, i am learning about more advanced theory in computer science, such as in Database Advanced and Machine Learning which i haven't got yet before.
  In database advanced, for example, i know  there are some index types in database, such as Be-tree and Hash Indexes. Before, i just know, database has index but what name of index, i did not know yet. Another new science i get is Machine Learning, which learn about some Algorithms to solve the problem based on data we have. They are useful and enrich my Knowledge as a web Developer, Freelance Web Developer exactly.
   A Web Developer often use Database, oftenly intermediate knowledge is enough but i am sure Advanced level is better to developing a better application.
   So, besides getting higher degree, knowledge and skill will increase, hopefully as a web developer. Networking is something useful. Knowing more people, friends and Great lecturers.
   And the last but not the least, hopefully studying continuously will become good point in The God's side

Source of Image : http://bahasa.cs.ui.ac.id/projects.php

Saturday, January 05, 2013

If we want to live in peace, get ready to war

Everybody loves peace including us but that doesn't mean other people not attack us because of certain reasons, including criminal, such as robbery and raping. Unfortunately, police is not always near us and get ready to help us.
For that reason, we need to protect ourselves from the attacker, which we can screaming for help, running away, using a weapon or using Martial art or maybe combine them.

Screaming for help is often effective to evict the attacker, especially if there are some concern people around us. Running away too, if we believe we can run fast and screaming for help in the same time. It can escape us from the attacker. But sometimes, the condition is not possible for us to scream and run away, for example, our house is robbed in the midnight while we can't scream or help because the robber force us to be quiet under a knife. At that time, only 2 ways we must choose, Be quiet and obey to what the robber said and can not do anything just see including they hurt one of our family member or struggle to paralyze them using Martial art but dare to take a risk, including die.
If we believe able to beat the Robber(s) and we brave enough, we can choose the latter.

Of course, hopefully, there is no one attack us including do something criminal to us, but There is no guarantee we will live in peace forever. That's why we need to alert, especially in certain condition, for example, when we are walking in a dark and quiet area alone.

Having skill and knowledge in martial art is something useful, not merely for defending ourselves , but also for health, get socialize and increase self confidence. But we have to make a lot practice and do it routine to make it useful. We can choose one of any Martial art suitable for us, such as Karate, taekwondo or Judo. For the beginner, a trainer is very important and we can join a club to get practise together under a/some trainers instruction.

Last, preventing is more important than curing for avoiding criminal such as, not wearing jewelry so many in a public area, which can tempting bad guys to steal or even rob us, stay away from criminals area especially if you are a woman and alone and Keep praying for The God's protection.

Image Source :
http://www.bowdoin.edu/security/crime-prevention-personal-safety/self-defense.shtml