Automated Redhat9 Compiere start

2003-11-26
2013-05-02
  • Hello,

    I'm looking for a script which allows in Linux Redhat 9 an automated start for :
    1) Oracle 9ir2
    2) Compiere 2.5 c

    I have seen and followed the excellent and brillant installation description  from Jaume Tauxi but dedicated to Debian.

    Thanks in advance

    Alain

     
    • Datawoo Admin
      Datawoo Admin
      2003-11-26

      Hi Alain,

      The following works for me. As an FYI... I removed the oracle apache startup commands.

      Cheers,
      Scott

      #!/bin/bash
      #
      # Startup script for the Oracle Database Server
      #
      # chkconfig: - 85 15
      # description: Oracle Database Server
      #
      # Source function library.
      . /etc/rc.d/init.d/functions

      #compiere environment
      export COMPIERE_HOME=/opt/Compiere2
      export JAVA_HOME=/usr/java/j2sdk1.4.1_05
      export JJ_PASSWORD=mypassword

      #oracle environment
      export ORACLE_HOME=/opt/oracle/product/9.2.0
      export PATH=$ORACLE_HOME/bin:$PATH
      export export NLS_LANG=AMERICAN
      export ORACLE_SID=TAGDEV

      export DISPLAY=:0
      oracle_user=oracle

      case $1 in
        start)
        # start listener, apache and database
        su - "$oracle_user"<<EOF
          lsnrctl start
          sqlplus /nolog<<EOL
            connect / as sysdba
            startup
      EOL
      EOF
      ;;
      stop)
        # stop listener, apache and database
        su - "$oracle_user"<<EOF
          lsnrctl stop
          sqlplus /nolog<<EOL
            connect / as sysdba
            shutdown immediate
      EOL
      EOF
        ;;
        *)
        echo "Usage: ora9ip [start|stop]"
        ;;
      esac

       
    • Datawoo Admin
      Datawoo Admin
      2003-11-26

      Woops. You'll want to put the following commands (or something similar) after oracle starts and prior to oracle shutdown.

      # Start the Compiere Server

      /usr/bin/su - root -c "/opt/Compiere2/utils/RUN_Server2.sh &"

      # Stop the Compiere Server

      /usr/bin/su - root -c "/opt/Compiere2/utils/RUN_Server2Stop.sh &"

       
    • jaume teixi
      jaume teixi
      2003-11-26

    • Hi guys,

      Thanks  a lot but it doesn't work on my side.
      I will try again !

      Cheers,

      Alain

       
  • Can someone help me to provide oracle and compiere startup script.
    OS:Fedora core 6
    Database: Oracle standard 10g 1

    Thanks a lot.

     
  • I forgot to mention that our compiere and oracle database are in two different server.