CreateAEDB.pl fails

book

Article ID: 222686

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

I am running CreateAEDB.pl script to create AEDB, and it fails with userid/password incorrect message.

 

Cause

The tablespace the user tried to create had already existed.

The script failed with the following:

CreateAEDB: The tablespace ASYSQA04_DATA already exists. Exiting...

The install_aedb.log, ends with the following:

SQL> SELECT COUNT(*) FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = UPPER('ASYSQA04_DATA');

  COUNT(*)
----------
  1

SQL> EXIT vresult;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
The userid and password combination for the autosys user is incorrect. Exiting...
CA Workload Automation AE database was not created or updated.

"The userid and password combination for autosys user is incorrect" probably is not the cause as there is no indication that the script checked autosys user id and password.

 

 

Environment

Release : 11.3.5/11.3.6

Component :

Resolution

Had DBA drop the tablespace and CreateAEDB.pl completed successfully.