:: Life to be True ::

Oracle merupakan database sistem yang handal, atau lebih dikenal dengan RDBMS.
Dari awal saya mengenal oracle atau sekitar tahun 1999, oracle merupakan sistem database yang cukup sulit di install pada sistem operasi Linux, saya inget pertama kali mencoba menginstall oracle 8i pada sistem operasi Slackware dengan penuh cucuran keringat darah plus pusing-pusing kepala… masa lalu kita lupakan.

Setelah sekian lama saya mengenal Oracle saya baru mengetahui ternyata ada Oracle versi Expessnya..
Atau lebih kenal dengan Oracle XE (Expess Edition), sistem database ini pada release terakhirnya berbasis pada Oracle 10g release 2 atau 10.2.0.1

Saya mencoba untuk menginstall Oracle diatas sistem operasi Linux RHEL 5.0, sebelum melakukan installasi pastikan bahwa swap memory pada sistem linux anda adalah minimal 1024MB, dan disarakan physical memory adalah 512MB untuk development atau 1GB untuk production.

Untuk source installer Oracle XE dapat anda download disini.

Berikut ini adalah installasi Oracle XE pada sistem operasi Linux RHEL :

[root@erp deni]# rpm -ivh oracle-xe-10.2.0.1-1.0
error: open of oracle-xe-10.2.0.1-1.0 failed: No such file or directory
[root@erp deni]# rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm
Preparing… ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing Post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to
configure the database.

atau bila tidak memerlukan preparation dapat dilakukan dengan perintah :

[root@erp deni]# rpm -ivh –nopre oracle-xe-10.2.0.1-1.0.i386.rpm

Setelah itu akan kita lakukan konfigurasi database dengan perintah :

[root@erp deni]# /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8081

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y

Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8081/apex”

lalu untuk menjalannya pake perintah
[root@erp deni]# /etc/init.d/oracle-xe start
Starting Oracle Database 10g Express Edition Instance.
Done!

dan hasil nya bisa dilihat pada layar gambar berikut:

Have fun bila ada yang mau mencobanya..:)

Rbl mungkin udah dikenal sejak dulu waktu masih di kampus, tapi semua itu running di atas postfix
kali ini mencoba rbl di atas exim bawaan dari Cpanel, ternyata akhirnya nemu link berikut
yang bisa di jadikan referensi dan kebetulan berbahasa indonesia…
http://www.giest.org/2007/01/07/spam-filter-exim-cpanel.html

Setelah mengikuti tahap-tahap yang ada pada blog tersebut, akhirnya dengan mengetes kirim email ke nelson-sbl-test@crynwr.com maka dari email tersebut akan mendapat balasan seperti dibawah ini :

Testing your SBL block. See http://www.crynwr.com/spam/ for more info.
Please note that this test will not tell you if your server is open for
relaying. Instead, it tests to see if your server blocks email from IP
addresses listed in various blocking lists; in this case, the SBL list.

Here’s how the conversation looked from sbl.crynwr.com.
Note that some sites don’t apply the SBL block to postmaster, so
I use your envelope sender as the To: address.

I connected to 202.67.15.138 and here’s the conversation I had:

220-server.arsena.biz ESMTP Exim 4.68 #1 Thu, 04 Oct 2007 13:39:15 +0700
220-We do not authorize the use of this system to transport unsolicited,
220 and/or bulk e-mail.
helo sbl.crynwr.com
250 server.arsena.biz Hello sbl.crynwr.com [192.203.178.107]
mail from:<>
250 OK
rcpt to:
550-Message rejected because sbl.crynwr.com [192.203.178.107] is blacklisted at
550 sbl.spamhaus.org see http://www.spamhaus.org/SBL/sbl.lasso?query=SBL230 :
Terminating conversation

Sip beres juga akhirnya…:)

Maybe this trick is old but it’s usefull for multiclient in windows XP..
I was copy from here

