8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Misc » Here

utPLSQL Installation and Upgrade

This article demonstrates the installation and upgrade of the utPLSQL unit test framework for PL/SQL.

Download

Always pick the latest version. You can download it from here.

Copy software to server. The examples below assume it is in "/u01/software".

cd /u01/software
unzip utPLSQL.zip
cd utPLSQL/source

All subsequent operations assume we are already in this directory. They also assume we need a shared installation, available for all users in the database. If your requirements are different, you will need to check out the utPLSQL Installation Guide.

Install in a PDB

Amend the environment variables are required for your installation.

export PDB_NAME=pdb1
export ORACLE_SID=cdb1
export USERNAME=ut
export PASSWORD=myUtPassword123

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

sqlplus / as sysdba <<EOF
alter session set container = ${PDB_NAME};
-- Comment out the following line if you are reusing an existing user.
@create_utplsql_owner.sql ${USERNAME} ${PASSWORD} users 

@install.sql ${USERNAME}

@create_synonyms_and_grants_for_public.sql ${USERNAME}
exit;
EOF

Install in a Non-CDB

Amend the environment variables are required for your installation.

export ORACLE_SID=orcl
export USERNAME=ut
export PASSWORD=myUtPassword123

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

sqlplus / as sysdba <<EOF
-- Comment out the following line if you are reusing an existing user.
@create_utplsql_owner.sql ${USERNAME} ${PASSWORD} users 

@install.sql ${USERNAME}

@create_synonyms_and_grants_for_public.sql ${USERNAME}
exit;
EOF

Remove From a PDB

Amend the environment variables are required for your installation.

export PDB_NAME=pdb1
export ORACLE_SID=cdb1
export USERNAME=ut

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

sqlplus / as sysdba <<EOF
alter session set container = ${PDB_NAME};
@uninstall.sql ${USERNAME}
-- Uncomment the following line if you want to drop the user.
--DROP USER ${USERNAME} CASCADE;
exit;
EOF

Remove From a Non-CDB

Amend the environment variables are required for your installation.

export ORACLE_SID=orcl
export USERNAME=ut

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

sqlplus / as sysdba <<EOF
@uninstall.sql ${USERNAME}
-- Uncomment the following line if you want to drop the user.
--DROP USER ${USERNAME} CASCADE;
exit;
EOF

Upgrade

utPLSQL doesn't have a conventional upgrade. Instead, you remove the old version and install the new version, as described above.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.