1. Oracle
Database
1.1 Install
Oracle Database
1.2 Uninstall
Oracle Database
2. Prepare
database for qAutomate
2.1 Create
database account for creating qautomate database
2.2 Generate
qautomate database
3. Deploy
qAutomate webservice
4. Configure
qAutomate
5. Export
and import database from one machine to other
5.1 Export
database
5.2 Import
database
1. Oracle Database
1.1 Install Oracle Database
Download
Oracle 11g R2 to get Oracle resource files (win64_11gR2_database_1of2.zip and
win64_11gR2_database_2of2.zip)
Extract
these files on our computer then go to extracted folder and click Setup.exe,
Installer window is opened as below:
At
“Configure Security Update” step, do not need to enter email and password,
click “Next >” button
On
“Email address not specified” dialog, click “Yes” button.
At
“Select installation option” step, select “Create and configure a database”
then click “Next >” button.
At “System Class” step,
select “Server Class” then click “Next >” button.
At “Grid installation
Options” step, select “Single instance database installation” then click “Next
>” button.
At “Select install type”
step, select “Typical install” then click “Next >” button.
At “Typical install
configuration” step, enter Oracle database paths, Global database name and
password (this password is used to connect to Oracle database as SYSTEM role),
click “Next >” button.
Wait for “Prerequisite
Checks” step completes, at “Summary” step, click “Finish” button.
Wait for “Install product”
step completes, click “Close” button at “Finish” step.
After we install Oracle
database completely, we can jump to Section
2 to prepare database for qAutomation. Section
1.2 is just used to uninstall Oracle database when we need.
1.2 Uninstall Oracle Database
-
Firstly, open Oracle Universal Installer (OUI) following the
path Windows > All Programs > Oracle - OraDb11g_home1 > Oracle
Installation Products > Universal Installer.
On OUI window, click “Deinstall Products…” button. Check “Oracle
Database 11g 11.2.0.1.0” checkbox, click “Remove…” button.
Then click “Yes” button on Confirmation dialog. Wait for
process is completed, then click “Close” button to close OUI window.
-
Secondly, Run regedit.exe, delete
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key (This contains registry entires for all
Oracle products.).
-
Thirdly, delete all
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle.* key (all keys
that start with Oracle).
-
If your machine is 64-bits Windows, delete
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE key (if any)
-
After that we have to reboot our machines.
-
Delete “D:\app” directory. (This is the place store Oracle
Base that we install Oracle in Section
1.1).
-
Delete “C:\Program Files\Oracle” directory.
-
Empty all contents in “C:\TEMP” directory.
-
Empty all contents in “C:\Users\<username>\AppData\Local\Temp”
-
Delete Oracle - OraDb11g_home1 in start menu (following path Windows
> All Programs).
-
Empty recycle bin.
Then Oracle database is
removed successfully from our machine.
2. Prepare database for qAutomate
2.1 Create database account for creating qautomate database
Connect to
Oracle Database:
-
Run cmd, enter command sqlplus
-
Enter user-name: system
-
Enter password: password that we use when installing Oracle
database.
On SQL console, enter
commands:
-
connect sys AS SYSDBA
-
Enter password: password that we use when installing Oracle
database.
-
create user <our user> identified by <our
password>;
-
grant SYSDBA to <our user>;
Then we see result in below
picture
2.2 Generate qautomate database
Get database_generate.zip
from the path D:\Project Name\Automation folder. Extract then go to the extract folder,
we edit the file wipeout.bat
We change <password>
by password of Oracle database system, <our user> by user and <our
password> by password that we enter
into SQL console. For example:
After that we save this file
and double-click on this file to generate database. Then database is
successfully generated
3. Deploy qAutomate webservice
This part is for those who want to
set up their own web server and deploy completely new qAutomate web service.
Precondition:
-
Get Tomcat server, “qautomate.xml” file and qAutomate build
-
Make sure Java has been installed and system
variable JAVA_HOME has been set up.
Open “Explorer”, navigate to “Control
Panel\All Control Panel Items\System”, click “Advanced system settings”
link. On “System Properties” panel, “Advanced” page, click “Environment
variables…” button. On “System variables” grid, create a variable
name “CATALINA_HOME” with value being Tomcat location
Also on “System variables”
grid, find “Path” variable, add “%CATALINA_HOME%\bin”.
Copy file “qautomate.webservice.war”
from qAutomate build folder and put it into “…\apache-tomcat-7.0.50\webapps” folder.
Paste file “qautomate.xml” into
“…\apache-tomcat-7.0.50\conf” folder.
Open file “qautomate.xml” and
configure below lines to point web service to your database:
<property
name="hibernate.connection.password">[your
password]</property>
<property
name="hibernate.connection.url">[your database
connection]</property>
<property
name="hibernate.connection.username">[your
username]</property>
For example:
Save and close this file.
Then we go to “…\apache-tomcat-7.0.50\bin”
folder, double-click “startup.bat” to start Tomcat server
4. Configure qAutomate
-
Inside qAutomate build folder, double click “launcher.bat”
file to start qAutomate.
-
Application will ask for webservice, click “Yes” button.
-
Use URL Connection: http://<your
computer IP>:8080/qautomate.webservice/ and click “Save &
Close” button
Finally, qAutomate Homepage
will be displayed.
5. Export and import database from one machine to other
Precondition: Stop Tomcat server and qAutomate on both machines.
5.1 Export database
On our machine, export the
database by command line:
expdp system/<database_password>
dumpfile=<dumpfile_name>.dmp schemas=<database_name>
query=’<database_name>.job_instance:"WHERE job_instance_id=-1"'
The dabase
dumpfile will appears in the Oracle base directory (e.g.
D:\app\<our_name>\admin\orcl\dpdump)
5.2 Import database
On the other
machine, we copy the dumpfile from our machine and pasted it to the Oracle base
directory this machine (e.g. D:\app\<other_name>\admin\orcl\dpdump).
Then we run the command line:
impdp system/<database_password>
dumpfile=<dumpfile_name>.dmp
After database is
imported successfully, we can run Tomcat server and start qAutomation as usual.
Automation Team