This chapter describes the how to import and export files to and from the server, how to manage the Oracle Load Testing database, and how to select the database to use.
The Oracle Load Testing database is used to store the results of your load test sessions. You use the Oracle Application Testing Suite Database Configuration to configure databases for use in Oracle Load Testing. The Databases option on the Manage menu in Oracle Load Testing is used to set the current database to use. The Database Manager dialog box has the following options:
Name - displays the ODBC System Data Source name of the database.
Description - displays a description of the database.
Type - displays the type of database.
Connection String - displays the connection string.
To add an Oracle database:
Use the Oracle Application Testing Suite Database Configuration utility to configure database connections to Oracle Load Testing databases. On Windows machines, you can access the Database Configuration utility from the Tools sub menu of the Oracle Application Testing Suite Start menu. On Linux machines, you can access the Database Configuration utility from <oats_install>/bin/DbConfig.sh.
Select Oracle Load Testing.
Click New.
Select Use existing schema or Create new schema & tables.
This dialog box has the following options:
System user credentials - specify the login authentication credentials if you select to create a new schema and tables, as follows:
User name - enter the login user name for the database system.
Password - enter the login password for the database system.
Connection details - enter the Oracle database connection information.
Name - enter the name of the database. This name appears in the Database selection lists for Oracle Load Testing and as the ODBC Data Source name.
Description - enter any description text to identify the database.
Host - enter the host name of the machine on which the database server is running.
Port - enter the port number that you want to communicate with. If you are running multiple instances of the database on the same host, specify the port number you want to communicate with.
User name - enter the login user name for the database.
Password - enter the login password for the database.
Enter the database information.
Click Save.
If creating a new schema, enter the password for both the Administrator and default accounts and click OK.
Click Close.
Either restart the computer or restart the Oracle Application Testing Suite Application service by going to the Control Panel Administrative Tools and open Services and restart the Oracle Application Testing Suite Application Service.
Select Programs from the Start menu then select Oracle Application Testing Suite Database Configuration from the Oracle Application Testing Suite - Tools menu.
Select Oracle Load Testing as the product type.
Select the database you want to use to store Oracle Load Testing data.
Click Set current.
Click Close.
Restart Oracle Load Testing.
You can remove databases from Oracle Load Testing. Doing so does not delete the database files. It removes the database from the database selection lists so that the database is no longer available in Oracle Load Testing. The database cannot be deleted if it is open in Oracle Load Testing.
To remove a database from Oracle Load Testing:
Select Programs from the Start menu then select Oracle Application Testing Suite Database Configuration from the Oracle Application Testing Suite - Tools menu.
Select the database that you want to remove.
Click Remove.
Click Yes to confirm the deletion.
You can change the name, location, and login information for databases that you are using in Oracle Load Testing.
Select Programs from the Start menu then select Oracle Application Testing Suite Database Configuration from the Oracle Application Testing Suite - Tools menu.
Select the database that you want to update.
Click Update.
Make any changes.
Click OK.
Oracle Application Testing Suite Release 12.1+ supports Oracle Database 10g, 11g or XE 10g as the RDBMS for its load testing and test management components. Oracle Application Testing Suite Release 12.5+ supports Oracle Database 11g, 12c or XE 11g as the RDBMS for its load testing and test management components. In some cases, it may be necessary to transfer data between databases. The basic procedure to is to export a database dump from one database and then import the dump file into the new database. The following sections provide basic details for exporting and importing an Oracle XE database. See the Oracle Database Utilities documentation for additional information about using the original Export (exp) and Import (imp) utilities and the Data Pump Export (expdp) and Data Pump Import (impdp) utilities.
The Database Export utility provides a way to transfer data objects between Oracle databases, even if the database reside on different platforms. Running the Export utility on an Oracle database extracts objects (such as tables) with all related objects (such as indexes, comments, and grants), if any. The extracted data is written to an Export file.
To export a database using the export utility:
Open a command prompt.
Change directory to Oracle home. For example, C:\OracleATS\oxe\app\oracle\product\10.2.0\server\BIN
Enter the following command:
exp userid=username/password owner=schema name file=Exportfile.dmp log=Export.log
where:
userid= specifies the username/password of the user performing the export.
owner= specifies the schema name to export ("oats", "olt", "otm").
file= specifies the file name to which the schema will be exported.
log= specifies the log file name to save any warnings or errors that may have occurred during export.
For additional parameter information, type exp help=y at the command prompt.
Example:
exp userid=system/oracle owner=olt file=olt.dmp log=olt.log statistics=none
The Import utility reads the object definitions and table data from an Export dump file and inserts the data objects into an Oracle database.
To import a database from an exported dump file:
Open Sql Plus and create a user (for example, Test) and grant roles (connect, resource, create any view) to the newly created user.
create user Test identified by password;
grant connect, resource, create any view to Test;
Open a command prompt.
Change directory to Oracle home. For example, C:\OracleATS\oxe\app\oracle\product\10.2.0\server\BIN
Enter the following command.
imp userid=user/pwd fromuser=OATS touser=Test file=Exportfile.dmp log=test.log
where:
userid= specifies the username/password of the user performing the import.
fromuser= specifies a list of owner usernames. This parameter enables you to import a subset of schemas from an export file containing multiple schemas.
touser= specifies a list of usernames whose schemas will be targets for import.
file= specifies the name of the exported dump file. For example, Exportfile.dmp.
log= specifies the log file name to save any warnings or errors that may have occurred during import.
For additional parameter information, type imp help=y at the command prompt.
Example:
imp userid=system/oracle fromuser=olt touser=tempuser file=olt.dmp log=t.log
Add the new database to the Oracle Application Testing Suite using the Oracle Application Testing Suite Database Configuration utility. See Section 13.1.1, "Adding an Oracle Database" for additional information.
In cases where the database was exported using the Data Pump Export (expdp) utility, you use the Data Pump Import (impdp) utility to import the database.
To import a database from a Data Pump Export utility:
Create a folder. (for example c:\test)
Open Sql Plus and enter the following command:
SQL> create directory test as '/backup/db_name/exports/dpump' ;
Grant read and write permissions to the users who will be performing the data pump import. Note: before granting following permission please log in as sys as sysdba (different user than logged in user and should be logged in as dba)
SQL> grant read, write on directory test to system, user1, user2, user3;
Open a command prompt.
Change directory to Oracle home. For example, C:\OracleATS\oxe\app\oracle\product\10.2.0\server\BIN
Enter the following command:
impdp system/<Password> DIRECTORY=<dir name> DUMPFILE=<dmpfile.dmp> LOGFILE=<logfilename.log> remap_schema=<source_schema>:<target_schema>
For additional parameter information, type impdp help=y at the command prompt.
Example:
impdp system/oracle DIRECTORY=test DUMPFILE=expdp_Exportfile.dmp LOGFILE=impfull.log remap_schema=oats:oats
You can import and export Data Bank files (.csv) to and from the Oracle Load Testing server and the local machine. This can be useful if you are accessing Oracle Load Testing on a remote machine via the Web UI and want to copy data files to another server.
To export Data Bank files from the server to the local machine:
Select Options from the User menu.
Select Data Bank in the Manage group.
Select the Data Bank file (.csv) file that you want to export.
Click Export.
Click Save As.
Select the location where you want to save the file and click Save.
To import Data Bank files from the local machine to the server:
Select Options from the User menu.
Select Data Bank in the Manage group.
Click Import Data Bank.
Enter the file name or click Browse to locate the file.
Select the destination location from which you want to copy the file.
Click Open.Click Upload.
You can import and export Download Manager data files (.dat) to and from the Oracle Load Testing server and the local machine. This can be useful if you are accessing Oracle Load Testing on a remote machine via the Web UI and want to copy data files to another server.
To export data files from the server to the local machine:
Select Options from the User menu.
Select Data File in the Manage group.
Select the data file (.dat) file that you want to export.
Click Export.
Click Save As.
Select the location where you want to save the file and click Save.
To import data files from the local machine to the server:
Select Options from the User menu.
Select Data File in the Manage group.
Click Import Data File.
Enter the file name or click Browse to locate the file.
Select the destination location from which you want to copy the file.
Click Open.Click Upload.
The Reset Password utility allows the installing user of the Oracle Application Testing Suite web applications to reset the password for the Administrator account in an Oracle Load Testing or Oracle Test Manager database.
The installing user of the Oracle Application Testing Suite can reset the password for:
Oracle Load Testing Administrator user
Oracle Test Manager Administrator user
The default Administrator user password is the password specified during the Oracle Application Testing Suite installation.
See the Oracle Application Testing Suite Installation Guide for additional information about using the Reset Password utility.