search cancel

Upon running the AAI upgrade the installation asks for the tablespace names and left it as the default when that doesn't match how Oracle was installed for AAI.

book

Article ID: 215205

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

Upon running the upgrade to AAI 6.2.0-1 the installation asks for the tablespace names. We made the mistake of not renaming those to JAWSDATA and JAWSINDICES (as they exist in our database) and left the pre-populated AAIDATA and AAIINDICES.

When running the .sql script that is generated post upgrade it fails stating that "tablespace 'AAIDATA' does not exist"

Environment

Release : 6.2.0-1

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR BMC

Resolution

Edit the upgrade .sql script in the /<Install Dir>/ scripts directory.

 

Search for instances of the tablespace name, AAIDATA and indices, AAIINDICES, and replace them with the tablespace name and indices name for your database.

 

Attempt to run the sql script again, if it fails, manually run each line of the script through SQL developer and ensure to commit the transactions.

 

Once all lines of the script have been run, start up the AAI service.