Tidal Enterprise Orchestrator: Deleting Oracle-based Process and Reporting Databases

Introduction

This document provides information about how to delete the TEOProcess and TEOReporting databases if they are Oracle-based.

Prerequisites

Components Used

The information in this document is based on these software and hardware versions:

• Tidal Enterprise Orchestrator (TEO) 2.2 or later

• Oracle Database

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Resolution

This section shows how to delete the TEOProcess and TEOReporting databases. This assumes that the end user named their process/configuration database "TEOProcess".

Delete TEOProcess

Run these commands in Oracle:

1. DROP TABLESPACE TEOProcess_DATA INCLUDING CONTENTS AND DATAFILES;

2. DROP TABLESPACE TEOProcess_TEMP INCLUDING CONTENTS AND DATAFILES;

3. DROP user TEOProcess CASCADE;

Delete TEOReporting

Run these commands in Oracle:

1. DROP TABLESPACE TIAReport_DATA INCLUDING CONTENTS AND DATAFILES;

2. DROP TABLESPACE TIAReport_INDEX INCLUDING CONTENTS AND DATAFILES;

3. DROP TABLESPACE TIAReport_TEMP INCLUDING CONTENTS AND DATAFILES;

4. DROP user TIAReport CASCADE;

   Note: Be careful when you delete the TEOReporting database as many TEO application servers can feed into it. Only delete the TEOReporting database if you no longer need it for any TEO application server.

Related Information

• Technical Support & Documentation - Cisco Systems