This Wiki is read-only for reference purposes to avoid broken links.
- For Our application we will install Oracle 10g.
- You will be able to find the application on the server.
- Double click on the executable file and follow the steps to install Oracle.
- Use system as password.
- For our application we will also need to install Java JDK (1.5.0) or the latest version.
- You will be able to find the application on the server or 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.
Creating a New database
- 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 adempiere 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.
Creating a User
- 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):
- The system should tell you that it is connected
create user username identified by password;
- The system should tell you that user has been created
grant resource, connect, dba to username;
- The system should tell you that resource has been granted
- This done type exit to go back to the console
Importing a database
- 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
- 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
Deploying the Application
- Now that you have imported a database, we are ready to deploy the application.
- Generally a file will be available on the server whose name is: Adempiere.zip
- Copy the file and paste it under c:
- Then extract the file into c:
- You will have a new file called Adempiere
- Go in Compiere2 and run the file RUN_SetupTMK.bat but before deploying make sure that the war on this Application is the one to be install. Generally its not, therefore follow the steps in Replacing a War Method one to replace the war
- This may take some minutes
- You will have the ADempiere screen appearing. In the Application server field enter the IP of the machine, in the database server enter the IP of the machine. Then choose the database that you have created and don't forget to put the password(adempiere in our case). Click on Test to see whether there is no error, then click on Save.
- Then in folder utils you will find RUN_tServer2.bat and RUN_Server2Stop.bat. Create shortcuts on the desktop for them and then double click on Start server to start the Application.
Replacing a War
- There are 2 methods to replace a war.
- The first method generally requires you to Run the Setup again therefore it is appropriate when you have not yet run the setup
- The Second method is if you don't want to run the setup again.
- Under Adempiere, go to dcslib.
- There you will find a file posterita.war. Copy and paste it somewhere as a backup and replace it with the new war provided.
- Then Run the setup
- Under Adempiere/Jboss/server/adempiere/deploy, copy paste the new war.(It is a good practice to save the old posterita.war as a backup)
- Then under temp/deploy , delete the folder deploy and under work/../posterita, delete the folder posterita
- Congratulation the war has been replaced.
- No need to run the setup in this case.