Setting up the Database MySQL Oracle

Once the database is set up, you need to run a script to create the tables, users, and so on that CTP will use. If you haven’t done so already, extract CTP from the download:

unzip parasoft_continuous_testing_platform_<version>.zip

MySQL

If you are using MySQL on the same host:

mysql –u root –p < mysql_db.sql

If you are using MySQL on a different host:

mysql –u root –p –-host=<host> --port=<port> < mysql_db.sql

Oracle

If you are using Oracle on the same host:

sqlplus <user>/<pass> < oracle_db.sql

If you are using Oracle on a different host:

1.  Edit oracle_db.sql line 13 and change connect em/em; to 

   connect em/em@<host>:<port>/<sid>;

2. From the command line, run:

   sqlplus <user>/<pass>@<host>:<port>/<sid> < oracle_db.sql

If you are using an Oracle database that is containerized and has startup script execution available, you will need to modify oracle_db.sql to properly utilize the container. For example, in the script below the first line (ALTER SESSION SET CONTAINER=XEPDB1;) has been added and the CONNECT statement has had @XEPDB1 appended to it. Note that your configuration might require different changes; this is just an example.

ALTER SESSION SET CONTAINER=XEPDB1;

CREATE TEMPORARY TABLESPACE "EM_TEMP" TEMPFILE 'EM_TEMP.ORA' SIZE 10M REUSE AUTOEXTEND ON NEXT 20M;
CREATE TABLESPACE "EM_DATA"  DATAFILE 'EM_DATA.ORA' SIZE 50M REUSE AUTOEXTEND ON NEXT 100M;

CREATE USER "EM"  PROFILE "DEFAULT"
    IDENTIFIED BY "em" DEFAULT TABLESPACE "EM_DATA"
    TEMPORARY TABLESPACE "EM_TEMP"
    QUOTA UNLIMITED
    ON "EM_DATA"
    ACCOUNT UNLOCK;

GRANT ALL PRIVILEGES TO EM;

CONNECT em/em@XEPDB1;