This Wiki is read-only for reference purposes to avoid broken links.

Database

For Our application we will install Oracle Database or PostgreSQL Database.
You can download the database from
- For Oracle - http://www.oracle.com/index.html
- Once downloaded, double click on the executable file and follow the steps to install Oracle.
- For PostgreSQL - http://www.postgresql.org/
- Once downloaded, follow the instructionsto get your PostgreSQL configure
Use adempiere as system password.

Java JDK

For our application we will also need to install Java JDK (1.5.0) or the latest version.
You can download the file from Sun Microsystems
Double click on the executable file and follow the instructions to install Java on your machine.
After installing the Java JDK, set the Java Home.
- For this, right click on My Computer.
- Go to Properties.
- Then go to Advanced tab, in the System Properties.
- Go to System Variables and say new.
- Enter in the variable name field JAVA_HOME (in caps letters).
- Enter in the variable value C:\Progra~1\Java\jdk1.5.0_07 or the folder you have install the Java JDK.

Go to your command prompt (Run cmd)
Go to Oracle interface. To do so type dbca in your command prompt.
Oracle interface will appear.
Choose create a database
Give your database a valid name (sid)
Note that the password used to create databases are always compiere there you give as password adempiere
Click on next and continue. Leave everything as default.
Don't forget to record the database name when you create it.

In your command prompt, (cmd) enter the following(Note: the space is required between sqlplus and the slash):
sqlplus /nolog
You will be forwarded to sql interface
Remember that we will use as password adempiere and here the dbname is the name that you recorded when you created you database
Type in(italic has to be replaced by actual password, dbname and username here adempiere, except for Oracle XE where the dbname is xe):

               connect system/password@dbname

               create user username identified by password;

               grant resource, connect, dba to username;

Before this procedure make sure you have a dump to import. This is generally available on the server.
Copy paste the dump in somewhere easy to access (on the desktop for example)
In the console view type in

               imp username/password@dbname

Then console will ask you the path of the file to import. Type in the path
For example if you paste it on the desktop, write desktop/cleandb.dmp
Press enter.
Leave all the requests default except Import entire export file where you put yes
Then Press enter an the file will be imported