Setup Oracle in Ubuntu

Step 1: Download Oracle Database Express Edition.

Step 2: Instructions before install Oracle

1. Copy the downloaded file and paste it in home directory.
2. Unzip using the command:

   unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip 
   

3. Install required packages using the command:

   sudo apt-get install alien libaio1 unixodbc
   

4. Enter into the Disk1 folder using command:

   cd Disk1/
   

5. Convert RPM package format to DEB package format (that is used by Ubuntu) using the command:

   sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
   

6. Create the required chkconfig script using the command:

   sudo pico /sbin/chkconfig
   

   The pico text editor is started and the commands are shown at the bottom of the screen. Now copy and paste the following into the file and save:

   #!/bin/bash
   # Oracle 11gR2 XE installer chkconfig hack for Ubuntu
   file=/etc/init.d/oracle-xe
   if [[ ! `tail -n1 $file | grep INIT` ]]; then
       echo >> $file
       echo '### BEGIN INIT INFO' >> $file
       echo '# Provides: OracleXE' >> $file
       echo '# Required-Start: $remote_fs $syslog' >> $file
       echo '# Required-Stop: $remote_fs $syslog' >> $file
       echo '# Default-Start: 2 3 4 5' >> $file
       echo '# Default-Stop: 0 1 6' >> $file
       echo '# Short-Description: Oracle 11g Express Edition' >> $file
       echo '### END INIT INFO' >> $file
   fi
   update-rc.d oracle-xe defaults 80 01
   

7. Change the permission of the chkconfig file using the command:

   sudo chmod 755 /sbin/chkconfig  
   

8. Set kernel parameters. Oracle 11gR2 XE requires additional kernel parameters which you need to set using the command:

   sudo pico /etc/sysctl.d/60-oracle.conf
   

9. Copy the following into the file and save:

   # Oracle 11g XE kernel parameters 
   fs.file-max=6815744  
   net.ipv4.ip_local_port_range=9000 65000  
   kernel.sem=250 32000 100 128 
   kernel.shmmax=536870912 
   

10. Verify the change using the command:

    sudo cat /etc/sysctl.d/60-oracle.conf 
    

11. You should see what you entered earlier. Now load the kernel parameters:

    sudo service procps start
    

12. Verify the new parameters are loaded using:

    sudo sysctl -q fs.file-max
    

    You should see the file-max value that you entered earlier.

13. Set up /dev/shm mount point for Oracle. Create the following file using the command:

    sudo pico /etc/rc2.d/S01shm_load
    

14. Copy the following into the file and save.

    #!/bin/sh
    case "$1" in
    start)
        mkdir /var/lock/subsys 2>/dev/null
        touch /var/lock/subsys/listener
        rm /dev/shm 2>/dev/null
        mkdir /dev/shm 2>/dev/null
    *)
        echo error
        exit 1
        ;;
    
    esac 
    

15. Change the permissions of the file using the command:

    sudo chmod 755 /etc/rc2.d/S01shm_load
    

16. Now execute the following commands:

    sudo ln -s /usr/bin/awk /bin/awk 
    sudo mkdir /var/lock/subsys 
    sudo touch /var/lock/subsys/listener
    

    Now, Reboot Your System

Step 3: Install Oracle

1. Install the oracle DBMS using the command:

   sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb
   

2. Configure Oracle using the command:

   sudo /etc/init.d/oracle-xe configure 
   

3. Setup environment variables by editting your .bashrc file:

   pico ~/.bashrc
   

4. Add the following lines to the end of the file:

   export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
   export ORACLE_SID=XE
   export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
   export ORACLE_BASE=/u01/app/oracle
   export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
   export PATH=$ORACLE_HOME/bin:$PATH
   

5. Load the changes by executing your profile:

   . ~/.profile
   

6. Start the Oracle 11gR2 XE:

   sudo service oracle-xe start
   

7. Add user YOURUSERNAME to group dba using the command:

   sudo usermod -a -G dba YOURUSERNAME
   

Step 4: Using the Oracle XE Command Shell

1. Start the Oracle XE 11gR2 server using the command:

   sudo service oracle-xe start
   

2. Start command line shell as the system admin using the command:

   sqlplus sys as sysdba
   

   Enter the password that you gave while configuring Oracle earlier. You will now be placed in a SQL environment that only understands SQL commands.

3. Create a regular user account in Oracle using the SQL command:

   create user USERNAME identified by PASSWORD;
   

   Replace USERNAME and PASSWORD with the username and password of your choice. Please remember this username and password. If you had error executing the above with a message about resetlogs, then execute the following SQL command and try again:

   alter database open resetlogs;
   

4. Grant privileges to the user account using the SQL command:

   grant connect, resource to USERNAME;
   

   Replace USERNAME and PASSWORD with the username and password of your choice. Please remember this username and password.

5. Exit the sys admin shell using the SQL command:

   exit;
   

6. Start the commandline shell as a regular user using the command:

   sqlplus
   

   Now, you can run sql commands…

Kapankan kita harus mempergunakan ERP?

ERP

bila anda merasa memerlukan waktu lebih dari 3 haru untuk membuat 1 form dataentry + 1report
bila anda merasa team anda sudah menjadi saingan anda (team work yang memegang konsep sendiri-sendiri)
bila anda terlalu sering melakukan perubahan struktur pada table database
bila aplikasi anda sudah melebihi 400 MB ketika berjalan
bia teamwork anda memiliki bhs pemerograman yang berbeda beda
bia database pada tempat anda banyak (orace/mysq,excell)
bila anda tidak bisa membuat 1 form + 1 report daam waktu sejam sesudah meeting
bila memory nebook anda 2GB dirasa kurang
bila anda berfikir harus cari compiler terbaru atau vcl terbaru

komponent yang dipakai disisi server
1. datasnap
2. Java J2EE

komponent apa yg kita pakai di client dephi
1. idhttp dari indy
2 cientdataset
3. twebbrowse atau tchromium
4. report boleh pake fastreport/report builder atau tidak
seebihnya standart tdbedit,tdbgrid

Persamaan Akuntansi

ASET + BIAYA = KEWAJIBAN + MODAL + PENDAPATAN

 

• ASET apabila bertambah akan dicatat disebelah Debet dan apabila berkurang akan dicatat disebelah kredit.
• BEBAN/BIAYA apabila bertambah akan dicatat disebelah Debet dasn apabila berkurang akan dicatat disebelah Kredit.
• KEWAJIBAN apabila bertambah akan dicatat disebelah Kredit dan apabila berkurang akan dicatat disebelah Debet.
• MODAL apabila bertambah akan dicatat disebelah Kredit dan apabila berkurang akan dicatat disebelah Debet.
• PENDAPATAN apabila bertambah akan dicatat disebelah Kredit dan apabila berkurang akan dicatat disebelah Debet.