Error: ORA-12514 during Oracle database configuration in Applications Manager

Products

• Automic Applications Manager

Issue/Introduction

Applications Manager fails to connect to the Oracle database during an initial installation, migration, or reconfiguration. This error typically surfaces in the installation logs or the Master process logs.

The following error is reported when attempting to start services or run configuration utilities: Error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Environment

• Applications Manager
• Oracle Database

Cause

This error occurs when the Oracle Service Name defined in the Applications Manager configuration does not match the SERVICE_NAME registered with the Oracle listener. This often happens if the service name in the install or awinstall parameters differs from the entry in the tnsnames.ora file or the database instance settings.

Resolution

Update the Applications Manager configuration to align with the Oracle tnsnames.ora/listener settings:

1. Stop all Applications Manager processes.
2. Open the tnsnames.ora file on the local server to verify the correct SERVICE_NAME.
3. Run the awinstall utility and select Option 1 (install/upgrade).
4. Enter the Oracle Service Name exactly as it appears in the tnsnames.ora or database configuration.
5. Complete the remaining prompts in the utility.
6. Restart Applications Manager