Forecast failing with ORA-12505

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Forecast failing with ORA-12505

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

?Applications Manager is running fine but the FORECAST module fails with the error below. This occurred after the customer had moved/upgraded from Oracle 10G to 11G:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
SP2-0306: Invalid option.

Investigation

Confirmed the values between:

1. Results of SQL below:

select so_login, so_passwd, so_encrypted, so_net_connect, so_db_id from so_ids where so_login='apwxdev';

2. Value of SO_DB_SID under [default] of the Master's $AW_HOME/site/awenv.ini file

3. The value that the SID was being used in the output file for the FORECAST module.

Solution

?The upgrade of Oracle had in fact changed the SID that was being used. There was an inconsistency between the so_ids table and the awenv.ini file which when correct, will resolved the issue.