CPs will not start after AE database move

Document ID : KB000109026
Last Modified Date : 02/08/2018
Show Technical Document Details
Issue:

After a Database migration, CPs will not start and WP logs show only error:

U00003367 No primary work process is registered in the database

JWP and JCP will start/stay running.

Oracle DBA relocated the Oracle 12.1 database to a new location and upgraded to Oracle version 12.2.

Environment:
Oracle Database
Cause:
Investigation:

WPs will start, but show the following message repeated:

U00003367 No primary work process is registered in the database

CPs will not start, and show the following messages:

20180730/180916.817 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 1324d20  DB-HDBC: 0
20180730/180916.817 - U00003591 UCUDB - DB error info: OPC: 'OCILogon' Return code: 'ERROR'
20180730/180916.817 - U00003592 UCUDB - Status: '' Native error: '12545' Msg: 'ORA-12545: Connect failed because target host or object does not exist'
20180730/180916.817 - U00003590 UCUDB - DB error: 'OCILogon', 'ERROR   ', '', 'ORA-12545: Connect failed because target host or object does not exist'
Resolution:
Check the tnsnames.ora file for correct spelling of the new server name. Example:

Old server name: aut03uc01bl
New server name: aut01uc01vl