If you have ever used a real remote computer system like Citrix, then you have probably been craving multiple Remote Desktop sessions since you first fired up Windows XP Professional and/or Media Center Edition. Here is a HACK (translated: USE AT YOUR OWN RISK), to enable multiple Remote Desktop sessions on your XP:

NOTE: You will have to have knowledge of the Windows operating system and more specifically the Windows Registry. If you have no experience with the registry, then I would recommend you find someone who does or leave these alone. I do not make any kind of warranty that this will work for you or your friends. This is provided for entertainment purposes only. Don’t call me if your computer stops working. Got it?

1. Print these directions so that you have them to work from.
2. Restart your computer in Safe Mode - Follow this link to learn how to restart Windows XP in Safe Mode
3. Turn off/disable Remote Desktop Connection (RDC) and Terminal Services

1. Right click My Computer
2. Select Properties
3. Click on the Remote tab at the top of the window
4. UNCHECK the box next to, “Allow users to connect remotely to this computer“
5. Click OK
6. Go to Start -> Control Panel -> Administrative Tools -> Services
7. Find Terminal Services in the list
8. Right click on Terminal Services and click Properties
9. In the Startup Type box, select Disabled
10. Click OK to close the window

# Next you will replace the current version of the Terminal Services DLL (termsrv.dll) with an unrestricted version from a previous release of Terminal Services.

1. Here is a copy of the Terminal Services DLL - Save it to your Desktop or other suitable location
2. Using a file manager like Windows Explorer open C:\Windows\system32\dllcache
3. Rename the file termsrv.dll to termsrv_dll.bak or whatever you would like.
4. Copy the downloaded termsrv.dll file (the one you just downloaded from the web) to C:\Windows\system32\dllcache
5. Open the C:\Windows\system32 folder
6. Delete the file termsrv.dll in C:\Windows\system32

# Now we can edit the Windows Registry to enable more than one RDP connection. Go to Start -> Run and type regedit - Hopefully you knew that already
# Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\Licensing Core
# Add a DWORD Key named EnableConcurrentSessions and give it a value of 1
# Close the Registry Editor window
# Go to Start -> Run and type gpedit.msc to run the Group Policy Editor
# Browse to Computer Configuration -> Administrative Templates -> Windows Components -> Terminal Services and double click Limit number of connections
# Select the Enabled button and enter the number of connections you would like to enable….at least 2.
# Restart Windows
# Right click My Computer and select Properties.
# Click on the Remote tab at the top of the window
# CHECK the box next to, “Allow users to connect remotely to this computer“
# Click OK
# Go to Start -> Control Panel ->Administrative Tools -> Services. Select Terminal Services from the list and double click it or right-click -> Properties. Set the Startup Type to Manual.
#
# Restart Windows/Computer

Have fun..

SSH merupakan aplikasi yang aman untuk melakukan remote server, terutama pada server berbasis Unix, walaupun sekarang telah ada ssh server untuk Microsoft .aka. windows, cuma fasilitas ini tidak populer untuk windows hehe..

Aplikasi SSH ini sangat bermanfaat untuk seorang Network Administrator atau System Administrator
untuk melakukan configurasi server atau peralatan jaringan yang bisa dilakukan secara remote, selama ini apabila saya ingin melakukan hal tersebut saya harus melalui komputer/laptop, akan tetapi sejak adanya barang yang bernama M600i dari SE dimana OS yang terinstall pada barang tersebut adalah Symbian OS UIQ3.

Secara default aplikasi yang terinstall pada barang ini tidaklah banyak, jadi apabila ingin melakukan remote server dengan menggunakan SSH kita perlu menginstall ssh client, untuk itu yang saya kenal adalah putty, setelah cukup lama saya menunggu akhirnya muncullah aplikasi tersebut yang berbasis OS Symbian UIQ3, apabila ada yang minat dapat mendownload disini.

Untuk pengalaman saya dalam mempergunakan SSH tersebut tunggu di postingan blogs saya berikut nya