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 FEBRUARY 08, 2018

Applies to:

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


Configuring an EBS (ATG RUP 5) with RAC ( 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


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

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



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