среда, 22. април 2009.

Import *.dmp into Oracle 10g XE Application Express on Linux Ubuntu 8.04

Using OS Linux Ubuntu 8.04 with install Oracle 10g XE application express, database users can imports *.dmp files, setting environmetn on this way>
0) instal *.deb file Oracle app expres and create user (in this samples user is adempiere and password is adempiere)
1) on terminal type> sudo gedit /etc/environment
2) set this environment>
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/lib/jvm:/home/nadrog:/home/nadrog/jdk1.6.0_11/bin:/home/nadrog/Adempiere/lib"
JAVA_HOME="/home/nadrog/jdk1.6.0_11"
JAVA="/home/nadrog/jdk1.6.0_11/bin/java"
CLASSPATH="/usr/lib/jvm:/home/nadrog"
JAVA_OPTS="-server -Xms128m -Xmx128m -Dprogram.name=run"
JRE_SRCROOT="/usr/lib/jvm/java-6-sun-1.6.0.07/bin/javaws"
ADEMPIERE_HOME="/home/nadrog/Adempiere"
JBOSS_HOME="/home/nadrog/Adempiere/jboss/lib"
COMPIERE_HOME="/home/nadrog/Compiere2"

3) restart PC and again on terminal type> sudo gedit /etc/environment
and add this environment
ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
ORACLE_SID="XE"
Restart PC and then type from terminal

nadrog@nadrog:~$ su oracle
Password:
To run a command as administrator (user "root"), use "sudo ".
See "man sudo_root" for details.

oracle@nadrog:/home/nadrog$ .
bash: .: filename argument required
.: usage: . filename [arguments]
oracle@nadrog:/home/nadrog$ cd Desktop
oracle@nadrog:/home/nadrog/Desktop$ cd..

oracle@nadrog:~/app/oracle$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp adempiere@adempiere

Figure 1> Import dmp files into Oracle Application Express
10g XE

петак, 17. април 2009.

Adempiere 3.52 Oracle Application Express10g

Adempiere 3.52 is smart Enterprise Resource planning system, and offer good support for management and all enterprise activity.
Main page looking like above>
Figure 1> Main page Adempiere smart ERP system
Oracle Application Express 10g is database and have relation tables

Figure 2> AD_MENU table with attributes
Figure 3> Main Window and product setup
Figure 4> Main window and Financial setup
Figure 5> Wirh Oracle 10g need setup users, login as SYSTEM and PASSWORD from installations, and setup ADEMPIERE/ADEMPIERE
Figure 6> Setup ADEMPIERE/ADEMPIERE on Oracle Apex,
Figure 7 > Imports of Adempiere.dmp file into user Adempiere
This is installation Adempiere smart ERP on Windows platform