Install Cannot Connect to Oracle

Document ID : KB000099898
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
After specifying the Oracle database information during the install, an error occurs stating...
"Could not connect to Oracle. If Oracle is not active, start Oracle and run the install again. Otherwise, verify the login credentials are correct."
Verified via sqlplus that the user specified as the Oracle sys user is able to connect with Oracle from the machine where the installation is taking place.
Resolution:
An Oracle database user with administrator privileges (such as SYS) is required to create the CA Workload Automation AE tablespaces, database users, and roles when you install server components. To bypass this requirement, run the waae_oracle.sql script before you install a server component. The waae_oracle.sql script creates the tablespaces, database users, and roles.

When you run the waae_oracle.sql script, connect as an Oracle database user with administrative privileges and run the waae_oracle.sql script from the Oracle command prompt.

When you run the waae_oracle.sql script, verify that you clear the Create the Tablespaces, Database Users, and Roles check box on the Primary Event Server Properties page during the installation. The installer does not prompt you to specify the Oracle administrator user and password information.