Compiere ERP + CRM Business Solution / Discussion / An Open Discussion: Best compiere Install server

Hi there!

after trying to fix compiere in fedora, red hat AS3 and windows, i would like to ask you, what's in your opinion the best possible install in terms of stability, functionality and easy of use.

my wish is to choose a linux server but I wasn't able to install with exit oracle 9i2 in both fedora or red hat.

so my question is:

Wich linux OS (and wich version): Fedora, red hat, suse...
Wich oracle version: 9.0.2.4......
Wich Compiere verion: 2.5c, 2.5b...

I understand that everyone will have their own opinions but I'm sure there is a good one for a non experimented linux guy like me.

and yes, I followed the steps in of Mr Puschitz and others, but after of couple of weeks trying, I thing something is missing.

Hi, Roger,

this are my steps:

-A clean suse 9.0
don't install Java SDK NOW!
as root do:

-The oracle cds together in /opt/OracleCDs
-group dba, group oinstall
-user oracle as member of oinstall with homedirectory /home/oracle

-make a directory tree like /u01/app/oracle/OraHome1
-make the oracle owner of this tree und all subfolder
[if you receife a error during (later) oracle installation looking like ...no permission or no rights... than make again oracle owner of the directory tree /u01 ... with all subfolders]

-add lines of TEXT1 to the File /etc/init.d/boot.local
-copy SCRIPT2 to /root [make it executable]
-copy SCRIPT3 to /home/oracle [make it executable]
-maybe you want to change the SID in this two script

-until Oracle runs proper [I mean reboot and start it again] modify SKRIPT2 like this: toggle of all about Java - you can use it later again

-restart linux login as oracle, run oracle installer
-install oracle
-> oracle as for a group? take oinstall
-> oracle ask for directory like /usr/lib? copy oracle's sugesstion
-modify etc/oratab like: *:/u01/app/oracle/OraHome1:N
erp2:/u01/app/oracle/OraHome1:Y
-copy u01/...OraHome1/dbs/init.ora to init[your SID here].ora into the same folder

now oracle shoud run propperly [after you start it via shell]

-restart
install JAVA SDK, modify in SCRIPT2 the paths to your java
-install Compiere under /Compiere2 and let it run once, than download sources [and all additional libs!!!] and modify to your own pleasure

TEXT1:
################################
#
# Oracle 9i

echo 2147483648 >        /proc/sys/kernel/shmmax
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 65536 >             /proc/sys/fs/file-max
ulimit -n 65536
echo 1024 65000          proc/sys/net/ipv4/ip_local_port_range
ulimit -u 16384

SCRIPT2: script name is .bash_profile

#! /bin/sh
#
############################################### allgemein ########
##################################################################
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib

############################################### oracle ###########
##################################################################
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/OraHome1
export DBHOME=$ORACLE_HOME/bin/dbhome
export ORAENV=$ORACLE_HOME/bin/oraenv
export CORAENV=$ORACLE_HOME/bin/coraenv
export ORACLE_SID=erp2
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm

###oracle LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

###oracle PATH:
export PATH=$PATH:$ORACLE_HOME/bin

############################################### java #############
##################################################################
export JAVA_ROOT=/usr/lib/java
export JAVA_HOME=/usr/lib/java
export JRE_HOME=/usr/lib/java/jre
export JAVA_BINDIR=/usr/lib/java/jre/bin

###java LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$JAVA_HOME/lib:$JRE_HOME/lib

###java PATH:
export PATH=$PATH:$JAVA_HOME/bin:$JRE_HOME/bin

###java CLASSPATH:
export CLASSPATH=$CLASSPATH:$JRE_HOME/lib/rt.jar:$JAVA_HOME/lib/tools.jar

############################################### compiere #########
##################################################################
export COMPIERE_ROOT=/
export COMPIERE_HOME=/Compiere2
export COMPIERE_INSTALL=/install
export COMPIERE_BASE=/root/build_work/compiere/compiere-all
export COMPIERE_SOURCE=/root/build_work/compiere/compiere-all

###compiere LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$COMPIERE_SOURCE/lib

###compiere PATH:
export PATH=$PATH:$COMPIERE_SOURCE/bin

############################################### compiere lib's ###
##################################################################
export ANT_HOME=/root/build_work/compiere/lib_for_compiere/apache-ant/apache-ant-1/apache-ant-1.6.1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ANT_HOME/lib
export CLASSPATH=$CLASSPATH:$ANT_HOME/lib/ant.jar

export COMMONS_HOME=/root/build_work/compiere/lib_for_compiere/commons net/commons-net-1.2.1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$COMMONS_HOME

export JAP_HOME=/root/build_work/compiere/lib_for_compiere/jap
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$JAP_HOME

export NETREXX_HOME=/root/build_work/compiere/lib_for_compiere/netrexx/NetRexx
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$NETREXX_HOME/lib
export CLASSPATH=$CLASSPATH:$NETREXX_HOME/lib/NetRexxC.jar

export ORO_HOME=/root/build_work/compiere/lib_for_compiere/oro/jakarta-oro-2.0.8
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORO_HOME
export CLASSPATH=$CLASSPATH:$ORO_HOME/jakarta-oro-2.0.8.jar

export XDOCLET_HOME=/root/build_work/compiere/lib_for_compiere/xdoclet/xdoclet-1.1.2
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$XDOCLET_HOME/lib
export CLASSPATH=$CLASSPATH:$XDOCLET_HOME/lib/xdoclet.jar
export CLASSPATH=$CLASSPATH:/root/build_work/compiere/lib_for_compiere/xdoclet/xdoclet-1.2.1/lib/xdoclet-ejb-module-1.2.1.jar

export COMPIERE_ENV=Y

export KEYTOOL_PASS=compiere
export KEYTOOL_DNAME="CN=john, OU=dow, O=macrosofts, L=Heidelberg, ST=Texas, C=DE"
export KEYSTORE_DIR=$COMPIERE_SOURCE/keystore
export KEYSTORE=$KEYSTORE_DIR/myKeystore

############################################################
#######use in shell:
#Create own key plus sign, export and check.
# keytool -genkey -keyalg rsa -alias compiere -dname "$KEYTOOL_DNAME" -keypass $KEYTOOL_PASS -validity 365 #-keystore $KEYSTORE -storepass $KEYTOOL_PASS
# keytool -selfcert -alias compiere -dname "$KEYTOOL_DNAME" -keypass $KEYTOOL_PASS -validity 365 -keystore # $KEYSTORE -storepass $KEYTOOL_PASS
# keytool -export -keystore $KEYSTORE -alias compiere -storepass $KEYTOOL_PASS -file $KEYSTORE_DIR/compiere.cer
# keytool -list -keystore $KEYSTORE -storepass $KEYTOOL_PASS
# keytool -printcert -file $KEYSTORE_DIR/compiere.cer

SCRIPT3: script name is also .bash_profile

#! /bin/sh
#
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/OraHome1
export DBHOME=$ORACLE_HOME/bin/dbhome
export ORAENV=$ORACLE_HOME/bin/oraenv
export CORAENV=$ORACLE_HOME/bin/coraenv
export ORACLE_SID=erp2
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

###oracle PATH:
export PATH=$PATH:$ORACLE_HOME/bin

Best compiere Install server

Forums

Help

Best compiere Install server

Best compiere Install server

Forums

Help

Best compiere Install server document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Best compiere Install server