Difference between revisions of "Initialize the ADempiere Database"
(→PostgreSQL) |
m (→Start with Database Creation) |
||
Line 18: | Line 18: | ||
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. | 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. | To start, open a console window and go to this directory. Verify the Adempiere.dmp file is located there. | ||
+ | |||
+ | For Linux users: it is irrelevant under which user you have to log on to create the database. | ||
=== Oracle === | === Oracle === |
Revision as of 08:49, 18 May 2007
Contents
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:
- Database supported by ADempiere
- Java JDK1.5.x
- ADempiere Server Installation
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.
For Linux users: it is irrelevant under which user you have to log on to create the database.
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 ==
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.
At the process end, you should see: no (error) rows selected
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.
If you receive an error that psql is not recognized, be sure to have added the directory Be sure that the directory C:\Program Files\PostgreSQL\8.2\bin to the classpath.
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)
- Please make sure that the tablespaces for the database user Adempiere exist. The Default database tablespace names are:
Links
- Complete ADempiere Server Install is the next thing after Create ADempiere Database.
- Initial Client Setup is the starting business setup within ADempiere.
- Installing ADempiere Tutorial on how to setup and configure ADempiere.
- Tutorials on many things from basic to advanced.