Running Autoconfig On RAC Instance, Failed With ORA-12504: TNS:listener was not given the SID in CONNECT_DATA (Doc ID 577396.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Applications DBA - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Configuring an EBS 11.5.10.2 (ATG RUP 5) with RAC 10.2.0.3 ( 2 Node RAC) in a TEST Environment:

Node 1 --- Forms/Web tier, hostname
Node 2 --- Database/Concurrent Tier, Hostname, SID=RACSID1
Node 3 --- Database/Concurrent Tier, Hostname, SID=RACSID2

SERVICE_NAME=RACSID

After performing the DB Autoconfig enabling section on <Note 362135.1>, the execution of Autoconfig ends with error:

adconfig.log - script afdbprf.sh
Executable : $ORACLE_HOME/bin/sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 13 11:32:29 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms