среда, 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

Нема коментара: