Sun Day Consulting, Inc.

Oracle’s Recovery Appliance (ZDLRA)

Posted by on Dec 09 2016

We’ve posted a database backup Bash shell script for Oracle’s Recovery Appliance (ZDLRA) as well as a reporting database refresh script. Designed for an Oracle PeopleSoft reporting database, the refresh script can easily be adjusted to work in any situation where database refreshes are required.

The scripts were tested in an Oracle PeopleSoft environment running Oracle RAC/ASM 12c on Solaris 11 (Oracle SuperCluster T5-8) and a ZDLRA X5 system.

Steps to implement:

Run zdlra.sql to add the protected database. From RMAN, register the database with the recovery appliance catalog. If the database will be backed up using an incremental level 1 strategy utilizing real-time redo, change the redo transport user to the virtual private catalog owner.

Run zdlra.bsh to update the RMAN configuration.

Replace the following references in the scripts with the appropriate values: <appliance admin> <passwd> <zdlra catalog database> <ra cluster SCAN> <virtual private catalog owner> <PeopleSoft database> <protection policy>

Create a clone_<PeopleSoft database>.rcv file for each database as per the clone_CSPRD.rcv example.

Run run_backup.bsh. The first parameter is the database instance. Specify tape as a second command line parameter to automatically schedule a Copy-To-Tape job once the backup completes.

Run refresh_rpt.bsh to refresh a reporting database. The first parameter is the database instance.

Download the code:   

Introducing TimeTrio

Posted by on Jan 28 2016

TimeTrio® is a cloud-based timesheet, expense management and project tracking system. Enter time and expense data from your computer or smart device.

Written in HTML5, CSS, PHP and Javascript using a MySQL database, TimeTrio® is designed for professional service firms who track time on an hourly basis and/or expenses by project.

Here’s a quick overview of the time entry component of the system:


Go to

TimeTrio® is a registered trademark of Sun Day Consulting, Inc.

A PeopleSoft Upgrade Impact Analysis

Posted by on Mar 03 2015

Tekopia is a Go program that performs an analysis of Oracle database structure changes and their impact on customizations during a PeopleSoft upgrade. It runs significantly faster than a traditional SQR version of the same program.

The program finds records and fields renamed in the new software release, records that are now views (and vice versa), field length changes, and obsolete records and fields. It searches custom SQRs, Queries, SQL and PeopleCode for references to such objects. The report provides a detail impact analysis, as well as a summary of the total number of custom SQR, PeopleCode, SQL and Query objects impacted by the various changes in the new software release.

Tekopia requires  a database link from the new release upgraded database to an old release demo database.

Prior to running the program in the newly upgraded database, insert all records and fields into an Application Designer project in the old release demo database and copy the project to file. Run a Record compare in the upgraded database against the file. Deselect all report filters, select ‘Update Project Item Status and Child Definitions’, Compare by Release (select the application version of the old release demo) and set the target orientation to ‘PeopleSoft Vanilla’.

The two Application Designer projects referenced in the variables upgrade and upgcust should exist in the newly upgraded database prior to running the program.

Tekopia runs in one of four modes – report changes, report changes and analyze SQRs, report changes and analyze online objects, report and analyze impact on SQRs and online objects.

The program references and uses the go-oci8 Oracle driver which is copyrighted by Yasuhiro Matsumoto and governed by a separate license agreement.

Download the code: