Initialize the ADempiere Database

From ADempiere
Revision as of 23:51, 5 April 2007 by MarkCity (Talk) (PostgreSQL)

Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

README

  • Further requests for assistance please direct to the HELP Forum. This wiki provides only written and publishable support.
  • Further private, local, or commercial assistance can be sought at World-wide Directory where consultants all over register themselves. The fee charges are up to the respective consultants and under their own responsilibity or control.
  • Please adhere to our bazaar etiquette to enjoy better support from us.

Introduction

This Create Database HELP is for create the database for your ADempiere installation. After this you can Complete ADempiere Server Install.

Pre-requisite Utilities

Before starting with the database creation, you should have the following installed:

Start with Database Creation

The ADempiere initial database is into the Adempiere.dmp file, located at $ADEMPIERE_HOME/data directory; this file contains the seed database for your ADempiere installation. To start, open a console window and go to this directory. Verify the Adempiere.dmp file is located there.

Oracle

Run the script RUN_ImportAdempiere (.bat or .sh in directory './utils'). You will see information about adempiere.dmp file (such as date creation, size, etc.) and the message: == The import will show warnings. This is Ok ==

CD Run ImportAdempiere.PNG

Press any key to start the process or Ctrl-C to cancel.

No worry if you see some warnings (such as Warning: object created with compilation warnings) ; this is normal and you can ignore it. After the import program, a SQL procedure makes sure that everything is imported correctly and will list all invalid objects if they exists.

CD Run ImportAdempiere2.PNG

At the process end, you should see: no (error) rows selected

CD Run ImportAdempiere3.PNG

Sharad Sharma In case or error in installing Oracle database or to deinstall Oracle Pls follow this like

http://download-east.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#CIHDDHJD

PostgreSQL

Same as the Oracle step above.Note that the database dump for PostgreSQL is Adempiere_pg.jar and Adempiere_pg.dmp.

Reference for import PostgreSQL: How To Install On PostgreSQL / WinXP (Bepivin) See Step 14.

Next Step

The next step is Complete ADempiere Server Install.

Notes

  • Be careful: the script RUN_AdempiereImport DROP the database, so if you run the script all your datas will be losed!. Don't execute this script if you have data and you need for them.
  • For Oracle Users:
    • Please make sure that the tablespaces for the database user Adempiere exist. The Default database tablespace names are:
      • default tablespace= USER (150 MB, 10 MB Autoextend),
      • index tablespace= INDX (100 MB, 10 MB Autoextend),
      • temporary tablespace= TEMP (100 MB, 10 MB Autoextend).
    • The setup script have been changed to use the EZCONNECT naming method instead of TNSNAMES. Open your Oracle Net Manager, under profile -> Naming, make sure EZCONNECT is one of the selected methods. Alternatively, verify that the SQLNET.ORA file have the following entries: NAMES.DIRECTORY_PATH = (EZCONNECT,TNSNAMES)

Links