Error setting up FDA Oracle external account on v7.0.9346 Windows
- I can telnet successfully from my acc instance to port 1521 on host machine running the Oracle 19c database (db:acc/user:accfda/host:10.0.2.2)
- I can connect using Oracle's Net configuration assistant and Olap analytic workspace manager tools installed on my acc server
- Installed and configured Oracle client on C:\Oracle as well as the tnsnames.ora file with the correct host, port, sid settings
- Configured TNS_ADMIN system variable with C:\Oracle value and also tried C:Oracle as per documentation guide
- Configured ORACLE_HOME to point to correct oracle application path
2022-02-04 01:46:26 WDB-200000 Unable to connect to database '10.0.2.2' of type 'Oracle' with login 'accfda' (iRc=-2006)
2022-02-04 01:46:26 ORA-210000 Oracle error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA (iRc=-2006)
2022-02-04 01:46:25 Starting 1 connection(s) on pool '[Oracle:accfda:/********@10.0.2.2;internalName=EXT2;NChar=1;unicodeData=1;timezone=_server_;dbSchema=;fileMethod=uploadFile;filePath=;] adobe' (Oracle, server='10.0.2.2', login='accfda')
2022-02-04 01:45:33 Starting 1 connection(s) on pool 'default adobe' (MSSQL, server='localhost', login='neolane:acc')
2022-02-04 01:45:28 Server started
2022-02-04 01:45:28 Tomcat started
2022-02-04 01:45:27 Starting Web server module (pid=3624, tid=4640)...
2022-02-04 01:45:27 Application server for Adobe Campaign Classic (7.2.1 build 9346@39fdbb5 of 20/12/2021)
Here is my tnsnames.ora content
# tnsnames.ora Network Configuration File: C:\Oracle\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.2)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
